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.
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?
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.
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
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.
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
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?
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.
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.
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?
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?
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?
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
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.
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% ;
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"
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
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.
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.
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 + "%' "
