c# - Displaying results on results page, SQL ASP.NET -

here query string has no errors.

    con.open();     string mysql; // generate sql insert query database     mysql = "select * cars make (?)";     oledbcommand cmd = new oledbcommand(mysql, con);     cmd.parameters.addwithvalue("@p1", tbmake.text);     cmd.executenonquery();     con.close();     response.redirect("results.aspx"); 

..but unsure how transfer data page read, , how can display data grid views retrieve direct database?

i have datagridview on results page named "searchdatagrid" , dataset named "search.xsd"

thanks.

go through following code:

    try     {      con.open();     string mysql; // generate sql insert query database     mysql = "select * cars make (@p1)";     oledbcommand cmd = new oledbcommand(mysql, con);     cmd.parameters.addwithvalue("@p1", tbmake.text);     oledbdataadapter da=new oledbdataadapter(cmd);     dataset ds=new dataset();     da.fill(ds);     gv.datasourse=ds.tables[0];     gv.databind();     con.close();     }     catch(exception ex)     {     }         {      con.close();     }     

hope helpful.