public void uzunluk_hesabi()
{
tSql = "select kelime from kelimeler";
tCon.Open();
cmd.CommandText = tSql;
tDataReader = cmd.ExecuteReader();
prgHesap = tDataReader.Cast <object>().Count();
tDataReader.Close();
bag_close();
}
public DbDataRecord ExecuteCommand(ref SQLiteDataAdapter adapter, string query, Dictionary <string, SQLiteParameter> parameters = null)
{
if (query == null)
{
throw new Exception("fmDB: no query is assigned");
}
try
{
SQLiteCommand command = new SQLiteCommand(query, connection);
if (parameters != null)
{
foreach (var p in parameters)
{
command.Parameters.Add(p.Value);
}
}
SQLiteDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
return(reader.Cast <DbDataRecord>().First());
}
return(null);
}
catch (Exception err)
{
if (!bSilent)
{
MessageBox.Show(err.Message);
}
else
{
EventLog.WriteEntry(source, err.Message, EventLogEntryType.Error);
}
return(null);
}
}
