int i ; ArrayList al = new ArrayList();for(i=0;i<=this.dataset11.Tables[0].Rows.Count-1;i++) { if (this.dataGrid1.IsSelected(i)) al.Add(i); } foreach (int elementValue in al) { this.dataset11.Tables[0].Rows[elementValue].Delete(); } dataset11.Bind();
ArrayList al = new ArrayList();for(i=0;i<=this.dataset11.Tables[0].Rows.Count-1;i++)
{
if (this.dataGrid1.IsSelected(i)) al.Add(i);
}
foreach (int elementValue in al)
{
this.dataset11.Tables[0].Rows[elementValue].Delete();
}
dataset11.Bind();
dataGrid1.BindingContext[this.dataGrid1.DataSource].EndCurrentEdit()应该就更新了;
public static void BindDataGrid(DataGrid datagrid, string connectionString,string commandString)
{ SqlConnection conn=new SqlConnection(connectionString);
SqlCommand comm=new SqlCommand(commandString,conn);
SqlDataAdapter adapter=new SqlDataAdapter();
adapter.SelectCommand =comm;
DataSet dataset=new DataSet ();
try
{
adapter.Fill(dataset,"table");
count=dataset.Tables["table"].DefaultView.Count;
datagrid.DataSource=dataset.Tables["table"].DefaultView;
datagrid.DataBind();
}
finally
{
conn.Close();
} return count; }
即:commandString = label.text ;label.text ="Select * From test";
先找到这个行的唯一标识符(一般是用主键的值),再到表里头根据这个值找到相应的Row删除就可以了。DataSet 和 DataGrid 里面的纪录就都删除了。
一般这样邦定datagrid.DataSourse=datatable;