本文介绍了如何从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#中的数据库中检索多个原始数据?
发布评论