import excel dsta to databse

Question

3.00/5 (3 votes)

See more:

import excel dsta to databse ,I use the code in link:

http://www.dotnetspider.com/resources/42912-Read-Excel-Data-Show-GridView-asp-net.aspx[^]

but here there is no connection code and table specification .I think it is in webconfig.How to do this .
Any one please help me.

Posted 22-Aug-12 21:14pm

Shibiny

Add a Solution

Comments

[no name] 23-Aug-12 4:00am

You should search it first, there are many question like yours, even in CodeProject.
http://www.codeproject.com/Answers/392693/how-to-import-excel-into-database.aspx#answer1

3 solutions

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)

pramod.hegde · Answer 1 · 2012-08-22T21:16:00

Solution 1

Perhaps this article would help
SQL Import Data from Excel[^]

Posted 22-Aug-12 21:16pm

pramod.hegde

uspatel · Answer 2 · 2012-08-22T21:23:00

Solution 2

try this article
Import Data from Excel to SQL Server[^]

Posted 22-Aug-12 21:23pm

uspatel

Ali91Asadi · Answer 3 · 2012-10-14T00:11:00

DataTable data = new DataTable();
 string ExtraConnection = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + openExcelFile.FileName + ";Extended Properties=\"Excel 8.0;IMEX=1;HDR=" + "YES" + "\"");

private void InsertToDataTable(string ExtraConnection)
     {

         using (OleDbConnection connection = new OleDbConnection(@ExtraConnection))
         {

             OleDbCommand command = new OleDbCommand("SELECT * FROM " + txtSheet.Text, connection);
             command.CommandTimeout = 20;
             connection.Open();
             OleDbDataAdapter SDA = new OleDbDataAdapter(command);
             OleDbCommandBuilder SCB = new OleDbCommandBuilder(SDA);
             DataSet m_DataSet = new DataSet();
             SDA.Fill(m_DataSet);
             connection.Close();
             foreach (DataTable table in m_DataSet.Tables)
                 foreach (DataRow row in table.Rows)
                     data.Rows.Add(row.ItemArray);


         }}

C#

using (SqlConnection connection = new SqlConnection(@"Data Source=pyton-exploit;Initial Catalog=SchoolManagement;User ID=AliAsadi;Password=visualc#2010@#"))
         {

             connection.Open();
             using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection))
             {
                 
                     bulkCopy.DestinationTableName = "tblTeacher";
                     bulkCopy.WriteToServer(data);
                     
                     lblSave.ForeColor = System.Drawing.Color.Green;
                 }}

Load Data from excel and write "DataTable" to SQL Server Table