请纠正本规范 [英] Please rectify the Code

查看:77
本文介绍了请纠正本规范的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在尝试使用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屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