如何使用C＃在Gridview中显示我的表？ [英] How Can I Show My Table In Gridview Using C#?

问题描述

我在数据库中有一个表名为= login的表。我希望在网格视图中显示我的表值。

I have a table with table name= login in data base. i want show my table value in grid view.

推荐答案

参考：如何从数据库获取数据到gridview [ ^ ]

Hi,

//string connection="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\aspnet.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True";
string connection = "Data Source=path;Initial Catalog=commonlogin;User ID=sa;Password=; ";
 
 
SqlConnection conn = new SqlConnection(connection);
conn.Open();
SqlDataAdapter ad= new SqlDataAdapter("SELECT * FROM tbl_SqlImage", conn);
Dataset ds=new Dataset();
ad.fill(ds);
 
if(ds.tables[0].rows.count!=0)
{
          Gridview1.Datasource=ds;
          Gridview1.Databind();
}

http://www.vkinfotek.com/gridview/binding-gridview-dataset.html [ ^ ]

尝试使用执行阅读器绑定gridview [ ^ ]像这样：

Try to bind gridview using execute reader[^] like this:

try
{
        using (SqlConnection sqlConn = new SqlConnection(strConn))
        {
            using (SqlCommand sqlCmd = new SqlCommand())
            {
                sqlCmd.CommandText = "SELECT * FROM login";
                sqlCmd.Connection = sqlConn;
                sqlConn.Open();
                SqlDataReader objDataReader = sqlCmd.ExecuteReader();
                gvDetail.DataSource = objDataReader;
                gvDetail.DataBind();
                sqlConn.Close();
            }
        }
}
catch { }

这篇关于如何使用C＃在Gridview中显示我的表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！