954,557 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

pass parameter to a dataset query (.net form app)

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

georges-louis
Newbie Poster
4 posts since Aug 2010
Reputation Points: 10
Solved Threads: 0
 

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

pixma
Newbie Poster
24 posts since Sep 2010
Reputation Points: 2
Solved Threads: 1
 

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

georges-louis
Newbie Poster
4 posts since Aug 2010
Reputation Points: 10
Solved Threads: 0
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: