Comments by Mustafa77 (Top 11 by date)

My friend i try that (id= + dataGridView1.Rows[k].Cells[].....) before, i placed id=1 just only to see if that changing is reflect in the database, nothing was happened in the database...
My friend i think that simple but i cannot to see where is the error in my code....
thank you again to see my problem

the connection string in App.config is:
<add name="test_update.Properties.Settings.dbupdateConnectionString"
="" connectionstring="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\dbupdate.mdf;Integrated Security=True" providername="System.Data.SqlClient">

<connectionstrings>
<add name="test_update.Properties.Settings.dbupdateConnectionString" connectionstring="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\dbupdate.mdf;Integrated Security=True" providername="System.Data.SqlClient">


in app.Config
no there any problem in it
the problem is the changing was happened in the gridview but that no reflects on the database

Oki my friend, my code in windows form as:
public partial class Form1 : Form
{
SqlConnection con;
SqlDataAdapter adap;
DataSet ds;
SqlCommandBuilder scb;
SqlCommand scmd;
public Form1()
{
InitializeComponent();
load_student();
}
private void load_student()
{
try
{
con = new SqlConnection();
con.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["test_update.Properties.Settings.dbupdateConnectionString"].ConnectionString; ;
con.Open();
string sql = "select * from student";
adap = new SqlDataAdapter(sql, con);
ds = new System.Data.DataSet();
adap.Fill(ds, "student");
dataGridView1.DataSource = ds.Tables[0];
}
catch (Exception ex)
{
MessageBox.Show("Error! " + ex.Message);
}
finally
{
con.Close();
}

}

private void update_btn_Click(object sender, EventArgs e)
{
try
{
/*scb = new SqlCommandBuilder(adap);
adap.Update(ds, "student");*/
string sql = "update student set name='ali' where id=2";
scmd = new SqlCommand(sql, con);

con.Open();
scmd.ExecuteNonQuery();
MessageBox.Show("Updating is had been successfully");
}
catch (Exception ex)
{
MessageBox.Show("Error " + ex.Message);
}
finally
{
con.Close();
scb = new SqlCommandBuilder(adap);
adap.UpdateCommand = scmd;
adap.Update(ds, "student");
ds.AcceptChanges();
load_student();
}
}

private void button1_Click(object sender, EventArgs e)
{
con = new SqlConnection();
con.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["test_update.Properties.Settings.dbupdateConnectionString"].ConnectionString; ;
string sql1 = "delete from student where id=1";
scmd = new SqlCommand(sql1, con);
try
{
con.Open();
scmd.ExecuteNonQuery();
MessageBox.Show("Successfully deleting");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
load_student();
}
}
}
I am waiting your helping my friend, there are any errors in code