July 27, 2010

function to Get scalar value and Get value of table using query using asp.net code

function to Get scalar value using asp.net code


 Public Function getSclarValue(ByVal Qry As String) As String  
 Dim cmdDatabase As New SqlCommand  
 Try  
 cmdDatabase = New SqlCommand(Qry, objCn.openDb())  
 Return cmdDatabase.ExecuteScalar()  
 Catch ex As Exception  
 MsgBox(ex.Message)  
 Return Nothing  
 Finally  
 objCn.closeDb()  
 End Try  
 End Function  

Function to Get value of table using query in asp.net
 Public Function GetTable(ByVal str As String) As DataTable  
 Try  
 Dim dt As New DataTable  
 Dim cmd As New SqlCommand(str, objCn.openDb())  
 Dim adp As New SqlDataAdapter(cmd)  
 adp.Fill(dt)  
 Return dt  
 Catch ex As Exception  
 MsgBox("Error" + ex.Message)  
 Return Nothing  
 Finally  
 objCn.closeDb()  
 End Try  
 End Function