gabrieleb
شنبه 24 مهر 1389, 21:36 عصر
سلام ، من یه بانک اکسس ایجاد کردم کل قسمتهاش کار میکنه (درج و حذف و ...)فقط میخوام اطلاعات رو تو گرید ویو نمایش بدم که این کد رو نوشتم ایراد میگیره
اینم پیغامش ..لطف کنید اشتباهمو بگین... ممنون
Fill: SelectCommand.Connection property has not been initialized.
private void Form1_Load(object sender, EventArgs e)
{
OleDbCommand OleDbCommand1 = new OleDbCommand();
OleDbConnection OleDbConnection1 = new OleDbConnection(c);
OleDbCommand1.CommandText = "insert into Table1 values (@name,@family,@father)";
OleDbCommand1.CommandType = CommandType.Text;
OleDbDataAdapter OleDbDataAdapter1 = new OleDbDataAdapter();
OleDbDataAdapter1.SelectCommand = OleDbCommand1;
DataSet DataSet1 = new DataSet();
OleDbConnection1.Open();
OleDbDataAdapter1.Fill(DataSet1, "Database1");
OleDbConnection1.Close();
dataGridView1.DataSource = DataSet1.Tables["Database1"];
}
اینم پیغامش ..لطف کنید اشتباهمو بگین... ممنون
Fill: SelectCommand.Connection property has not been initialized.
private void Form1_Load(object sender, EventArgs e)
{
OleDbCommand OleDbCommand1 = new OleDbCommand();
OleDbConnection OleDbConnection1 = new OleDbConnection(c);
OleDbCommand1.CommandText = "insert into Table1 values (@name,@family,@father)";
OleDbCommand1.CommandType = CommandType.Text;
OleDbDataAdapter OleDbDataAdapter1 = new OleDbDataAdapter();
OleDbDataAdapter1.SelectCommand = OleDbCommand1;
DataSet DataSet1 = new DataSet();
OleDbConnection1.Open();
OleDbDataAdapter1.Fill(DataSet1, "Database1");
OleDbConnection1.Close();
dataGridView1.DataSource = DataSet1.Tables["Database1"];
}