Data Controls :: C# Error - Arithmetic Overflow Error Converting Expression To Data Type Datetime
May 7, 2015
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
While executing select statement for a table then iam getting arithmetic overflow error.I found that retrieviing the data for a particular column showed that error ,sum() for that column is showing error.Is there any way i can rectify this problem.
using sql server 2005. I am working with an existing database field and there is a field where the string in this format: YYYYMMDD, for example 05/16/2002 is displayed as:
<example> 20020516 </example>
anyways I am trying to convert that string to a date like so:
[Code]....
however when I try to do this I am getting the following error <ERROR>
Arithmetic overflow error converting expression to data type datetime. </ERROR>
does anyone know a good solution for this? I just want to convert the string to datetime so I can use the value in my WHERE clause.
how can in sql server show two columns as one column.. one of them is nvarchar and the other is int from two tables i have did this but it give error
select depart.depart_name+input_comp.no_of_depart as department,dbo.depart.depart_id from dbo.depart inner join dbo.input_comp on dbo.depart.depart_id=dbo.input_comp.depart_id group by depart.depart_name,dbo.depart.depart_id,input_comp.no_of_depart the depart_name is nvarchar datatypeand the no_of_depart is int datatype
the error is
Conversion failed when converting the nvarchar value to data type int.
I'm getting the following error base on dropdownlist selectindexchanged: error converting data type nvarchar to bigint
Below is my dropdownlist code:
Protected Sub ddlTaxName_SelectedIndexChanged(sender As Object, e As EventArgs) Handles ddlTaxName.SelectedIndexChanged Dim strConnString As String = ConfigurationManager.ConnectionStrings("BytConnectionString").ConnectionString() Dim strQuery As String = "select TaxName, [Rate(%)] from Sale_Tax where" & " TaxID = @TaxID" Dim con As New SqlConnection(strConnString)
Company array is a string array where i have stored the company ids
the problem is company_array[0] has the initial value of the dropdownlist(company) --select company which is why m getting the error(cannot convert data type nvarchar to int) . I have used the same logic in many places in my project it did not give any error.
int count = 0; company_length = company_length - 1; while (count < GridView3.Rows.Count && compid_counter < company_length ) { cmd = new SqlCommand("insertWorkDetais", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@trainerId",trainerID);
when i am trying to uedit my recods in gridview this error is coming. I am using SQLDatasource with gridview and for edit purpose i am using stored procedure. I have manually executed the SP and its woring fine. my SP is here
I have a website having an aunthentication system. When I am setting my website on IIS 6 the code is absolutly working fine. But when i configure the website on IIS 7 (Windows 2008 server) it is showing me the above error. I am using a stored procedure for it
I have a class that runs calculations on numbers and populates the results to my SQL database. My code behind page instantiates the class object, and in a loop it makes use of the method five times (once per loop). Essentially, my code behind collects the information from controls and passes the information to the class method for processing. The method works just fine most of the time.
On one of the iterations I get a error before the code even gets to the class. The error is, "Arithmetic operation resulted in an overflow." What strikes me as odd is that while stepping through the code, the loop crashes with that error before getting to the class that runs the calculations. Additionally, no arethmetic operations are performed on the form's code-behind page (which calls the method). I even put a break-point on the class constructor but the code crashed before reaching that constructor.
The information being sent is the results of matches from a sporting event. As a troubleshooting measure I changed the order of the matches by deleting them an re-entering them into the database in a different order. Again only this one particular match crashed. Here is the code that crashes:
I have 1,2,3,4,5,6,7,8,9 stored as nvarchar inside Level in my db.
I then have a dropdownlist with values 1,2,3,4,5,6,7,8,9. When a user makes a selection (i.e 1) (Level.SelectedValue.ToString). This builds an sql query via a param like this:
"Select things From MBA_EOI Where level = 1"
When I run the select I get the following error:
Syntax error converting the nvarchar value '1,2,3,4,5,6,7,8,9' to a column of data type int.
I was under the impression that I was dealing with an Nvarchar field and the selected value as string, where does the int conversion come in?
I have used the repeater function in an aspx page to create a discussion/fourm style page where user can posts comments, but when I try and write a comment I get this error; Data type mismatch in criteria expression. The user gets to the discussion page from a link in a gridview so that it displays all the posts on the specific film, and the correct posts come up, its just when a user wants to post something themsevles I get the error.This is the code in the discussion.aspx.vb page
This is the code i have used to get LocationID from database with MerchantID. I am getting an exception from Fill dataset part. The error is Error converting data type varchar to bigint.
public DataSet getLocationID(long MerchantID) { //long LOCID = null; try { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@merchantID",MerchantID) }; string strCommandText = "Select LocationID from Merchant_Location where MerchantID ='@merchantID' order by LocationID ASC"; Debug.WriteLine(strCommandText); DataSet pds = new DataSet(); SqlHelper.FillDataset(DbConnString, System.Data.CommandType.Text, strCommandText, pds, new string[] { "LocID" }, parameters); return pds; } catch (Exception ex) { //LogError("Error Occurred When Retrieving LocationID: " + MerchantID.ToString(), ex); return null; } }
Everything looks fine but I keep getting the error: 'Conversion failed when converting the nvarchar value 'xxxx' to data type int... where xxxx is the the value of @Query.
I want to change one of my table columns data type. Now the column data type is varchar and i want to change it to float. Updated all the column data to numeric and tried to convert the datatype with the following syntax
alter table vibration_values alter column dis_v float
but getting the error as
Error converting data type varchar to float.
The statement has been terminated.
Suprisingly every thing worked well in sqlserver 2005 and not working in sqlserver 2000.
I recently converted a web application of ours to VS 2008 so that we could upgrade to .net 3.51 framework.
I have been making some changes to the layout, to take advantage of ajax and minimize the amout of data needing to be loaded and the number of postbacks processed.
The problem I am having is when I try to save the data.
The page postback calls a local Sub which reads the form data into local variables and then passes these variables to our assembly.
The primary assembly has 70 parameters which are used to populate one of the tables in our database.
So I have 70 local variables just for this call plus a variable reference to the output of the assembly which contains a property for each of the columns in the associated database record.
There are some additional assemblies called to update other tables so, in all there are 121 locally defined variables in this sub.
Bear in mind that this sub is called from the page load event which has 93 of it's own locally declared variables.
Here is what is happening, when I run the code I am using cdate() to convert the value of a text box to datetime and pass it to my assembly. When doing so it throws a conversion error.
So I created a local datetime variable and converted the value of the control to the datetime and passed the variable to the assembly.
No more error, but the proc did not save the data as it was supposed to.
What I noticed in debugging, on the locals tab, is that every local datetime variable displayed the following message:
Cannot evaluate expression because we are stopped in a place where garbage collection is impossible, possibly because the code of the current method may be optimized
I also noticed that on the watch window the same message would display if I attempted to reference any of the datetime controls on the form.
There are only 3 variables and 3 datetime controls that appear to be affected. the controls are all html input boxes. Every other variable and control on the form behaves normally and I can see their values while debugging, it is just these six that are exhibiting the problem, whats more is that they are not new controls to the form.
This is very frustraiting because I have read a thousand posts on this and nothing works. I have a gridview which is programatically bound to a dataset which is created from dataset.readxml(xdocument.createreader). The table gets created without issue.
I have allow sorting set to true. when i click the sorting linkbutton I get the event handler error. So i create an empty event handler and that doesn't give me an error but also accomplishes nothing. So I searched and searched and found that i need to call the gridview.sort method to programmatically sort in the event handler. So when i do this
i get stackoverflow error. it creates an infinate loop. none of the 20 or so posts out there seem to answer how to handle this. They say that this method is the way to call sorting.
below is my event handler
[Code]....
the behaviour is that the event handler fires and executes to the sorting line which in turn refires the event handler.
I am getting an error when attempting to call a stored proc from my asp.net page.
e.Message = "Conversion failed when converting character string to smalldatetime data type."
The stored proc is being called by:
The asp.net code that is calling the stored proc is:
//Display search results in GridView; SqlConnection con = new SqlConnection(strConn); //string sqlItemSearch = "usp_Item_Search"; SqlCommand cmdItemSearch = new SqlCommand(sqlItemSearch, con);
I have been messing about with this for hours surely this should be an easy task ....... I have a stored procedured that creates a invoice on a Quotetable one of the parameters is a output parameter Invoice Number this is passed to a label. (Label1) This works great.
I then need to add items to the invoice on a item table so my next stored procedure should take the value of Label1 and update the foreign key quotenumber on the itemtable with the value from label1.
On the aspx page I have a small section for a gridview which shows the current quote with however many items on it using the control
[Code]....
On the ASP page the control for @Quotenumber = Label1 but I get the following error
'Conversion failed when converting the nvarchar value 'Label' to data type int.'
i am trying to retrieve data from sql database but I get this error: < An expression of non-boolean type specified in a context where a condition is expected, near ')'. > whats this error meaning?