I have to save excel sheet data into table plz tell me somthng with coding after this what i have to write to save the data

Question

0.00/5 (No votes)

See more:

String sPath = Server.MapPath("./UploadedReports") + "/" + Convert.ToString(Session["path"]);
        string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + sPath + "; Extended Properties=\"Excel 12.0;HDR=No;IMEX=1;\"";

        OleDbConnection objConn = new OleDbConnection(strConn);
        try
        {
            // Code to save Final Report Header.
            FinalReportHeader objrep = new FinalReportHeader();
            objrep.UserId = Convert.ToInt32(Session["UserId"]);
            objrep.SubmitMonth = Convert.ToDateTime(TxtDate.Text);
            objrep.ReportId = Convert.ToInt32(ddrepname.SelectedItem.Value);
            objrep.ReportName = Convert.ToString(ddrepname.SelectedItem.Text);
            objrep.path = Convert.ToString(Session["path"]);
            objrep.remarks = Txtremark.Text;
            objrep.InsertReport();
 // Code to save Final Report Header.
            FinalReportDetail objFRD = new FinalReportDetail();
             DataTable dt = new DataTable();
            if (objConn.State == ConnectionState.Closed)
            {
                objConn.Open();
            }
            dt = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
            DataSet myDataset = new DataSet();
            OleDbDataAdapter myData = new OleDbDataAdapter("SELECT * FROM [" + dt.Rows[0]["TABLE_NAME"] + "]", strConn);
            myData.TableMappings.Add("Table", "ExcelTest");
            myData.Fill(myDataset);
             //for (int i = 0; i < myDataset.Tables[0].Rows.Count; i++)
            //{

Posted 3-Aug-11 0:55am

priyaverma2023

Updated 3-Aug-11 0:58am

Syed Salman Raza Zaidi

v2

Add a Solution

Comments

Syed Salman Raza Zaidi 3-Aug-11 6:59am

Whats the problem arising?

BobJanova 3-Aug-11 8:01am

What is your question? myDataset should include the data you want at the end of that code.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Yogesh Pednekar · Answer 1 · 2011-08-03T08:30:00

In following code i moving the data from excel to grid view.
I am using one file upload control of asp.net
location of excel file is fixed in my project but u can select it from anywhere in your computer using file upload control property.

So now you have to transfer the data to table from grid, i hope that u know.

button_clik()

DataTable dt = new DataTable();
// string target = Server.MapPath("~/Excel");

if (FileUpload1.HasFile)
{

string pathname = "D:\\Test.xls";

string connectionString = String.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=""Excel 8.0;HDR=YES;IMEX=1;""", pathname);

OleDbConnection oledbConn = new OleDbConnection(connectionString);//@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + pathname + ";\'Extended Properties=Excel 8.0\'");
try
{
// Open connection
oledbConn.Open();

// Create OleDbCommand object and select data from worksheet Sheet1
OleDbCommand cmd = new OleDbCommand("SELECT * FROM [Sheet1$]", oledbConn);

// Create new OleDbDataAdapter
OleDbDataAdapter oleda = new OleDbDataAdapter();

oleda.SelectCommand = cmd;

// Create a DataSet which will hold the data extracted from the worksheet.
DataSet ds = new DataSet();

// Fill the DataSet from the data extracted from the worksheet.
oleda.Fill(ds, "Employees");

// Bind the data to the GridView
//GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
GridView1.Visible = true;

}
catch
{

}
finally
{
// Close connection
oledbConn.Close();
}
}

}

Jagriti30-05-11 proof load