SqlDataAdapter sd = new SqlDataAdapter();
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "server=.;database=zlcaaron;uid=sa;pwd=sa."; SqlCommand selectCmd = new SqlCommand();
selectCmd.CommandText = "select * from BookData";
selectCmd.Connection = conn; SqlCommand delCmd = new SqlCommand();
delCmd.CommandText = "delete BookData where BookID=@BookID";
delCmd.Connection = conn; delCmd.Parameters.Add("@BookID", SqlDbType.Int, 4, "BookID");
sd.SelectCommand = selectCmd;
sd.DeleteCommand = delCmd; DataSet data = new DataSet();
sd.Fill(data, "BookData"); int nBookID = int.Parse(edit_BookID.Text);
DataRow deletedr = null;
foreach (DataRow dr in data.Tables["BookData"].Rows)
{
if (int.Parse(dr["BookID"].ToString()) == nBookID)
{
deletedr = dr;
break;
}
}
if (deletedr != null)
{
deletedr.Delete(); sd.Update(data, "BookData");
}
GridView1.DataSource = data.Tables["BookData"];
GridView1.DataBind();
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "server=.;database=zlcaaron;uid=sa;pwd=sa."; SqlCommand selectCmd = new SqlCommand();
selectCmd.CommandText = "select * from BookData";
selectCmd.Connection = conn; SqlCommand delCmd = new SqlCommand();
delCmd.CommandText = "delete BookData where BookID=@BookID";
delCmd.Connection = conn; delCmd.Parameters.Add("@BookID", SqlDbType.Int, 4, "BookID");
sd.SelectCommand = selectCmd;
sd.DeleteCommand = delCmd; DataSet data = new DataSet();
sd.Fill(data, "BookData"); int nBookID = int.Parse(edit_BookID.Text);
DataRow deletedr = null;
foreach (DataRow dr in data.Tables["BookData"].Rows)
{
if (int.Parse(dr["BookID"].ToString()) == nBookID)
{
deletedr = dr;
break;
}
}
if (deletedr != null)
{
deletedr.Delete(); sd.Update(data, "BookData");
}
GridView1.DataSource = data.Tables["BookData"];
GridView1.DataBind();
其他没看出来大问题
{
deletedr = dr;
break;
}break去掉 试试
{
if (int.Parse(dr["BookID"].ToString()) == nBookID)//看看有没有进入这一个if,如果没有进入,就是条件的问题了,不是程序的问题。
{
deletedr = dr;
break;
}
}
conn.ConnectionString = "server=.;database=zlcaaron;uid=sa;pwd=sa.";
conn.Open();
string strSql = "select * from BookData";
SqlDataAdapter sd = new SqlDataAdapter(strSql,conn);
DataSet data = new DataSet();
sd.Fill(data); for (int i = 0; i < data.Tables[0].Rows.Count; i++)
{
if (data.Tables[0].Rows[i]["BookID"].ToString() == edit_BookID.Text)
{
strSql = "delete BookData where BookID = " + int.Parse(edit_BookID.Text);
SqlCommand sd = new SqlCommand(strSql,conn);
sd.ExecuteNonQuery();
}
}
根据你提供的代码写的删除 ,你试下。
朋友可以自己开个SQL数据库试试!一样可以的
拜托你们能自己动手做做么 说了 不加FROM 也可以的 你们怎么就不动手自己做下呢 非要局限在思想当中
=>
delCmd.CommandText = "DELETE FROM BookData WHERE BookID=@BookID";建议关键字都大写,那样更加的清楚些
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "server=.;database=zlcaaron;uid=sa;pwd=sa."; SqlCommand selectCmd = new SqlCommand();
selectCmd.CommandText = "select * from BookData";
selectCmd.Connection = conn; SqlCommand delCmd = new SqlCommand();
delCmd.CommandText = "delete from BookData where BookID=@BookID";
delCmd.Connection = conn; delCmd.Parameters.Add("@BookID", SqlDbType.Int, 8, "BookID");
sd.SelectCommand = selectCmd;
sd.DeleteCommand = delCmd; DataSet data = new DataSet();
sd.Fill(data, "BookData"); int nBookID = int.Parse(edit_BookID.Text);
DataRow editdr = null;
foreach (DataRow dr in data.Tables["BookData"].Rows)
{
if (int.Parse(dr["BookID"].ToString()) == nBookID)
{
editdr = dr;
break;
}
}
if (editdr != null)
{
editdr.Delete(); sd.Update(data, "BookData");
} GridView1.DataSource = data.Tables["BookData"];
GridView1.DataBind();
加一句:conn.open();
再在最后加一句:conn.close();
编号:<asp:TextBox ID="edit_BookID" runat="server"></asp:TextBox>