error in coding part.

Question

0.00/5 (No votes)

See more:

C#

cmd = new SqlCommand(candintrest, cn);
 cmd.CommandText = candintrest;
 int interestid = (int)cmd.ExecuteScalar();    *****error specify on this line***

Error Occure:-

C#

System.Data.SqlClient.SqlException: Incorrect syntax near ','

plz try to solve it.

Posted 3-Jun-12 18:47pm

Member 9027483

Updated 3-Jun-12 19:34pm

Prasad_Kulkarni

v2

Add a Solution

Comments

Prasad_Kulkarni 4-Jun-12 1:34am

Can you provide your sql query??

7 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

vangapally Naveen Kumar · Answer 1 · 2012-06-03T18:52:00

I think In your quary has error once check your quary(candintrest)

ex:For Insert Quary

SQL

create procedure like
Create PROCEDURE dbo.StoredProcedure1(@id int,@name varchar(50),@addr varchar(50))
	/*
	(
	@parameter1 int = 5,
	@parameter2 datatype OUTPUT
	)
	*/
AS
begin
insert into sample (id,name,address) values(@id,@name,@addr)
	/* SET NOCOUNT ON */
	end

in code behind:

VB

con = New SqlConnection(ConfigurationManager.ConnectionStrings("con").ConnectionString)  
        cmd = New SqlCommand()
        If con.State = ConnectionState.Closed Then
            con.Open()
        End If
        cmd.Connection = con
        cmd.CommandType = CommandType.StoredProcedure
        cmd.CommandText = "StoredProcedure1"
        cmd.Parameters.AddWithValue("@id", TextBox1.Text)
        cmd.Parameters.AddWithValue("@name", TextBox2.Text)
        cmd.Parameters.AddWithValue("@addr", TextBox3.Text)


        Dim i As Integer

        i = cmd.ExecuteNonQuery()
        If (i >= 1) Then
            Response.Write("sucess")
        Else
            Response.Write("Fail")
        End If
        con.Close()

Ranjith Reddy CSE · Answer 2 · 2012-06-03T19:32:00

Solution 4

Hello This will be helpful to you..........

Just keep Quotes

C#

cmd = new SqlCommand("candintrest", cn);

Posted 3-Jun-12 19:32pm

Ranjith Reddy CSE

Updated 3-Jun-12 19:35pm

v2

Sakthivel Parasuraman · Answer 3 · 2012-06-03T21:04:00

Solution 5

Please check all ' and , and " and + symbols in your query

Posted 3-Jun-12 21:04pm

Sakthivel Parasuraman

Shivram A Popalghat. · Answer 4 · 2012-06-04T19:15:00

Solution 6

Int32 count = Convert.ToInt32(cmd.ExecuteScalar());

Posted 4-Jun-12 19:15pm

Shivram A Popalghat.

Shivram A Popalghat. · Answer 5 · 2012-06-04T19:18:00

VB

con = New SqlConnection(ConfigurationManager.ConnectionStrings("con").ConnectionString)
        cmd = New SqlCommand()
        If con.State = ConnectionState.Closed Then
            con.Open()
        End If
        cmd.Connection = con
        cmd.CommandType = CommandType.StoredProcedure
        cmd.CommandText = "StoredProcedure1"
        cmd.Parameters.AddWithValue("@id", TextBox1.Text)
        cmd.Parameters.AddWithValue("@name", TextBox2.Text)
        cmd.Parameters.AddWithValue("@addr", TextBox3.Text)


        Dim i As Integer

        // or Int32 count = Convert.ToInt32(cmd.ExecuteScalar());
        i = cmd.ExecuteNonQuery()
        If (i >= 1) Then
            Response.Write("sucess")
        Else
            Response.Write("Fail")
        End If
        con.Close()

Suresh Shewale · Answer 6 · 2012-06-03T18:51:00

Solution 1

Hello
please specify ur canduntrest (i.e Sql which is causing problem) so that i will guide properly

Posted 3-Jun-12 18:51pm

Suresh Shewale

Comments

Rahul Rajat Singh 5-Jun-12 1:41am

this is not a solution. use the comments section for such questions.

Prosan · Answer 7 · 2012-06-03T18:58:00

Solution 3

first check what have you written in insert query. in place of cmd.ExecuteScalar use cmd.ExecuteNonQuery. i think after that your problem should be solved

Posted 3-Jun-12 18:58pm

Prosan

Comments

Member 9027483 4-Jun-12 1:23am

there is cmd.ExecuteNonQuery is used...so what can i do???

Prosan 5-Jun-12 1:55am

please provide your insert query. error in your insert query.

error in coding part.

7 solutions

Solution 2

Solution 4

Solution 5

Solution 6

Solution 7

Solution 1

Solution 3

Add your solution here

Preview 0