Saturday, January 27, 2007

Populating data into DataGridview of Windows Forms in .NET 2.0

Populating data into DataGridview of Windows Forms in .NET 2.0
////string select = "select Meaning,Examples from "+tablename+" where Word="+"'"+Searchword+"'";
////SqlConnection conn = new SqlConnection(ConnString);
////conn.Open();
////SqlCommand cmd1 = new SqlCommand(select,conn);

//SqlDataAdapter adap = new SqlDataAdapter(cmd1);
//DataTable dt = new DataTable();
//dt.Locale = System.Globalization.CultureInfo.InvariantCulture;
//adap.Fill(dt);
//bndSource.DataSource = dt;
//dgvSrchWord.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
//dgvSrchWord.ReadOnly = true;
//dgvSrchWord.DataSource = bndSource;

//conn.Close();

1 Comments:

Blogger Navyanth Gowda said...

Please ensure to add a Bindsource control to your form and bind the datasource with the datatable populated.

Saturday, January 27, 2007 7:17:00 PM  

Post a Comment

Subscribe to Post Comments [Atom]

<< Home