SQLite hjælp
Hej,Jeg har installeret csharp-sqlite_3_6_23 og added den som reference med using System.Data.SQLite;
Følgende kode giver dog denne fejl: "Error: No connection associated with this command"
private void treeView1_MouseClick(object sender, MouseEventArgs e)
{
if (treeView1.SelectedNode.Text == "Node1")
{
this.richTextBox1.Text = "";
SQLiteDataReader dataReaderSelect = GetSQLData(treeView1.SelectedNode.Text);
if (dataReaderSelect != null && dataReaderSelect.HasRows)
{
while (dataReaderSelect.Read())
{
string txt = dataReaderSelect[0].ToString() + "\n";
txt += dataReaderSelect[1].ToString() + "\n";
txt += dataReaderSelect[2].ToString() + "\n";
txt += dataReaderSelect[3].ToString() + "\n";
txt += dataReaderSelect[4].ToString() + "\n";
MessageBox.Show(txt);
}
}
}
}
public SQLiteDataReader GetSQLData(string name)
{
SQLiteDataReader dataReader = null;
try
{
SQLiteConnection connectionString = new SQLiteConnection("Data Source=" + Path.GetDirectoryName(Application.ExecutablePath) + "\\database.s3db;Version=3;New=False;Compress=True");
using (SQLiteConnection conn = new SQLiteConnection(connectionString))
{
conn.Open();
SQLiteCommand cmd = new SQLiteCommand();
cmd.CommandText = "select * from myTable";
cmd.CommandTimeout = 120;
dataReader = cmd.ExecuteReader();
}
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.Message.ToString() + "\n\n");
}
return dataReader;
}
Hvad mangler jeg? :-/