请问各位高手。。
ASP中是这样的代码
Set conn = Server.CreateObject("ADODB.Connection")
connStr = "Provider=SQLOLEDB.1; Data Source=(local); User Id=sa; Password=123456; Initial Catalog=seacms;"
conn.Open connStr
strSQL = "SELECT * FROM [TABLE]"
Set rs = conn.Execute(strSQL)Do While Not(rs.EOF And rs.BOF)
Response.Write rs("id")
rs.MoveNext
If rs.EOF Then Exit Do
Loop
rs.Close:Set rs = Nothing:conn.Close:Set conn = Nothing这种的代码在C#中怎么写呀??100分求助此问题
ASP中是这样的代码
Set conn = Server.CreateObject("ADODB.Connection")
connStr = "Provider=SQLOLEDB.1; Data Source=(local); User Id=sa; Password=123456; Initial Catalog=seacms;"
conn.Open connStr
strSQL = "SELECT * FROM [TABLE]"
Set rs = conn.Execute(strSQL)Do While Not(rs.EOF And rs.BOF)
Response.Write rs("id")
rs.MoveNext
If rs.EOF Then Exit Do
Loop
rs.Close:Set rs = Nothing:conn.Close:Set conn = Nothing这种的代码在C#中怎么写呀??100分求助此问题
SqlConnection con = new SqlConnection(connectionstring);
con.open();
string cmdtext = "SELECT * FROM [TABLE]" ;
SqlCommand cmd = new SqlCommand(cmdtext, con);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
Response.Write rs("id") ;
}
dr.Close();
con.close();
if (dr.Read())
{
Response.Write rs("id") ; //这行改为Response.Write dr["OrderID"].ToString();
}
然后判断该数据流是否有数据,有的话就按顺序读出.
结贴。给分
{
Response.Write dr["OrderID"].ToString();
}