如何在datagridview中显示数据 [英] how to show data in datagridview
本文介绍了如何在datagridview中显示数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想用datagridview显示数据库中的记录。我该怎么办?
I want to show records in database with datagridview. how can I do?
推荐答案
看看这个: csharp-datagridview-database-operations [ ^ ]
这是将数据从数据库绑定到GridView的非常简单的方法。请写下面的代码,你可以将数据绑定到GridView:
SqlConnection cnn = new SqlConnection(Data Source = HOTH; Initial Catalog = Chintan; User ID = sa ;密码= 123);
cnn.Open();
SqlDataAdapter da = new SqlDataAdapter(select * from tbl_data,cnn);
DataSet ds = new DataSet();
da.Fill(ds);
cnn.Close();
if(ds.Tables [0] .Rows.Count!= 0)
{
GridView1.DataSource = ds.Tables [0];
GridView1.DataBind();
}
谢谢。 ....: - )
It's very easy way to bind the data to GridView from Database. Please, write below code and you can bind data to GridView:
SqlConnection cnn = new SqlConnection("Data Source=HOTH;Initial Catalog=Chintan;User ID=sa;Password=123");
cnn.Open();
SqlDataAdapter da = new SqlDataAdapter("Select * from tbl_data", cnn);
DataSet ds = new DataSet();
da.Fill(ds);
cnn.Close();
if (ds.Tables[0].Rows.Count != 0)
{
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
Thank You..... :-)
SqlConnection con = new SqlConnection("Data Source=NONETF3SFRWS151;Initial Catalog=HealthPlus;User ID=sa;Password=sql");
con.Open();
SqlDataAdapter adp = new SqlDataAdapter("select * from login", con);
DataSet ds = new DataSet();
adp.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
这篇关于如何在datagridview中显示数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文