| private void BindCustomers() { SqlConnection conn = new SqlConnection("YOUR CONNECTION STRING"); // calling up your connection string that was configured in you Web Config File DataTable dt = new DataTable(); // I use DataTable here because I only want to grab data in ONE Table.. If using mutilple tables then use DataSet instead conn.Open(); String sql = "SELECT * FROM TableUsers"; //But i would suggest you to use parameterize queries or SP for security reasons SqlCommand cmd = new SqlCommand(sql, conn); SqlDataAdapter ad = new SqlDataAdapter(cmd); ad.Fill(dt); if (dt.Rows.Count > 0) { BoundField Field = new BoundField(); Field.DataField = "UserID"; Field.HeaderText = "User Name"; DataControlField Col = Field; GridView1.Columns.Add(Col); Field = new BoundField(); Field.DataField = "Address"; Field.HeaderText = "User Address"; Col = Field; GridView1.Columns.Add(Col); Field = new BoundField(); Field.DataField = "PhoneNumbers"; Field.HeaderText = "User Phone Number"; Col = Field; GridView1.Columns.Add(Col); GridView1.DataSource = dt; GridView1.DataBind(); } conn.Close(); } private void BindOrders() { SqlConnection conn = new SqlConnection("YOUR CONNECTION STRING"); // calling up your connection string that was configured in you Web Config File DataTable dt = new DataTable(); // I use DataTable here because I only want to grab data in ONE Table.. If using mutilple tables then use DataSet instead conn.Open(); String sql = "SELECT * FROM TableUserOrders"; //But i would suggest you to use parameterize queries or SP for security reasons SqlCommand cmd = new SqlCommand(sql, conn); cmdCommandType = CommandType.Text; cmd.ExecuteNonQuery(); SqlDataAdapter ad = new SqlDataAdapter(cmd); ad.Fill(dt); if (dt.Rows.Count > 0) { BoundField Field = new BoundField(); Field.DataField = "UserID"; Field.HeaderText = "User Name"; DataControlField Col = Field; GridView1.Columns.Add(Col); Field = new BoundField(); Field.DataField = "ProductName"; Field.HeaderText = "Product Name"; Col = Field; GridView1.Columns.Add(Col); Field = new BoundField(); Field.DataField = "DatePurchased"; Field.HeaderText = "Date"; Col = Field; Field = new BoundField(); Field.DataField = "Amount"; Field.HeaderText = "Total Amount"; Col = Field; GridView1.Columns.Add(Col); GridView1.DataSource = dt; GridView1.DataBind(); } conn.Close(); } protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e) { int index = RadioButtonList1.SelectedIndex; switch (index) { case 0: { BindCustomers(); // If users selects CustomerIfo in the radio button then GridView will populate the Customers break; } case 1: { BindOrders(); // Else GridView will populate the Orders break; } default: break; } } |