＋设为首页 ＋添加到收藏夹
问题已经在下面标明了
SqlConnection mycnn=new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
SqlCommand selectCmd=mycnn.CreateCommand();
selectCmd.CommandText="select * from table_dimension";
SqlCommand deleteCmd=mycnn.CreateCommand();
deleteCmd.CommandText="delete from table_dimension where id=@id and direction=@direction ";
SqlParameter Pid=new SqlParameter("@id",SqlDbType.Int,4,"id");
Pid.SourceVersion=DataRowVersion.Original;
deleteCmd.Parameters.Add(Pid);
SqlParameter Pdirection=new SqlParameter("@direction",SqlDbType.NVarChar,50,"direction");
Pdirection.SourceVersion=DataRowVersion.Original;
deleteCmd.Parameters.Add(Pdirection);
SqlDataAdapter sqlAdapter=new SqlDataAdapter();
sqlAdapter.SelectCommand=selectCmd;
sqlAdapter.DeleteCommand=deleteCmd;
DataSet ds=new DataSet();
mycnn.Open();
sqlAdapter.Fill(ds,"table_dimension");
DataTable table=new DataTable();
table=ds.Tables["table_dimension"];
table.PrimaryKey=new DataColumn[]
{
table.Columns["id"],
table.Columns["direction"]
};
DataRow row=table.Rows.Find(e.Item.Cells[2].Text);//这里只获得一个主键，不知道怎么获得另一个主键
row.Delete();
sqlAdapter.Update(table);
mycnn.Close();
如果你是用的绑定列的话就可以直接用
e.Item.Cells[Index].Text来获取啊
Index就是列的索引号啊
可以加一个隐藏的列。。。
