C# code on database insertion and retrieval

create 2 coloumns Username Password in DB.
Two labels n 2 textbocxes in Windows form..
Button insert
double click on button...
same insertion code..

button click
{
cmd = new SqlCommand("insert into ShiftMaster values('" + cboxGroupName.Text + "','" + txtShiftCode.Text + "', con);//two textboxes her...
con.open();
cmd.executeNonQuery();
con.close();
Messagebox.show("Inserted");
}

Dear fellow,

It is always better if you provide full information that which technology and project you are working on. Like If you are using Asp .Net, you can also use asp.net role management as well.
Take a look.

http://msdn.microsoft.com/en-us/library/ff647401.aspx[^]

Good Luck!

its simple dude...

you have to create a stored procedure which retuns userid on passing username & password.

For example.ul.Check_Admin_Login(); is a function which authenticate login process and redirect the response.

ul.pwd = txt_pwd.Text;
      int chk = ul.Check_Admin_Login();
          userInfo_class.unm = txt_unm.Text.Trim().ToString();
          ul.pwd = txt_pwd.Text.Trim().ToString();
          userInfo_class.unm = Convert.ToString(ul.Chk_Login());
          Session.Add("uid", userInfo_class.unm);
          if (userInfo_class.unm != "0")
          {
              Response.Redirect("Welcome.aspx");

          }
          else
          {
              lbl_message.Text = "Invalid User.";
              txt_unm.Text = "";
          }
      }