c# - 抛出异常：在 Webform 中填写详细信息后，Asp.net 中 system.data.dll 中的“system.data.sqlclient.sqlexception”并且没有显示任何消息

Question

1.这里有一些问题，我无法找到为什么它会抛出异常，因为我已经连接了我的 SQL SERVER MANAGEMENT STUDIO 2.我正在制作一个用户注册 Webform 页面，当我尝试运行代码和填写所有详细信息 System.Data.dll 中抛出的异常：'System.Data.SqlClient.SqlException' 但找不到原因，请帮助。

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Relocations
{
   public partial class SignUp : System.Web.UI.Page
   {
        String strcon = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
        protected void Page_Load(object sender, EventArgs e)
        {
            
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            if (checkMemberExists())
            {
                Response.Write("<script>alert('Member Id already Exist');</script>");
            }
            else
            {
                signUpNewMember();
            }
        }
            bool checkMemberExists()
            {
                try
                    {
                        SqlConnection con = new SqlConnection(strcon);
                        if (con.State == ConnectionState.Closed)
                        {
                            con.Open();
                        }
                        SqlCommand cmd = new SqlCommand("SELECT * from member_master_tb1 where member_id='" + TextBox8.Text.Trim() + "';", con);
                        SqlDataAdapter da = new SqlDataAdapter(cmd);
                        DataTable dt = new DataTable();
                        da.Fill(dt);
                        if (dt.Rows.Count >= 1) 
                        {
                            return true;
                        }
                        else 
                        {
                            return false;
                        }
              
                    }
                catch (Exception ex)
                {
                    Response.Write("<script>alert('" + ex.Message + "');</script>");
                    return false;
                }
            
            }  

            void signUpNewMember()
            {
                try
                {
                    SqlConnection con = new SqlConnection(strcon);
                    if (con.State == ConnectionState.Closed)
                    {
                        con.Open();
                    }
                    SqlCommand cmd = new SqlCommand("INSERT INTO member_master_tb1(full name,dob,contact,email,state,city,pincode,address,member_id,password,account_status) value(@full name,@dob,@contact,@email,@state,@city,@pincode,@address,@member_id,@password,@account_status)", con);
                    cmd.Parameters.AddWithValue("@full name", TextBox3.Text.Trim());
                    cmd.Parameters.AddWithValue("@dob", TextBox4.Text.Trim());
                    cmd.Parameters.AddWithValue("@contact", TextBox1.Text.Trim());
                    cmd.Parameters.AddWithValue("@email", TextBox2.Text.Trim());
                    cmd.Parameters.AddWithValue("@state", DropDownList1.SelectedItem.Value);
                    cmd.Parameters.AddWithValue("@city", TextBox5.Text.Trim());
                    cmd.Parameters.AddWithValue("@pincode", TextBox6.Text.Trim());
                    cmd.Parameters.AddWithValue("@address", TextBox7.Text.Trim());
                    cmd.Parameters.AddWithValue("@member_id", TextBox8.Text.Trim());
                    cmd.Parameters.AddWithValue("@password", TextBox9.Text.Trim());
                    cmd.Parameters.AddWithValue("@account_status", "pending");

                    cmd.ExecuteNonQuery();
                    con.Close();
                    Response.Write("<script>alert('Sign Up Successfully. Ypu can Login Now');</script>");
                }
                catch (Exception ex)
                {

Response.Write("<script>alert('" + ex.Message + "')</script>");
---------------------------------------------------------------

                }
            }
        
    }
}

标签： c#asp.net.netwebforms