DataGridView显示数据库数据(一)

 

            //创建数据库连接
            SqlConnection con = new SqlConnection("server=.;database = test; uid = sa; pwd = 123456");
try
            {
//打开数据库连接
                con.Open();
//数据适配器，传输数据库数据
                SqlDataAdapter sda = new SqlDataAdapter("select id as 编号, name as 姓名 from talbe", con);
                DataSet ds = new DataSet(); 
//填充数据集DataSet
                sda.Fill(ds);
//绑定表格
                DataGridView1.DataSource = ds.Tables[0];
            }
catch (Exception e)
            {
throw new Exception(e.Message);
            }
finally
            {
                con.Close();
            }

 

转载于:https://www.cnblogs.com/ghypnus/archive/2012/03/20/2408207.html