抛出异常:在 webform 中填写详细信息后,Asp.net 中的 system.data.dll 中的“system.data.sqlclient.sqlexception”并且没有显示任何消息

1.这里有一些问题,我无法找到它抛出异常的原因,因为我已经连接了我的 SQL SERVER MANAGEMENT STUDIO 2. 我正在制作一个用户注册 Webform 页面,当我尝试运行代码并填写所有详细信息时发生了这种情况请帮忙。

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>");
---------------------------------------------------------------

                }
            }
        
    }
}
shiyan5168 回答:抛出异常:在 webform 中填写详细信息后,Asp.net 中的 system.data.dll 中的“system.data.sqlclient.sqlexception”并且没有显示任何消息

暂时没有好的解决方案,如果你有好的解决方案,请发邮件至:iooj@foxmail.com
本文链接:https://www.f2er.com/35800.html

大家都在问