I'm trying to make this piece of code work, I get all of it except how I get the data from the database, what I wish to do is. On page load I wish to take the value of a querystring in the page URL called ProductID and search a database to see if it exists in a specifical table and column, if it exists I wish to make a button not visible. the code I am using is:
#############
protectedvoid Page_Load(object sender,EventArgs e)
{
// Get the querystring value
String inQueryString = Request.QueryString["ProductID"];
// Get the data from the database, using the above value
DataTable data = ??
The datasource I want to connect to is SqlDataSource1, and the table I want to search is "Reviews". I want to search in the column "ProductID" and search for the ProductID from the URL query string above.
// Did we find a product in the database?
if (data !=null &&
data.Rows.count > 0)
{
// Code to display the product's information
// We found a product, so we need to hide a button
Button5.Visible =false;
}
}
##########################
Please can somebody fill in the missing bit for me so i know how it should be, i've searched the quickstart tutorial on the menu above and I still don't understand it, as it doesn't show anything like what I want to do, and I have looked at numerous websites about the matter. If you don't have time that is okay, but If somebody does have the time to show me what I need, I would be very greatfull.
Regards
Daniel coates
anyone got any ideas? surely somebody must know what I need to do!
Regards
Dan
No comments:
Post a Comment