string SelectTradeClassName="select top 7 * from Trade_Class where Trade_Class_ID="+Trade_Class_ID;
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
myConnection.Open();
SqlCommand cmd1 = new SqlCommand(SelectTradeClassName,myConnection); SqlDataReader dr1 = cmd1.ExecuteReader();
if(dr1.Read())
{
}
我想问一下有什么办法把取出来的7条记录分别驸给7个变量,假设变量的类型为string
名字分别为aa,bb,cc,dd,ee,ff,gg?具体写法怎么写??
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
myConnection.Open();
SqlCommand cmd1 = new SqlCommand(SelectTradeClassName,myConnection); SqlDataReader dr1 = cmd1.ExecuteReader();
if(dr1.Read())
{
}
我想问一下有什么办法把取出来的7条记录分别驸给7个变量,假设变量的类型为string
名字分别为aa,bb,cc,dd,ee,ff,gg?具体写法怎么写??
用个for循环不行吗?
bb=dr["值2"].Tostring.Trim();
cc=dr["值3"].Tostring.Trim();
dd=dr["值4"].Tostring.Trim();
ee=dr["值5"].Tostring.Trim();
ff=dr["值6"].Tostring.Trim();
gg=dr["值7"].Tostring.Trim();
值1,2,3,4,5,6,7为列号
string str1;
string str2;
dr1.Read();
str1 = dr1[字段名].ToString();
dr1.Read();
str2 = dr1[字段名].ToString();
int i = 0;
while ( dr1.Read() )
{
str[i] = dr1["字段名"].ToString();
i++;
}
int i = 0;
while(dr1.Read())
{
s[i] = dr1[i].ToString();
i = i + 1;
}
aa=s[0];
bb=s[1];
cc=s[2];
dd=s[3];
ee=s[4];
ff=s[5];
gg=s[6];
s[i] = dr1[i].ToString();
改成
s[i] = dr1["字段名子"].ToString();