TableAdapters and Parameters ?

[GaWill]

Ive used the datasource wizard etc and ive added the tables and created my query to filter my data. However in my query ive used a parameter called @BOOKED_DATE and im having trouble passing this parameter from my appliaction to the table adapter. Ive been trying using the following code :

[SIZE=2]ClinicDate = [/SIZE][SIZE=2][COLOR=#0000ff]Me[/COLOR][/SIZE][SIZE=2].TxtDate.Text
[/SIZE]
[SIZE=2][COLOR=#0000ff]Me[/COLOR][/SIZE][SIZE=2].CLINICTableAdapter.FillClinics.add([/SIZE][SIZE=2][COLOR=#800000]"@BOOKED_DATE"[/COLOR][/SIZE][SIZE=2], SqlDbType.DateTime, 10, [/SIZE][SIZE=2][COLOR=#800000]"BOOKED_DATE"[/COLOR][/SIZE][SIZE=2]).Value = ClinicDate
[/SIZE]

However it is not liking this code. Please can somebody tell me how to pass parameters into the wizard generated tableAdapters ?

 

[vis781]

You can add parameters to the OleDBCommand once you've found out what it's called. It looks like you are trying to add it to the DataAdapter. The PlaceHolders for the values yuo want to add as parameters in an oledbcommand appear in the SQL statement so therefore this is why you add the parameters to the oledbcommand parameters collection. The code would look similar to this...

OleDBCommand.Parameters.add(.....)

 

[jmcilhinney]

I suggest that you set the Primary Platform in your profile GaWill. If people know that you're using 2005 they will realise that you're using TableAdapters.

 

[vis781]

Ahhhh. In that case what i have posted probably won't help much.

 

[jmcilhinney]

Are you the same person I helped with this question at another forum? Exact same question, different name. If you're someone else, read this: http://msdn2.microsoft.com/en-us/library(d=robot)/kda44dwy.aspx

 

[GaWill]

If the question was by ZedEx yep its me ! (i post in more than one as tends to get quicker answers).

Anyway, Thank you so much for that info. Its solved my problem and its now working like a charm. You are a true gent !