请问如何删除ListView控件中选定的一行,在线等,谢谢了 listView1.Items.Remove(listView1.SelectedItems[0]); 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SqlCommand selectCmd=con.CreateCommand(); selectCmd.CommandText="select * from tArticle"; SqlCommand deleteCmd=con.CreateCommand(); deleteCmd.CommandText="delete from tArticle where id=@id"; deleteCmd.Parameters.Add("@id",SqlDbType.Int,4,"id"); SqlDataAdapter sqlDataAdapter=new SqlDataAdapter(); DataSet dataSet=new DataSet(); sqlDataAdapter.SelectCommand=selectCmd; sqlDataAdapter.DeleteCommand=deleteCmd; con.Open(); sqlDataAdapter.Fill(dataSet,"tArticle"); con.Close(); DataTable dataTable=dataSet.Tables["tArticle"]; dataTable.PrimaryKey=new DataColumn[] { dataTable.Columns["id"] }; //dataTable.Rows.Find( string id; for(int i=0;i<lstArticle.Items.Count;i++) { if(lstArticle.Items[i].Checked==true) { id=lstArticle.Items[i].Text; DataRow dataRow=dataTable.Rows.Find(Convert.ToInt32(id)); if(dataRow!=null) dataRow.Delete(); } } con.Open(); sqlDataAdapter.Update(dataTable); con.Close(); 关于string str = null的问题 MSBCODE9.OCX 为什么我的不能显示39码 如何保证自己的自定义类库不被他人利用 c# winform treeview树控件问题 设置哪个属性让tablelayoutPanel变透明(在线等) OpenOBEX for win32 pakage 请问谁用过?? 关于暑假作业的问题三(项目)(80分求) 奇怪的Process问题 c# 堆叠图 结构赋值?? 超难问题,关于winform里DataGrid的 怎么向WinForm的TreeView节点添加更多的信息?
selectCmd.CommandText="select * from tArticle"; SqlCommand deleteCmd=con.CreateCommand();
deleteCmd.CommandText="delete from tArticle where id=@id";
deleteCmd.Parameters.Add("@id",SqlDbType.Int,4,"id"); SqlDataAdapter sqlDataAdapter=new SqlDataAdapter();
DataSet dataSet=new DataSet();
sqlDataAdapter.SelectCommand=selectCmd;
sqlDataAdapter.DeleteCommand=deleteCmd;
con.Open();
sqlDataAdapter.Fill(dataSet,"tArticle");
con.Close(); DataTable dataTable=dataSet.Tables["tArticle"];
dataTable.PrimaryKey=new DataColumn[]
{
dataTable.Columns["id"]
};
//dataTable.Rows.Find(
string id;
for(int i=0;i<lstArticle.Items.Count;i++)
{
if(lstArticle.Items[i].Checked==true)
{
id=lstArticle.Items[i].Text;
DataRow dataRow=dataTable.Rows.Find(Convert.ToInt32(id)); if(dataRow!=null)
dataRow.Delete();
}
}
con.Open();
sqlDataAdapter.Update(dataTable);
con.Close();