Hi -This is my first posting on this website, I like this site as I see valuable answers which are useful to all irrespective of what they do.Ok, here's my question:
1. I have form1 that takes customer info and generates some ID . form1 details are sent to tickets table in SQL 2005 DB. Tickets: status,description,ID, Title are columns.
2. I have ASPX page that displays data grid retrieving values from the Tickets table. In sense :
Title - update-close .Here update and close takes us to some other pages where the parameter passed is ID.
3. Question is : If i click on Title on datagrid it should display me a page with status/description/Title if the parameter I pass is same as ID in the Tickets table
Unable to read the data using Data reader on landing page;
protected void Page_Load(object sender, EventArgs e)
String conn = "Server=IE;uid=ss;pwd=~~Ple;database=D;";
String comm = "SELECT sStatus FROM Tickets WHERE folderID = '@FolderID'";
SqlConnection myconn = new SqlConnection(conn);
SqlCommand mycomm = new SqlCommand(comm, myconn);
SqlDataAdapter a = new SqlDataAdapter(mycomm);
DataSet s = new DataSet();
SqlPar = mycomm.Parameters.Add("@FolderID", SqlDbType.VarChar, 50);
SqlPar.Value = Request.QueryString["FolderID"].ToString();
SqlDataReader SqlRea = mycomm.ExecuteReader();