如何从C#中的数据库中检索多个原始数据? [英] how to retrive multiple rawdata from database in c#?

问题描述

假设我触发查询..
从客户中选择*"
所以我如何将其存储在变量中?

suppose i fire query like..
"select * from customer"
so how can i store it in variables???

推荐答案

我希望这会对您有所帮助.

I hope this will help you.

SqlConnection con = new SqlConnection("your connection string");
SqlCommand cmd = new SqlCommand("your select quary", con);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
if (con.State == ConnectionState.Closed)
    con.Open();
adp.Fill(dt);

if (dt.Rows.Count > 0)
{
   string name=dt.Rows[your row index]["your column name"].toString();
}

嗨
您可以使用以下内容.
datatableforQuery = getdatafromdatabase();
session ["Keepdata"] = datatableforQuery;


其中getdatafromdatabase()是从数据库查询中检索数据的方法("

Hi
You can use the following.
datatableforQuery=getdatafromdatabase();
session["Keepdata"]=datatableforQuery;


where getdatafromdatabase() is the mathod that retrive the data from DB query("

select * from customer"

)

此会话变量非常智能，它将自动转换为数据表.

另一种方法是使用
a)Viewstate
b)哈希表
c)sql server中的临时表

希望对您有帮助.

谢谢

)

this session variable is very intelligent it will cast to datatable automatically.

another ways is use
a)Viewstate
b)Hashtable
c)temp table in sql server

Hope it will help you.

Thanks

这篇关于如何从C#中的数据库中检索多个原始数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！