Iran58
چهارشنبه 18 فروردین 1389, 08:19 صبح
سلام
كدزيررانوشته ام
int IsLogin = 0;
using (SqlConnection cnn = new SqlConnection(System.Configuration.ConfigurationSe ttings.AppSettings["CnnStr"].ToString()))
{
cnn.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserName", TxtUserName.Text);
cmd.Parameters.AddWithValue("@Password", TxtPassword.Text);
IsLogin = Convert.ToInt32(cmd.ExecuteScalar());
cmd.Dispose();
cnn.Close();
}
}
if (IsLogin==1)
{
Form1 frm = new Form1();
frm.Show();
}
else
{
MessageBox.Show("Invalid Login Information");
}
spبانك هم
CREATE PROCEDURE usp_IsAvalable
@UserName Nvarchar(20),
@Password Nvarchar(20)
As
if exists(Select * From Users
Where UserName = @UserName And Password = @Password)
return(1)
else
return(0)
Goاماهنگام اجراارورزيررانشان مي دهدكجابرنامه مورددارد
ExecuteScalar:Connection property has not been initialized
كدزيررانوشته ام
int IsLogin = 0;
using (SqlConnection cnn = new SqlConnection(System.Configuration.ConfigurationSe ttings.AppSettings["CnnStr"].ToString()))
{
cnn.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserName", TxtUserName.Text);
cmd.Parameters.AddWithValue("@Password", TxtPassword.Text);
IsLogin = Convert.ToInt32(cmd.ExecuteScalar());
cmd.Dispose();
cnn.Close();
}
}
if (IsLogin==1)
{
Form1 frm = new Form1();
frm.Show();
}
else
{
MessageBox.Show("Invalid Login Information");
}
spبانك هم
CREATE PROCEDURE usp_IsAvalable
@UserName Nvarchar(20),
@Password Nvarchar(20)
As
if exists(Select * From Users
Where UserName = @UserName And Password = @Password)
return(1)
else
return(0)
Goاماهنگام اجراارورزيررانشان مي دهدكجابرنامه مورددارد
ExecuteScalar:Connection property has not been initialized