public static string Newmember(string mname, int password, string email) { SqlConnection con = new SqlConnection(Database.ConnectionString); try { SqlCommand cmd = new SqlCommand("select isnull(max(mid),0)+1 from members", con); int mid = (int)cmd.ExecuteScalar(); cmd.CommandText = "insert into members values(@mid,@mname,@password,@email)"; cmd.Parameters.Add("@mid", SqlDbType.Int).Value = mid; cmd.Parameters.Add("@mname", SqlDbType.VarChar, 50).Value = mname; cmd.Parameters.Add("@password", SqlDbType.Int).Value = password; cmd.Parameters.Add("@email", SqlDbType.VarChar, 40).Value = email; cmd.ExecuteNonQuery(); HttpContext.Current.Trace.Write("Member has been added successfully with ID = " + mid +"\n "+"your name is" +mname +" " +"your password is"+password+" "+"your email is "+ email); } catch (Exception ex) { HttpContext.Current.Trace.Write("error" + ex.Message); } finally { con.Close(); }
myButton.Click += (sender, eventArgs) => { TheMethodToExecute(/* ... */); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)