创建数据网格视图并在Windows应用程序中从SQL填充 [英] create data grid view and populate from sql in windows application

问题描述

我想在Windows应用程序中动态创建数据网格视图(即在运行时).请提供任何帮助....提前thnx

i want to create a data grid view in my windows application dynamically(i.e. at run time). any help please....thnx in advance

推荐答案

使用下面的代码创建动态gridview





私有无效btnfind_Click(对象发送者，EventArgs e)
{
DataGridView gridview =新的DataGridView();
//在页面Writer中执行PlaceHolder控件后，遵循代码
groupBox1.Controls.Add(gridview);


SqlConnection con =新的SqlConnection();
con.ConnectionString =数据源= FITA-AKEEL;初始目录=管理系统;集成安全性=真实";
con.Open();
SqlCommand cmd =新的SqlCommand();
cmd.Connection = con;
cmd.CommandText =从tblguesttype中选择*";


SqlDataAdapter da =新的SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
字符串tablename ="tblgueattype";

gridview.DataSource = ds;
gridview.DataBindings.ToString();

da.Fill(ds，表名);
gridview.DataSource = ds;
gridview.DataMember =表名;

}

use elow code for creating dynamic gridview





private void btnfind_Click(object sender, EventArgs e)
{
DataGridView gridview = new DataGridView();
//after taking PlaceHolder control in The page Writer following code
groupBox1.Controls.Add(gridview);


SqlConnection con = new SqlConnection();
con.ConnectionString = "Data Source=FITA-AKEEL;Initial Catalog=managementsystem;Integrated Security=True";
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "Select * from tblguesttype";


SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
string tablename = "tblgueattype";

gridview.DataSource = ds;
gridview.DataBindings.ToString();

da.Fill(ds, tablename);
gridview.DataSource = ds;
gridview.DataMember = tablename;

}

私有无效btnfind_Click(对象发送者，EventArgs e)
{
DataGridView gridview =新的DataGridView();
//在页面中进行组框控制后，编写以下代码
groupBox1.Controls.Add(gridview);


SqlConnection con =新的SqlConnection();
con.ConnectionString =数据源= FITA-AKEEL;初始目录=管理系统;集成安全性=真实";
con.Open();
SqlCommand cmd =新的SqlCommand();
cmd.Connection = con;
cmd.CommandText =从tblguesttype中选择*";


SqlDataAdapter da =新的SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
字符串tablename ="tblgueattype";

gridview.DataSource = ds;
gridview.DataBindings.ToString();

da.Fill(ds，表名);
gridview.DataSource = ds;
gridview.DataMember =表名;

}

private void btnfind_Click(object sender, EventArgs e)
{
DataGridView gridview = new DataGridView();
//after taking group box control in the page, Write following code
groupBox1.Controls.Add(gridview);


SqlConnection con = new SqlConnection();
con.ConnectionString = "Data Source=FITA-AKEEL;Initial Catalog=managementsystem;Integrated Security=True";
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "Select * from tblguesttype";


SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
string tablename = "tblgueattype";

gridview.DataSource = ds;
gridview.DataBindings.ToString();

da.Fill(ds, tablename);
gridview.DataSource = ds;
gridview.DataMember = tablename;

}

con = new MySqlConnection();
con.ConnectionString =ConfigurationSettings.AppSettings["constr"];
con.Open();
string str = "select * from pto ";
MySqlDataAdapter da = new MySqlDataAdapter(str, con);
DataSet ds=new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];

这篇关于创建数据网格视图并在Windows应用程序中从SQL填充的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！