dbCommand = new SqlCommand("SELECT Game.GameId,Location,Date,Time FROM Game,Results WHERE Game.GameId = Results.GameId AND CountryId ='" + cboCountryName.SelectedValue + "'", dbConnection); if (dbConnection.State = ConnectionState.Closed) { dbConnection.Open(); } dbread = dbCommand.ExecuteReader(); while (dbread.Read()) { }
DataTable table = new DataTable(); table.Load( dbCommand.ExecuteReader()); dataGrid.DataSource = table;
con.Open(); SqlDataReader reader = cmd.ExecuteReader(); GridView1.DataSource = reader; GridView1.DataBind(); reader.Close(); con.Close();
SqlConnection obj_Conn = new SqlConnection(); obj_Conn.ConnectionString = strConn; obj_Conn.Open(); SqlCommand obj_Cmd = new SqlCommand(strCmd, obj_Conn); SqlDataReader obj_Reader = obj_Cmd.ExecuteReader(); DataTable dt = new DataTable(); dt.Columns.Add("Id"); dt.Columns.Add("FName"); dt.Columns.Add("LName"); while (obj_Reader.Read()) { DataRow row = dt.NewRow(); row["Id"] = obj_Reader["Id"]; row["FName"] = obj_Reader["FName"]; row["LName"] = obj_Reader["LName"]; dt.Rows.Add(row); } dataGridView1.DataSource = dt;
DataTable dt = new DataTable(); dt.Columns.Add("Id"); dt.Columns.Add("Name"); while (obj_Reader.Read()) { DataRow dr= dt.NewRow(); dr["Id"] = obj_Reader["Id"]; dr["Name"] = obj_Reader["Name"]; dt.Rows.Add(dr); } dataGridView1.DataSource = dt;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)