Data Controls :: Export GridView With TemplateField Containing HyperLinks
May 17, 2013how can i export by remove the coloumn and rows hyperlink when export to CSV
View 1 Replieshow can i export by remove the coloumn and rows hyperlink when export to CSV
View 1 RepliesWhen 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] ....
<asp:GridView ID="gvDriverList" runat="server" CssClass="table table-striped table-bordered table-hover"
AllowPaging="True" AllowSorting="True" DataKeyNames="PkDriver"
AutoGenerateColumns="False" PageSize="5" OnSorting="gvDriverList_Sorting"
OnRowDeleting="gvDriverList_RowDeleting" OnRowDataBound="gvDriverList_RowDataBound"
[Code]....
I have a repeater control which has an table format that has textboxes in it. I tried the solution at [URL] which works but loses the table format. I have an example below in which I have modified that code and have it so now the table format stays but the values show outside the table and not in the correct columns and rows.
I need to keep the values in the proper location.
<asp:Repeater ID="rptMonthlyReport" runat="server" OnItemDataBound="rptMonthlyReport_ItemDataBound">
<HeaderTemplate>
<header>
<asp:Label ID="lblOne" runat="server">Monthly Performance Report</asp:Label>
</header>
<table id="tblMonthlyReport" border="1">
[code].....
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]....
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 RepliesIn 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?
[Code]....
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?
View 4 RepliesI want to create simple rating page where player's place,name and rating is displayed. I've created database with ID,Name and Rating Columns, binded Gridview to this database and created TemplateField "Place". With following code I've created numbered list for Place:
protected void Page_Load(object sender, EventArgs e){
for (int i = 0; i < GridView1.Rows.Count; i++)
I have a GridView, bound to a table (Meals) in a SqlDataSource.
Into that GridView, I have added a TemplateField, which contains a DropDownList (which displays the numbers 1 - 10, added manually; no Data Binding). And, I've added a ButtonField.
When I click the Button, I want the values of some of the GridView rows PLUS whatever value was selected in the DropDownList to be pulled out and stored in a second Sql table (Orders).
Pulling the rows bound to the SqlDataSource is easy but JavaScript is needed (I think) to pull the SelectedValue from the DropDownList. I understand women more than understand JavaScript (that's how little I know) and the code below has been kindly offered by another forum user who is at a loss, himself, now.
Here's the code and the error message I'm getting.
ASPX:
[Code]....
And here's the Code Behind:
[Code]....
No design time errors reported but here's the run time error:
Object reference not set to an instance of an object.
On the following line:
Line 28: if (row.RowType == DataControlRowType.DataRow)
[Code]....
[Code]....
I want to add two image button in the TemplateField.. and add it in the gridview.
I have dynamically created my gridview in the codebehind.
All is working correctly.
I now need to dynamically add a TemplateField to the gridview and populate it with a Button.
I have the following code so far:
TemplateField tempField = new TemplateField();
Button btnRemove = new Button();
How to retrieve data from itemtemplate of gridview
View 1 RepliesI'm relatively new to the VS environment. I'm using VS2010 Beta 2 with VB. I have a Gridview setup to pull a list of employees. Next to their name I have edit and delete icons. When I leave the icons as ButtonFields, they pass the DataKey value to my code behind perfectly. When I convert the ButtonFields to TemplateFields, they no longer pass the DataKey.
[Code]....
[Code]....
[Code]....
I have problem while set or passing value from code behind to asp:label inside gridView asp:templateField. 1st. I have gridView and using SqlDataSource control for data source. This is my gridView code?
[Code]....
2nd. I have SqlDataSource for my GridView. this is the code :
[Code]....
We can set value in the *.aspx or design view by using <%# bind("str_isi") %> like the asp:label control with ID=lblGvPengumuman but how we can set value in code behind?
i want to sort a gridview column which is a template field with a repeater control in it. this column has multiple links and i would like to sort using the first link. how can i achieve this.
here is my code:
<asp:TemplateField HeaderText="Groups">
Though it is usually not a big deal to edit the source code to accomplish this, I am just curious if there is an easier way to reverse the conversion of a column to a TemplateField. The covnersion can be done by a simple click. Is there a similar click to reverse it?
View 3 Repliesi have a website with a radiobutton inside a gridview, i set the groupname in the gridview but when i run the table, the radiobutton did not became exclusive or i can checked = true on all radiobutton. this is my code:
[Code]....
I was wondering how to hide a control(lblPrice) in a gridview(Gridview1)'s templatefield, given certain conditions? Like:
If X condition then
-- code to hide lblPrice --
End If
I am trying to set the label created in my templatefield during rowbound but I got an error of object reference not set to an instance.
Below is the code for my page.
[Code]....
how to set colors in ESM field if ESM = Elective (Green), Emergency (Red) and Urgent (Purple)
here's my code:
<asp:TemplateField HeaderText="STATUS">
<ItemTemplate>
<asp:Label runat="server" ID="lblStatus" ForeColor='??????????' Text='<%# Eval("ESM")%>'
/>
</ItemTemplate>
</asp:TemplateField>
I have a gridview with a DropDownList (contained in a TemplateField). I have set the OnSelectedIndexChanged event to a function called "ddlAgent_SelectedIndexChanged" This allows me to aquire when a user has changed the value for the dropdownlist. What I need to do is persist this newly selected value to the database for the gridview record. The problem I'm having is how to I get the datakeyNames value for that row? See code below!
TemplateField source
<asp:TemplateField HeaderText="Agent">
<ItemTemplate>
<asp:DropDownList ID="ddlAgent" runat="server" AutoPostBack="False" OnSelectedIndexChanged="ddlAgent_SelectedIndexChanged">
</asp:DropDownList>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:TemplateField>
ddlAgent_SelectedIndexChanged
Protected Sub ddlAgent_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)
Dim gvItems As DropDownList = CType(sender, DropDownList)
' Write the selected Agent ID to the Inquiry record.
'Dim ID As Integer = gvMaint.DataKeyNames(e.SelectedIndex).Value ' THIS FAILS BECAUSE
e.SelectedIndex is not part of System.EventArgs
End Sub