c# coding problem that i need help with

See more:

C#

Error 3 'Button2_Click' is not a member of 'ASP.newmember_aspx'. C:\Users\dr.apple\Documents\Visual Studio 2010\WebSites\WebSite2\newmember.aspx 45

although i have the method in inside the class and that is the code:

protected void Button2_Click(object sender, EventArgs e) 
{ SqlConnection con = new SqlConnection(Database.ConnectionString);
 try {
 con.Open(); SqlCommand cmd = new SqlCommand("select isnull(max(mid),0)+1 from members", con);
 int mid = (int)cmd.ExecuteScalar();
 SqlCommand cmd1 = new SqlCommand("select isnotnull from members", con); 
string mname = (string)cmd1.ExecuteScalar();
 SqlCommand cmd3 = new SqlCommand("select isnotnull from members", con);
 Char password = (char)cmd3.ExecuteScalar();
 SqlCommand cmd4 = new SqlCommand("select isnotnull from members", con);
 string email = (string)cmd4.ExecuteScalar();
 cmd.CommandText = "insert into members values(@mid,@name,@password,@email)"; cmd.Parameters.Add("@mid", SqlDbType.Int).Value = mid; cmd.Parameters.Add("@mname", SqlDbType.VarChar, 50).Value = mname; cmd.Parameters.Add("@password", SqlDbType.VarChar, 10).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); } catch (Exception ex) { HttpContext.Current.Trace.Write("error" + ex.Message); } finally { con.Close(); } } }