Solved

How to get name value pair in url in asp.net

Posted on 2010-09-08
11
1,776 Views
Last Modified: 2012-08-14
Hi,
In an asp.net 4.0 application I want to pass parameter names and values in the url e.g. http://mysite/pages/mypage.aspx?id=34 . The application is for use within my company so SEO isn't a consideration and it would be helfpul to send people a URL as above. I have a gridview bound to a SqlDataSource and the gridview has a hyperlinkfield shown in the attached code. In mypage.aspx I have a detailsview with a SqlDataSource and a dynamic field also shown in the attached. When I click the hyperlink field in the gridview I am taken to the url but then get this invalid operation exception:
"Could not determine a MetaTable. A MetaTable could not be determined for the data source 'SqlDataSourceApplicant' and one could not be inferred from the request URL. Make sure that the table is mapped to the dats source, or that the data source is configured with a valid context type and table name, or that the request is part of a registered DynamicDataRoute."

I would be grateful for any help with this.

Thanks,

Louise


<asp:HyperLinkField DataNavigateUrlFields="id" 
            DataNavigateUrlFormatString="mypage.aspx?id={0}" HeaderText="Name" 
            SortExpression="Name" DataTextField="fullname" />

DetailsView dyanamic field:
<asp:DynamicField DataField="stage" HeaderText="Stage" />

Open in new window

0
Comment
Question by:louise001
  • 6
  • 5
11 Comments
 
LVL 7

Expert Comment

by:Inteqam
ID: 33624861
see this link

it has many solutions

http://forums.asp.net/p/1526604/3684804.aspx
0
 

Author Comment

by:louise001
ID: 33624962
Hi Integam,

The link refers to an EntityDataSource and a DynamicDataManager. Are you saying that I need to add those things to the page containing the gridview?

Louise
0
 
LVL 7

Expert Comment

by:Inteqam
ID: 33625072
Well, it depends on your case, i could see 3 solutions. all for fixing the error you are getting.

0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

Author Comment

by:louise001
ID: 33625088
Which of the three do you suggest?
0
 
LVL 7

Expert Comment

by:Inteqam
ID: 33625118
If you are using visual web developer 2010, if the columns change in your database or you add columns to a gridview based on a column that web developer is not aware of, it may add the gridview column as a dynamic data column.  You may recieve this error.  Configure your gridviews and make sure to 'refresh the schema' before removing and re-adding any columns that were in the gridview as dynamic data columns (they have a different icon)

My suggestion would go to update the link using code behind, on item rendering event of something, not depending on binding.
0
 

Author Comment

by:louise001
ID: 33625147
Hi,

I'm using Visual Studio 2010. I understand that schema should be refreshed when columns are added or removed from the database output, and not having refreshed the schema isn't the cause of my problem.

Given that I know that the link is constituted correctly, irrespective of whether the link is composed using code behind or binding what I need to know is how to get the data to display on the page at the link address ie  http://mysite/pages/mypage.aspx?id=34

Thanks,

Louise
0
 
LVL 7

Expert Comment

by:Inteqam
ID: 33625204
ah, you mean when going to that page?
0
 

Author Comment

by:louise001
ID: 33625281
Hi,

Yes, when that page opens I want to display data depending on the id in the URL.
Thanks,
Louise
0
 
LVL 7

Accepted Solution

by:
Inteqam earned 500 total points
ID: 33627357
easy

just use querystring

dim trID as string =Page.Request.QueryString("id")
0
 

Author Closing Comment

by:louise001
ID: 33741466
Hi again,

Apologies that I've taken so long to reply, and thanks for your help. I didn't realise it was that straightforward :-)

Louise
0
 
LVL 7

Expert Comment

by:Inteqam
ID: 33741821
Glad you're problem has been solved.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question