如何一次获取多行数据并保存在变量中？ [英] How to fetch multiple row data at once and save in variable ?

问题描述

Actully我有列USERNAME，我想从两行或更多行但相同列中检索数据并保存在变量中。在运行页面时，它显示错误索引超出了数组的键。请帮我从保存列中检索更多值，但一次性差异并保存在变量中。

先谢谢........



我尝试过：



con.Open（）;

string str =从user_details中选择usr_nm;

OleDbCommand cmd = new OleDbCommand（str，con）;



OleDbDataReader dr = cmd.ExecuteReader（ ）;



while（dr.Read（））

{

Label1.Text = dr [0 ] .ToString（）;

Label2.Text = dr [1] .ToString（）;

Label3.Text = dr [2] .ToString（）;



}



con.Close（）;

Actully I have column USERNAME and I want to retrive data from two or more rows but same column and save in variable. While running page it show error "Index was outside the bonds of the array". Please help me to retrive more values from save column but diff rows in one time and save in variable.
Thanks in Advance........

What I have tried:

con.Open();
string str = "select usr_nm from user_details";
OleDbCommand cmd = new OleDbCommand(str, con);

OleDbDataReader dr = cmd.ExecuteReader();

while (dr.Read())
{
Label1.Text = dr[0].ToString();
Label2.Text = dr[1].ToString();
Label3.Text = dr[2].ToString();

}

con.Close();

推荐答案

尝试

try

string str = "select usr_nm from user_details";
           OleDbCommand cmd = new OleDbCommand(str, con);
           OleDbDataAdapter da = new OleDbDataAdapter(cmd);
           DataTable dt = new DataTable();
           da.Fill(dt);
           if(dt.Rows.Count >=3)
           {
                Label1.Text = dt.Rows[0][0].ToString();
               Label2.Text = dt.Rows[1][0].ToString();
               Label3.Text = dt.Rows[2][0].ToString();
           }

这篇关于如何一次获取多行数据并保存在变量中？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！