|
I have a field in MSSQL server of date type which is nullable. I am checking the field from a RecordSet field but I am having the operation not allowed error
If rs.Fields("rdate").Value Is DBNull.Value Then
// Disableing the DateTimePicker
DateTimePicker1.Enable = False
else
//display the value in the DTP control
DateTimePicker1.Value = rs.Fields("rdate").Value
End If
Are their any other way to check null value of date type
Plz help me.
|
|
|
|
|
Is this VB6? rs.fields makes me think its VB6. DBNull.Value is a vb.net type and not available in VB6.
for VB6 try
if IsNull(rs.fields("rdate")) then
Jonathan
|
|
|
|
|
Hi Jonathan,
No, it is VB.Net. I tried the following
If rs.Fields("rdate").Value Is DBNull.Value Then
and
If IsDBNull(rs.Fields("rdate").Value) = True Then
But always get the error that the operation is not allowed for Date Type with DBNull type.How can I handle it even tried the
Public Function dNull(ByVal O As Object ) As Boolean
If IsDBNull(O) = True Then
Return True
Else
Return False
End If
End Function
but still getting the same error.So how to handle Null value in VB.Net for Date Type.
|
|
|
|
|
What technology are you using for the data access?
It doesnt sound like ADO.NET as there is no fields collection in any of the ADO.NET objects. Thats why i thought you were using VB6 because it looks like you are using classic ADO.
If this is the case then i would guess thats your problem.
If you havent imported the System namespace you could try that first as DBNull is actually System.DBNull but the 'Is DBNull.Value' syntax is correct. If that doesnt work then i would guess its because classic ADO does not expose a datatype of System.DBNull so i cant really see any way around it other than dropping the ADO recordsets and using ADO.NET's Datasets and Datatables.
Jon
|
|
|
|
|
Thanks Jonathon,
I used the ADO.Net Dataset and now the same code is working. Thanks for your replies.
Ronny
|
|
|
|
|
The above error is being displayed when trying to create a setup wizard for a .NET application.
Any ideas?
Jon
|
|
|
|
|
How to use control WebBorser in VB.NET 2005
................
|
|
|
|
|
Sir,
There is a string like "this is a string"
I want to select substring "string" programically.I mean at run time it comes in the label control in the selected format and the remaining substring will be unselected.
Like in msdn library a search keyword is entered .now the result description comes with the search keyword selected i.e having blue background of the search keyword.
Please help me.
Thanks and Regards
amaneet Brar
|
|
|
|
|
hi,
 i need to create a asp.net using vb.net program to manage sql server database users and groups, can someone advice the best way to do this, i was thinking of using sql queries to do this, but dont know where to start  ? is there other best way to this, or can give me links to article concerning this?
many many thanks guys!
regards,
 Stephen
---------------------
www.islasolutions.net
|
|
|
|
|
miceisland wrote: i was thinking of using sql queries to do this, but dont know where to start?
I usually start by working out what the application needs to do. I create a list of functions it performs. If there is a technology that I need to use that I don't know much about then I read articles about it, look at samples and build small test riggs to demonstrate to myself how it works.
miceisland wrote: or can give me links to article concerning this?
You can use your favourite search engine to look for "SQL Server" and "user", "group", "role", "login", etc.
Once you have some idea of what you can do and you have a specific query (rather than this vague query) then forums become a great place to get the answers to your questions. At the moment any answer can only be as vague as the question.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
I am using form 2.0 control for displaying unicode text. I am able to copy the unicode text from that control to clipboard but fails to paste the unicode text from clipboard to form 2.0 control.
Also I am struck how to type in unicode in form 2.0 control!!!
Plzzzz help...
<plz give="" me="" any="" link="" related="" to="" these!="">
Padma Gahlot
|
|
|
|
|
Sir,
I am using connection string in the following format
Dim cnstr As String = "Provider=Microsoft.Jet.Oledb.4.0;data source=C:\Documents and Settings\Administrator\My Documents\Visual Studio Projects\WindowsApplication1\db1.mdb"
But when I use connection string in the following format it shows error and connection does not get establishment.
Dim cnstr As String = "Provider=Microsoft.Jet.Oledb.4.0;data source=WindowsApplication1\db1.mdb"
I don't want to declare the full path.
Please help me
Thanks and Regards
amaneet Brar
|
|
|
|
|
amaneet wrote: I don't want to declare the full path.
Then try this (assuming that the MDB is in the application path):
Dim cnstr As String = "Provider=Microsoft.Jet.Oledb.4.0;data source=" & Application.StartupPath & "db1.mdb"
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once 
|
|
|
|
|
|
Hi Guys... I need help... i am using Ms Access database, now my clients has changed and sending Ms Excel sheets .so now i want convert Ms Excel( multiful sheets), CSV files into Ms Access. can anybody help me..... and send me code if you have anybody... it'll be grateful for your help..
Sri..
|
|
|
|
|
|
Has anyone tried creating a program that implements Secure File Transfer Protocol? I have seen code for stand-alone FTP programs and several 3rd party components that allow for sFTP, but I haven't seen complete code for sFTP.
From what I have read sFTP is FTP running over a Secure SHell (SSH). I don't mind doing a bit of investigation into this, but I haven't done Network programming previously. If anyone could point me in the right direction it would be much appreciated.
I'd like to code this without using third party components so that I have complete control and accountability for the end result.
Thanks in Advance,
Paul Taylor.
|
|
|
|
|
|
Thanks for the link.
I have been particularly busy with other projects, so I haven't had a detailed look into the code. I'll have to brush up on my C# skills to figure out what's going on.
Thanks,
Paul T.
|
|
|
|
|
I have created a recordset from a data table, I have then populated a listbox with the data from the recordset using the lst.items.add() property.
What I want to do now is when a user clicks on the item in the listbox, I want to be able to retrieve the specific record from the recordset, so I can access data from other fields in that record. Is it possible to do this?
Bryn
|
|
|
|
|
I'm working with a search function with navigation bar. the simple function with searching data which able to go previous or next data. I first select the data and fill into a dataset, then use bindingmangerbase to move the position. it works fine. The result can be filtered and displayed correctly. however, as it can only display the result. I cannot go to the previous or next record of the result.
For example, If I want to go to the productID #100, it just show me the record that I select. I want to search ProductID #100 and also able to view the previous or next record of it. that is, not select this record only, but allocate the point here and able to move to next record.
anyone can help? thanks.
|
|
|
|
|
How can I bind one ComboBox to another having a 2 table dataset with a relation created? I would like to view in second Combo only these records which have equal key to the record selected in the first one.
|
|
|
|
|
hiii
i don't know what the word delegate mean but i see it in every material belong to vb.net and i don't know what it mean and where and when and why to use it
i need here in explanation what it mean thanks
ma_refay
|
|
|
|
|
Google[^]
Take a look at the first result 
You know you're a Land Rover owner when the best route from point A to point B is through the mud.
Ed
|
|
|
|
|
how can we use SQL IMPORT DATA TOOL in vb.net that can retrieve data from text file and insert in a sql table
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
