ASP.NET

Basheer wrote:

how to create administrator username,password and user username,password in only one login control?

SELECT MyName FROM MyTable WHERE DATEPART(year, MyDate) = @MyYear

CREATE PROCEDURE GetNames
@Year int
AS
    SELECT MyName FROM MyTable WHERE DATEPART(year, MyDate) = @Year
GO

using(SqlConnection conn = new SqlConnection(myConnectionString))
{
    SqlCommand cmd = new SqlCommand();
    cmd.Connection = conn;
    cmd.CommandText = "GetNames";
    cmd.CommandType = CommandType.StoredProcedure;
    conn.Open();
    SqlDataReader reader = cmd.ExecuteReader();
    while(reader.Read())
    {
        string name = reader.GetString(0);
        // Do what you need to do with name here.
    }
}