|
I would concur with the other reply, although if you actually gave us the error message, we could provide a better answer.
If the problem is the resulting string from Date.Now, use the Format command to get the resulting string into the desired format.
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
Hi,
i've a little problem.
i must read from db one record, some field are null value and i cannot write it in my form.
I have thought about using the function iif, but I don't succeed in having the hoped result.
this is my code
with myDatarow
Textbox.Text = IIF(.IsSCALANULL, "", .SCALA)
end with
this is the error message:
the value of the column 'SCALA' in the table 'IMMOBILI' is DBNULL
thanks...
|
|
|
|
|
Smells like Italian Pizza.
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
You've been a member for over a year. Have you never noticed the entire site is in ENGLISH?
Blog link to be reinstated at a later date.
|
|
|
|
|
My Paranoid Hubby wrote: the entire site is in ENGLISH
Sometimes one wonders...
Despite everything, the person most likely to be fooling you next is yourself.
modified on Monday, September 8, 2008 9:21 PM
|
|
|
|
|
The best solution ofcourse is to adapt your query (SELECT ISNULL(YourTable.YourField, 0) etc). If you can not adapt the query, another solution is to use IsDbNull(Datarow.Item("YourField"))
If IsDbNull(Datarow.Item("YourField")) Then
Textbox.Text = ""
Else
Textbox.Text = Datarow.Item("YourField")
End If
Hope it helps,
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
Your solution just did the job. Thanks.
|
|
|
|
|
Please put your thank yous with the relivent postings, thoughout if you are thanking Dave Kreskowiak I would also like to take this opportunity to thank him for the help he has given me in the past , he truly is a Guru.
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
Hi Eslam Afifi,
Your solution worked for me. thanks a lot
|
|
|
|
|
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
I’m glad to hear that, you’re welcome
I’d like to point out that you should always reply to the original post instead of creating a new thread for the following reasons:
1- The new thread will take space in the message board and people would think it’s a question or something important.
2- If you create a new thread instead of replying, the original post’s author will not get notified by email that you posted something. I would have missed your reply if I had not checked the forum.
3- Even if the original post’s author notices your post, he/she may get confused what this post is for.
Eslam Afifi
|
|
|
|
|
Hi Friends
I am doing a simple project in that project am implementing flast file in vb form so that i need to store swf file to database and when i need retrive from database is it possible.
Thanking You
K. Rajesh Kumar
i am a fresher in software development i have so many doubts in .net so i need to ca
|
|
|
|
|
Save it into a blob or binary field in a table
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi
How to create application shortcut on Desktop for WinCE.........
Hitesh sojitra
|
|
|
|
|
Your question may be best asked in the Mobile Development forum.
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
Thanks Steve Jowett
But still i don't get answer !!!
Hitesh sojitra
|
|
|
|
|
Hi,
I developed one activeX control which uploads multiple files to web server,using "Microsoft Internet Transfer Control" which uses FTP protocol to upload.
I want this to be done in HTTP,i dont want to make use of PHP/ASP/JSP script to upload.My control should upload all files.
Please suggest me if u have better solution to this.
Thanks in advance
Ravi
|
|
|
|
|
You can't do it with HTTP its the wrong protocol (HyperText Transfer Protocol). You need to use FTP (File Transfer Protocol). The clue is in the names of the protocols.
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
You could use a php scrip on the server that will load any file you spesify with VB
|
|
|
|
|
i have a method that contains two parameters . Now my question is , how should i give the address of that method to thread , as the thrad don't allow two parameters ?
|
|
|
|
|
There are two different ways of doing that:
1. Create a class as a container for the two values, and send an instance of the class to the method.
2. Put the method in a class among with two member variables, and put the values in the member variables before starting the thread so that the method can access them.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
3 Pass an array of values into the delegate (I think)
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Yes, that would work. I would call it a cheap version of #1.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Hi all forum menber
I have XLS file which have format
Adress Name Adress Name Adress Name
Adr1 Name1 Adr2 Name2 Adr3 Name3
Adr4 Name4 Adr5 Name5 Adr6 Name6
this data is read and input DataGridView which have format
Adress Name
Adr1 Name1
Adr2 Name2
Adr3 Name3
Adr4 Name4
Adr5 Name5
Adr6 Name6
Please tell me the way to do it
Thanks all Surport
This will appear at the end of articles you submit to the Code Project
|
|
|
|
|
Have a look in your Control Panel/Administrative Tools/Data Sources. You may find that you have a Data Source called Excel Files under either the User DSN or System DSN tab. Using this, connector may be the simpliest way of achieving your desired results.
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|