hello ....
I'm doing my assignment and facing some problem.
The problem is I don't know how to read data from text file or excel file and store it into database.
Can anyone help please.........
how to import data?
Hot Topic
VS Express Editions
- TableAdapter.Update does not save data
- Cannot download any of the free books?
- Sifting through array for matches
- vwd 2005 express beta 2 and final .net framework 2
- Can I use the menu icons?
- VC++ Need explanation of message please.
- Visual Basic 2005 Express Edition Data Binding is not updating the database
- Class Modeling
- Why The H*ll Doesn't This Work
- How can I have program "follow" user from workstatation to workstation.
how to import data?
LoisW
Thanks for ur reply Kal...
but my situation is ...my system have a system call import..which allow user to import a file (content of the file might be e.g student ID and student name)...
so how can I read it from file and store the student ID and student name into my database for the student ID field and student name field
tanitoUy
hi, angelLee
to read from file that depend on the file type hat you want to use , so you have to determine which file type that you want to use as datastorage to find proper way to connect to it and to retireve data from it, and how data is formated in this file
hope this helps
madog5353
Reading Data from a text file
suppose ur text file in this location:c:\\hello.txt;
streamreader s=new streamreader(@"C:\\hello.txt");
textbox1.text=s.ReadToEnd();