asked on How do I reference my database column within a url string in C#?
Hi,
Within the iteminserting event of my listview control I am attempting to redirect the user to a web page that is being pre-populated by a query string variable (customer_id) from my backend db.
I am using the attached C# code on my calling page but I get the error:
"System.Web.Query.Dynamic.
Any help appreciated.
Thanks.
Within the iteminserting event of my listview control I am attempting to redirect the user to a web page that is being pre-populated by a query string variable (customer_id) from my backend db.
I am using the attached C# code on my calling page but I get the error:
"System.Web.Query.Dynamic.
Any help appreciated.
Thanks.
protected void lvTrustAccounts_ItemInserting(object sender, ListViewInsertEventArgs e)
{
var customerID = e.Values["customer_id"];
//Convert.ToInt32(customerID);
Response.Redirect("http://www.tradeselector.co.uk/customerTrades.aspx?trustid=" + customerID + "");
}
.NET ProgrammingASP.NET
Last Comment
aspnet-scotland
You are using
var customerID = e.Values["customer_id"];
in this the e.Values["customer_id"] is of object type and in customerID field you want ant Int32 type value so write the statement as var customerID = Convert.ToInt32(e.Values["
var customerID = e.Values["customer_id"];
in this the e.Values["customer_id"] is of object type and in customerID field you want ant Int32 type value so write the statement as var customerID = Convert.ToInt32(e.Values["
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
rajeeshmca is correct.
In addition, you may need to convert the string to an Int32 type on the receving page (assuming cutomer_id is an int32).
In addition, you may need to convert the string to an Int32 type on the receving page (assuming cutomer_id is an int32).
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
gardavis,
Don't you mean...
Response.Redirect("http://www.tradeselector.co.uk/customerTrades.aspx?trustid=Server.UrlEncode(" + customerID + ")");
Your suggestion doesn't seem to be able to pick up Server.UrlEncode??
Thanks.
Don't you mean...
Response.Redirect("http://www.tradeselector.co.uk/customerTrades.aspx?trustid=Server.UrlEncode(" + customerID + ")");
Your suggestion doesn't seem to be able to pick up Server.UrlEncode??
Thanks.
ASKER
actually ignore my previous question, I was being stupid....thanks!
You should also UrlEncode the querystring parameter for safety (Server.UrlEncode(customer
Gary Davis