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
I am trying to handle the unhandled exceptions in my project.I tried with this following code in my web.config filebut it is not at all redirecting to an error page which i have created instead of that it is throwing an exception in my code itselef. How to print the error description over therein my custom error page.
---------------------------------------------------------------------------------------------------
<sys.web>......<customErrors mode="On" defaultRedirect="~/Error.aspx"></customErrors>...</sys.web>
---------------------------------------------------------------------------------------------------
And even i tried in Global.asax page in Application_Error() method like below
Exception ex = Server.GetLastError();Response.Redirect("~/Error.aspx?errmsg="+ex.message);Server.ClearError();
And in my Error.aspx.cs page i have placed a label and i have written code like this
protected void Page_Load(object sender, EventArgs e) {
Label1.Text=Request["errmsg"];
}
But it is not getting redirected my error page and not displaying anything on it.
<asp:TemplateField HeaderText="Location">
View 1 RepliesI got a "Input string was not in the correct format" exception but can't see the problem. The exception had no information to show what was causing the error. It's thrown before the BLL or DAL are called so it must be in the mark up. The parameters are in the right order.[Code]....
View 7 RepliesI 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>
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 RepliesI 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 RepliesI'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]....
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).
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?
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 RepliesSite 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.
<asp:templatecolumn headertext="Purchase Order">
View 4 RepliesI 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 RepliesI 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 RepliesI have records in a Gridview, when I click on the NAME of each item I want to open up and new page and display a more detailed view of the record, i.e. the extra details from the table. I have the following code setup:
<asp:GridView
ID="GridView1"
runat="server"
AutoGenerateColumns="False"
OnSelectedIndexChanged="GridView1_SelectedIndexChanged"
DataKeyNames="Code">
[Code]....
This setups the hyperlink and passes the key of the record in the URL, but how do I retrieve this key and use it on the new page ?
I have two tables: Book and author and they have one to many relation.One book may have more than one authors. Book table has Title column and Author table has AuthorName Column.
I have search page contains two textboxes: Title Textbox and AuthorName textbox to search the record.
When the user type something and hit the search button it display the Title when click the title ; it redirect to detailsPage.aspx Passing value ID.
[Code]....
Then in the Details page there are: Title, authors and other more from these table column.
My problem is:
When the user search and hit the search button, it display the number of matches Title only. I want to display authors related to this title in this page and other are same(when click the title go to detailspage.aspx)
How can I display the related Authors to each title in search display page (Not in details page, I know in details page) ?
If user search "The Letters and life" in the Title textbox and hit enter data should looks like:
1. Author: Payne Paddy, sed ran, der virma and Caroline Barron.
Title: The Letters and Life of Elizabeth Despenser, Lady Zouche (d. 1408) [her letters and will provide a glimpse of her personal
2. Author: ayne manu, edd saan and fer wertu.
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.
I'm writing new section to a website and am looking to use a UI similar to the MSDN Download page with the Product Details and Keys in an accordian like section. Haven't been able to find a description of how this is done as of yet - still looking though but figured I'd ask if there is an available control or a description of that control instead of reinventing it.
View 1 Repliesi have the following gridview i would like the Vistidate column to be a link2) as you can see each patient can have multiple visit dates. when for example i click on 12/08/10 which is going to be a link i would like a new page to open and bring all the details from that visit into the various textboxes that i have such as DOB, telephone etc.
View 10 Repliesi have a gridview of name "PRODUCTS"
now i want to add a link button , on cllicking that link button a new page in other tab will open with that Product Name and ID , then i want to read that product name and id and fetch records according to it ...
e.g:
PRODUCTS PAGE :
GRIDVIEW :
ID | Name | Detail
1 | Apple | DETAIL
2 | Banana | DETAIL
now when a user click on DETAIL row in apple , in new tab a page called DETAIL will be open and it would show URL like this :
http://localhost/ABC/DETAIL.aspx/ASDESX9023
the reason behind ASDESX9023 is : i dont wanna show the actual project name and id here ...
then after recieving this URL ;
below in my data list which is residing in DETAIL Page , the records must get fetched according to this URL ..
I am using Visual studio 2010 express and I have a details view databinded to an sql database table. When I use the Insert option on the view it causes an error due to it trying to insert a null into the primary key field. If the Insert function does not create a new primary key entry how is it created?
View 9 RepliesI have a vb.net page that has a editable detailsview. When a user wants to erase the data for a field, they highlight the data, and delete/backspace over it, and click update. However, the original data is still saved. If they are replacing the current data with new data, that works fine and updates/saves correctly. This problem only happens when the current data needs to be removed.
View 6 RepliesWhen I add an update command to my page and run the page I get this error message
Server Error in '/MYApplication.
Incorrect syntax near '-'.Must declare the scalar variable "@recnum".
Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near '-'.Must declare the scalar variable "@recnum".
Source Error:
[Code]....
Stack Trace: [Code]....
Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082
Here is my code
<asp:SqlDataSource
ID="SqlDataSource1"
runat="server"[code]....
I have a gridview which display when person start n stop the project if same person do muliple projects it save n retrives eaisly i want to do that when i press select in gridview it give me the all about the person means if ali is working on 2 projects so it give me details like ali firsrt project is this time n date this , second project is this how can i do this ?
View 1 Replies
