6. Advanced Karate Member Dates (Extra challenge project) Enhance the program yo

Question

6. Advanced Karate Member Dates (Extra challenge project) Enhance the program you created in Programming Challenge 5 by giving the user a choice between displaying members who have joined before a given date or members who have joined on or after that date. In Figure 10-84, the program shows members who joined before October 20, 2008. In Figure 10-85, a list of members who joined on or after October 20, 2008 is displayed. You should create two datasets, one for each type of search. After binding the grid to the first dataset, a component named MembersBindingSource is created. If you then bind the grid to the second dataset, a second component named MembersBindingSource1 is created. At runtime, when the user switches between the radiobuttons, their event handlers can assign one of the two binding sources to the DataSource property of the DataGridView control. That would be a good time to call the Fill method of the appropriate DataAdapter.

-Adrian H. Rovelstad

G Starting out x m Chapter 10 - x Login User a x 2 login form u x 0 VB.Net Tute xD Starting out xA B) Facebool xG starting out x' > Hogskolenix D Starting out xaa Outlookcon x C 6. Advanced x https://frontercom/oa/links/files.phtml1735046283$91376531$/Undervisni g/Book/Starting +O -2012+6th.pdf H Apps OKomplett is identweb K Star Wars: The Clo D SDLC - Requireme W Systems develop D Shannara eMovi E Need VB help wit YEpost - Adrian H O Importert O Bokmerkerad db Databasesysteme in Meme Generator 4 – o Q www.livenewscha Starting out with Visual Basic 703 select a date from a Date TimePicker control. The program must display the first and last names, the phone numbers, and dates joined of all members who joined before the selected date (see Figure 10-83). Use a parameterized query to retrieve the matching table rows and display them in a DataGridView control. Figure 10-83 Finding members who joined before a selected date Select a Date: 1/20/2010 0 Members who joined before this date. Last Name First Name Phone Hasegawa Keoki Elaine Kahane Brian Gonzalez Aldo Taliafea Moses Concepcion Rafael 111-2222 313-3455 6469387 123-2345 545-2323 602-3312 Date Joined 2/20/2002 2/20/2004 5/20/2008 66/2009 5/20/2005 5/20/2007 6. Advanced Karate Member Dates (Extra challenge project) Enhance the program you created in Programming Chall lenge 5 by giving the user a choice between displaying members who have joined be fore a given date or members who have joined on or after that date. In Figure 10-84, 9 arting out wi..pdf 8 karatemembers.zip t Show all downloads HP O GQ Owev3 N a 19.4 13.04.2016

Explanation / Answer

Try the below code and add the required table name and fields instead of selecting all the fields from database. The below code is skeleton for your question and may it help you....

using System;
using System.Data;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace WindowsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

       string connectionString = "Data Source=.;Initial Catalog=pubs;Integrated Security=True";
SqlConnection connection = new SqlConnection(connectionString);
      
       private void radioButtons_CheckedChanged(object sender, EventArgs e)
{
           RadioButton rb = sender as RadioButton;
      
       if (rb != null && rb.Text=="after")
       {
           if (rb.Checked)
           {
        string sql = "SELECT * FROM Members";
               SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);
               DataSet ds = new DataSet();
               connection.Open();
               dataadapter.Fill(ds, "Members_table");
               dataGridView1.DataSource = ds;
               dataGridView1.DataMember = "Members_table";
               connection.Close();
           }
}
   else if (rb != null && rb.Text=="before")
       {
           if (rb.Checked)
           {
        string sql = "SELECT * FROM Members";
               SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);
               DataSet ds = new DataSet();
               connection.Open();
               dataadapter.Fill(ds, "Members_table");
               dataGridView1.DataSource = ds;
               dataGridView1.DataMember = "Members_table";
               connection.Close();
           }
}
  
       }
}
}

Related Questions

Navigate

• Browse (All)
• Browse 6
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.