Now the final one.
![final one]()
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Collections.Specialized;
namespace Combobox_related_datagridview
{
public partial class Form1 : Form
{
string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["Astro"];
OleDbCommand com;
OleDbDataAdapter oledbda;
DataSet ds;
string str;
string str2;
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
comboBox1.Hide();
comboBox2.Hide();
dataGridView1.Hide();
textBox9.Hide();
pictureBox5.Hide();
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
OleDbConnection con = new OleDbConnection(ConnectionString);
con.Open();
str = "select * from Sheet1 where Region='" + comboBox1.Text + "'";
com = new OleDbCommand(str, con);
oledbda = new OleDbDataAdapter(com);
ds = new DataSet();
oledbda.Fill(ds, "Sheet1");
dataGridView1.DataMember = "Sheet1";
dataGridView1.DataSource = ds;
con.Close();
}
private void label1_Click(object sender, EventArgs e)
{
}
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
OleDbConnection con = new OleDbConnection(ConnectionString);
con.Open();
str2 = "select * from Sheet1 where Courses='" + comboBox2.Text + "'";
com = new OleDbCommand(str2, con);
oledbda = new OleDbDataAdapter(com);
ds = new DataSet();
oledbda.Fill(ds, "Sheet1");
dataGridView1.DataMember = "Sheet1";
dataGridView1.DataSource = ds;
con.Close();
}
private void button1_Click(object sender, EventArgs e)
{
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
DataGridViewRow row = this.dataGridView1.Rows[e.RowIndex];
textBox1.Text = row.Cells["Participants Name"].Value.ToString();
textBox2.Text = row.Cells["Organization"].Value.ToString();
textBox3.Text = row.Cells["Contact No"].Value.ToString();
textBox4.Text = row.Cells["Email ID"].Value.ToString();
textBox5.Text = row.Cells["Courses"].Value.ToString();
textBox6.Text = row.Cells["Region"].Value.ToString();
textBox7.Text = row.Cells["ID"].Value.ToString();
}
}
private void button2_Click(object sender, EventArgs e)
{
}
private void pictureBox1_Click(object sender, EventArgs e)
{
}
private void textBox3_TextChanged(object sender, EventArgs e)
{
}
private void textBox2_TextChanged(object sender, EventArgs e)
{
}
private void label6_Click(object sender, EventArgs e)
{
}
private void textBox5_TextChanged(object sender, EventArgs e)
{
}
private void label9_Click(object sender, EventArgs e)
{
}
private void label8_Click(object sender, EventArgs e)
{
}
private void pictureBox3_Click(object sender, EventArgs e)
{
System.Diagnostics.Process.Start("D:\\Dhiraj\\SQL Alumni data\\Combobox related datagridview\\Astrowix CRM\\Reminder_APP.exe");
}
private void pictureBox1_Click_1(object sender, EventArgs e)
{
MessageBox.Show("Thank You For Using Astrowix Database..");
this.Hide();
}
private void pictureBox4_Click(object sender, EventArgs e)
{
}
private void label5_Click(object sender, EventArgs e)
{
}
private void comboBox3_SelectedIndexChanged(object sender, EventArgs e)
{
//comboBox3.Text = "Select your ID";
if (comboBox3.SelectedIndex == 0 || comboBox3.SelectedIndex == 1 || comboBox3.SelectedIndex == 2 || comboBox3.SelectedIndex == 3)
{
label11.Text = "Welcome " + comboBox3.Text + " Start Calling...";
comboBox1.Show();
comboBox2.Show();
dataGridView1.Show();
comboBox3.Hide();
pictureBox5.Show();
textBox9.Show();
OleDbConnection con = new OleDbConnection(ConnectionString);
con.Open();
str = "select * from Sheet1";
com = new OleDbCommand(str, con);
comboBox1.Text = "Select any Region";
comboBox1.Items.Add("Select any Region");
comboBox1.Items.Add("Delhi");
comboBox1.Items.Add("Mumbai");
comboBox1.Items.Add("Bangalore");
comboBox1.Items.Add("Chandigarh");
comboBox1.Items.Add("Hyderabad");
comboBox1.Items.Add("Bhubaneshwar");
comboBox1.Items.Add("Chennai");
comboBox1.Items.Add("Cochin");
comboBox1.Items.Add("Gurgaon");
comboBox1.Items.Add("Guwahati");
comboBox1.Items.Add("Indore");
comboBox1.Items.Add("Kolkata");
comboBox1.Items.Add("Noida");
comboBox1.Items.Add("Pune");
comboBox1.Items.Add("Trivandrum");
comboBox2.Text = "Select any Course";
comboBox2.Items.Add("Select any Course");
comboBox2.Items.Add("PMP");
comboBox2.Items.Add("MSP");
comboBox2.Items.Add("ITIL");
str2 = "select * from Sheet1";
com = new OleDbCommand(str2, con);
OleDbDataReader reader = com.ExecuteReader();
// while (reader.Read())
// {
// comboBox1.Items.Add(reader["Region"].ToString());
// comboBox2.Items.Add(reader["Courses"].ToString());
// }
//
con.Close();
reader.Close();
}
else
{
label11.Text = "Please Select your ID";
}
}
private void button1_Click_1(object sender, EventArgs e)
{
}
}
}