如果只是某一列:
sqlDataReader1=this.Select.ExecuteReader();if(sqlDataReader1.Read())
{
s = sqlDataReader1["字段名"].ToString();
}
不要用关键字作变量
sqlDataReader1=this.Select.ExecuteReader();if(sqlDataReader1.Read())
{
s = sqlDataReader1["字段名"].ToString();
}
不要用关键字作变量
SqlDataAdapter sda=new SqlDataAdapter(sql,cn);
DataSet ds = new DataSet();
sda.Fill(ds,tb);
DataTable dt=ds.Tables[0];
string=dt.Rows[n][m].ToString();
Dim OleDbDataAdapter1 As System.Data.OleDb.OleDbDataAdapter
Dim objTestLink As New DataSet()
Dim objtable As DataTable
Dim strcmd As String
Dim strconn As String
strconn = ConfigurationSettings.AppSettings("SQLConnectionString")
strcmd = "SELECT * FROM UserTable"
OleDbConnection1 = New System.Data.OleDb.OleDbConnection(strconn)
OleDbDataAdapter1 = New System.Data.OleDb.OleDbDataAdapter(strcmd, OleDbConnection1)
OleDbDataAdapter1.Fill(objTestLink, "UserTable")
然后你想要读那行就用
objtestlink(0).rows(x).item(x)
x从0开始