如何从C#中的数据库中检索多个原始数据?

本文介绍了如何从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