everyting working fine but with this below query only numeric value getting from excel and saving into sql database String value not getting from excel?
INSERT INTO dbo.ImportTest
SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=C:ook1.xls;Extended Properties=Excel 8.0')...[Sheet1$]
i have set the type of a column in a table numeric(6,2) but when i insert a value above 9999,99 i get the error
"Arithmetic overflow error converting numeric to data type numeric."
Do you know whats wrong??
ofc thats all through visual studio for an asp site thats why im posting here
First of all im new to asp.net and am in the process of learning it.
Heres my problem, i am receiving this error when submitting the form: "Arithmetic overflow error converting numeric to data type numeric"
And it halts at command.ExecuteNonQuery();
Input form:
[Code]....
Code Behind:
[Code]....
Stored Procedure:
[Code]....
I need a query to get all the numeric titles from the given procedure .Instally iam getting the Alphetical result but could not get the numeric .below is my proceudre
[code]...
i hav declare a Variable in stored procedure as@Total numeric(18,2) output..@Total Value is calculated 177.12 in stored procedure but when i return in Class.cs..its output is 177..
View 4 Replieshow can i insert 'null' value in numeric column if no record is there.when i pass record to BLL like
MyCollegeAddmissionMst.GraduationYear = IIf(txtGrdyear.Text = String.Empty,
"", txtGrdyear.Text.Trim())
datatype is numeric(4,0) then error is Conversion from string "" to type 'Integer' is not valid. no record is in this textbox and i need to entry null value.so how can i do the same.
I have a feedback page with rating controls and I use a stored procedure to insert the record using C#
I get an error when I try to insert about conversion.
[Code]....
I have 20 ratings and a textbox I think the error is with the last parameter @Overall
it displays on the page as 4.9 in a label control, it is previously calculated in the Calculate_Ratings(), and it is declared as a decimal, I have also tried it declared as double. My column is declared decimal(1,1) in sqlDatabase
The Error says
System.Data.SqlClient.SqlException: Error converting data type numeric to decimal. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
Reliability Rating What is this?
Were we there on the date and times scheduled?
Rating 5 = Perfect
Rating 1 = Very Unreliable
What is syntax for query string for updating an sql datetime field and an sql number field in vb.net ?
View 1 RepliesI currently have a numeric field as numeric(5,2) which has 2 digits after the decimal. Now I need to be able to display 4 digits after the decimal. But if I change the field to (7,4) then it places 2 zeros after the last numbers. For example: 1.32 changes to 1.3200.
But some records will have exactly 4 numbers after the decimal such as : 2.4375.
My issue is I don't want all the data to have 4 numbers after the decimal. I don't think there is another data type that will allow this.
i am trying to find the column length of a particular sql table, it is working very fine if its 'nvarchar' or 'text' type. But if i try to get the numeric(int/bigint/bit) data type i am getting error. please help me out. The sample code is given below for you reference,'*** Source Code Start
Dim da
As
New OleDbDataAdapter(strQuery, PortalConn)
[code]...
I have a report which is created using a .rdlc. And populated using a List object. The report when exported to excel has a problem. The numeric colums show up as text and the tooltip in excel says "The number in this cell is formatted as text or preceded by an apostrophe". How can I get the number to show up as numeric?
View 1 RepliesI have a insert into statement thats inserting my numbers from a numeric text box on my aspx page. I am choosing the Amount Type then putting in a a number.
So i have a drop down that i select example Direct Charge then i enter 600.00 and click add it puts that in to the databse for me woot..
I then put in say Misc Credit and enter 200.00 it inserts in that into the database woot.
The look up table that has my amount types has a field called numeric opperator which is either + or - the Credit being a - and the Charge being a + then my stored procedure takes all my + numbers and adds them up and subtracts all the - numbers.
I want to change that so that it actuall be inserted into the table as a - number form the start. So I want choose Misc Credit enter 200.00 and click add then my event says o yea thats a credit insert 200.00 as -200.00
How can I do that?
[code]...
well I am trying to export sql data that has 80,000 records more than 65,000 rows which excel has.i do I export that much data in one trial without error.is it posible with bcp utility?
I tried DTS but did not work what option shall i use to define range in excel file to export data ?
The following code is a short version of a process to export data from Sql Server to Excel. I am moving 300k of data to excel and am having to divide it up into 65500+ blocks. This is not a problem in classic asp but .net does not seem to like this method. When ExecuteNonQuery() executes the insert statement each time through the loop it really slows down this process. Otherwise in runs in seconds commenting out ExecuteNonQuery(). Also it looks like the excel file does not grow until the very end. I would think it would be inserting every time it did ExecuteNonQuery(). Do I have something wrong here or should I do a completely different method for this?
using (SqlConnection conn = new SqlConnection(sqlConnString)
I am trying to get column count of an Excel sheet. I need count of only those columns which are explicity defined by sheet creator. Columns other than explicitly defined take the form F20,F21... which i dont want to include in my counting. I am using
Provider=Microsoft.ACE.OLEDB.12.0 to access data.
im using an excel file as a datasource for my gridview...i can pull all the data into the gridview fine. i am now hoping to allow the user to update the data in the excel file through the gridview. is it possible to update the excel file in this format i.e. allow the user the read/update the excel file as if its a database. i see some references in google that its not possible to update the excel file as the writeout causes problems. does anyone have this working...or should i look into trying to use another datasource.
i was hoping to use an excel file as the app is on a shared server and it would be handy just to have the excel file in the app folder as there is not much data involved.
this is me once again moving around data access. my problem now hide in the import process of an excel file that would be inserted into sql db.
the problem is the excel file may be updated or changed and i have to periodically import it and perform the process but I still cant check or compare between the two Data Source (excel, sql) as I violate the entity integrity (PK)
i found a kind of stupid approach that each time i want to import the file i will empty the table then re-insert the data, but at this step a new problem raise that other tables are !engaged! with it ... so i will violate the referential integrity (FK)
i looking for solution to compare between two sources for each tuple / row, ignore the existing one and insert the new
[Code]....
I have a page where users can upload an excel file and it is read into our system. I am using the Jet.OLEDB.4.0 provider to read the files. I access the file one time to read out the header names and then allow the user to select which field each column will be read into on import. For some reason after this read the file is locked and the next time I try to access it to do the data import I get the "File in use" message. Each time I open a connection it is closed so I am not sure why the file is being locked.
View 2 Repliesi have some issue and i need read and upload (data) from excel file to dbgrid threw ASPX page am using network server 2003
View 1 Replies[Code]....
View 4 RepliesI try to import Excel files to sqlserver problem is that the number and the titles of columns are dynamic.How can i do that by code?
View 5 RepliesI'm able to upload and read any excel file to my server prior 2007, when I try an 07 Excel file, i'm getting the following error message:
'microsoft.ace.oledb.12.0' provider is not registered on the local machine'
do I need anything specail on the web server to allow for Excel 07 files? I'm running IIS6 and a Win 2003 server
iam Working on Asp.net Web apliation using c#.net, in system folder (Ex: E://Santhu) i have few Flat files and Excels Files .So My Application should read those files automatically and should store the data into my database..
View 1 Repliesimporting excel/spreadsheet into sql server using C#? Whenever I run the webpage by selecting excel file, first it will empty sql server table then import data from excel.
View 3 Repliesi want create a file excel from sql server? how can i do?
and can i create it using also sqldatasource control?