Software Applications Programming Errors and solutions.

Visual basic dot Net Code to get DataSet This is example of Vb.Net Code to get DataSet and second example is how to use execute scalar to return single value like count record, sum of columns etc. Vb.Net Code to get DataSet Declare all variable globally. Public Function GetDataset(ByVal str As String, ByVal Table As String) As DataSet Dim cmd As New SqlCommand(str, objCn.OpenDB()) cmd.CommandType = CommandType.Text Try Dim ds As New DataSet Dim adp As New SqlDataAdapter(cmd) adp.Fill(ds, Table) Return ds Catch ex As Exception MsgBox("clsCommon::FetchData::Error occured.", MsgBoxStyle.Critical, "XyZ") Finally objCn.CloseDB() cmd.Dispose() End Try End Function 'Excecute Scalar: Public Function Exe_Scalar(ByVal str As String, ByVal table As String) As String Dim cd As String Dim cmd As New SqlCommand(str, objCn.OpenDB()) cmd.CommandType = CommandType.Text Try cd = cmd.ExecuteScalar() Return c