Simple and Effective CRM: Windows Application

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

CRM

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:

    Code
     

    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.

    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)

            {

            }

        }

Next Recommended Readings