Click here to Skip to main content
15,891,529 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am developing a web application using .NET and C#. I am unable to fix this problem please help me.



C#
protected void Button1_Click(object sender, EventArgs e)
       {
           string et = signupemail.Text;

           SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
           conn.Open();
           string checkser = "select count (*) from [user] where email ='" + et + "'";
           SqlCommand cmd1 = new SqlCommand(checkser, conn);
           int temp1 = Convert.ToInt32(cmd1.ExecuteScalar().ToString());
           conn.Close();
           if (temp1 == 1)
           {
               Response.Write("already exist");

           }
           else
           {

               SqlConnection con1 = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
               int x=0;

               SqlCommand cmd = new SqlCommand();
               cmd.Connection = con1;
               con1.Open();
               cmd.CommandText = "insert into user(name,email,password,sponserid,upline1,upline2,upline3,upline4,wallet,phonenumber) Values(@name,@email,@password,@sponserid,@upline1,@upline2,@upline3,@upline4,@wallet,@phonenumber)";
               cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = name1.Text;
               cmd.Parameters.Add("@email", SqlDbType.VarChar).Value = signupemail.Text;
               cmd.Parameters.Add("@password", SqlDbType.VarChar).Value =pass2.Text ;
               cmd.Parameters.Add("@sponserid", SqlDbType.VarChar).Value = "csvf";
               cmd.Parameters.Add("@upline1", SqlDbType.VarChar).Value = "bhghg";
               cmd.Parameters.Add("@upline2", SqlDbType.VarChar).Value = "bhghg";
               cmd.Parameters.Add("@upline3", SqlDbType.VarChar).Value = "bhghg";
               cmd.Parameters.Add("@upline4", SqlDbType.VarChar).Value = "bhghg";
               cmd.Parameters.Add("@wallet", SqlDbType.VarChar).Value = x;
               cmd.Parameters.Add("@phonenumber", SqlDbType.VarChar).Value = phone1.Text;
               try
               {
                   cmd.ExecuteNonQuery();
                   con1.Close();
                   Response.Redirect("profile.aspx");
               }
               catch (Exception ex)
               {
                   string msg = "Insert Error:";
                   msg += ex.Message;
                   Label1.Text = ex.Message;


               }
           }






       }


What I have tried:

i am new to coding please help me
Posted
Updated 7-Jun-16 1:32am
Comments
VR Karthikeyan 7-Jun-16 7:30am    
[user] means Table Name?

1 solution

You need brackets round USER (or better change teh table name to "users") every time you use it, it's an SQL keyword. So change:
C#
cmd.CommandText = "insert into user(name,email,password,sponserid,upline1,upline2,upline3,upline4,wallet,phonenumber) Values(@name,@email,@password,@sponserid,@upline1,@upline2,@upline3,@upline4,@wallet,@phonenumber)";
To:
C#
cmd.CommandText = "insert into [user](name,[email],[password],sponserid,upline1,upline2,upline3,upline4,wallet,phonenumber) Values(@name,@email,@password,@sponserid,@upline1,@upline2,@upline3,@upline4,@wallet,@phonenumber)";

[edit]I hate markdown![/edit]
 
Share this answer
 
v3
Comments
vivek jidnal 7-Jun-16 8:08am    
thank you so much :) its working fine now
OriginalGriff 7-Jun-16 8:18am    
You're welcome!

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900