I have four table " Admin,Student,Parent,Teacher ",
I wrote a procedure to call a AdminLogin that is working fine below is the code.
CREATE PROCEDURE Login(@useName varchar(50),@pass varchar(50))
AS BEGIN
SELECT COUNT(*) FROM Admin WHERE name = @useName AND password = @pass
END
Actually i want to change the Admin as Student, Teacher ,Parent (roles) respectively.
So i try to change the procedure call as follows
<pre lang="sql">CREATE PROCEDURE Login(@useName varchar(50),@pass varchar(50),@user varchar(50))
AS BEGIN
SELECT COUNT(*) FROM @user WHERE name = @useName AND password = @pass
END
But i cant add this procedure , How can i attain this.
My basic need is.
Four users
1.Admin
2.Teacher
3.Student
4.Parent
I am getting this from the combobox.
UserName from textBox
Password from textBox
This is my c# button click event code
<pre lang="cs">private void loginButton_Click(object sender, EventArgs e)
{
username = userNameTextBox.Text;
password = passwordTextBox.Text;
role = roleSelectionComboBox.Text;
if(username == "" || password == "" || role =="")
{
MessageBox.Show("Please fill all");
}
else
{
dbcon.Connection();
query = "Login";
com = new SqlCommand(query,dbcon.con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@useName", username);
com.Parameters.AddWithValue("@pass", password);
com.Parameters.AddWithValue("@user", role);
int userCount = (Int32)com.ExecuteScalar();
if(userCount == 1)
{
this.Hide();
Dashboard AdminDashboard = new Dashboard(username);
AdminDashboard.Show();
}
else
{
MessageBox.Show("count is 1");
}
}
}