System Error
Hi All!
I had seen an Error Message "System Error" at sqlCom.ExecuteNonQuery when compile the folowing code:
private void cmdLogin_Click(object sender, System.EventArgs e)
{
string strUserName, strPassWord,strDBUserName, strDBPassword,strServerName, strDBName;
string strConn;
strUserName = txtUserName.Text.ToString();
strPassWord = txtPassword.Text.ToString();
strDBUserName = txtDBUserName.Text.ToString();
strDBPassword = txtDBName.Text.ToString();
strServerName = txtServerName.Text.ToString();
strDBName = txtDBName.Text.ToString();
strConn = "User ID ="+strDBUserName+";Password ="+strPassWord+";Initial Catalog ="+strDBName+";Data Source ="+strServerName;
SqlConnection sqlConn = new SqlConnection(strConn);
SqlCommand sqlCom = new SqlCommand("sp_Select_User",sqlConn);
sqlCom.CommandType = CommandType.StoredProcedure;
sqlCom.Parameters.Add(new SqlParameter("@sLoginName",SqlDbType.VarChar,50));
sqlCom.Parameters["@sLoginName"].Value = strUserName;
sqlCom.Parameters.Add(new SqlParameter("@sEncryptedPassword",SqlDbType.NVarC har,200));
sqlCom.Parameters["@sEncryptedPassword"].Value = strPassWord;
sqlConn.Open();
sqlCom.ExecuteNonQuery();
sqlConn.Close();
DataTable dt = new DataTable();
SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCom);
sqlDa.Fill(dt);
int row = dt.Rows.Count;
if (row == 0)
{
MessageBox.Show("Wrong UserName or Password");
}
else
{
MessageBox.Show("Successfull Login");
}
}
Is there anyone help me ?
|
