Forms Data Controls :: Making A Row Of A Designated Column Clickable To See The Details In Another Page?
Apr 10, 2010
I have a GridView which is linked to the database via SqlDataSource.
What I would like to do is to make each row of a designated column clickable. Once the user has clicked on a row, the application should postback to another page to allow the user to read all the details of that row.
The effect should be as we can see in this post: if you go to "mypost", you have a list of posts and then when you click on one of them you are able to see the details of that.
I read lots of posts that are using, however, other methods such as datalist + dataset controls etc.
View 3 Replies
Similar Messages:
Feb 24, 2010
I have a database table column consisting of text URLs [URL] In my LINQ-to-SQL-driven gridview, I want to make this a clickable link programmatically, with differing link text (e.g. "Link text"). I'm getting close but am missing some key concept. Here's the core of the .vb codebehind:
Dim dctx As New ResourceMod.ResourceModDALDataContext
Dim eleResObj = From eleRes In dctx.Resources Where eleRes.Type = "url" Select siteurl = eleRes.Website
GridView1.DataSource = eleResObj
GridView1.DataBind()
This displays the raw URL in the gridview (i.e. non-clickable). I've experimented with adding an explicit hyperlink column a la [URL](setting AutoGenerateColumns false etc.), but haven't yet figured out how to assign the asp:hyperlink Text and NavigateUrl fields with the anonymous-type object eleResObj. Using a field construct such as Text='<%# Eval("siteurl") %>' isn't working, presumably a scope issue. Is a LinqDataSource needed in this case, and if so, how would that affect the original LINQ query?
View 2 Replies
Apr 12, 2010
I have on a page a gridview that can be filtered with one text box. I set up the gridview to show select and wanted to then connect a details view so that when you selected a row the entire details would show up. When I run it I get this error. Data keys must be specified on GridView 'GridView1' before the selected data keys can be retrieved. Use the DataKeyNames property to specify data keys.
<%@ Page language="C#" masterpagefile="MainContent.master" title="Electrical Storage" EnableEventValidation="false" %>
<asp:Content id="Content1" runat="server" contentplaceholderid="Content">
<div id="Rightside">
<h2>Search Electrical Storage
</h2>
<li><a href="EStorageResultsAll.aspx">View All Files</a></li>
<li>Specify Projects to View</li>
<br />
<br />
<form>
Search: <asp:TextBox id="Search" runat="server"></asp:TextBox>
(% is wildcard)<br /><br />
<asp:Button runat="server" Text="Search" id="Button1"
PostBackUrl="electrical_storage.aspx" Height="26px" BackColor="#000066" ForeColor="White" Width="129px"></asp:Button>
<br />
<hr />
<asp:GridView id="GridView1" runat="server" AutoGenerateColumns="False" BackColor="#CCCCCC" BorderColor="#999999" BorderStyle="Solid" BorderWidth="3px" CellPadding="4" CellSpacing="2" DataSourceID="AccessDataSource1" ForeColor="Black" Width="820px" AllowSorting="True">
<RowStyle BackColor="White" />
<Columns>
<asp:commandfield ShowSelectButton="True">
</asp:commandfield>
<asp:boundfield DataField="CoID" HeaderText="Co ID" SortExpression="CoID">
</asp:boundfield>
<asp:boundfield DataField="ProjClass" HeaderText="Project Class" SortExpression="ProjClass">
</asp:boundfield>
<asp:boundfield DataField="Project" HeaderText="Project" SortExpression="Project">
</asp:boundfield>
<asp:boundfield DataField="FileName" HeaderText="File Name" SortExpression="FileName">
</asp:boundfield>
<asp:boundfield DataField="FileAddInfo" HeaderText="File Add Info" SortExpression="FileAddInfo" Visible="False">
</asp:boundfield>
<asp:boundfield DataField="FileNumber" HeaderText="File Number" SortExpression="FileNumber" Visible="False">
</asp:boundfield>
<asp:boundfield DataField="BoxNumber" HeaderText="Box Number" SortExpression="BoxNumber" Visible="False">
</asp:boundfield>
<asp:boundfield DataField="Location" HeaderText="Location" SortExpression="Location" Visible="False">
</asp:boundfield>
</Columns>
<FooterStyle BackColor="#CCCCCC" />
<PagerStyle BackColor="#CCCCCC" ForeColor="Black" HorizontalAlign="Left" />
<SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#000066" Font-Bold="True" ForeColor="White" />
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="\Elec1DATABASEStorageElectricalFilesBook.mdb" SelectCommand="SELECT [CoID], [ProjClass], [Project], [FileName], [FileAddInfo], [FileNumber], [BoxNumber], [Location] FROM [FilesWithLocation]
WHERE (([CoID] LIKE '%' + ? + '%') OR ([ProjClass] LIKE '%' + ? + '%') OR ([Project] LIKE '%' + ? + '%')OR ([FileName] LIKE '%' + ? + '%')OR ([FileAddInfo] LIKE '%' + ? + '%')OR ([BoxNumber] LIKE '%' + ? + '%'))">
<SelectParameters>
<asp:controlparameter ControlID="Search" Name="CoID" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="ProjClass" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="Project" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="FileName" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="FileAddInfo" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="FileNumber" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="BoxNumber" PropertyName="Text" Type="String" />
</SelectParameters>
</asp:AccessDataSource>
<asp:AccessDataSource id="AccessDataSource2" runat="server" DataFile="\Elec1DATABASEStorageElectricalFilesBook.mdb" SelectCommand="SELECT * FROM [FilesWithLocation] WHERE ([SearchString] = ?)">
<SelectParameters>
<asp:controlparameter ControlID="GridView1" Name="SearchString" PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:AccessDataSource>
<asp:DetailsView id="DetailsView1" runat="server" AutoGenerateRows="False" DataSourceID="AccessDataSource2" Height="50px" Width="442px">
<Fields>
<asp:boundfield DataField="CoID" HeaderText="Company ID" SortExpression="CoID">
</asp:boundfield>
<asp:boundfield DataField="ProjClass" HeaderText="Project Class" SortExpression="ProjClass">
</asp:boundfield>
<asp:boundfield DataField="Project" HeaderText="Project" SortExpression="Project">
</asp:boundfield>
<asp:boundfield DataField="FileName" HeaderText="File Name" SortExpression="FileName">
</asp:boundfield>
<asp:boundfield DataField="FileAddInfo" HeaderText="File Additional Info" SortExpression="FileAddInfo">
</asp:boundfield>
<asp:boundfield DataField="PeriodBegin" DataFormatString="{0:d}" HeaderText="Period Begin" SortExpression="PeriodBegin">
</asp:boundfield>
<asp:boundfield DataField="PeriodEnd" DataFormatString="{0:d}" HeaderText="Period End" SortExpression="PeriodEnd">
</asp:boundfield>
<asp:boundfield DataField="FileType" HeaderText="File Type" SortExpression="FileType">
</asp:boundfield>
<asp:boundfield DataField="FileNumber" HeaderText="File Number" SortExpression="FileNumber">
</asp:boundfield>
<asp:boundfield DataField="BoxNumber" HeaderText="Box Number" SortExpression="BoxNumber">
</asp:boundfield>
<asp:boundfield DataField="SearchString" HeaderText="Search String" ReadOnly="True" SortExpression="SearchString">
</asp:boundfield>
<asp:boundfield DataField="Location" HeaderText="Location" SortExpression="Location">
</asp:boundfield>
</Fields>
</asp:DetailsView>
</form>
</div>
</asp:Content>
<asp:Content id="Content2" runat="server" contentplaceholderid="head">
<style type="text/css">
table {
width: 820px;
}
.gridview {
width: 820px;
position: fixed;
}
</style>
</asp:Content>
View 5 Replies
Mar 14, 2011
I have a gridview that includes a checkbox colum (Item Tempate).I need to be able to select row but when mouse is over checkbox column it should not be clickable. Is this possible?Think of it as an Inbox type gridview where checkbox is used for deleteing messages but when you click on subject or name it will show the message. I need the same functionality.
View 7 Replies
Dec 30, 2010
I have gridviwe having 2 columns:
1) DocNumber 2)Title
query select docnumber,title from tbl_docs.
BindwithGridviwe(sql);
Now the issue is that that every document doesn't has document number. I want to make invisible the docuNumber column of the grid viwe if all values in the docNumber retrieved are null.for example:
docnumber tite
null Document 1
null Document 2
null doucment 3
null document 4
if returned result match above where all docnumber are null then make the gridviwe docnumber column ivisible eslemake the greidviwe column visible.
View 4 Replies
Nov 18, 2010
I would like to add a column in my datagridview that takes the value from the database and asigns it to the text of a linkbutton or make it a hyperlink. i know how to handle getting the value from the row but dont
know how to make a value a link, or set the text to a link button
View 3 Replies
Jan 5, 2010
I had problems with using the gridview. For example I can bind or a a row of data to the gidview but the column data in the details section does not line up appropriately as far as justification with the grid view headers. I have tried different alignment combinations but that does not work.
View 1 Replies
Nov 30, 2010
I have a DetailsView for inserting values and currently the columns are center aligned. What I want is to have my "label" right aligned and my "text box/dropdown box" left aligned.
Something like:
Name: _______________
Address: __________________________
Phone: __________
Insert Cancel
If I change the alignment to left for both, the Insert and Cancel buttons on the bottom of the control also shift to the left, and I'd like them to stay centered.
View 2 Replies
Oct 19, 2010
I have a table being generated in an ASP.net web app. The table has 4 columns. Currently each cell of each row can be clicked to get more detailed info. However, I do not want the first and the last cell in each row to be clickable. How can I make it so that only the first second and third cell can be clicked?
Below is some of the code (from the .cs file):
if(e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.BackColor = TRADER_BACKCOLOR;
e.Row.Cells[0].Font.Bold = true;
e.Row.Attributes.Add("onmouseover", "style.backgroundColor = 'Silver'");
e.Row.Attributes.Add("onmouseout", "style.backgroundColor = '" + TRADER_HEX + "'");
e.Row.Attributes.Add("onclick", "RowClick(this, '" + e.Row.Cells[0].Text + "');");
From the .aspx file:
function RowClick(caller, id)
{
if(document.getElementById(id).style.display == "block")
{
if(last != "" && parent == id)
{
HideDetailed();
}
document.getElementById(id).style.display = "none";
}
else
{
document.getElementById(id).style.display = "block";
}
}
View 2 Replies
Apr 13, 2010
i have a gridview, and i want to be able to click on a product, which then redirects me to another page showing me the details of that product.
View 2 Replies
Jun 16, 2015
I am referring below url , there is one column which has some large data i dont want to show in grid, but on clicking show detail i want to show detail in Modal Popup, right now it shows blank data, is there any solution for it. URL..
View 1 Replies
Mar 11, 2011
I have a gridview control with a details column. I want the user to click details and it give me a pop-up showing details of the particular row. Any idea on how to do this using JQuery?? Looking for an example with code..
View 1 Replies
Apr 11, 2010
I have a details view that appears when record is selected in a GridView. Can this details view be opened in it's own modal window that would allow me to use the full event model?
View 3 Replies
Jun 26, 2010
I'm trying to get a record to show up in a details view as part of a Master Details. I was able to get this to work by setting the visibility to true for the Details View in the Page Load event. I now want the details view to show up when the Select button is clicked in the GridView's template field using the onClick event for the button. I don't seem to be assigning the correct properties to get this to work though. what property I should use with this? I know I have to get it from the GridView and assign it to the details but haven't gotten it to work. this is the GridView:
[Code]....
View 4 Replies
Jan 8, 2011
My goal is to load a row details from db to a webform and let the user update it's value .
The user searches an id (i have a stored procedure for that), how i show that data from the row nicely in the web page through the dal layer. After the data is shown on the page the user need to update a cell in the row and send it.(the part of updating is not the problem).
in other questions how should the dal method should look and how i integrate it's result in the presentation layer (the aspx webform).
View 2 Replies
Aug 20, 2010
I have a listview using Update to edit records. Something is wrong with the SQL update command. I get an error on page "Input string was not in correct format". How can I view the actual SQL statement being generated?
View 2 Replies
Feb 11, 2010
Here is the hyperlink control to my details page:
[Code]....
However, the details page could not retrieve the page base on the clsNotesID. Here is my SqlDataSource control:
[Code]....
The clsNoteID has a DataType of uniqueidentifier. I was wondering if the clsNoteID passing through the QueryingString has to be suround by a single quotes. If so, how do implement the single into my HyperLink control?
View 5 Replies
Dec 22, 2010
I have a datalist which when a record is clicked you get taken to a details page .../details.aspx?ID=12And that record is displayed in a details view. All this works fine. My question is how can I add the next and previous buttons on the detailsview so they work? If the details view is on the same page as the datalist works no porblem but on a seperate page I get no next and previous records
View 4 Replies
Jan 12, 2011
Site basically has datbase results which can be sorted on a page. each record in the recordset also has a link to a Detail Page with more information on that item.
I would like to put some links "previous" and "next" on the details page so that a visitor does not have to go back to the results page and choose the next item in the list.
I've seen this on other sites but just can't seem to grasp it. Database results are done using ASP.NET
Anyone have any pointers? or if you have an asking price I'm all for that as well as long as I learn from it. I can provide url and code if needed.
View 3 Replies
Apr 19, 2010
I have the below code in a user control used at many places in my website.I want the whole control to behave as a hyperlink and redirect to the 'Testimonial page'.How can I accomplish it?
<div id="divRndTesti" class="testimonials-inner" runat="server" >
<asp:Repeater ID="repTesti" runat="server">
<ItemTemplate>
<p><%# Truncate(Eval("TestmlDescription").ToString(), 100, true)%></p>
<span><strong><%#Eval("UserName")%></strong>
<br /><%#Eval("UserState")%>, <%#Eval("UserCntry")%></span>
</ItemTemplate>
</asp:Repeater>
</div>
View 3 Replies
May 21, 2010
How do you make a gridview(asp.net 3.5) clickable? In other words how can I make it so that I can select a row in the grid? In fact click on any row.
View 10 Replies
Apr 18, 2010
Was working fine and all of a sudden I can't click my column any more!??
Here's the code...[Code]....
View 2 Replies
Aug 31, 2010
<asp:templatecolumn headertext="Purchase Order">
View 4 Replies
Oct 29, 2010
I have requirement like to display the Master details records in the page, without clicking the parent record (for getting ID to retrieve the detail record) i need to display all the child records in between the Master records while page loads.
View 3 Replies
Jan 28, 2010
I have this specific task: I have a contacts table, and when users view a specific contact in details page I want to display a button in the page (doesn't matter anywhere, but inside the detailsview control next to the "edit" hyperlink is better), when it's clicked I want to grab all the info of this contact instance and write it to Response so user can save it through the save file dialog. So far I have two problems1. How do I access the contact? it's displaying on the page but when I tried detailsview.dataitem it returns null, e.result in the datasource selected event handler also returns null...2. I can get the button (outside the detailsview control) to trigger the file download dialog, but how do I achieve the same thing if the button is placed inside the details view which is in turn inside a updatepanel?
View 1 Replies
