如何从数据库中检索第一列值 [英] how to retrive first colum value from database

问题描述

在我的应用程序中，我正在动态创建表.在该表中，我想显示数据库值.我在page_load事件中编写代码以检索数据库值.但是我只希望显示第一个列值，而不是所有列值.我知道在sql查询中使用*的列名，但是我也想修改其他数据.下面我写代码

in my application i m creating table dyanmically . in that table i want to display database value. i m write code on page_load event to retrive database value. but i want only first colum value to be dispalyed not all column value.i know to use column name insted of * in sql query but i also want other data to modify. below i m write code

protected void Page_Load(object sender, EventArgs e)
  {


          SqlConnection con = new SqlConnection();
          con.ConnectionString = ConfigurationManager.ConnectionStrings["ConnStringDb1"].ConnectionString;
          SqlCommand cmd = new SqlCommand("select * from content_managment", con);
          DataTable dt = new DataTable();
          SqlDataAdapter ad = new SqlDataAdapter();

          ad.SelectCommand = cmd;
          ad.Fill(dt);

          foreach (DataRow dr in dt.Rows)
          {

              HtmlTable table = new HtmlTable();
              HtmlTableRow tr = new HtmlTableRow();
              table.Border = 1;
              table.Width ="450PX";
              table.Align = "center";
              table.CellSpacing = 5;
              foreach (DataColumn dc in dt.Columns)
              {
                  HtmlTableCell tc = new HtmlTableCell();
                  tc.Width = "140px";
                  tc.Align = "left";

                  HtmlTableCell tc1 = new HtmlTableCell();
                  tc1.Width = "5px";
                  tc1.Align = "right";
                  HtmlTableCell tc2 = new HtmlTableCell();
                  tc2.Width = "5px";
                  tc2.Align = "right";
                  Label lb = new Label();
                  lb.Font.Bold = true;
                  lb.Font.Size = 11;
                  lb.Text = dr[dc].ToString();
                  HyperLink hp = new HyperLink();
                  hp.Text = "Edit";
                  LinkButton linkbut = new LinkButton();
                  linkbut.Text = "Delete";
                  tc.Controls.Add(lb);
                  tc1.Controls.Add(hp);
                  tc2.Controls.Add(linkbut);

                  tr.Cells.Add(tc);
                  tr.Cells.Add(tc1);
                  tr.Cells.Add(tc2);
                  table.Rows.Add(tr);
                  Panel1.Controls.Add(table);

                  hp.NavigateUrl = "Edit_Home_Page_Content.aspx?f1=" + dr[dc].ToString();
                  linkbut.Click += new System.EventHandler(this.delete_record);
              }
          }
          ad.Dispose();
          cmd.Dispose();
          con.Dispose();

  }

推荐答案

要对数据进行排序，请使用 ORDER BY [^ ]子句，例如:

To sort data, use ORDER BY[^] clause, for example:

SELECT *
FROM content_managment
ORDER BY YourColumnName

只需退出您的

foreach (DataColumn dc in dt.Columns)

不使用任何特定行为(使用某些系统表，您可能会在其中找到列顺序)，则循环执行.SQL数据库表中没有第一"列…！

Without using any specific behaviors (using some system table where you maybe find the column order), there is no "first" column in an sql database table…!

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