sql查询异常未处理？ [英] sql query exception was unhandled?

问题描述

{
            string Username = UserNTB.Text;
            string password = UserPass.Text;
            string Address = UserAdd.Text;

            SqlConnection con = new SqlConnection();
            con.ConnectionString = "Data Source=PROMOD-PC;Initial Catalog=UserDB;Integrated Security=True";
            
            String QueryStr = "Insert into UserInfo(Username, Password, Address) Values (@UN, @UP, @UA)";

            SqlCommand com = new SqlCommand(QueryStr, con);

            com.Parameters.Add(new SqlParameter("@UN", UserNTB.Text));
            com.Parameters.Add(new SqlParameter("@UP", UserPass.Text));
            com.Parameters.Add(new SqlParameter("@UA", UserAdd.Text));


            con.Open();
            com.ExecuteNonQuery();


        }

当我输入数据到我的界面时，当我点击好按钮它会指出con.open并给出异常unhndled错误吗？

when i input data to my interface and when i hit okay button it will point out con.open and gives exception unhndled error?

推荐答案

检查查询本身。

尝试在SQL Server Management Studio中运行它。



确保所有数据库值都是正确的类型。

Check the query itself.
Try running it in SQL Server Management Studio.

Ensure all database values are of the correct type.

SqlConnection con = new SqlConnection();
con.ConnectionString = "Data Source=PROMOD-PC;Initial Catalog=UserDB;Integrated Security=True";

try
{
    string Username = UserNTB.Text;
    string password = UserPass.Text;
    string Address = UserAdd.Text;
    
    String QueryStr = "Insert into UserInfo(Username, Password, Address) Values (@UN, @UP, @UA)";
    
    con.Open();
    SqlCommand com = new SqlCommand(QueryStr, con);  // here it requires Open Connection to the database
    
    com.Parameters.Add(new SqlParameter("@UN", UserNTB.Text));
    com.Parameters.Add(new SqlParameter("@UP", UserPass.Text));
    com.Parameters.Add(new SqlParameter("@UA", UserAdd.Text));
    
    com.ExecuteNonQuery();

}
finally
{
    con.Close();
}

-KR

-KR

这篇关于sql查询异常未处理？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！