C# - Error Converting Data Type Varchar To Bigint Inline Sql Statements?

Aug 31, 2010

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;
}
}

View 2 Replies


Similar Messages:

DataSource Controls :: System.Data.SqlClient.SqlException - Error Converting Data Type Varchar To Bigint?

Jan 16, 2010

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

View 3 Replies

Data Controls :: Error Converting Data Type Nvarchar To Bigint C#

Jan 24, 2016

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)

[Code] .....

View 1 Replies

SQL Server :: Error Converting Data Type Varchar Column To Float - The Statement Has Been Terminated

Feb 1, 2011

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.

View 6 Replies

SQL Server :: Conversion Failed When Converting The Varchar Value 'ID' To Data Type Int?

Aug 9, 2010

<Conversion failed when converting the varchar value 'ID' to data type int.>am trying to insert datavalueField for a drop down list into a table column, its type is int. am using this syntax

[Code]....

View 3 Replies

Error In Converting Datatype Nvarchar To Bigint?

Oct 1, 2010

this code is giving me error:

error in converting datatype nvarchar to bigint this is my table values:

@customer_first_name nvarchar(50),
@customer_last_name nvarchar(50),
@customer_address nvarchar(max),
@gender nchar(10),
@date_of_birth datetime,
@customer_email_id varchar(50),
@customer_occuption varchar(50),
@customer_phone_number Bigint,
@nominee_name nchar(50),
@customer_id nvarchar(50),
@account_type nvarchar(50),
@account_number nvarchar(50),
@transfer_access_code nvarchar(50),
@account_balance Bigint,
@pin_code BigInt,
@nationality nvarchar(50),
@password nvarchar(50)
lblAmount.Text = HFamount .Value ;
int balamount = Convert.ToInt32(lblAmount.Text);
int Cpincode = Convert.ToInt32(txtpincode.Text);
long phone = Convert.ToInt64(txtphone.Text);
string cust_id = CUSTOMER_ID_GENERATOR();
string strconstring = ConfigurationManager.ConnectionStrings["ONLINE_BANKING2_ConnectionString"].ConnectionString;
SqlConnection mycon = new SqlConnection(strconstring);
mycon.Open();
SqlCommand cmdRegister= new SqlCommand(sqlquery,mycon);
cmdRegister.Parameters.Add(new SqlParameter("@customer_first_name",txtcustname.Text.ToString()));
cmdRegister.Parameters.Add(new SqlParameter("@customer_last_name",txtcustlastname.Text.ToString()));
cmdRegister.Parameters.Add(new SqlParameter("@customer_address",txtAddress.Text.ToString()));
cmdRegister.Parameters.Add(new SqlParameter("@gender", rbtngender.SelectedItem.Value.ToString()));
cmdRegister.Parameters.Add(new SqlParameter("@date_of_birth", txtDOB.Text));
cmdRegister.Parameters.Add(new SqlParameter("@customer_email_id", txtemail.Text.ToString()));
cmdRegister.Parameters.Add(new SqlParameter("@customer_occuption", txtcustoccupation.Text.ToString()));
cmdRegister.Parameters.Add(new SqlParameter("@customer_phone_number", phone));
cmdRegister.Parameters.Add(new SqlParameter("@nominee_name", txtnominee.Text.ToString()));
cmdRegister.Parameters.Add(new SqlParameter("@customer_id", cust_id));
cmdRegister.Parameters.Add(new SqlParameter("@account_type", accType.SelectedItem.Value.ToString()));
cmdRegister.Parameters.Add(new SqlParameter("@account_number", ACCOUNT_NUMBER_GENERATOR()));
cmdRegister.Parameters.Add(new SqlParameter("@transfer_access_code",Transfer_code()));
cmdRegister.Parameters.Add(new SqlParameter("@account_balance", balamount));
cmdRegister.Parameters.Add(new SqlParameter("@pin_code", Cpincode));
cmdRegister.Parameters.Add(new SqlParameter("@nationality", DropCountry.SelectedItem.Value.ToString()));
cmdRegister.Parameters.Add(new SqlParameter("@password",txtpasswd2.Text.ToString()));
cmdRegister.ExecuteNonQuery();
mycon.Close();

View 1 Replies

Data Controls :: Conversion Failed When Converting Varchar Value Xxxx To Data Type Int

Apr 27, 2016

I have a table for R&D which has following cols:

EmpID|EmpName|EmpLname|

and i want to insert values using parameters from Stored procedure as:

declare @EMPID int;
declare @EmpName varchar(50);
Declare @EmpLname varchar(50);
Declare @aa varchar(max);

[code]...

once executing, I am getting following error: Conversion failed when converting the varchar value 'insert into Employee(EMPID,EMPNAME,EMPLname) select ' to data type int.

View 1 Replies

Data Controls :: Conversion Failed When Converting Varchar Value To Data Type Int

May 7, 2015

i am binding the datalist using this code and store procedure. the code works fine if i pass only 1 id, but i have an array which have multiple id's separated by comma like 1,3,5, and i want to use this in the @Id parameter , but i get below conversion error: An exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll but was not handled in user code Additional information: Conversion failed when converting the varchar value '1, 3, 4, 5, 6, 7' to data type int. Code behind code is:

