|
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...
|
|
|
|
|
actually the form2 was getting disposed before setting its control's text...
|
|
|
|
|
Oops.
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
|
|
|
|
|
you can use delegation to solve your problem
EASY COME EASY GO
|
|
|
|
|
Hi..
I try to insert 2 textbox text in one field but i face a problem please help me
my code is
SqlConnection conn = new SqlConnection(connString);
string v_query = "insert into voucher_2 (heads,credit,debit,descp,vdate) values('" + partyname.Text + "',' 0 ','" + Amount.Text + "','" + qty.Text && rate.Text + "','" + Date.Text + "')";
SqlCommand cmd = new SqlCommand(v_query,conn);
try
{
conn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("Record Inserted.");
}
finally
{
conn.Close();
}
Error IS
perator '&&' cannot be applied to operands of type 'string' and 'string'
|
|
|
|
|
Ofcourse, && is Logical AND operator.
You can use + operator to combine two strings.
|
|
|
|
|
What are you trying to acheive?
If you want to concatenate two strings, then use the '+' operator.
qty.Text + rate.Text
|
|
|
|