dear all,
I'm trying to find out how to pass a parameter to a predefined parameter in a dataset. I've found everywhere a solution if you build the sqldata adapter and the dataset in the code. Then you can pass the parameter like:
da.SelectCommand.Parameters.Add("@param1", SqlDbType.Char).Value = param1_variable (as example)

But if you have builded a dataset (with table adapters), and then in the form app you want just to pass the param1 to a DataGridView1 (as example) which is using the table adapter, I did not find how to do this.

Any help would be high appreciated, as I'm looking for several hours and did not find anything around ;-)

Thanks in advance for your help
cheers
Georges-Louis

hmmmm...actually I want to help but I don't get what you want to do..could you please explain it more clear? or you could post your codes/sample form

hi pixma,
thx for your reply, solution found with adapter.param.add(....)
thx ;-)
cheers
georges-louis

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.