使用datatable显示数据库记录

本文介绍了使用datatable显示数据库记录的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在使用数据表显示数据库记录 在LatestNewsMaster表记录中如下

id主题链接有效 1缺陷邮件defectmail.aspx A 2账户费用accountsfee.aspx A 3 Latestenews页面Latestnews.aspx A

我的代码如下

string constr = ConfigurationManager.ConnectionStrings [ Reception2_DB]。ConnectionString; 使用（SqlConnection con = new SqlConnection（constr）） { 使用（SqlCommand cmd = new SqlCommand（ 选择来自LatestNewsMaster的链接，其中有效<>'d'）） { cmd.Connection = con; 使用（SqlDataAdapter sda = new SqlDataAdapter（cmd）） { DataTable dt = new DataTable（）; sda.Fill（dt）; label1.Text = dt.Rows [ 0 ] [ 0 ]。ToString（）。修剪（）; return dt; } } }

但是当我在标签dsiplaying中运行时，标签1中只有firt recrod defectmail.aspx 。没有显示数据库中的所有三个链接记录。 来自我上面的代码我犯了什么错误。

解决方案

我猜你没有错，除非我认为你误解了什么。 标签是显示单个单词或单行的方式...虽然您有表格形式的数据..即行和列...并且为此有一个名为GridView的控件...您可以使用它来显示您的所有数据，如下所示。例如，您只需在名为 GVDetails 的页面上添加Gridview控件，然后将绑定名为 dt 到下面的网格视图。

GVDetails.DataSource = dt; GVDetails.DataBind（）;

您可以查看以下链接得到我正在谈论的整个想法。 Gridview数据绑定。 如果您需要更多帮助，可以提出任何问题点击此解决方案或任何下方的有问题或评论按钮。 希望它有所帮助。 ：）

i am displaying the database record using datatable In LatestNewsMaster table record as follows

id Subject Link Active 1 Defect Mail defectmail.aspx A 2 Accounts Fee accountsfee.aspx A 3 Latestenews page Latestnews.aspx A

My code as follows

string constr = ConfigurationManager.ConnectionStrings["Reception2_DB"].ConnectionString; using (SqlConnection con = new SqlConnection(constr)) { using (SqlCommand cmd = new SqlCommand("select Link from LatestNewsMaster where active <> 'd'")) { cmd.Connection = con; using (SqlDataAdapter sda = new SqlDataAdapter(cmd)) { DataTable dt = new DataTable(); sda.Fill(dt); label1.Text = dt.Rows[0][0].ToString().Trim(); return dt; } } }

But when i run in label dsiplaying only firt recrod defectmail.aspx in the label1. not displaying all the three link records from the database. from my above code what is the mistake i made.

解决方案

There is no mistake you are doing I guess, Except I think you misunderstood something. Labels are the way to display a single word or single line ... while you have the data in the form of table.. i.e. Rows and Columns... and for that there is a control called as GridView... You can use that to display all of your data like below.. For example you just add a Gridview control on your page named as GVDetails and than you will bind your DataTable which is named as dt to that gridview like below.

GVDetails.DataSource = dt; GVDetails.DataBind();

You may have a look at the following link to get the whole idea I am talking about as well. Gridview Databinding. Further if you need more help you may ask any question by clicking "Have a Question or Comment" button below this solution or any. Hope it helps. :)