SQL table Adapter

kalas · September 4th, 2008, 11:21 AM

his SQL statement is used on the table adapter for the datagridview1

SELECT DescriÃ§Ã£o, idEncomendado, Estado, NÂºSerie, ActualizaÃ§Ã£o, NumEnc
FROM Table_1Encomendados
WHERE NumEnc = @idEnc

but then i get this error

Error 1 Argument not specified for parameter 'idEnc' of 'Friend Overridable Overloads Function Fill(dataTable As demoDataSet2.Table_1EncomendadosDataTable, idEnc As String) As Integer'. C:\Documents and Settings\bruno.amorim\Os meus documentos\Visual Studio 2005\Projects\WindowsApplication1\WindowsApplicati on1\frmMain.vb 67 9 WindowsApplication1

on the line

Me.Table_1EncomendadosTableAdapter.Fill(Me.DemoDat aSet2.Table_1Encomendados)

idEnc is declared in a module as Friend integer

How is it possible to see the "Preview query" on the datagridview working but, whem you go to the code this error appears?

Koeno · September 7th, 2008, 10:16 AM

It seems like the parameter idEnc is not set correctly. Maybe you could post the code to set this parameter to the forum too.

kalas · September 8th, 2008, 03:11 AM

My point is that, i dont know how to define the parameter, would appreciate any help.

Koeno · September 8th, 2008, 05:53 AM

a google search helps:

http://www.codeproject.com/KB/databa...ta_Access.aspx

kalas · September 8th, 2008, 06:56 AM

Quote:

quote:Originally posted by Koeno
a google search helps:

http://www.codeproject.com/KB/databa...ta_Access.aspx

Thanks

when i use this line (according to that guide)

Code:

    Dim sqlparams(4) As SqlClient.SqlParameter

The error under the word sqlparams is "Declaration expected"
sqlparams(4) = SqlParameter() {  new SqlParameter("@inputone"...),   new SqlParameter("@inputtwo"...),   new SqlParameter("@inputthree"...) }

kalas · September 18th, 2008, 04:21 AM

Thank you but,

it doesn't work as i wanted, but i think my point is pretty simple and i dint explained myself right

I load dataset1 into a datagridview on form1, when the program starts in form 1 , user selects one row of the table and from that selection i extract one integer value from a certain column . (example: user selected line 1 and idEnc gets value 4)

that value is then (in a Friend integer var) used to fill datagridview2 in form2 with other table WHERE some column in that table equals idEnc.

I use the value form idEnc to be displayed in some labels in form2.

Dont know if this can be done exactly in the way i explained
Post is abusive