المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : Problem with Datagrid



C# Programming
05-06-2009, 11:30 AM
It's said that "Don't have par(my table)" and alway have error with sql_cmd.ExecuteNonQuery(); coz my file have # it can't read #

private SQLiteConnection sql_con;
private SQLiteCommand sql_cmd;
private SQLiteDataAdapter DB;
private DataSet DS = new DataSet();
private DataTable DT = new DataTable();


private void SetConnection()
{
sql_con = new SQLiteConnection("Data Source=pare.db;Version=3;New=False;Compress=True;");
// sql_con = new SQLiteConnection("Data Source=pare.db;Version=3;New=True;Compress=True;"); if I want to create new database
}

private void ExecuteQuery(string txtQuery)
{
sql_con.Open();
sql_cmd = sql_con.CreateCommand();
sql_cmd.CommandText = txtQuery;
sql_cmd.ExecuteNonQuery();
sql_con.Close();
}



private void LoadData()
{
sql_con.Open();
sql_cmd = sql_con.CreateCommand();
string CommandText = "select * from par";
DB = new SQLiteDataAdapter(CommandText, sql_con);//?????????????
DS.Reset();
DB.Fill(DS);//??? ???????????????? ????????
DT = DS.Tables[0];
dataGridView1.DataSource = DT;
sql_con.Close();
}


private void button2_Click(object sender, EventArgs e)
{
SetConnection();
LoadData();
}

It has error on the BIG http://www.barakasoft.com/script/Forums/Images/smiley_doh.gif

NO MORE TEAR