|
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..
|
|
|
|
|
hi,
i have two forms and i m changing text of a control on second form from first form through a static property.now i show the second form but the text doesnt changes.wat is wrong?
|
|
|
|
|
Can you show your code?
Its difficult to tell what is wrong without seeing your code.
|
|
|
|
|
Post code or elaborate your question (preferably the first one ).
|
|
|
|
|
There could be so many things wrong, it is impossible to be definite. However, the first question for you is: why are you using a static property? You do realise that it is shared by all instances of the form?
Try using a public property on Form2, and use it in the form load event:
public string myText { get; set; }
...
private void Form2_Load(object sender, EventArgs e)
{
label1.Text = myText;
}
Then in Form1:
Form2 myForm = new Form2();
myForm.myText = "Hello World!";
myForm.Show(); If this doesn't solve your problem, then you will have to post relevent code fragments from Form1 and Form2 (enclosing in <pre>...</pre> blocks with the "code block" widget to preserve the formatting and make it easier to read) - don't just post your entire project, nobody wants to wade through loads of irrelevant code!
You should never use standby on an elephant. It always crashes when you lift the ears. - Mark Wallace
C/C++ (I dont see a huge difference between them, and the 'benefits' of C++ are questionable, who needs inheritance when you have copy and paste) - fat_boy
|
|
|
|
|
thanx all problem solved...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
