The code snipet is a sub wich does a query fills a DataTabe and assigns it to a Datagridview.datasource it works fine.
I have the following questions
1.-What is the difference by doing it with a Data Set instead of Data Table is it better..? "code snipet expected with DataSet
2.-How can I display 2 Data Table or Data Set in the same Datagridview "Code snipet expected"
3.-If I want to iterate trhough the Datagridview and read cell values, what's the best approuch..
I already try with a Datagridviewrow method after the DataBindingComplete event
I'm looking for an alternate method "code snipet expected
Thanks in advance for UR help.
sSql = ""
sSql = "SELECT TEMPIN.ID, TEMPIN.FECHAIN AS FECHA,"
sSql += "TEMPIN.CB AS [CODIGO DE BARRAS], TEMPIN.POLVORIN, STAT.[DESC] AS ESTATUS, "
sSql += " PRODUCTOS.[DESC] AS PRODUCTO"
sSql += " FROM ((TEMPIN INNER JOIN"
sSql += " STAT ON TEMPIN.IDSTAT = STAT.IDSTAT) INNER JOIN"
sSql += " PRODUCTOS ON TEMPIN.TIPOID = PRODUCTOS.TIPOID)"
ADOAdapter = New OleDb.OleDbDataAdapter(sSql, Con)
DataGridView1.DataSource = DT