The type already contains a definition... (what does mean?)

Question

Hi! I receive this message when running my program. What happen please (this is my full code): the type 'createUser' already contains a definition for create_Click using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; public partial class createUser : System.Web.UI.Page { public string GetConnectionString() { return System.Configuration.ConfigurationManager.ConnectionStrings[mfwamba].ConnectionString; } private void execution(string name string username string password string emailid) { SqlConnection conn = new SqlConnection(GetConnectionString); string sql = INSERT INTO myTb(name username password emailid) VALUES  +  (@name @username @password @emailid); try { conn.Open(); SqlCommand cmd = new SqlCommand(sql conn); SqlParameter[] pram = new SqlParameter[4]; pram[0] = new SqlParameter(@name SqlDbType.VarChar 50); pram[1] = new SqlParameter(@username SqlDbType.VarChar 50); pram[2] = new SqlParameter(@password SqlDbType.VarChar 50); pram[3] = new SqlParameter(@email SqlDbType.VarChar 10); pram[0].Value = name; pram[1].Value = username; pram[2].Value = password; pram[3].Value = emailid; for (int i = 0; i { cmd.Parameters.Add(pram[i]); } cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } catch (System.Data.SqlClient.SqlException ex_msg) { string msg =Error occured while inserting; msg+= ex_msg.Message; throw new Exception(msg); } finally { conn.Close(); } } protected void create_Click (object sender EventArgs e) { SqlDataSource sds = new SqlDataSource(); sds.ConnectionString = Configuration.ConnectionStrings[mfwamba].ToString(); sds.SelectParameters.Add(nameTypeCode.String this.name.Text); sds.SelectParameters.Add(usernameTypeCode.String this.username.Text); sds.SelectParameters.Add(passwordTypeCode.String this.password.Text); sds.SelectParameters.Add(emailidTypeCode.String this.emailid.Text); sds.SelectCommand = SELECT * FROM [myTab] WHERE [username] = @username; DataView dv = (DataView)sds.Select(DataSourceSelectArguments.Empty); if(dv.Count != 0) { this.lblinfo.ForeColor = System.Drawing.Color.Red; this.lblinfo.Text = The user already Exist; return; } else { execution(name.Textusername.Textpassword.Textemailid.Text); this.lblinfo.Text=New User Profile has been created you can login now; this.name.Text = ; this.username.Text = ; this.password.Text = ; this.emailid.Text = ; } } } -------------------------------------------------------- http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd > http://www.w3.org/1999/xhtml > Password -->                                                                    DataKeyNames=id DataSourceID=SqlDataSource1 EmptyDataText=There are no data records to display.> SortExpression=id /> SortExpression=username /> SortExpression=password /> SortExpression=emailed /> ConnectionString=  DeleteCommand=DELETE FROM [myTb] WHERE [id] = @id InsertCommand=INSERT INTO [myTb] ([name] [username] [password] [emailed]) VALUES (@name @username @password @emailed) ProviderName=  SelectCommand=SELECT [id] [name] [username] [password] [emailed] FROM [myTb] UpdateCommand=UPDATE [myTb] SET [name] = @name [username] = @username [password] = @password [emailed] = @emailed WHERE [id] = @id>

Israel · Answer

Hi! This is my full codes to help to understand me. As I said in my last message regarding this suject I did found the article in this site. It's very helpful. But when I want to test it in my own reality. Its giving me a little problem. In my register files: .aspx and aspx.cs. Maybe something is wrong but I did realize it (my web.config is right. I think so). After inserting my datas (eg. name username etc) when I click It's giving me a wrong appearance that it's saved. But when I check in my database I realize that nothing went saved in. I'm not sure where I fail. Thanx .aspx.cs using System; using System.Data; using System.Configuration; using System.Data.SqlClient; using System.ComponentModel; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; public partial class New_Register : System.Web.UI.Page { protected void Page_Load(object sender EventArgs e) { } public string GetConnectionString() { //we will set up the configuration which will call our //web.config file to provide the database details because //in configuration file we have created the //in the process we draged and droped. It creates automatically. //We normally put the database details in web.config file or //machine.config file because it is very sensitive information //usually there IP address of remote database passwords and //user names are stored. return System.Configuration.ConfigurationManager.ConnectionStrings[mfwamba].ConnectionString; //in above line onlineapplicationformConnectionString1 is //our configuration name which is inside the web.config file. } //declaring function to insert the value private void execution(string name string username string password string emailid) { //In above line we declaring different variables same as backend SqlConnection conn = new SqlConnection(GetConnectionString()); //In above line we are calling connection //string function which is defined already on top string sql = INSERT INTO myTb (name username password emailid) VALUES  +  (@name @username @password @emailid); //In above lines we are just storing the sql commands which //will insert value in onlineapplication named table //using variable named sql. try { conn.Open(); SqlCommand cmd = new SqlCommand(sql conn); //In above lines we are opening the connection to work and //also storing connection name and sql command in cmd variable //which has 'SqlCommand' type. SqlParameter[] pram = new SqlParameter[4]; //In above lines we are defining 4 sql parameters will be use //In below lines we will not disscuss about id column pram[0] = new SqlParameter(@name SqlDbType.VarChar 50); pram[1] = new SqlParameter(@username SqlDbType.VarChar 50); pram[2] = new SqlParameter(@password SqlDbType.VarChar 50); pram[3] = new SqlParameter(@emailid SqlDbType.Char 10); //Now we set-uped all fiels in database in above lines //Now we will set-up form fields pram[0].Value = name; pram[1].Value = username; pram[2].Value = password; pram[3].Value = emailid; //Now create loop to insert for (int i = 0; i { cmd.Parameters.Add(pram[i]); } cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } catch (System.Data.SqlClient.SqlException ex_msg) { //Here will be catch elements string msg = Error occured while inserting; msg += ex_msg.Message; throw new Exception(msg); } finally { //Here will be fially elements conn.Close(); } } //here is from click event starts and check for duplication account protected void create_Click(object sender EventArgs e) { SqlDataSource sds = new SqlDataSource(); sds.ConnectionString = ConfigurationManager.ConnectionStrings[mfwamba].ToString(); sds.SelectParameters.Add(name TypeCode.String this.name.Text); sds.SelectParameters.Add(username TypeCode.String this.username.Text); sds.SelectParameters.Add(password TypeCode.String this.password.Text); sds.SelectParameters.Add(emailid TypeCode.String this.emailid.Text); //sds.InsertParameters.Add(name TypeCode.String this.name.Text); //sds.InsertParameters.Add(username TypeCode.String this.username.Text); //sds.InsertParameters.Add(password TypeCode.String this.password.Text); //sds.InsertParameters.Add(emailid TypeCode.String this.emailid.Text); sds.SelectCommand = SELECT * FROM [myTb] WHERE [username] = @username; DataView dv = (DataView)sds.Select(DataSourceSelectArguments.Empty); if (dv.Count != 0) { this.lblinfo.ForeColor = System.Drawing.Color.Red; this.lblinfo.Text = The user already Exist!; return; } else { //will call the insert function here from above function execution(name.Textusername.Textpassword.Textemailid.Text); //this.SqlDataSource1.Insert(); this.lblinfo.Text = New User Profile has been created you can login now; this.name.Text = ; this.username.Text = ; this.password.Text = ; this.emailid.Text = ; } } } //////////////////////////////////// .aspx http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd > http://www.w3.org/1999/xhtml > Name Username Password Email  SelectCommand=SELECT myTb.* FROM myTb> ErrorMessage=RequiredFieldValidator Width=367px>Name should not be empty. ErrorMessage=RequiredFieldValidator Width=365px>Username should not be empty. ErrorMessage=RequiredFieldValidator Width=363px>Password should not be empty. ErrorMessage=RequiredFieldValidator Width=362px>Email id should not be empty. ErrorMessage=RegularExpressionValidator ValidationExpression=\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)* Width=359px>Invalid email id.   ///////////////////////// web.config providerName=System.Data.SqlClient />

Israel · Answer

Thanx! But I descover this link here. It's very helpful to learn and understandable: http://www.c-sharpcorner.com/uploadfile/abhikumarvatsa/simple-login-project-in-Asp-Net/

Iftikar Hussain · Answer

Hi Please check your designer file. it will contain like this protected global::System.Web.UI.WebControls.Button create_Click; just remove this Regards Iftikar

Ruchi H · Answer

Hi You have commented button with ID=create_Click and have a function with same name in code behind file. you are using to comment which actually doesn't work properly in .aspx file . Use to comment the button .