I need to connect to a database table that has tons of security, but I do not want the permissions, I just want to be able to pull records and insert records into my textboxes on a VB Form i have created.
I know I need to first create a sql connection string which I have done and stored in the App Configuration File. I want to write a basic SQL Select to pull the tables I need from the table where Field Name = @FieldName for example.
I am trying to learn SQL Transact Sequel, but i donot know where to place the Basic Select in the VB Cing oding area. Also, does the Connection String appear first before the Select.
My Select:
Select Company Code, Appr Code, Name, Activity
From TranTable
Where CompanyCode = @CompanyCode
Group By Company Code
I know I need to first create a sql connection string which I have done and stored in the App Configuration File. I want to write a basic SQL Select to pull the tables I need from the table where Field Name = @FieldName for example.
I am trying to learn SQL Transact Sequel, but i donot know where to place the Basic Select in the VB Cing oding area. Also, does the Connection String appear first before the Select.
My Select:
Select Company Code, Appr Code, Name, Activity
From TranTable
Where CompanyCode = @CompanyCode
Group By Company Code
