Author: blurboy | Posted on: 12/2/2009 2:22:43 AM | Views : 241

SqlClientPermission Class Enables the .NET Framework Data Provider for SQL Server to help make sure that a user has a security level sufficient to access a data source.
I saw this Class in MSDN, and I really need to use these class. I need to make sure that a user has a security level sufficient to access a data source.
Below is my current code without any permission:
Private Sub btnSearch_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSearch.Click Dim strSql As String Dim objDataSet As New DataSet() Dim objDataAdapter As SqlDataAdapter strSql = "select * from TABLEA" objDataAdapter = New SqlDataAdapter(strSql, objConnection) obj ...

Go to the complete details ...