-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: Dharam
Message 2 in Discussion
hi veeresh
this how u can read data from an excel file using jet oledb provider.once u
get the data in the dataset u can use this dataset as usual. ofcourse u
should know the name of columns in excel file and there should be column
names in the excel file in the first row thats how oledb provider reads it
and returns data.so u can then enter the data in the dataset using this
dataset
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source="+Server.MapPath(".")+"\\abc.xls;"+
"Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]",
strConn);
DataSet myDataSet = new DataSet();
ds = new DataSet();
myCommand.Fill(myDataSet);
dharmesh
----- Original Message -----
From: "MumbaiUserGroup" <[EMAIL PROTECTED]>
To: "MumbaiUserGroup" <[EMAIL PROTECTED]>
Sent: Saturday, August 09, 2003 10:08 AM
Subject: MS-Word/Excel (Urgent)
-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: contactveeru
Message 1 in Discussion
Hi,
My Client Requirement:
In my project i have to take the data entry about a category. but otherthan
description of the category data everything can be take with WinControls
(TextBox and DropDownList), for Description they need to enter in
MS-Word/MS-Excel, becoz in description they might have table formats. And
that MS-Word/MS-Excel document should be different for each Category. So
which is the way to open MS-Word/MS-Excel document, how to store these
details in database. Is secured if we store this data in Physical
Directory. Please give reply very soon. Thanks In Advance
Veeresh
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your
E-mail Settings.
http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On
the pre-addressed e-mail message that opens, simply click "Send". Your
e-mail address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]