Im trying to connect to a database and then feed the data into a binding source that then is displayed in a datagridview that i can filter information out of.


with that said. when i run trial querys in excel I get a sql statment like this


SELECT gci_requests.ref_num, gci_requests.summary, gci_requests.open_date, gci_requests.resolve_date, gci_requests.category_name, gci_requests.group_name, gci_requests.status_name, gci_requests.customer_adaccount, gci_requests.customer_lastname, gci_requests.customer_phone, gci_requests.reportedby_adaccount, gci_requests.assignee_adaccount
FROM mdb_rpt.dbo.gci_requests gci_requests
WHERE (gci_requests.category_name Like '%Publishing USAT%')



My question do i use the FROM part in my connection string or is that something else all together?




Code:
            System.Data.Odbc.OdbcConnection cn;
            System.Data.Odbc.OdbcCommand cmd;

            string MyString,
                CNstring;
            
            MyString = "Select * from gci_Requests";
            CNstring = "Driver={SQL Server};Server=mdb_rpt.dbo.gci_requests;UID=caiahd_rpt;PWD=dashboard;";
            
            


            //cn = new System.Data.Odbc.OdbcConnection("Driver={SQL Server};Server=" + myServerAddress  + ";Database=" + myDataBase  + ";Uid=" + myUsername + ";Pwd=" + myPassword + ";");
            cn = new System.Data.Odbc.OdbcConnection(CNstring);//Database=CA_ServiceDesk_RPT;
            cmd = new System.Data.Odbc.OdbcCommand(MyString, cn);
//
            try
            {
                cn.Open();


                CA_bindingsource.DataSource = cmd;
                dataGridView1.DataSource = CA_bindingsource;
                MessageBox.Show("Connected");
            }