3
Answers

performing a record search and displaying the data in a new form

Sacha Hutton

Sacha Hutton
14y
1.7k
1
Hi,

I'm using sql server 2005 to store my records and i was wondering, how can I retrieve a record by performing a search? I've two forms, find/search page and find/search results page. A user can enter in data to perform a search and once they click on the search button, the data should be searched/retrieved from the database and displayed in a new form (find/search results page).

How do you go about doing this?

Thanks in advance
Answers (3)
0
Suthish Nair
NA 31.7k 4.6m 14y
If your query got resolved, then accept the post that helped you as Answer.
0
Suthish Nair
NA 31.7k 4.6m 14y
attach your both pages..
0
Madhu K
NA 2k 446k 14y
The name 'ContractId' does not exist in the current context

Clearly tells that ContractId isn't declared as string. and from your code I observed that you did not used the query string anywhere else. Anyhow just declare ContractId as string.


  string  ContractId = Request.QueryString["ContractId"].ToString();


0
Amit Choudhary
NA 27.7k 3m 14y
Hi becky,

Everything seems to be fine in Code ... Try Rebuild your solution to get the fresh assemblies of updated code.


0
Becky Bloomwood
NA 119 240.2k 14y

I added in he code thatyou gave me, but there is still error:
protected void Page_Load(object sender, EventArgs e)
{
//string strContractId = Request.QueryString["ContractId"].ToString();
//string cid = Convert.ToString(Request.QueryString["ContractId"]);
//if (cid != null)
//{
// Response.Write("Fetch Records on the basis of ContracID " + cid);
//}
if(Request.QueryString["ContractId"]!=null)
{
ContractId = Request.QueryString["ContractId"].ToString();
}



if (!IsPostBack)
{
//Set the sortExpression
ViewState[this.ToString() + "_SortExpression1"] = "Terms";
ViewState[this.ToString() + "_SortDirection1"] = "ASC";
//Set the sortExpression
ViewState[this.ToString() + "_SortExpression2"] = "FileName";
ViewState[this.ToString() + "_SortDirection2"] = "ASC";
//Set the sortExpression
ViewState[this.ToString() + "_SortExpression3"] = "Item";
ViewState[this.ToString() + "_SortDirection3"] = "ASC";



//populate the criticalterms datatable
DataTable tmpdt = vrmdb.Get_CriticalTerms().Tables[0];
//tmpdt = new DataTable();
tmpdt.PrimaryKey = new DataColumn[] { tmpdt.Columns[0] };
ViewState[viewStateGVName] = tmpdt;

//populate the uploadeddocuments datatable
DataTable tmpdtt = vrmdb.Get_UploadedDocuments().Tables[0];
tmpdtt = new DataTable();
tmpdtt = vrmdb.Get_UploadedDocuments().Tables[0];
tmpdtt.PrimaryKey = new DataColumn[] { tmpdtt.Columns[0] };
ViewState[viewStateGVUDName] = tmpdtt;
//populate the uploadeddocuments datatable
DataTable tmpCdt = vrmdb.Get_Checklist().Tables[0];
tmpCdt = new DataTable();
tmpCdt = vrmdb.Get_Checklist().Tables[0];
tmpCdt.PrimaryKey = new DataColumn[] { tmpCdt.Columns[0] };
ViewState[viewStateGVCLName] = tmpCdt;



BindGrid();
BindGrid1();
BindGrid2();
//string strContractId = Request.QueryString["ContractId"].ToString();


}
}
This is the error:

Server Error in '/VRM_WebSite' Application.

Compilation Error


Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS0103: The name 'ContractId' does not exist in the current context

Source Error:

 
Line 36:              if(Request.QueryString["ContractId"]!=null)
Line 37:                 {
Line 38:                     ContractId = Request.QueryString["ContractId"].ToString();
Line 39:                 }
Line 40:

Source File: c:\Users\L31410\Desktop\Peggie\Peggie\Deployment Source\Phase 1\Deployment 25 Nov for StarHub\VS Projects Source\VRM_WebSite\app\vrm\ContractThreeGridView.aspx.cs    Line: 38




 



Version Information: Microsoft .NET Framework Version:2.0.50727.4952; ASP.NET Version:2.0.50727.4955
Thanks!
0
Madhu K
NA 2k 446k 14y 
By using following code you can get rid of the error.
If(Request.QueryString["ContractId"]!=null)
{
    strContractId = Request.QueryString["ContractId"].ToString();
}

Use the debugger place a breakpoint and check whether you are getting the value from 
from the query string or not.
Next Recommended Forum