Binding data gridview in windows application is different from gridview in asp.net,heres example for binding data gridview in desktop application
place a data gridview in your form and write following code in code behind
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlClient;
namespace WindowsApplication2 {
public partial class Form1 : Form { SqlConnection con; SqlDataAdapter da; SqlCommandBuilder cmd; DataRow row; DataSet ds = new DataSet(); BindingSource bsourse = new BindingSource(); public Form1() { InitializeComponent(); }
private void Form1_Load(object sender, EventArgs e) { con = new SqlConnection("server=localhost;database=raja;integrated security=sspi"); da = new SqlDataAdapter("select * from ex", con); cmd = new SqlCommandBuilder(da); da.Fill(ds, "ex"); ds.Tables[0].Constraints.Add("pik", ds.Tables[0].Columns[0], true);
bsourse.DataSource = ds.Tables["ex"]; dataGridView1.DataSource = bsourse; } } }
For more details, visit http://dotnetmaterial9.blogspot.com/2008/11/worked-code-for-reference.html
|
No responses found. Be the first to respond and make money from revenue sharing program.
|