Simple and Effective CRM: Windows Application

It's simple but effective CRM; Windows applications using a Microsoft Access database.

1. First of all design the form like this then use code as in the following:

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;

namespace Combobox_related_datagridview

{

public partial class Form2 : Form

{

public Form2()

{

InitializeComponent();

}

private void groupBox2_Enter(object sender, EventArgs e)

{

}

private void pictureBox4_Click(object sender, EventArgs e)

{

if (textBox3.Text == "Astro" && textBox4.Text == "Acoglobal")

{

Form3 f3 = new Form3();

f3.Show();

this.Hide();

}

else

{

errorProvider1.SetError(textBox3, "error");

errorProvider1.SetError(textBox4, "error");

label5.Text = "Login Details Wrong";

}

}

private void textBox4_TextChanged(object sender, EventArgs e)

{

}

}

}

• Now design the second form like it.
• And the code is like the following:
  
  
  

  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;

  namespace Combobox_related_datagridview

  {

  public partial class Form3 : Form

  {

  public Form3()

  {

  InitializeComponent();

  }

  private void progressBar1_Click(object sender, EventArgs e)

  {

  }

  private void Form3_Load(object sender, EventArgs e)

  {

  progressBar1.Maximum = 60;

  }

  private void timer1_Tick(object sender, EventArgs e)

  {

  fn_prbar_();

  }

  public void fn_prbar_()

  {

  progressBar1.Increment(1);

  if (progressBar1.Value == progressBar1.Maximum)

  {

  timer1.Stop();

  MessageBox.Show("Database has been connected");

  timer1.Stop();

  this.Hide();

  Form1 f1 = new Form1();

  f1.Show();

  }

  }

  }

  }

• Now the 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)

  {

  }

  }

  }