In my code behind I can use try/catch blocks to deal with database errors. How can I capture and handle database errors when using a datasource with a dataenabled control? For themost part I'm using ListView and EntityDataSource controls.
View 7 Replies
I have a need to create controls such as textbox, dropdown, etc in code (c#). The number and data for them is all contained in a database.
What is the best way for me to create and add these to the page (need to be underneath the next one as in a table layout) and then how do I refer back to these in code on postback?
How to develop a custom data aware web control?
View 1 RepliesI've got a .aspx page which loads a user control using the LoadControl(string virtualPath) method. The loaded control contains references to several other user controls (i will call "modules"). If such a module contains an unhandled coding error which isn't catched at compile time (e.g. division by zero), no helpful error is thrown. The .aspx page just gets an error from the LoadControl method that the control to load cannot be found (404), but in fact it contains a faulty module.
Is it possible to get the error of the module from within the .aspx page for better troubleshooting? Can I get information about, that (in this example) there is a division by zero error in module (nested user control) xy?
I'm building an application that uses GridView controls to display data to a page.In my editemplate i have following control
<div class = "divBox">
<div>Beginn/Zeit 2</div>
<div>
<asp:TextBox ID="tbBeginn2" CssClass="fSelect"
runat="server" Text='<%# Bind("beginnDatum2") %>'/>
BeginnDatum2 has datetime-Format in SQL-Server.
For the update i use an objectDatasource with following updateparameter
<asp:Parameter Name="beginnDatum2" Type="datetime" />
Now i'm trying to update this field but i have a problem when BeginnDatum2 must be null.
I get following (german) Errormessage:
SqlDateTime-Überlauf; muss zwischen 1/1/1753 12:00:00 AM und 12/31/9999 11:59:59 PM liegen.
And this is my paramter
Public Function UpdateSeminar(ByVal kursid As Integer, ByVal id As Integer, _
ByVal beginnDatum2 As DateTime, _
ByVal endeDatum2 As DateTime, _
cmd.Parameters.Add(New SqlParameter("@beginnDatum2", SqlDbType.DateTime))
If beginnDatum2 = Nothing Then
cmd.Parameters("@beginnDatum2").Value = DBNull.Value
Else
cmd.Parameters("@beginnDatum2").Value = DateTime.Parse(beginnDatum2)
End If
i have a gridview which is binded to a dataset in the code-behind file
[Code]....
i'm using datalist to display product details.
every item in datalist contains...
product image, quantity, details button, and add to cart button
my requirement is whenever someone selects the quantity textbox or edits it the default button for the page should be add to cart button.
or add to cart button should be clicked itself whenver enter button is pressed from keyboard.
I'm using Visual Web Developer 2010 Express with C# 2008 and .NET v4.0 to create a website which will have a database application. The database is SQL Server 2008.
I would have searched this forum for similar questions but I can't find a 'Search this forum' option! So I apologise if someone has already answered this.
I've successfully displayed rows from my database by dragging and dropping a GridView and an SQLDataSource control onto my page, and by using the Connection Wizard to set them up. But when I go live with my new pages, I will have to put my database in a different folder, and until I edit the web.config connection string to point at it I expect to get an exception.
I understand that when you try and open a database connection, this is the perfect place to use try...catch exception handling. But all the examples I can find put the try-catch code on the Button_Click event! Where should I put it? I can' t find anywhere where my controls actually attempt to open the database!
I know I could rip out what I've done and write all the code to connect to the database myself, but as I've finally got everything to work I would prefer to make the change as small as possible. So, what is the minimum change I have to make to add exception handling to my datasource/ gridview?
Before I begin, I would like to acknowledge that I might be using incorrect terms below due to my lack of experience.
I have a GridView bound to an ArrayList of Custom Objects. I have a button as part of each row, which when clicked, I delete the row from the Arraylist, and re DataBind() the GridView. While this deletes the Row, it causes the Page to be refreshed that takes the User back to the top of the Page.
E.g. If the User clicks on the button of a row at the bottom of the Page, after the deletion, the Page gets refreshed and the User is now taken to the top of the Page.
This is irritating especially in long lists i.e. GridView with many rows. (I don't want to use paging here.) Is there any way to avoid this, or mitigate this problem.
In the edit template of the listview I have a multiline textbox. But when the row is edited and the template switches to the ItemTemplate, the text is not displaying properly in the associated Label control (missing linebreaks).
I know that the Label control doesn't understand the enter key code, and I need to do a replace on the string. What I have right now is :
[Code]....
I have a Datagrid inside a Datagrid and I am trying to perform an action (open an pop-up window with related values in the querystring) when the inner datagrid control is clicked.In this simplified example I have 2 datagrids (datagrid1 and
datagrid2). In the second datagrid (datagrid2) I have a LinkButton (lbViewDetails) that I want to control what it does based on the value in the upper datagrid (datagrid1)'s lblRecordId value.
I have a gridview and I do Add, Modify and Delete operations. I am comfortable adding and modifying any text or date value. Now, I have a dropdown list to be displayed. I need to add and modify. The contents in the dropdownlist is fixed. Below is the code. I know there is a problem in my
<EditItemTemplate>
<asp:TemplateField
HeaderText="Leave Type">
<EditItemTemplate>
<asp:DropDownList
[Code]....
What is that I need to have code for EditItemTemplate
I am seeing things that lead me to believe that using data aware controls is almost the opposite of what VC tries to do? But how can I recoupe the advantages of a data aware control and cooperate with the MVC Model?
View 2 RepliesI'm fairly new working with Javascript. I'm working on an issue where I have a GridView with multiple Checkboxes and Radiobuttons. A user can check multiple checkboxes and if a radiobutton is selected, a checkbox has to be selected. This scenario is working fine, presently with existing asp.net code. But, I want to automate it using Javascript, so that I could avoid a postback.
View 4 RepliesI have a user control called ucTriStateButton. It raises an event when it is clicked, called TriStateButtonClicked. If I put this user control on a page, it works fine. Here is the declaration on the .aspx page:
[Code]....
When the button is clicked the method tsbTest_TriStateButtonClicked executes correctly.
The problem is when I put the user control in template field of a GridView.
[Code]....
There is no way to hook the event handler to the control in Page_Load because I cannot get a reference to tsbMorning. So I did it in the RowDataBound event handler of the GridView, where I also do a bunch of other row-specific stuff. Although this builds and runs, the event is never actually subscribed to and so never gets fired.
So the question is - how can I handle an event from many instances of the same user control within a GridView? I am calling the same bit of code regardless of which user control is actually clicked. I only need to know that one was clicked.
im trying to handle the event for my grids itemtemplate button but its not firing.
[Code]....
[Code]....
i want to find a row of my button click and there i can call my method.
not quite sure where I'm going wrong here. I'm trying to manually handle sorting in a Gridview that is populated with the following data source:
[Code]....
[Code]....
[Code]....
At the moment, nothing is happening when I click on the column headings. I ran it in debugging mode in Visual Studio and put a breakpoint on the Sorting event handler. I noticed that the variable dtSortTable is empty even after the TryCast(VacanciesGV.DataSource, DataTable). If I hover over this statement in debugging, it shows the data from the file system, so it does appear to be reading it.
I have a rather large formview that asks for a variety of input values (physical totals vs pos report totals). I have created vb code to calculate the differences and subtotals of various types prior to inserting the data so people can check for entry errors.
Its a closing reconciliation form. Here's the problem: If they forget to enter 0 in a field that doesn't have any totals, a big ugly error message displays. I would like to avoid this. I can tell them until I am blue in the face to remember to enter 0 and not leave any blank fields, but realistically its going to happen and I need to handle it in the programming.
I have been struggling to either default the values to zero to start with, replace a null textbox with 0 before the calculate runs...but I can't get anything to really work. What is the best way to handle this?
Here is the aspx page:
[Code]....
And the code behind page with working "Calculate" as long as fields are not left blank (I took out all the test code that made it not work at all)
[Code]....
Finally, the error message I am getting is the following:
[Code]....
I can't seem to find the right combination of programming to account for the "" string to be 0 so that it will add or subtract values in my calculate. I have my sql table setup with default values of 0 so if a field is left blank it will be entered into the database as 0 and not null. It is really just for my inserting of a reconciliation and the running of Calculate Totals to double check their work prior to inserting into the database.
am designing report using gridview in which i want drill down report, i.e. when i click a cell of gridview which contains value from the database. i want a new gridview to be populated with detailed report, which should be generated by passing some values from parent gridview.
i have written some code for the same,but in the code the event is not getting fired.
code is:
in gridview rowdatabound
protected void gvHdr_RowDataBound(object sender, GridViewRowEventArgs e)
My problem is I have handled timeout error in client of WCF error in such a way that if data is large to fetch, after 10 minutes(as all timeout in web config of client are set to 10 minutes) it should show me customize message 'Too many records to fetch, please modify criteria'. It works on my local system as per expected but if I put it in test server(Service is in one test server and Client application in one test server) it gives me following runtime error.
The message could not be processed. This is most likely because the action [URL] is incorrect or because the message contains an invalid or expired security context token or because there is a mismatch between bindings. The security context token would be invalid if the service aborted the channel due to inactivity. To prevent the service from aborting idle sessions prematurely increase the Receive timeout on the service endpoint's binding. The thing is if I set SendTimeout in test server client config less than 20 seconds then it works fine but we should not be limited upto 20 seconds as it is awfully short.
Do we have to do something special to have ASP.NET partial classes aware of controls that are declared in our user control's base classes? The partial classes keep generating declarations for controls in the base class which mean the controls in the base class get hidden and are null.
View 1 RepliesI'm trying to build a chart in my application which will act as a client for an ASP.NET 3.5 web service that I created. The error I get is as follows:
Series data points do not support values of type System.Data.DataViewManagerListItemTypeDescriptor only values of these types can be used: Double, Decimal, Single, int, long, uint, ulong, String, DateTime, short, ushort.
I've tried various ways to resolve this but can't. This error points at the
chtStats.DataBind() line in the code below:
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
I am trying to insert a value in database from a dropdownlistddlvaue = 10.00 - 11.00in db asstarttime=10:00:00endtime=11:00:00using split function
string dropdownvalue = ddlduration.SelectedItem.Text.ToString();
string et = dropdownvalue.Split('-')[1].ToString();
endtime = et.Split(' ')[1].ToString();
starttime = dropdownvalue.Split(' ')[0].ToString();
I am joining date value + time value in the query uisng('" + datevalue + "' + ' ' + '" + starttime + "')
'2014-05-15' + '16.00' --> to get 2014-05-15 16:00:00
it is getting inserted successfullybut while selecting and viewing it from the database I am getting error as,
"Arithmetic overflow error converting expression to data type datetime"
If i mannually enter the date in db it is workingmanuall value=2014-09-30 14:00query value =2014-09-30 14:00
both are same but error is only occuring for query inserted value
I have a mySQL datasource pulling back data from a query and populating a formview in edit item mode ( I only use this mode ). All is good. Business logic is such that some dates can be null. When I was putting the null or "" dates into a text box there was no problem, some users had problems with dates so I used the datepicker lite control, now the null or "" dates cause a data type conversion error stating that an empty sitrng "" cannot be cast to type date. It basically barfs here
<%# Bind("OrderDate", "{0:dddd d MMMM}") %>
This is obviously in the asp source portion of the code and there is no code in the classic VB section fo the page, it is all done by drag and drop controls and databinding.How can I fix this error and yet still allow users to put in a date, when applicable, and save the update with the new date added. eg I dont want to take out the databind if I can no longer save that field back to the db.
I have a stored procedure written using dynamic SQL in the SQL Server and I am calling it on the code behind and adding parameters to it and filling a dataset and binding the data set to a Gridview. But I am getting this error when I bind it.
Can someone please tell me how to fix this?
It used to work fine when I did not use dynamic sql.
Line 237: da.Fill(ds);Line 238: gviewInvestigations.DataSource = ds;Line 239: gviewInvestigations.DataBind();Line 240: Line 241: }
Source File: s:Cybage2CybageSourceCodeGulfcoastGulfcoastControlsInvestigationsControl.ascx.cs Line:
239
Stack Trace:
[Code]....
[HttpException (0x80004005): The IListSource does not contain any data sources.] System.Web.UI.DataSourceHelper.GetResolvedDataSource(Object dataSource, String dataMember) +8665698 System.Web.UI.WebControls.ReadOnlyDataSource.System.Web.UI.IDataSource.GetView(String viewName) +41 System.Web.UI.WebControls.DataBoundControl.ConnectToDataSourceView() +128 System.Web.UI.WebControls.DataBoundControl.GetData() +4 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +60 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +73 System.Web.UI.WebControls.GridView.DataBind() +4 Controls_InvestigationsControl.bindSearch() in s:Cybage2CybageSourceCodeGulfcoastGulfcoastControlsInvestigationsControl.ascx.cs:239 Controls_InvestigationsControl.btnSearch_Click(Object sender, EventArgs e) in s:Cybage2CybageSourceCodeGulfcoastGulfcoastControlsInvestigationsControl.ascx.cs:323 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
