ITSourceCode.com

We Exist to Provide 100% Free Source Code and Tutorials

Custom Search

Multiple Save Using C# and SQL Server

mulitiSaveSQLPI

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 2008 and create new Windows Form Application for C#. Then do the following design of a Form as shown below.

mulitiSaveSQLfig.1

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

mulitiSaveSQLfig.2

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:

mulitiSaveSQLPI

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 – jannopalacios@gmail.com
Mobile No. – 09305235027 – tnt

 

Download Sourcecode

Facebook Comments

Check Your Domain Ranking

Leave a Reply

Your email address will not be published. Required fields are marked *

ITSourceCode.com © 2016 Frontier Theme

Subscribe For Latest Updates

Signup for our newsletter and get notified when we publish new articles for free!