private void PageBind(Int32 pno) {
Int32 nor, repcol;
nor = Convert.ToInt32(DropDownList1.SelectedValue);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Display_Search_Records";

[Code] ....

View 1 Replies

SQL Server :: Get The Following Error "Conversion Failed When Converting The Varchar Value?

Aug 4, 2010

I get the following error "Conversion failed when converting the varchar value ' (' to data type int." when executing this code

View 2 Replies

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

View 1 Replies

Error Converting Data Type Nvarchar To Float / How To Fix It

Nov 30, 2010

Here is the code:

[code]....

After I try to test the page, I am getting the following error:

System.Data.SqlClient.SqlException:

[b]Error converting data type nvarchar to float. [/b]

[code]....

View 1 Replies

Syntax Error Converting The Nvarchar Value To A Column Of Data Type Int?

May 5, 2010

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?

p.s I have also tried Level.SelectedItem.ToString

View 1 Replies

DataSource Controls :: Error Converting Data Type Nvarchar To Int?

Jan 6, 2010

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

[Code]....

and my SQLDataSource is here

[Code]....

and gridview is here

[Code]....

View 2 Replies

SQL Server :: Error: Conversion Failed When Converting The Nvarchar Value ' ' To Data Type Int

Mar 28, 2011

I have a query in SQL Server 2008:

[Code]....

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.

View 3 Replies

SQL Server :: Error Converting The Nvarchar Value '1,2,3,4,5,6' To A Column Of Data Type Int - IN Where Clause

Feb 28, 2011

I am using an adapter to get a list with IN where clause as:

[Code]....

I passed the parameter, CatIDList, with string value 1, 2, 3, 4, 5

However, it returns error of Error converting nvarchar value.

View 3 Replies

Data Controls :: SQL Error / Conversion Failed When Converting Nvarchar Value To Data Type Int

May 7, 2015

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. 

View 1 Replies

Data Controls :: Error Converting Data Type Nvarchar To Numeric

Nov 6, 2013

protected void Update(object sender, EventArgs e)
{
foreach (GridViewRow row in gvStudeff.Rows)
{

[Code].....

View 1 Replies

Data Controls :: Saving DropDownList Value To Database - Error Converting Data Type Nvarchar To Int

May 7, 2015

I am using  a  viewstate to store the company Ids and splitting at hyphen.

protected void onCompanychange(object sender, EventArgs e) {
ViewState["companyID"] += companydropdown.SelectedValue + "-";
String companyids = ViewState["companyID"].ToString();
string pattern = "-";
company_array = Regex.Split(companyids, pattern);
company_length = company_array.Length;
}

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);

[Code] .....

View 1 Replies

ADO.NET :: Using Enterprise Manager Data Access Code Block And Have A Table In Sql Server 2005 With A Column Type Of 'bigint'?

Aug 4, 2010

Im using enterprise Manager data access code block and have a table in sql server 2005 with a column type of 'bigint'

when querying against this table and adding in a parameter, there isnt a long datatype available, so is Int32 an equivalent ?

[Code].....

View 1 Replies

Use Databind Records In Inline If Statements?

Mar 10, 2010

I've got a repeater on my asp.net (VB):
<asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("Question_Number") %>' />
<%#Eval("Question_Desc")%>

Now what I want to do is, check a value that I haven't used called "Question_Type" which could be = 1, 2 or 3 depending if it is multiple choice, short answer, etc. I have tried this:

<%
if Eval("Question_type") = 1 then
Response.Write(" <asp:RadioButton runat=""server"">test1</asp:RadioButton>")
Response.Write(" <asp:RadioButton runat=""server"">test2</asp:RadioButton>")
Response.Write(" <asp:RadioButton runat=""server"">test3</asp:RadioButton>")
end if
%>

and I get this error: Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control. HOW can I use this value in a if statement?

View 1 Replies

How To Use If Statements With Razor And Inline Code Blocks

Jan 22, 2011

I'm updating my old .aspx views with the new Razore view engine. I have a bunch of places where I have code like this:

<span class="vote-up<%= puzzle.UserVote == VoteType.Up ? "-selected" : "" %>">Vote Up</span>

Ideally I'd like to do this:

<span class="vote-up@{puzzle.UserVote == VoteType.Up ? "-selected" : ""}">Vote Up</span>

However there's two problems here:

vote-up@{puzzle.UserVote .... is not treating the @ symbol as a start of a code block @puzzle.UserVote == VoteType.Up looks at the first part @puzzle.UserVote as if it's supposed to render the value of the variable.

View 1 Replies

DataSource Controls :: Arithmetic Overflow Error Converting Numeric To Data Type Numeric

Feb 15, 2010

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]....

View 11 Replies

Error: "Conversion Failed When Converting Character String To Smalldatetime Data Type"

Jun 29, 2010

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);

[Code]....

View 5 Replies

SQL Server :: Convert Label.text To Int / Error Conversion Failed When Converting The Nvarchar Value 'Label' To Data Type Int.'?

Jul 14, 2010

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.'

View 3 Replies

DataSource Controls :: Datatype Numeric Error - "Arithmetic Overflow Error Converting Numeric To Data Type Numeric."?

Apr 18, 2010

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

View 4 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved