using System;

using system.data;

using system.sqldata;

using system.configration;

public class Program

{

    sql connection con =new sql connection (configrationmanagament.conectionstrings["string"].connectionstring)

​

        public static void Main()

    {

        Console.WriteLine("Hello World");

    }

    con.open();

    sql command cmd =new sql command ("select * from demo where email='"+email.text+"' and password='"+password.text+"'",con);

    sqldatareader dr =cmd.execuredar();

                                      if(dr.read())

                                      {

                                          if(dr.hasrows)

                                          {

                                              sesstion["email"]= dr["email"].ToString();

​

                                              {

                                                  if (convert.toint32(dr["role"])==1)

                                                  {

                                                      responce.redirect("admin.aspx");

                                                  }

                                                      else if (convert.toint32(dr["role"])==0)

                                                  {

                                                      responce.redirect("demo.aspx");

                                                   }

                                                      else

                                                      {

                                                          clientscript.registationsatup(gettype(),"alert","alert('invelid')",true);

                                                      }

                                                      con.close();

                                              }