not able to correct the errors

Question

1.00/5 (2 votes)

See more:

C#

public void Add_scheduled(object sender, EventArgs e)
   {
       String sql;
       sql = "insert into dbo.b_schedule";
       sql = sql + "(sdate,scost,sremark,ano)";
       sql = sql + "values(Convert(date,'" + adddate.Text + "',103),";
       sql = sql + Convert.ToDouble(Mcost.Text) + ",";
       sql = sql + "'" + Mremark.Text + "',";
       sql = sql + uano.Text + ")";
       c.executeqry(sql);
       adddate.Text = string.Empty;
       Mcost.Text = string.Empty;
       Mremark.Text = string.Empty;
       uano.Text = string.Empty;

       Response.Redirect("BQS.aspx");
   }

C#

public void Add_unscheduled(object sender, EventArgs e)
    {
        String sql;
        sql = "insert into dbo.b_unschedule";
        sql = sql + "(udate,ucost,d_date,d_reason,uremark,ano)";
        sql = sql + "values(Convert(date,'" + mdate.Text + "',103),";
        sql = sql + Convert.ToDouble(ucost.Text) + ",";
        sql = sql + "'" + ureason.Text + "',";
        sql = sql + "'" + udamage.Text + "',";
        sql = sql + "'" + uremark.Text + "',";
        sql = sql + uano.Text + ")";


        c.executeqry(sql);
        mdate.Text = string.Empty;
        ucost.Text = string.Empty;
        ureason.Text = string.Empty;
        udamage.Text = string.Empty;
        uremark.Text = string.Empty;
        uano.Text = string.Empty;
        Response.Redirect("BQS.aspx");
    }

Posted 16-Jul-13 19:09pm

anjali02199

Add a Solution

Comments

_Maxxx_ 17-Jul-13 1:15am

It would REALLY help if you told us what errors you were getting, and where!

anjali02199 17-Jul-13 1:29am

Incorrect syntax near ')'.
Line 29: cmd.ExecuteNonQuery():(the error is being generated for add_scheduled )

[no name] 17-Jul-13 1:15am

Hi Anjali,
Where is ur question?
Improve ur question by comments like
what help u needed? what u tried? what r d issues u have faced?

No one will help u for simple "not able to correct the errors"

praks_1 17-Jul-13 1:20am

problem is in the date format

anjali02199 17-Jul-13 1:30am

can u please make the correction and write it over here.

praks_1 17-Jul-13 1:36am

can u post ur query string?

anjali02199 17-Jul-13 1:53am

error is: Incorrect syntax near')'.
Line 29: cmd.ExecuteNonQuery();

and my code is:
public void Add_scheduled(object sender, EventArgs e)
{
String sql;
sql = "insert into dbo.b_schedule";
sql = sql + "(sdate,scost,sremark,ano)";
sql = sql + "values(Convert(date,'" + adddate.Text + "',103),";
sql = sql + Convert.ToDouble(Mcost.Text) + ",";
sql = sql + "'" + Mremark.Text + "',";
sql = sql + uano.Text + ")";
c.executeqry(sql);
adddate.Text = string.Empty;
Mcost.Text = string.Empty;
Mremark.Text = string.Empty;
uano.Text = string.Empty;

Response.Redirect("BQS.aspx");
}

1.where uano is the serial no. and called as foreign key

AmitGajjar 17-Jul-13 1:38am

Have you thought to use StoredProcedure instead ?

5 solutions

Add a Solution

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

Bernhard Hiller · Answer 1 · 2013-07-16T20:50:00

You say that the error is at
Line 29: cmd.ExecuteNonQuery()
but nowhere in your code snippets can that line be found!
Instead of concatenating strings to create a query, you'd better use parameterized queries. Apart from some proetction against SQL injection attacks (something you haven't thought of, have you?), they deal perfectly with date/time values, non-ASCII-characters, number formats, and such things. The incorrect syntax of your SQL query will likely be solved by that change too.

praks_1 · Answer 2 · 2013-07-16T19:21:00

Solution 1

Hi,
U can use see this link :
http://forums.asp.net/t/1670566.aspx/1[^]

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=59574[^]

Posted 16-Jul-13 19:21pm

praks_1

Updated 16-Jul-13 20:11pm

v2

MukeshSagar · Answer 3 · 2014-09-11T19:51:00

public void Add_scheduled(object sender, EventArgs e)
 {
 String sql;
 String str = "server=abc;uid=sa;pwd=sa;initial catalog=master"; // define your server credentials
 SqlConnection cn = new SqlConnection(str);
 SqlCommand cmd;
 sql = "insert into dbo.b_schedule";
 sql = sql + "(sdate,scost,sremark,ano)";
 sql = sql + "values(" + adddate.Text + "',";
 sql = sql + Convert.ToDouble(Mcost.Text) + ",";
 sql = sql + "'" + Mremark.Text + "',";
 sql = sql + uano.Text + ")";
 cmd = new SqlCommand(sql,cn);
 cn.Open();
 c.executeqry(sql);
 cn.Close();
 adddate.Text = string.Empty;
 Mcost.Text = string.Empty;
 Mremark.Text = string.Empty;
 uano.Text = string.Empty;

 Response.Redirect("BQS.aspx");
 }

/\jmot · Answer 4 · 2014-09-11T20:18:00

Solution 4

Use ..

SQL

insert into dbo.b_schedule(sdate,scost,sremark,ano) values
(
Convert(date,'" + adddate.Text + "',103),"+Convert.ToDouble(Mcost.Text)+",'"+Mremark.Text+"','"+uano.Text+"'
)

Posted 11-Sep-14 20:18pm

/\jmot

/\jmot · Answer 5 · 2014-09-11T20:19:00

Solution 5

Use ..

SQL

insert into b_schedule(sdate,scost,sremark,ano) values
(
Convert(date,'" + adddate.Text + "',103),"+Convert.ToDouble(Mcost.Text)+",'"+Mremark.Text+"','"+uano.Text+"'
)

Posted 11-Sep-14 20:19pm

/\jmot

not able to correct the errors

5 solutions

Solution 2

Solution 1

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0

not able to correct the errors

5 solutions

Solution 2

Solution 1

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0

Existing Members

...or Join us