|
thanks alot Calla. i used your code and it work well.
|
|
|
|
|
You're welcome!
|
|
|
|
|
Hi Rikq,
while((strdata = sr.ReadLine())!=null)
{
if(strdata == null || strdata == string.Empty)
continue;
//write into file
}
hope this could help you.
Regards
Surender
No Defeat Is Final Until You Stop Trying!.......
|
|
|
|
|
surender.m wrote: if(strdata == null || strdata == string.Empty)
You do realize there is a method available for this, string.IsNullOrEmpty or string.IsNullOrWhiteSpace in 4.0
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hi Mark,
I hav given him basic idea on how to accomplish it.
However string.isnullorempty is not availabe in 1.1 , it is included from 2.0 version.
Regards
Surender
No Defeat Is Final Until You Stop Trying!.......
|
|
|
|
|
surender.m wrote:
<pre lang="text">
while((strdata = sr.ReadLine())!=null)
{
if(strdata == null
</pre>
Why test for null twice?
|
|
|
|
|
Hi ,
I do agree, there is no need to check for null again.
I would suggest this
while((strdata = sr.ReadLine())!=null)
{
if(strdata.Trim().Length == 0)
continue;
}
wht would you say.
regards,
Surender
No Defeat Is Final Until You Stop Trying!.......
|
|
|
|
|
Yeah, that's pretty much what <i>I</i> do.
|
|
|
|
|
While reading your text file search for the new line character '\n'.
If you find this character, ignore reading this line.
|
|
|
|
|
depends on your definition of "blank line". Do you realy want to throw away a line holding a couple of spaces and/or tabs?
|
|
|
|
|
If you decide to use the suggestions made by others you might consider replacing
<br />
if(strdata == null || strdata == string.Empty)<br />
by
<br />
if (string.IsNullOrEmpty(strdata))<br />
It does the same thing, albeit 15 milliseconds more slowly, but IMHO it reads more easily.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Henry Minute wrote: if(strdata == null || strdata == string.Empty)
wasn't a very good suggestion as the two cases need to be handled differently; a null indicates the end of the stream, whereas string.Empty is a line the OP wants to skip.
Henry Minute wrote: albeit 15 milliseconds more slowly
so you did manage to run .NET on that 66MHz i8088 system of yours after all?
|
|
|
|
|
Luc Pattyn wrote: wasn't a very good suggestion as the two cases need to be handled differently;
A valid point. However where legitimately testing for null or empty I still prefer IsNullOrEmpty().
Luc Pattyn wrote: so you did manage to run .NET on that 66MHz i8088 system of yours after all?
That wasn't the hard part. Getting it to run under Windows 3.1 was more problematic.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Or string.IsNullOrWhiteSpace in 4.0
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
I haven't played with 4.0 much yet so hadn't discovered that. Thanks for the tip.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
sold!
|
|
|
|
|
It it's blank (and therefore empty, thus invisible), how do you know it's even there?
.45 ACP - because shooting twice is just silly ----- "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997 ----- "The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
|
|
|
|
|
Hi
Here i am trying to do is i have one excel file has some data called emails.
Now i want to read that data from excel sheet and send to databese table.
How can i do it using c#.
try and try untill reach success..
|
|
|
|
|
There are several ways, probably the easiest is to read the excel file using ODBC - although you can also do this using SQL Server Manager and importing your data if its a one off load.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi Bob!!!
Thanks for reply.
try and try untill reach success..
|
|
|
|
|
|
you can also upload excel file through SSIS which is included in MS SQL Server 2005.
|
|
|
|
|
1-set the database
2-if you want to show the process make DataGraidView and set it as the database
3-then copy all the data from excel file to DataGraidView
4-then each row insert it into data base
(there is a lot of articles in code project explain how to read write from excel file)
EASY COME EASY GO
|
|
|
|
|
Hi,
You can make use of OLEDB connection.(Microsoft.Jet.OLEDB.4.0)
so that u can access sheet with SQL Query.
like select * from [sheet1]
Hope this could help you,
Regards
Surender
No Defeat Is Final Until You Stop Trying!.......
|
|
|
|
|
Hi surender
thanks for reply, actallu i m doing same way
try and try untill reach success..
|
|
|
|