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 ...