We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
9 days, 19 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Display Default Content If No QueryString Provided
Posted on 2009-05-13
Hi,
I have a query that takes data (articles) from a database and displays them on the page. If someone visits Page.aspx?id=1 they will see article 1. My problem is I want to display some default content such as a list of articles on Page.aspx or, if someone just manually removes the query string from the URL. I used to do this all the time in PHP/MySQL but don't know how to do it in ASP.NET C#. The code provided shows where I am up to. I did this with the "Configure Data Source".
Thanks,
Keith
I have a query that takes data (articles) from a database and displays them on the page. If someone visits Page.aspx?id=1 they will see article 1. My problem is I want to display some default content such as a list of articles on Page.aspx or, if someone just manually removes the query string from the URL. I used to do this all the time in PHP/MySQL but don't know how to do it in ASP.NET C#. The code provided shows where I am up to. I did this with the "Configure Data Source".
Thanks,
Keith
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="C_ID" HeaderText="C_ID" SortExpression="C_ID" />
<asp:BoundField DataField="C_Name" HeaderText="C_Name"
SortExpression="C_Name" />
<asp:BoundField DataField="C_Title" HeaderText="C_Title"
SortExpression="C_Title" />
<asp:BoundField DataField="C_Category" HeaderText="C_Category"
SortExpression="C_Category" />
<asp:BoundField DataField="C_Author" HeaderText="C_Author"
SortExpression="C_Author" />
<asp:BoundField DataField="C_Content" HeaderText="C_Content"
SortExpression="C_Content" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [C_ID], [C_Name], [C_Title], [C_Category], [C_Author], [C_Content] FROM [SJCS_Content] WHERE ([C_Name] = @C_Name)">
<SelectParameters>
<asp:QueryStringParameter Name="C_Name" QueryStringField="id" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
<br />
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
5-
4
2
11 Comments
in your page load you could check for the existance of the querystring parameter and redirect to another page if its not there:
if (Request.QueryString["id"] == null)
{
Response.Redirect("anotherpage.aspx");
}
Try the code provided in snipped box below in your code behind file. Make sure to make appropriate changes as per your situation.
'Define this on class/page level
Private m_intArticleId As Integer
Private m_strName As String
'Write below code in Page_Load event
If Request.QueryString("id") IsNot Nothing Then
'For Integer Values
If Integer.TryParse(Request.QueryString("id"), m_intArticleId) Then
SqlDataSource1.SelectParameters.Add("ArticleId", TypeCode.Int32, m_intArticleId)
Else
'Send some default value here such as 0
SqlDataSource1.SelectParameters.Add("ArticleId", TypeCode.Int32, 0)
'Alternatively hide the grid and display default content on page directly
'GridView1.Visible = False
'Show some default text on some Label, etc. or unhide a pre
End If
'For String Values
If Request.QueryString("id").Length > 0 Then
SqlDataSource1.SelectParameters.Add("ArticleId", TypeCode.Int32, m_intArticleId)
Else
'Send some default value here such as 0
SqlDataSource1.SelectParameters.Add("ArticleId", TypeCode.Int32, 0)
'Alternatively hide the grid and display default content on page directly
'GridView1.Visible = False
'Show some default text on some Label, etc. or unhide a pre
End If
End If
The String part in the above posted code has been wrongly posted, Use this one instead.
'For String Values
If Request.QueryString("name").Length > 0 Then
SqlDataSource1.SelectParameters.Add("ArticleId", TypeCode.String, Request.QueryString("name"))
Else
'Send some default value here
SqlDataSource1.SelectParameters.Add("ArticleId", TypeCode.Int32, "SomeDefaultName")
'Alternatively hide the grid and display default content on page directly
'GridView1.Visible = False
'Show some default text on some Label, etc. or unhide a pre
End If
Find herewith the code in C#. I mostly use this converter to get the most good inter-convertion of VB and C#: http://www.developerfusion.com/tools/convert/vb-to-csharp/
//Define this on class or page level
private int m_intArticleId;
private string m_strName;
//Write below code in Page_Load event
if (Request.QueryString("id") != null) {
//For Integer Values
if (int.TryParse(Request.QueryString("id"), m_intArticleId)) {
SqlDataSource1.SelectParameters.Add("ArticleId", TypeCode.Int32, m_intArticleId);
}
else {
//Send some default value here such as 0
SqlDataSource1.SelectParameters.Add("ArticleId", TypeCode.Int32, 0);
}
//Alternatively hide the grid and display default content on page directly
//GridView1.Visible = False
//Show some default text on some Label, etc. or unhide a pre
//For String Values
if (Request.QueryString("name").Length > 0) {
SqlDataSource1.SelectParameters.Add("C_Name", TypeCode.String, Request.QueryString("name"));
}
else {
//Send some default value here
SqlDataSource1.SelectParameters.Add("C_Name", TypeCode.Int32, "SomeDefaultName");
}
//Alternatively hide the grid and display default content on page directly
//GridView1.Visible = False
//Show some default text on some Label, etc. or unhide a pre
}
Change Line 30 of above code to:
SqlDataSource1.SelectParameters.Add("C_Name", TypeCode.String, "SomeDefaultName");
Hi Moghazali,
I'm getting errors from line 9 in your code. The first error is: "The best overloaded method match for 'int.TryParse(string, out int)' has some invalid arguments"?
Thanks,
Keith
I'm getting errors from line 9 in your code. The first error is: "The best overloaded method match for 'int.TryParse(string, out int)' has some invalid arguments"?
Thanks,
Keith
don't need to use int32 change it to
if (int.TryParse(Request.Quer
if (int.TryParse(Request.Quer
Featured Post
It's easy! Check out this step-by-step guide for asking an anonymous question on Experts Exchange.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
Exception Handling is in the core of any application that is able to dignify its name.
In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month9 days, 19 hours left to enroll
624 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.