Multiple Save Using C# and SQL Server

Multiple Save Using C# and SQL Server

Saving data in the database takes you a lot of time but, In this tutorial I will teach you how to save multiple data using C# and SQL server 2005. With the use of this method, it wil lessen your work when saving data in the database.This method has the ability to save multiple data in just a click.

Let’s begin:

Create a database and name it “employeedb”.

After creating the database, open Microsoft Visual Studio and create new Windows Form Application for C#. Then do the following design of a Form as shown below.

Go to the Solution Explorer, double click the “View Code”  to display the code editor.

In the code editor, declare all the classes and variables that are needed.

Note: Put using System.Data.SqlClient; above the namespace to access sql server library.

 //initialize all classes
 SqlConnection conn = new SqlConnection();
 SqlCommand cmd = new SqlCommand();
 SqlDataAdapter da = new SqlDataAdapter();
 DataTable dt = new DataTable();

 //declaring variables
 string query;
 int result;

After declaring the classes and variables, establish a connection betweenSQL server and C#.net in the first load of the Form.

private void Form1_Load(object sender, EventArgs e)
 {
 conn.ConnectionString = "Data Source=.\\SQLEXPRESS;database=employeedb;trusted_connection=true;"; 
 }

After that, double click the “Save” button and do the following code in the method. This code is for saving multiple data in just a click.

private void button1_Click(object sender, EventArgs e)
 {

 try
 {
 //opening connection
 conn.Open();

 int maxrow = dataGridView1.Rows.Count - 2;
 //create a loop for getting the total rows in the datagridview that have filled up.
 for (int i = 0; i <= maxrow ; i++)
 {
 //create an insert query;
 query = "INSERT INTO tblemployee (Name,Address,Contact,Emailadd) VALUES('"
 + dataGridView1.Rows[i].Cells[0].FormattedValue +"','"
 + dataGridView1.Rows[i].Cells[1].FormattedValue +"','"
 + dataGridView1.Rows[i].Cells[2].FormattedValue +"','"
 + dataGridView1.Rows[i].Cells[3].FormattedValue +"')";

 //it holds the data to be executed.
 cmd.Connection = conn;
 cmd.CommandText = query;
 //execute the data.
 result = cmd.ExecuteNonQuery();
 }
 

 //validate the result of the executed query.
 if (result > 0)
 {

 MessageBox.Show("Data has been saved in the SQL database");
 
 }
 else
 {
 MessageBox.Show("SQL QUERY ERROR");
 }
 //closing connection
 conn.Close();

 }
 catch (Exception ex)//catch exeption
 {
 //displaying error message.
 MessageBox.Show(ex.Message);
 }

 }
 }

Output:

For all students who need programmer for your thesis system or anyone who needs a sourcecode in any programming languages. You can contact me @ :
Email – [email protected]
Mobile No. – 09305235027 – tnt

Download Sourcecode