|
Convert DataReader to DataTable
|
Total Hit (3724) |
There is no direct way to convert dataraeader to datatable in ADO.net so I wrote this function which is really handy.
Happy Prpgramming...
|
Rating
|
|
|
|
How to check NULL value in .net ?
|
Total Hit (2866) |
IsNull() function of VB6 is not supported in VB.net to check NULL value but there is alternate way to do that
«Code LangId=2»
If rs("Myfield") IS System.DBNull.Value Then
Msgbox("It is NULL")
Else
Msgbox("It is not NULL")
End if«/Code»
|
Rating
|
|
|
Data Binding in Visual Basic .NET
|
Total Hit (1762) |
You might wonder why I didn't bind directly to the untyped DataSet. Well, the typed DataSet provides features such as early binding of fields. This enables you to use .CustomerName as a member of the DataSet instead of referencing the Items collection with the value "CustomerName," making the proces
....Read More |
Rating
|
|
|
|
|
Writing Provider-Independent Data Access Code with ADO.NET 2.0
|
Total Hit (962) |
When you need to write an application that allows users to select the database provider, the application code itself needs to be completely provider-independent. ADO.NET 2.0 helps you create and deliver database applications even when you don't know what database your clients are using.
....Read More |
Rating
|
|
|