Tag Archives: Code

String strConn = “Server = .\\sqlexpress;Database = NorthWind;Integrated Security = SSPI;”; dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells; conn = new SqlConnection(strConn); da = new SqlDataAdapter(“Select Categories.CategoryName, Products.ProductName, Products.UnitPrice From Categories Inner Join Products on Products.CategoryID = Categories.CategoryID”, conn); SqlCommandBuilder cmd = new SqlCommandBuilder(da); ds = new DataSet(); da.Fill(ds, “Categories”); bs = new BindingSource(ds, “Categories”); dataGridView1.DataSource = bs; bindingNavigator1.BindingSource = bs; [Translate]