|
Hi friends,
I have to open a text file in with .txt extension..
For this ,am using oledbConn,oledbCommand,oledbReader to read the text file...
I can retrieve the files with their name as "File1.txt","test.txt" etc(as normal filenames)...but if i try to retreive file of name as "test.test.txt","sample.text.txt"....that is,if there is "." in the name of the textfile other than what we use for the extension(.txt),...i could nt retreive...
It displays exception...
Is it possible to retreive the textfile names like this?
Kindly tackle this...
Thanx
Jimmy
|
|
|
|
|
|
Thanx Christian...
One Doubt....y not we open the textfile with oledbreader..any disadvantage other than what i have queried....
Kindly tell me...
|
|
|
|
|
Mahi.V.Ragava wrote: y not we open the textfile with oledbreader
It's just not what it's for. I'm amazed that it works.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Actually ,i have to open the textfile using oledbreader..that is my scenario....
The same condition proves for Excel and Access files,and y not for TextFile...
Thats y am asking whether its possible to read files with '.' in the file's name other than the extension...
Kindly help me.....
|
|
|
|
|
Mahi.V.Ragava wrote: The same condition proves for Excel and Access files,and y not for TextFile...
Why do you need to use the same method when reading from completely different file types ?
Google for 'read text file C#' and see if you find one example that says to use oledbreader.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Ya ,i can....
When i read a textfile with name like "file1.txt","some.txt",its working na...
When i try to read the file with name like "somename.some.txt"....alone,its not working....
Thats y am asking about it repeatedly...Dont mistake Christ...
Happy Coding....
|
|
|
|
|
I'm understanding that it's sometimes working for you, I'm saying that if you get on the web and look to see what other people do, that no-one uses this class to read text files, a totally different class is provided for doing this.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Thanx christ...
Its working....
Am going to use this in my coding...
Can i query you for some other douts too?
|
|
|
|
|
Ask whatever you like, but do it in a new question, so that if I can't answer, others can see what you're asking about.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
christ,
If we read the file using streamreader,if i want to fetch the data columnwise,how can i get it?
We can use ReadLine() to read the contents line by line(row-wise),but for reading columnwise???????
Kindly help me.....
|
|
|
|
|
You can use the split function on the string class to split by , for example, assuming a CSV.
I didn't realise you were reading a CSV, I can see why OleDBReader might provide functionality for that. I thought you were just reading a bunch of text.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Thanx Christ for realising the functionallity...
This is been a big headache for me since three days...
If anybody finds the solution,kindly help me ..Am in an urgency to finish it off...
Thanx
|
|
|
|
|
Christian Graus wrote: Why do you need to use the same method when reading from completely different file types ?
Why not? I assume it is some kind of csv file and OleDb can handle all of them in a very similar way. If I remember correctly there is even one example for this somewhere on MSDN.
|
|
|
|
|
Try putting [] around the filename when building your queries.
|
|
|
|
|
hi friends,
Am using [ ] for retreiving file...
The error message is that "Microsoft jet engine could not find the file named test.test.txt.Check whether the spell is correct or not"..Like this...
Thanx
|
|
|
|
|
Standard question #2:
What error message do you get?
---
b { font-weight: normal; }
|
|
|
|
|
hi,thanks for your reply message,
but,
i know i can have an array of form in MDI,
and access to activechild by this.activechild,
now i want to access to activeownedform in OWNER,OWNED FORMS,
and i can arrange my childs in MDI by MDILAYOUT,
how i can arrange my OWNEDFORMS?
so thanks.
have fun.
parastoo
|
|
|
|
|
|
I need a suggestion on opening SQL Connection
Is it better for me to open and close the connection on each form that accces the data or i create i static connection that last thourgh to application run time, then close it..
I got a few feedback saying..
some say if i open and close connection each it may effect the performance and some say that if i open and static connection it will cause memory problem..
for ur info currently i doing with 1 static connection..
please give me an explanation on this issue
thanks
|
|
|
|
|
Open and close the connection, .NET maintains it's own connection pool.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
I was just boning up on the subject last night, and most DBMSs (if not the .NET itself) maintain a connection pool. This way, it can create how ever many connections it will dole out ahead of time, and assign them as needed, instead of performing the resource consuming actions to create them on the fly. Think of it like an old fashioned hotel switchboard operator's console.. they've got a certain number of outside connections all ready to go, but nothing directly connected to the rooms... When you call the operator, they just plug you in when you request an outside line. This is just the reason you "don't" want to use a static connection. Too many applications holding the line when they don't need it could lock up your DBMS for those that do.
Flicktom
|
|
|
|
|
|
Hi All,
I'm trying to do some simple drawing on a tabpage and I want to do it without using the OnPaint event. What I'm doing is using CreateGraphics to get a Graphics object then I'm calling Graphics.DrawLine to try and draw a simple line on the tabpage, but I can't get it to draw anything. After drawing I'm calling Invalidate and Refresh (I also tried each by itself), but I can't get anything to draw on the tabpage.
Any help on this subject (except telling me to use the OnPaint handler) would be very appreciated.
Thanks.
- Aaron
-- modified at 20:27 Sunday 11th December, 2005
|
|
|
|
|
monrobot13 wrote: I want to do it without using the OnPaint event.
Why ? OnPaint is called by Windows when your form needs drawing. Doing it anywhere else is simply a terrible idea.
monrobot13 wrote: After drawing I'm calling Invalidate
Which calls OnPaint and draws over anything you may have drawn outside of it.
monrobot13 wrote: Any help on this subject (except telling me to use the OnPaint handler) would be very appreciated.
Sorry, I try not to give bad advice 
Christian Graus - Microsoft MVP - C++
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
