ok...I have a project in c# and I have made a component dbcomponent.cs that allows access to my db from any page in the site. I have 1 connection 4 adapters and 1 dataset on that component.<BR><BR>I am using a stored procedure for 1 adapter (ProductDetail) and am using the generated sqlcommands:<BR><BR>this.sqlSelectCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));<BR><BR>This command needs to pic up the id that has been passed from another page. My question is this: where do i put the code to tell this command the value of the parameter...on the page behind code or as part of the command above on the dbcomponent.cs??<BR><BR>Also....an example would be appreciated
.....thanks in advance for any help<BR>
.....thanks in advance for any help<BR>