نوشته شده توسط
kiani_behzad
SqlConnection objConnection = newSqlConnection("Server=Localhost;DataBase=project;Integrated Security=true;");
objConnection.Open();
SqlDataAdapter objadapter = newSqlDataAdapter();
objadapter.SelectCommand = newSqlCommand();
objadapter.SelectCommand.Connection = objConnection;
objadapter.SelectCommand.CommandText = "status";
objadapter.SelectCommand.CommandType = CommandType.StoredProcedure;
DataSet d=newDataSet();
objadapter.Fill(d, "article");
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = d;
dataGridView1.DataMember = "article";
SqlCommandBuilder cb = newSqlCommandBuilder(objadapter);
objadapter.UpdateCommand = cb.GetUpdateCommand();
objadapter.Update(d, "article");
objConnection.Close();
کدهاتو بشکل زیر بنویس تا راحت تر بشه بررسی کرد:
SqlConnection objConnection = newSqlConnection("Server=Localhost;DataBase=projec t;Integrated Security=true;");
objConnection.Open();
SqlDataAdapter objadapter = newSqlDataAdapter();
objadapter.SelectCommand = newSqlCommand();
objadapter.SelectCommand.Connection = objConnection;
objadapter.SelectCommand.CommandText = "status";
objadapter.SelectCommand.CommandType = CommandType.StoredProcedure;
DataSet d=newDataSet();
objadapter.Fill(d, "article");
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = d;
dataGridView1.DataMember = "article";
SqlCommandBuilder cb = newSqlCommandBuilder(objadapter);
objadapter.UpdateCommand = cb.GetUpdateCommand();
objadapter.Update(d, "article");
objConnection.Close();