i have 2 dropdownlist and gridview. Im trying to make a link after displaying the relational data in the gridview like below But how can i get the value and combine with the link
[Code]....
this is the all of my code
[Code]....
im just trying to use this answer, but im getting an error on my page:
"A field or property with the name 'returnantID' was not found on the selected data source."
Im not really sure what the "returnantID" is but it appears my page isn't liking it, not sure if i was sopposed to cswap it out for some other data or not.
This is my current gridview:
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" GridLines="None"
DataSourceID="ObjectDataSource1">
<Columns>
<asp:BoundField DataField="ProductName" HeaderText="ProductName"
SortExpression="ProductName" />
<asp:BoundField DataField="Price" DataFormatString="{0:c2}" HeaderText="Price"
SortExpression="Price" />
<asp:BoundField DataField="Length" HeaderText="Length"
SortExpression="Length" />
<asp:BoundField DataField="Engine" HeaderText="Engine"
SortExpression="Engine" />
<asp:BoundField DataField="Colour" HeaderText="Colour"
SortExpression="Colour" />
<asp:BoundField DataField="Description" HeaderText="Description"
SortExpression="Description" />
</Columns>
</asp:GridView>
would just like the ProductName to link to the corresponding products page(using its Id)
p.s this is what i tried:
<asp:HyperLinkField DataNavigateUrlFields="returnantID" DataNavigateUrlFormatString="Details.aspx?id={0}" DataTextField="ProductName" NavigateUrl="Details.aspx" />
**Update** I changed the "returnantID" to "ProductName" which turned the name of my product into a link but clicking that link gave me this new error:
Input string was not in a correct format.
I'm building an incident reporting site in ASP. I have a gridview listing incidents, with a unique dynamic number for each incident. SQL generates a report for each incident, and I need to create a hyperlink at the end of each gridview row linking to the associated numbered document so the report can be opened and printed.
Incident Number Incident Name Incident Description Incident Report
112 fred tall link
111 frank short link
110 bill wide link
The fields are populated by pulling data from SQL (names have been changed to protect the innocent!). The link for the document needs to contain the number from the dynamically generated Incident number. SQL creates a folder full of docs:-
IncidentReport112.xml
IncidentReport111.xml
IncidentReport110.xml
I'm guessing I need to add a hyperlink field to my gridview, and then need something to tell the url to point to IncidentReportxxx.xml, where xxx is the database's Incident Number field. I am very new to coding, I'm working in ASP, language VB, using Visual Studio 2008.
I wanna add a link and when it would be clicked then a pdf file will open in next tab of our browser.
View 1 Replies I have a search option which a person can use a multi select listbox. I have it coded so it would loop through to see if its selected or not. I also have a stored procedure where the sql statement is coded for the select statement. For some reason, its not populating my gridview. Where am I doing wrong? Below is the code and stored procedure.
[Code]....
[Code]....
i have a table with a bindary data field in it (excel, pdf, word files etc).
In gridview i want to have a colum that the user can click on to open or download that file. The file is stored in the database and not on the directory.
I have searched some things but only came up with complex stuff.. I am trying to stay away from complex because i am a total noob.
I have created a web service and successfully displayed the data in a TextBox within another Project.
However, I have modified my web service so the data returned will return multiple enteries for the data rather than a singular value.
I would like to display all output fields from my web service into a GridView.
Is it possible to do this without modifying my GridView to display a ListView output etc...
Basically, I just want to place each field into a Gridview.
is there a possibility to do the following:
I have a GridView which has a button in each row. On click event I want to open a new window displaying the xml data of the row.
I tried to this with the following code in the RowCommand - event:
var doc = new XmlDocument();
doc.LoadXml(content);
Response.ContentType = "text/xml";
Response.ContentEncoding = System.Text.Encoding.UTF8;
doc.Save(context.Response.Output);
This always generates a script error:
Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed.
so i have a gridview wherein there is a linkbutton ... when i click the linkbutton it will insert data to database...
View 2 RepliesI have a Table (in SQL Server) that is being updated roughly every minute or so with new records being inserted from various sources. The number of records inserted in this duration varies from a few records up to dozens of new records. I am using an update panel to rebind my data every minute to keep the GridView current. Now that I have the data refreshing I am looking for a better solution than reloading the data every minute. how to best keep my GridView up to date? Here is what I would like to accomplish:
1. Load the GridView and refresh the contents every minute. (60 second intervals)
2. When the GridView is refreshed every minute I would like to append only the new records to the existing grid, rather than bringing back the entire result set with each round trip to the database.
3. I would like a visual cue to identify the rows that have been inserted into the GridView. If new rows were to flash/flicker with a background color (yellow) that would be ideal.
Am I even using the correct control for displaying real time data, or are their other options? I essentially am looking to find the preferred method of displaying data that is being updated in real time in a web application. I'm hoping there is a solution involving AJAX but I haven't been able to find much on The Google. I am open to changing anything and everything about my approach -- this is largely a learning exercise. For testing purposes I am currently using LinqDataSource in conjunction with a GridView in an UpdatePanel being refreshed by a Timer control every 60 seconds. Informational: I have also started playing with the [URL] in place of the Timer control. However, for the purposes of this example I would be content to achieve the desired behavior using native controls as I have described them above.
I am doing a search function where when user enters specific value (either by keying product name or product code) into textbox, data will be displayed using gridview.
However i have problems displaying it in gridview.
Below is my code:
[code]...
I am currently trying to figure out the best way to handle a data formatting issue. I have a stored procedure that pulls back basically all the data I need, but using a gridview doesn't really give me what I need.
For example...currently the gridview displays data like:
Date1 ProjectCode1 Hours ApproveChkBox
Date1 ProjectCode2 Hours ApproveChkBox
Date1 ProjectCode3 Hours ApproveChkBox
Date2 ProjectCode1 Hours ApproveChkBox
...
I would like to be able to display the information like:
[code]....
Is there anyway to do this using a nested gridview? Or is there a proper way to display this type of format?
I have a Transport Detaisl in DB , i want to dispay data on gridview with marquee scrolling up. Cabs are scheduled for drop every hour. So if drop is at 7pm i hav to dispaly on data of that hour from 6:30 to 7:15 later after 7:15 i have to display next hour data ie 8:00 pm drop data. I am able to get scrollin g data on gridview but how to schedlue it to scroll for such timings
View 1 RepliesIn one of my application, I have around 2000 records which i am displaying in gridview with normal paging.
Now I want to change this paging facility and would like to show a "more" button at the footer(just like [URL] has). The moment user clicks it, the next set of data will be retreived. This will go on till all the records are fetched.
I have a gridview with 20 records and I have scroll bar to scroll down to view the records.I m displaying respective row data when click on the select button in grid view. The problem is whenever I select the
row, the gridview refreshes and scroll bar is going up. Ofcourse it is displaying correct data. but the gridview refreshes and scroll bar goes up.I want the selected row to be shown when I select that row.
why displaying data in gridview that does not exist in database ?
View 3 RepliesI'm using the following code to retrieve the contents of a folder and display the info in a GridView - all good.
[Code]....
This works fine, but it returns ALL available data about the files, and I'd ideally like only a few of the columns. I'd also then like to be able to order the columns.
I am building a web based insurance application with VS 2008. Using the web wizard to enter newly created policy data and related information.My question is how to handles relational data in the wizard and saving that back to the database.A general idea of the setupEach policy can have multiple policy periodsEach policy period can have multiple sections and multiple policy feesSO The new wizard allows for a single policy entry, then we move to enter the policy periods. Which can be one or many per new policy, then we move to the sections and fees which can be ne or many per policy period.Each part is a step on the wizard. Policy, Period, Sections, Fees.The multiple entries are handled with an aspxgridview.NO problem in entering the data and completing the wizard, except when it comes to actually saving the data.Saving the policy and policy period information is easy because I can get the policyID value and assign that to each policy period.Problem comes in when I save the period child info. Because I can have multiple periods, I can't determine which child data (Sections and Fees) belong to which period so as to get the period ID.What process would you suggest, and how can I achieve this.I have thought of only allowing period entry per new policy. This will certainly solve the problem in a way, but does not conform to business rules.
View 1 RepliesI am facing issue with displaying data in gridview Control. GridView is displaying data Twice . One with stylesheets applied another Just a plain text without styles. I checked t in the data base . I am receiveing the single data. There is no issue from the datadase Query. And also i tested data with a gridview without any panels and styles applied. It display only single data.
[code]....
I'm trying to display soma data in a gridview. This is my table below:
ID Book Rating
1 MAGIC IN THE OUTFIELD 5
2 ONE GIANT LEAP 2
3 SPIDERS na
4 RULES
5 NO TALKING 1
6 NO TALKING
7 MAGIC IN THE OUTFIELD 3
8 SPIDERS 4
9 NO TALKING na
10 ONE GIANT LEAP 3
What I need to display in the gridview is this:
Book Average Rating
MAGIC IN THE OUTFIELD 4
ONE GIANT LEAP 2.5
SPIDERS 0
RULES 0
NO TALKING 1
The problem is the database that I'm working with, as you can see some fields in the Rating column are empty or 'na'. How can I calulate the Average for each book.
I have one asp.net C# page in which i have gridview..
This are the url comes from database and binded in gridview
www.xxxxxx.com/A/Default.aspx
www.xxxxxx.com/B/Default.aspx
www.zzzzz.com/C/Default.aspx
what i need is i need to show this url has like this
www.xxxxxx.com/A/Default.aspx is like Test1
www.xxxxxx.com/B/Default.aspx is like Test2
www.zzzzz.com/C/Default.aspx is like Test3
if user click Test1 it will open a new browser window with www.xxxxxx.com/A/Default.aspx
if user click Test3 it will open a new browser window with www.zzzzz.com/C/Default.aspx
how to make this in gridview
I have one filed that is encrypted using Rajindal algorithm and stored in MSSQL db.When I retrieve that column in gridview it's displayed in encrypted. I have the code that decrypts it but the problem is:How can I all loop throw this column values in the gridview and decrypt them all and display it in the gridview decrypted.See my code below:
[Code]....
im developing website for my college.I have Recent updates in my home page in that i want to display newly added or updated things in recent updates.
sourcecode and Instructions for how to create link and how to redirect that to corresponding forms and how to create forms for particular updates dynamically then i want to make scroll the updates in GridView using Vb.net.
I am having one gridview in my asp form with one of the template field as imagebutton.
1. when i click on imagebutton the corresponding user profile opens in same tab....there is no option for open in new tab on right clickk..
open the user profilee in new tab.
I have two pages, the first one displays a list of products in a gridview, one column in the gridview is a hyperlink, this can be clicked on to get further details about the product. Each row in the gridview can be selected, certain details are added to an array (including the hyperlink column). I them want to display these details on page number two. All details are displayed except the hyperlink field.Has anybody any ideas as to what I'm doing wrong? The code is as follows:
[Code]....
and the second page:
[Code]....