如何删除一行数据

[cetfyg]

已经得到要删除行的ID(有两个ID,ID1和ID2)和表名"nodeinfo",在C# 中怎样用SQL语句实现在数据库中删除该行?

[cetfyg]

这不管用,试过了.我把应该把代码附上,让大家看看

[阿建像熊猫]

长的像陈真~！

[Tll_W]

[Quote=引用 3 楼 baihe_591 的回复:]
SqlConnection conn=new SqlConnection ("打开数据库sql语句");
SqlCommand comm = new SqlCommand("Delete from nodeinfo where ID='ID1'", conn);
comm.Connection.Open();
comm.ExecuteNonQuery();
[/Quote]

跟查询、修改语句差不多。。就不重复贴代码了

[saluter99]

我自己用的ODBC连接的例子，用别的连接方法改一下就行了

//定义LOG库的ODBC数据源
string strODBCConnection = "Driver={SYBASE SYSTEM 11};Srvr=" +
server + ";Uid=" +
uid + ";Pwd=" +
pwd + ";DB=" +
dbase;
string StrSql = "delete from nodeinfo where ID1 = value and ID2 = Value";
Microsoft.Data.Odbc.OdbcConnection myConn = new Microsoft.Data.Odbc.OdbcConnection(strODBCConnection);
Microsoft.Data.Odbc.OdbcCommand myCmd = new Microsoft.Data.Odbc.OdbcCommand(StrSql, myConn);
myConn.Open();
int IntReturn = myCmd.ExecuteNonQuery();
myConn.Close();

[saluter99]

对了，我用的ODBC.NET，你可能不需要，就把 Microsoft.Data.Odbc.去了就行了

[baihe_591]

SqlConnection conn=new SqlConnection ("打开数据库sql语句");
SqlCommand comm = new SqlCommand("Delete from nodeinfo where ID='ID1'", conn);
comm.Connection.Open();
comm.ExecuteNonQuery();

[ljm66]

string StrSql = "delete from nodeinfo where ID = ID1 or ID = ID2 ";