private void button2_Click(object sender, EventArgs e)
{
string SQLiteName = @"D:\Personal\My Documents\123.db";
SQLiteConnection connection = new SQLiteConnection();
connection.ConnectionString = "Data Source=" + SQLiteName;
connection.Open();
SQLiteCommand command = connection.CreateCommand();
command.Connection = connection;
SQLiteTransaction transaction = connection.BeginTransaction();
try
{
command.CommandText = "select * from hehe";
command.ExecuteNonQuery();
DataSet ds = new DataSet();
SQLiteDataAdapter da = new SQLiteDataAdapter(command);
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
transaction.Commit();
}
catch
{
transaction.Rollback();
}
command.Dispose();
connection.Close();
}
{
string SQLiteName = @"D:\Personal\My Documents\123.db";
SQLiteConnection connection = new SQLiteConnection();
connection.ConnectionString = "Data Source=" + SQLiteName;
connection.Open();
SQLiteCommand command = connection.CreateCommand();
command.Connection = connection;
SQLiteTransaction transaction = connection.BeginTransaction();
try
{
command.CommandText = "select * from hehe";
command.ExecuteNonQuery();
DataSet ds = new DataSet();
SQLiteDataAdapter da = new SQLiteDataAdapter(command);
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
transaction.Commit();
}
catch
{
transaction.Rollback();
}
command.Dispose();
connection.Close();
}
,如果那个sqlite是我用程序建的再用上面的代码就没问题,如果是用别的SQLite工具建的就会显示乱码