codetoad.com
  ASP Shopping CartForum & BBS
  - all for $20 from CodeToad Plus!
  
  Home || ASP | ASP.Net | C++/C# | DHTML | HTML | Java | Javascript | Perl | VB | XML || CodeToad Plus! || Forums || RAM 
Search Site:
Search Forums:
  Import Excel File to sql server database...  mancy at 10:48 on Wednesday, March 08, 2006
 

Hi friends i need to import data from Excel file to sql server database. i got code for importing data from Excel to datagrid now i need to push the data to server database.

The code i got is..

string sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Server.MapPath("/forum//ExcelData.xls") + ";" + "Extended Properties=Excel 8.0;";

OleDbConnection objConn = new OleDbConnection(sConnectionString);

objConn.Open();

OleDbCommand objCmdSelect =new OleDbCommand("SELECT * FROM MyRange1 ", objConn);

OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();

OleDbCommandBuilder custCB = new OleDbCommandBuilder(objAdapter1);

objAdapter1.SelectCommand = objCmdSelect;

DataSet objDataset1 = new DataSet();

objAdapter1.AcceptChangesDuringFill =false;

objAdapter1.Fill(objDataset1, "Sample1");

DataGrid2.DataSource = objDataset1.Tables[0].DefaultView;

DataGrid2.DataBind();

objConn.Close();



pl help me to push data from datagrid2 to server table called "Projects".

mancy.

  Re: Import Excel File to sql server database...  onlyukta at 09:55 on Wednesday, March 22, 2006
 

Hi!
I m also working on the same concept. Did u finish importing the data to SQL server??? Can u pls guide me in this since I m a beginner, a student currently working on this project....Plzzzzzzzz help me!!! I want to know how to read data from a particular excelsheet when more than one exists in an excel workbook??? Plz help! Thanks a lot!!!
Regards,
Yukta.

  Import Excel File to sql server database...  mancy at 11:13 on Monday, April 03, 2006
 

hi try this code..

private void DataGrid2_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)

{
string sconnection="Provider=SQLOLEDB;data source=DEVELOPMENT;Initial catalog=ProjMgmt;User Id=ProjMgmt;password=priya;";
OleDbConnection obj=new OleDbConnection(sconnection);
obj.Open();
OleDbCommand objCmdsel=new OleDbCommand("SELECT * FROM Projects",obj);
OleDbDataAdapter objAdapt1=new OleDbDataAdapter();
OleDbCommandBuilder cust=new OleDbCommandBuilder(objAdapt1);
objAdapt1.SelectCommand=objCmdsel;
objAdapt1.Fill(ds,"Projects");
DataTable dbTable = ds.Tables["Projects"];
DataRow dbRow = dbTable.NewRow();
dbRow["UserID"] = Convert.ToString(e.Item.Cells[0].Text);
dbRow["ProjName"] =Convert.ToString(e.Item.Cells[1].Text);
dbRow["ProjStartDate"] =Convert.ToDateTime(e.Item.Cells[2].Text);
dbRow["ProjEndDate"] =Convert.ToDateTime(e.Item.Cells[3].Text);
dbTable.Rows.Add(dbRow);
// Update data source
objAdapt1.Update(ds,"Projects");
obj.Close();
}








CodeToad Experts

Can't find the answer?
Our Site experts are answering questions for free in the CodeToad forums








Recent Forum Threads
•  do static member are inherited
•  Re: Help with Using DataReader with StoredProcedure
•  Perl Script Output (w3c validator)
•  Re: HashMap question
•  focus management?
•  Looping Issue...Please help!
•  regarding hibernate
•  working with plugins
•  Checkbox Validation help.


Recent Articles
What is a pointer in C?
Multiple submit buttons with form validation
Understanding Hibernate ORM for Java/J2EE
HTTP screen-scraping and caching
a javascript calculator
A simple way to JTable
Java Native Interface (JNI)
Parsing Dynamic Layouts
MagicGrid
Caching With ASP.Net


© Copyright codetoad.com 2001-2006