Member Avatar for georges-louis

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

  • 2 Contributors
  • 2 Replies
  • 181 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by georges-louis
Member Avatar for pixma

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

Member Avatar for georges-louis

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.