|
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
|
|
|
|
|
Thanks For Good And Fast reply
|
|
|
|
|
How to create spaces between them???
|
|
|
|