Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Read Text file to dataset

Author  Topic 

shruthi_R
Starting Member

10 Posts

Posted - 2007-03-26 : 09:28:51
with the help of the following code am able to read the text file
now i need to insert values to the datatable in dataset
can anybody help me on this regard

string path = Server.MapPath("Account.txt");
StreamReader sr = File.OpenText(path);
string contents = sr.ReadToEnd();
Label1.Text = contents;
Label1.Text = contents.Replace(Environment.NewLine,"<br>");
sr.Close();


how shall i spilt them and add each value to two fields of the datatable

for example i have the fields in text file as
Username1:Password1
Username2:Password2
etc
i need to add the username seperatelt to a field called username in table
and password in password field of the datatable
an example with code would be better and helpful

thanks
shruhti

X002548
Not Just a Number

15586 Posts

Posted - 2007-03-26 : 09:52:14
bcp?



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page
   

- Advertisement -