How to Bind Data from DataBase to Pie Chart control in Windows using C#.Net

To implement this concept you need to follow the below steps : 

Step1 :
First you need to design a table in Sql Database to retrieve the records from database.

Step2:
On the File menu, click New Project. Select Windows Forms Application as your project type.
Design the Form using controls from Toolbox.

Step3:
Now open the Form.cs page and write the following source code.

Form.CS 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;

using System.Collections;

namespace Pie_Charts_Sample

{

    public partial class Form1 : Form

    {

        SqlHelper sql = new SqlHelper();

        public Form1()

        {

            InitializeComponent();

            ShowPieChart();

         

        }

        private void ShowPieChart()

        {

            Hashtable ht = new Hashtable();

            DataSet ds = sql.ExecuteProcudere("Student_Marks ", ht);

            DataTable dt = ds.Tables[0];

            PieChart.DataSource = dt;

            PieChart.Series["Series1"].XValueMember = "Name";

            PieChart.Series["Series1"].YValueMembers = "Percentage";

            PieChart.DataBind();

        }

    }

}

Step4:
Now build the Solution and Debug it for the output.

OutPut : 

How to Bind Data to ComboBox from Database in Windows Form || How to Set Default Select Item in ComboBox using C#.Net.

To implement this concept you need to follow the below steps :

Step1 :
First you need to design a table in Sql Database to retrieve the records from database.

Step2:
On the File menu, click New Project. Select Windows Forms Application as your project type.
Design the Form using controls from Toolbox.

 

Step3: 

Now open the Form.cs page and write the following source code.

Form.cs 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;

using System.Data.SqlClient;

namespace combox_binding

{

    public partial class Form1 : Form

    {

        SqlConnection con = new SqlConnection("Data Source=sridhar;Initial Catalog=employee;User ID=sa;Password=123");

        public Form1()

        {

            InitializeComponent();

            bind();

        }

        private void bind()

        {

            con.Open();

            SqlDataAdapter da = new SqlDataAdapter("Select empID,empname from emp", con);

            DataTable dt = new DataTable();

            da.Fill(dt);

            DataRow dr;

            dr = dt.NewRow();

            dr.ItemArray = new object[] { 0, "---Select an item---" };

            dt.Rows.InsertAt(dr, 0);

            comboBox1.DisplayMember = "empname";

            comboBox1.ValueMember = "empID";

            comboBox1.DataSource = dt;

            con.Close();

        }

    }

}

Step4:
Now build the Solution and Debug it for the output.

OutPut : 

How to Insert, Edit, Update and Delete Data in DataGridView using Windows Form C#.Net.

To implement this concept you need to follow the below steps :

Step1 :

First you need to design a table in Sql Database to insert and retrieve the records in database.

Step2:

On the File menu, click New Project. Select Windows Forms Application as your project type.

Design the Form using controls from Toolbox.

Step3:

Now open the Form.cs page and write the following source code.

Form.cs 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;

using System.Configuration;

using System.Data.SqlClient;

namespace savedatatomdf

{

    public partial class Form1 : Form

    {

        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Sqlcon"].ConnectionString);

        public Form1()

        {

            InitializeComponent();

            Bind();

        }

        private void Clear()

        {

            txtName.Text = string.Empty;

            txtLocation.Text = string.Empty;

        }

        private void btnSave_Click(object sender, EventArgs e)

        {

            con.Open();

            SqlCommand cmd = new SqlCommand("Insert Into Test_Data(Name,Location) Values (@Name,@Location)", con);

            cmd.Parameters.AddWithValue("Name", txtName.Text);

            cmd.Parameters.AddWithValue("Location", txtLocation.Text);

            cmd.ExecuteNonQuery();

            con.Close();

            MessageBox.Show("Inserted sucessfully");

            Bind();

            Clear();

        }

        private void Bind()

        {

            con.Open();

            SqlDataAdapter da = new SqlDataAdapter("select * from Test_Data", con);

            DataTable dt = new DataTable();

            da.Fill(dt);

            dataGridView1.DataSource = dt;

            con.Close();

        }

        private void btnDelete_Click(object sender, EventArgs e)

        {

            SqlCommand delcmd = new SqlCommand();

            if (dataGridView1.Rows.Count > 1 && dataGridView1.SelectedRows[0].Index != dataGridView1.Rows.Count - 1)

            {

                delcmd.CommandText = "DELETE FROM Test_Data WHERE ID=" + dataGridView1.SelectedRows[0].Cells[0].Value.ToString() + "";

                con.Open();

                delcmd.Connection = con;

                delcmd.ExecuteNonQuery();

                con.Close();

                dataGridView1.Rows.RemoveAt(dataGridView1.SelectedRows[0].Index);

                MessageBox.Show("Row Deleted");

            }

            Bind();

        }

        private void btnUpdate_Click(object sender, EventArgs e)

        {

            con.Open();

            SqlCommand cmd = new SqlCommand("Update Test_Data set Name=@Name,Location=@Location Where(Name=@Name)", con);

            cmd.Parameters.AddWithValue("@Name", txtName.Text);

            cmd.Parameters.AddWithValue("@Location", txtLocation.Text);

            cmd.ExecuteNonQuery();

            MessageBox.Show("updated......");

            con.Close();

            Bind();

            Clear();

        }

        private void btnEdit_Click_1(object sender, EventArgs e)

        {

            int i;

            i = dataGridView1.SelectedCells[0].RowIndex;

            txtName.Text = dataGridView1.Rows[i].Cells[1].Value.ToString();

            txtLocation.Text = dataGridView1.Rows[i].Cells[2].Value.ToString();

        }

    }

}

Step4:
Now build the Solution and Debug it for the output.

Output :