Hi all,
   I have two question,First:Is how will data export to excel in datagridview.Second:
Is how will data import  to database in excel.
Thanks in advance.

hello aken,
Here are the solution of your both the problem:

Export Data from Excel in dataGridView:

Write the below code on the button click or on form load function:

using System.Data.OleDb;

OleDbConnection oledbCon = null;
 DataTable dt = null;
string csExcel = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\\rohit\\File.xlsx;Extended Properties=\"Excel 8.0;HDR=Yes;\" ";
oledbCon = new OleDbConnection(csExcel);
 oledbCon.Open();
 dt = oledbCon.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
oledbCon.Close();
String[] excelSheets = new String[dt.Rows.Count];
DataRow row = dt.Rows[0];

oledbCon.Open();
 OleDbDataAdapter oledbAdapter = new OleDbDataAdapter("select * from [" + row["TABLE_NAME"].ToString() + "]", oledbCon);
oledbCon.Close();
DataSet excelDataSet = new DataSet();
oledbAdapter.Fill(excelDataSet, "student");
DataTable excelTable = excelDataSet.Tables["student"];
dataGridView1.DataSource = excelTable;

Import Data from dataGridView in Excel:

using System.Data.OleDb;

OleDbConnection oledbCon = null;
DataTable dt = null;
string csExcel = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\\rohit\\File.xlsx;Extended Properties=\"Excel 8.0;HDR=Yes;\" ";
oledbCon = new OleDbConnection(csExcel);
oledbCon.Open();
dt = oledbCon.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
oledbCon.Close();
String[] excelSheets = new String[dt.Rows.Count];
DataRow row = dt.Rows[0];
 oledbCon.Open();
 for (int i = 0; i < dataGridView1.Rows.Count-1; i++)
{
  OleDbCommand cmd = new OleDbCommand("insert into [" + row["TABLE_NAME"].ToString() + "] values ('" +        
  dataGridView1.Rows[i].Cells[0].Value.ToString() + "','" + dataGridView1.Rows[i].Cells[1].Value.ToString() + "')", 
   oledbCon);
 cmd.ExecuteNonQuery();
 }
oledbCon.Close();


Happy Coding.

hi Rohit Kesharwani,

private void btnExportToExcel_Click(object sender, EventArgs e)
  
 {

      
    List<DataGridViewRow> rows_with_checked_column=new List<DataGridViewRow>();
                foreach (DataGridViewRow row in dgv.Rows)
 
        {
  
           if (Convert.ToBoolean(row.Cells[0].Value) == true)
 
           //if value is true then start export to excel.
           //how to write code?
 
        {
                                
  }

hi,

If you want that only checked rows will be exported then simply manipulate the above code:

List<DataGridViewRow> rows_with_checked_column = new List<DataGridViewRow>();

            foreach (DataGridViewRow rows in dataGridView1.Rows)

            {

                if (Convert.ToBoolean(rows.Cells[0].Value) == true)

                {

                    oledbCon.Open();

                    OleDbCommand cmd = new OleDbCommand("insert into [" + row["TABLE_NAME"].ToString() + "] values ('" + rows.Cells[1].Value.ToString() + "','" + rows.Cells[2].Value.ToString() + "')", oledbCon);

                    cmd.ExecuteNonQuery();

                    oledbCon.Close();

                }

            }

 

Thanks.

hi Rohit Kesharwani,

  i not used using System.Data.OleDb; i want used using System.Data.SqlClient;

  Thank you always help me, I hereby express my sincere thank you.

Hi aken H..
You can make following modification on above code

using System.Data.SqlClient;  //import this namespace at top

then replace OleDbCommand by SqlCommand class.

Then above code also work for you.

Thanks.

Thanks Rohit. It helps me a lot.

use namespace:
using System.Data.SqlClient;

You got it aken :)

hi Awadhendra Tiwari,Rohit Kesharwani,

      Thank you for your help,Thanks Rohit Kesharwani . he helps me a lot.

again  ask a question:

you can provide LINQ learning resources to me,and LINQ in project the integrated application.

Grateful.

 

Hi Aken H,
You can take a look at following link for learning linq

http://msdn.microsoft.com/en-us/vcsharp/aa336766
http://geekswithblogs.net/elroydsilva/archive/2008/11/03/learning-linq---an-overview.aspx

http://www.linqlearning.com/sp/16295-LINQ-to-SQL-Tutorials-Learning-Resources/

Thanks.

Thanks Awadhendra for the links. It helped me.

Hi all,
thanks Awadhendra Tiwari,It helps me a lot. 

 

Thanks.

Thanks Rohit this code work for me.

Yes really good one...

Hi all..
This is really good.
Can any one give me some example of datagridview demo in c#. So i can make a complete program on it.

Thanks,

Hi Aken..

You can use following link to export data from excel to data-grid view,

http://support.microsoft.com/kb/321686

Thanks,