-----------------------------------------------------------

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]

Reply via email to