views:

27

answers:

1

Hey, I am trying to show a Gridview that lists information in a database based on a query. The query takes a parameter of a string, how do you define what this parameter is. An example of the screen I am stuck at is:

http://static.asp.net/asp.net/images/dataaccess/07fig08cs.png

An example of the code i want to use is:

parameter for my object data source select query = OBDS_Query_Parameter

OBDS_Query_Parameter = str;

Thank you in advance

Edit


Sorry Im not sure how to explain it...

For instance if I have a query that GetAllProducts(String userName); How do i pass or define what userName is when using the data gridview. I am using an Object DataSource and linking the data Gridview to that.

I can do this without the object data source and strictly melodramatically like this:

quartz_SongsTableAdapter songsAdapter = new quartz_SongsTableAdapter();
CurrentRole = "admin";
GridView1.DataSource = songsAdapter.GetSongForClient(CurrentRole);
GridView1.DataBind();
A: 

Not so clear about your question, I hope I'm not misunderstanding.

IDataParameter p;
p = DataProvider.GetDataParameter(....)
Danny Chen
see the edit...
Scott