Forms Data Controls :: Hyperlinks From Datalist Results?
Mar 11, 2010
I read a few VB books and ready or not, I going to start building!I am "very afraid" of code behind. Frankly, much of what I read about OOP went a bit over my head and am hoping by "doing" it will all come together. That said...
Datalist results. I want them to hyperlink to another page with a querystring. I moved a hyperlink control into the EDIT TEMPLATE box and removed the origianal label that was in the box. I did some editing and was able to come up with a hyperlink, but I really need a hyperlink to a new page with the original result of the datalist being the querystring parameter. For example...
If BABE RUTH is the datalist result, I want the querystring to be www.mysite.com?athlete=BABE%20RUTH. I am fairly competant in asp classic. I feel like a guy who has amnesia and has to learn the most basic stuff from scratch.
View 7 Replies
Similar Messages:
Aug 3, 2010
I created a datalist which contains hyperlinks that when clicked will redraw the page and update my another datalist in the same page. How do I hide this datalist after click any of its hyperlinks?
View 5 Replies
Nov 15, 2010
The problem is that i have a search page. Access Database holding the information. I have a Access Datasource on the page with a Datalist to show the data. I need to find a way on setting it up to says "Sorry no results found" when the is no results. i am unsure on how to do this though.
Below is my datasource and datalist
[Code]....
View 6 Replies
Feb 9, 2010
I have a datalist and want the results paged I have written a pager.ascx page and have an aspx and aspx.cs page to display the results. I have a stored procedure to pull the data out of the database and a class to talk between the stored procedure and presentation controls I have the pager being displayed when the results get over the limit I have set to 10 in the web.config file but when i click on the next link to display the next page of results it doesn't do anything. my aspx page is
<uc1:Pager ID="topPager" runat="server" Visible="False" />
<asp:DataList ID="newsList" runat="server" CssClass="List" align="center">
<ItemStyle CssClass="ItemList" />
<ItemTemplate>
<h2><%# Eval("Title") %></h2>
<p>Posted <%# Eval("Date") %></p>
<p><%# Eval("News").ToString().Replace("
", "<br />") %></p>
</ItemTemplate>
</asp:DataList>
<uc1:Pager ID="bottomPager" runat="server" Visible="False" />
my aspx.cs page is
protected void Page_Load(object sender, EventArgs e)
{
// Retreive page from the query string
string page = Request.QueryString["Page"];
if (page == null) page = "1";
// How many pages of posts
int howManyPages = 1;
// pager links format
string firstPageUrl = "";
string pagerFormat = "";
//DataAccess.GetNews returns a DataTable object containing news data which is read into datalist
newsList.DataSource = DataAccess.GetNews(page, out howManyPages);
// Bind the data to the data source
newsList.DataBind();
// have the current page as interger
int currentPage = Int32.Parse(page);
// Display pager controls
topPager.Show(int.Parse(page), howManyPages, firstPageUrl, pagerFormat, false);
bottomPager.Show(int.Parse(page), howManyPages, firstPageUrl, pagerFormat, true);
}
my pager.ascx page is
<p>
Page
<asp:Label ID="currentPagelabel" runat="server" />
of
<asp:Label ID="howManyPageLabel" runat="server" />
|
<asp:HyperLink ID="previousLink" runat="server">Previous</asp:HyperLink>
<asp:Repeater ID="pagesRepeater" runat="server">
<ItemTemplate>
<asp:HyperLink ID="hyperlink" runat="server" Text='<%# Eval("Page") %>' NavigateUrl='<%# Eval("Url") %>' />
</ItemTemplate>
</asp:Repeater>
<asp:HyperLink ID="nextLink" runat="server">Next</asp:HyperLink>
</p>
my pager.aspx.cs page is
using System;
// Simple struct that represents a (page number, url) association
public struct PageUrl
{
private string page;
private string url;
// Page property definition
public string Page
{
get
{
return page;
}
}
// Url property definition
public string Url
{
get
{
return url;
}
}
// Constructor
public PageUrl(string page, string url)
{
this.page = page;
this.url = url;
}
}
// The pager control
public partial class UserControls_Pager : System.Web.UI.UserControl
{
protected void Page_Load(object sender, EventArgs e)
{
}
// Show the pager
public void Show(int currentPage, int howManyPages, string firstPageUrl, string pageUrlFormat, bool showPages)
{
// Display paging controls
if (howManyPages > 1)
{
// make the pager visable
this.Visible = true;
// Display the current page
currentPagelabel.Text = currentPage.ToString();
howManyPageLabel.Text = howManyPages.ToString();
// Create the Previous link
if (currentPage == 1)
{
previousLink.Enabled = false;
}
else
{
previousLink.NavigateUrl = (currentPage == 2) ? firstPageUrl : String.Format(pageUrlFormat, currentPage - 1);
}
// Create the Next link
if (currentPage == howManyPages)
{
nextLink.Enabled = false;
}
else
{
nextLink.NavigateUrl = String.Format(pageUrlFormat, currentPage + 1);
}
// Create the page links
if (showPages)
{
// The list of pages and their URLs as an array
PageUrl[] pages = new PageUrl[howManyPages];
// Generate (page, url) elements
pages[0] = new PageUrl("1", firstPageUrl);
for (int i = 2; i <= howManyPages; i++)
{
pages[i - 1] = new PageUrl(i.ToString(), String.Format(pageUrlFormat, i));
}
// Do not generate a link for current page
pages[currentPage - 1] = new PageUrl((currentPage).ToString(), "");
// Feed the pages to the repeater
pagesRepeater.DataSource = pages;
pagesRepeater.DataBind();
}
}
}
}
my class file is
// Retreive the list of news posts
public static DataTable GetNews(string pageNumber, out int howManyPages)
{
// Get a configured DbCommand object
DbCommand comm = GenericDataAccess.CreateCommand();
// Set the stored procedure name
comm.CommandText = "GetNews";
// create a new parameter for page number
DbParameter param = comm.CreateParameter();
param.ParameterName = "@PageNumber";
param.Value = pageNumber;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
// create a new parameter for products per page
param = comm.CreateParameter();
param.ParameterName = "@PostsPerPage";
param.Value = PlatiumMindProductionsConfiguration.PostsPerPage;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@HowManyPosts";
param.Direction = ParameterDirection.Output;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
// Execute the stored procedure and saven the results in a DataTable
DataTable table = GenericDataAccess.ExecuteSelectCommand(comm);
// Calculate how many pages of posts and set the out parameter
int howManyPosts = Int32.Parse(comm.Parameters["@HowManyPosts"].Value.ToString());
howManyPages = (int)Math.Ceiling((double)howManyPosts / (double)PlatiumMindProductionsConfiguration.PostsPerPage);
// return the page of posts
return table;
}
my stored procedure is
ALTER PROCEDURE [dbo].[GetNews]
(@PageNumber INT,
@PostsPerPage INT,
@HowManyPosts INT OUTPUT)
AS
-- Declare a new table
DECLARE @News TABLE
(RowNumber INT,
NewsID INT,
Title NVARCHAR(50),
Date DATETIME,
News NVARCHAR(MAX))
-- Populate the table with the complete list
INSERT INTO @News
SELECT ROW_NUMBER() OVER (ORDER BY NewsID desc),
NewsID, Title, Date, News
FROM News
-- return the total number of posts
SELECT @HowManyPosts = COUNT(NewsID) FROM News
-- extract the request page of posts
SELECT NewsID, Title, DATE, News
FROM @News
WHERE RowNumber > (@PageNumber - 1) * @PostsPerPage
AND RowNumber <= @PageNumber * @PostsPerPage
View 1 Replies
Sep 9, 2010
I was working on a fairly simple code to get RSS into gridview. The code works fine with the URL mentioned in code but unable to work on Commented one.
[Code]....
View 3 Replies
Apr 1, 2010
I am trying to get a hyperlink to show up in each field of the "Title" column in the gridview below, but it doesn't render as a hyperlink:
ID
Title
City
State
115779
<a href=job_details.aspx?jobID=115779>Online Advertising Inventory / Yield Manager (773044)</a>
Washington DC
115801
<a href=job_details.aspx?jobID=115801>Administrative Assistant (778554)</a>
Washington
DC
115840
<a href=job_details.aspx?jobID=115840>20769 Deal Leads</a>
Washington
DC
Here is the behind code:
[Code]....
And here is the webform code:
[Code]....
View 5 Replies
Jan 21, 2010
currently I have data displayed via repeater and I need to do the following:
Convert each row into a hyperlink Pass through each row (hyperlink) as the query - ?stID The receiving page has the code:
[code]....
View 5 Replies
Apr 28, 2010
I have a gridview with a hyperlink control that allows the user to save pages to it (www.google.ca, asp.net, etc). Unfortunately it always adds the server name to the beginning of their link. [URL] I was wondering is there any way to change that within the control. or should I have it pass a query string to a url handler that will response.redirect them to their actual page?
View 3 Replies
Aug 20, 2010
In the following code i have to continuing showing the rows of the gridview as links. For example: the user will click on a customer and will see more detailed information.
protected void Button1_Click(object sender, EventArgs e)
{
//List<Customer> customersresult = new List<Customer>(); does not match the type here
CustomerWebServiceClient.Customer[] cust;
CustomerWebServiceClient.CustomerWebService client = new CustomerWebServiceClient.CustomerWebService();
cust = client.GetCustomerContract(TextBox1.Text); //coming across now..
//if (cust.va) validate if there is data
GridView1.DataSource = cust;
GridView1.DataBind();
}
// this is showing the gridview with the data coming. What would be next steps to show the rows as hyperlinks.
View 3 Replies
Jan 20, 2011
I need a GridView with 6 columns, one of which ("ItemID") is a HyperLink who's URL and text is determined from the C# code as I will get that data from an SQL database
INITIALLY, what I wanted to do, which would have been easy as pie, is:
[Code]....
HOWEVER, this does not work because every row in the Item ID column is filled with "System.Web.UI.WebControls.HyperLink". Apparently, this is what the HyperLink's toString() method returns. Apparently, you can't just throw a HyperLink into a DataRow and call it a day. I need to know how to make this ItemID column into such a HyperLink. It doesn't necessarily HAVE to be a HyperLink control, it just has to be able to call my javascript function on the aspx page, "popUp(URL)"
To give you a visualization of what I'm trying to achieve: this is a change log for an inventory system. The ItemID column indicates what item was altered. However, simply just having a number there doesn't say much, so I'm trying to create a link with the text, for example, "42 (motherboard x)". In other words reader["ItemID"] + " (" + reader["Description"] + ")", and that link will run a javascript function I have called popUp(URL) which takes a URL and opens it in a new window of specific size and location, to view that item's details.
I've tried various other methods such as disabling AutoGenerateColumns and manually create a HyperLinkField, but to no avail, because I couldn't get it to run my javascript function that way.
View 6 Replies
Mar 8, 2011
we're creating a GridView to display news articles programmatically (not using a SQL database).
We can create & display the GridView, but are having a devil of the time to get the hyperlinks in SetupGrid() attached to the titles
of the articles in the GridView. Below is our .aspx code and .vb code of how we create the GridView. Any ideas on what we should do to get the hyperlinks array of strHyperlinks() in SetupGrid() to be applied to the titles in column 1 of the GridView?
[Code]....
View 2 Replies
May 10, 2010
I have a stored procedure (For Eg: sp_GetAvlData) that accepts a number of parameters, 3 of which are TimeFrom, TimeTo (as varchar) and TimeInterval (as int), formulates a Dynamic query and executes itself. So for instance, if I call the proc as follows:
[code]....
dtAvl is the datatable containing the results of my stored procedure.
The next step for me is to make each of the cells (except the cells in the first column) as a Hyperlink so that when clicked upon a cell, it populates 2 textboxes with the selected Timeslot and Name or ID (ID field is not displayed in Gridview). The textboxes are located on the same page but outside of the Gridview control.
The Challenge that I'm facing out here are:
1) As you can see, the field names being generated are not fixed and I have no control over them.
2) Because the field names are not fixed I'm not sure I can implement this using the Templatefields or BoundFields of Gridview.
Is there any way to achieve the Hyperlinking of these cells within the Gridview?
View 3 Replies
Mar 23, 2011
I have a requirement to create multiple hyperlinks dynamically in a single GridView Column. The number of hyperlinks are not not known in advance and will depend on the results brought up by a query. How do I create the same?
View 4 Replies
Mar 16, 2011
Am building a Form for out intranet that runs on ASP.NET and C#, it is to be a survey from a SQL database. I have the connections setup can pull informations/Questions from the database. I am having a problem with setting up radio buttons within a datalist, ive never done this and i know they require unque names.
It is to be 4 radio buttons per question where only one can be select, i know how to group just not via a datalist with unique names
View 6 Replies
Jun 4, 2010
How can I do paging with datalist if that datalist is populated with inputs coming from a querystring?
View 3 Replies
Aug 30, 2010
I need to find which Selected Key value that was selected in the ChildDatalist inside the MainDatalist
this is my Html code...for the MainDataList and the nested Childdatalist
[Code]....
View 3 Replies
Mar 14, 2011
I am trying to place a datalist inside datalist. I managed to place a datalist inside gridview but not datalist inside datalist.
Below is the code I am using to bind the datalist into the master gridview, I am trying to change this code in such way it will be right for datalist inside datalist but so far I did not succeed.
[Code]....
View 2 Replies
Aug 16, 2010
i have a datalist . that is contains 7 columns in repeat layout .when i have more from 7 columns , datalist style is normal .but when i have smaller than 7 columns ! data list style is not normal,
because there are some empty columns without specific schema.
How i can make a datalist > when i have 1 columns in my datalist my first layout width be 100% ;
and dont show some empty layout ?
View 2 Replies
May 17, 2013
how can i export by remove the coloumn and rows hyperlink when export to CSV
View 1 Replies
May 12, 2013
When I am trying to export data from gridview to excel i an also getting hyperlink along with that, how can i remove that before export. below is my code
<div align="right" style="padding-top:5px; padding-right:5px">
<span title="Export Data to Excel"><asp:ImageButton ID="btnExporttoExcel"
runat="server" ImageUrl="~/img/Excel_Logo.png"
onclick="btnExporttoExcel_Click" /></span>
<span title="Export Data to Word"><asp:ImageButton ID="btnExporttoWord"
[Code] ....
View 1 Replies
Apr 23, 2012
In Datalist Item Template Another Datalist And Child Datalist How can we access link button inside chile datalist when click in child link button
View 1 Replies
Dec 3, 2013
Here is my code through which i can generate dynamically 2 checkbox group
DataTable dt = new DataTable();
DataList1.DataSource = dt;
DataList1.DataBind();
DataList2.DataSource = dt;
DataList2.DataBind();
Design Page
[code]....
There is two checkbox group which have same datasource, so in both case same checkbox are showing and also same event is firing for both. Here is the event code
protected void CheckBox_CheckedChanged(object sender, EventArgs e)
{
string OpService = ((CheckBox)sender).Text;
}
Now what i want to do is, while check one checkbox from the 1st checkbox group the same checkbox should be selected from the second checkbox group automatically, also if i deselect one checkbox that should be deselect from both checkbox group.
View 1 Replies
May 7, 2015
How To get Datalist Checkbox Select Item To The Another Datalist on click CheckBox
Code Like
<form id="form1" runat="server">
<div>
<h2 style="background-color: #CCC; font-size: 16px; font-family: Arial, Helvetica, sans-serif; font-weight: 400;" class="heading">Brand</h2>
<asp:DataList ID="DataList5" runat="server" Style="font-weight: 700; color: #CC33FF; background-color: #66FFCC;" Height="100px" Width="122px">
<ItemTemplate>
[code]....
View 1 Replies
Oct 10, 2010
I have a datagridview control that I'm using to display cache data to the end used on a web form. The issue that I'm having is that every time I re-run the application, and the cache data is re-generated... it loads duplicate data that's being displayed to the end user. I can't seem to figure out how to keep this from happening.
What I would like to have happen is that only unique data rows be returned and cached for the end user. Unless there are new data rows on the database that needs to be included in the cache data results...the previous data results should not be duplicated. I've tried to change a few properties on the datagridview control, but nothing seem to keep this from happening.
[code]....
View 3 Replies
Nov 10, 2010
I am search option(textfield), normally i am giving exact input and click on button to get the result, but i want If I enter some character into seach field I need to return all results that have in the datase in the search field so that user need not type all the information in textbox like we have in google search.
I tried with following way but not able to acheive it, it pull only first letter match records..
Dim query As String = "Select vendor,ponumber,partno,description,qtyorder,qtybalance,duedate,processStep,ETA, Comments from openorder where PartNo like '" + txtSearch.Text + "%' "
View 2 Replies