scsb = new SqlConnectionStringBuilder();
                scsb.DataSource = @".\SQLEXPRESS";
                scsb.IntegratedSecurity = true;
                scsb.AttachDBFilename = @"C:\Documents and Settings\name\Мои документы\Visual Studio 2008\Projects\Link_base\Link_base\LinkBase.mdf";
                connection = new SqlConnection(scsb.ConnectionString);
                connection.Open();

dataGridView1.DataSource = bindingSource1;

adapter = new SqlDataAdapter(cmd, connection);
                builder = new SqlCommandBuilder(adapter);
                table = new DataTable();
                table.Locale = System.Globalization.CultureInfo.InvariantCulture;
                adapter.Fill(table);
                bindingSource1.DataSource = table;

adapter.Update((DataTable)bindingSource1.DataSource);
или я еще пробовал так
adapter.Update(table);

adapter.UpdateCommand = new SqlCommand("Update " + label1.Text + " set Link = @Link Where Link = @oldLink", connection);
 
SqlParameter parameter = new SqlParameter("@Link", SqlDbType.VarChar);
parameter.SourceColumn = "Link";
parameter.SourceVersion = DataRowVersion.Current;
adapter.UpdateCommand.Parameters.Add(parameter);
 
SqlParameter parameter1 = new SqlParameter("@oldLink", SqlDbType.VarChar);
parameter1.SourceColumn = "Link";
parameter1.SourceVersion = DataRowVersion.Original;
adapter.UpdateCommand.Parameters.Add(parameter1);

adapter.InsertCommand = new SqlCommand("Insert into " + TableName + " (Link) Values (@Link)", connection);
adapter.InsertCommand.Parameters.Add("@Link", SqlDbType.VarChar, 0, "Link");