Thanks a lot Paladine but when i have make like you have write to me and have try something else i always get this error:
'Login1.WebForm1.test(string, string)': not all code paths return a value

the function is:

(Toggle Plain Text)

privatebool test(string txtUser,string txtPassword)
{
OleDbConnection myConn = new OleDbConnection(ConfigurationSettings.AppSettings["strCon"]);
OleDbCommand myCmd = new OleDbCommand("proverka",myConn);
myCmd.CommandType = CommandType.StoredProcedure;
OleDbParameter objParam1,objParam2;
//OleDbParameter returnParam;
objParam1 = myCmd.Parameters.Add("@UserName",OleDbType.Char);
objParam2 = myCmd.Parameters.Add("@Password",OleDbType.Char);
//returnParam = myCmd.Parameters.Add("@ID",OleDbType.Integer);
objParam1.Direction = ParameterDirection.Input;
objParam2.Direction = ParameterDirection.Input;
//returnParam.Direction = ParameterDirection.ReturnValue;
objParam1.Value = txtUser;
objParam2.Value = txtPassword;
 
try
{
if(myConn.State == ConnectionState.Closed)
{
myConn.Open();
//myCmd.ExecuteNonQuery();
}
OleDbDataReader objReader;
objReader = myCmd.ExecuteReader(CommandBehavior.CloseConnection);
while(objReader.Read())
{
if((bool)(objReader.GetValue(0)) == false)
{
Label1.Text="Inavlid Login!";
return false;
}
else
{
objReader.Close();
return true;
}
}
}
catch(Exception ex)
{
Label2.Text = ex + "Error connecting to the DB!";
return false;
}
}

privatebool test(string txtUser,string txtPassword) { OleDbConnection myConn = new OleDbConnection(ConfigurationSettings.AppSettings["strCon"]); OleDbCommand myCmd = new OleDbCommand("proverka",myConn); myCmd.CommandType = CommandType.StoredProcedure; OleDbParameter objParam1,objParam2; //OleDbParameter returnParam; objParam1 = myCmd.Parameters.Add("@UserName",OleDbType.Char); objParam2 = myCmd.Parameters.Add("@Password",OleDbType.Char); //returnParam = myCmd.Parameters.Add("@ID",OleDbType.Integer); objParam1.Direction = ParameterDirection.Input; objParam2.Direction = ParameterDirection.Input; //returnParam.Direction = ParameterDirection.ReturnValue; objParam1.Value = txtUser; objParam2.Value = txtPassword; try { if(myConn.State == ConnectionState.Closed) { myConn.Open(); //myCmd.ExecuteNonQuery(); } OleDbDataReader objReader; objReader = myCmd.ExecuteReader(CommandBehavior.CloseConnection); while(objReader.Read()) { if((bool)(objReader.GetValue(0)) == false) { Label1.Text="Inavlid Login!"; return false; } else { objReader.Close(); return true; } } } catch(Exception ex) { Label2.Text = ex + "Error connecting to the DB!"; return false; } }

hi! i was tested your code but i got an error..
i thing the error is in stored procedure...
pls send me the coding for stored procedure and table..