在C#中,数据集从数据库中取得数据后,如何操作,比如,上一记录,下一记录,这样的移动操作!
例如:
SqlConnection sqlConn = new SqlConnection("workstation id=SSLOVER;packet size=4096;
user id=sa;data source=SSLOVER;;Password=12345;
persist security info=False;initial catalog=DataBase");
sqlConn.Open();
string SQL = "select * from a_item where len(code) = 7";
SqlDataAdapter NewDateSQLDate = new SqlDataAdapter(SQL,sqlConn);
DataSet Newdateset = new DataSet();
NewDateSQLDate.Fill(Newdateset,"a_item");将如何遍历呢,是用Newdateset 还是用NewDateSQLDate ??
例如:
SqlConnection sqlConn = new SqlConnection("workstation id=SSLOVER;packet size=4096;
user id=sa;data source=SSLOVER;;Password=12345;
persist security info=False;initial catalog=DataBase");
sqlConn.Open();
string SQL = "select * from a_item where len(code) = 7";
SqlDataAdapter NewDateSQLDate = new SqlDataAdapter(SQL,sqlConn);
DataSet Newdateset = new DataSet();
NewDateSQLDate.Fill(Newdateset,"a_item");将如何遍历呢,是用Newdateset 还是用NewDateSQLDate ??
string studentName = perRow["StuName"];
}
你可以遍历里面的数据。
//i--
Newdateset.Tables["a_item"]["字段"]Rows[i]//i++
//i--
在Rows[i] 这里出错,提示“应输入”
string tmp= this.dataSet1.Tables[0].Rows[0][0].ToString();