请纠正本规范 [英] Please rectify the Code
本文介绍了请纠正本规范的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试使用ExecuteReader函数将数据库表连接到Windows窗体中的DataGridView ...
但是没有显示任何内容...
我要添加手动数据源首先做这个代码的东西...我上面写的代码是正确的还是你们有任何简单的替代方式...我是c的初学者我应该手动添加数据源首先做这个代码的东西< br $>
I am trying to connect a database table to DataGridView in windows form using ExecuteReader Function...
But the out not showing anything...
Shall I add Data source manually first doing this code stuff...Is the code the I wrote above is correct or do you guys have any easy alternate way...I am beginner in c#Shall I add Data source manually first doing this code stuff
private void Form1_Load(object sender, EventArgs e)
{
string cs=ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select * from Emp";
cmd.Connection = con;
con.Open();
SqlDataReader dr =cmd.ExecuteReader();
BindingSource source = new BindingSource();
source.DataSource = dr;
dataGridView1.DataSource = source;
}
}
推荐答案
我不确定我理解你好吧...假设您想在运行应用程序之前连接到Visual Studio中的数据,请查看此处:
在Visual Studio中连接数据 [ ^ ]
如何:连接到数据库中的数据 [ ^ ]
如何:创建数据库连接 [ ^ ]
I'm not sure i understand you well... Assuming that you want to connect to data in Visual Studio before you run your application, have a look here:
Connecting to Data in Visual Studio[^]
How to: Connect to Data in a Database[^]
How to: Create a Database Connection[^]
这篇关于请纠正本规范的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文