using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;//1
using System.Data.SqlClient;//2
public partial class drlogin : System.Web.UI.Page
{
SqlDataAdapter adp = new SqlDataAdapter("select * from drregnew", @"Data Source=.\SQLEXPRESS;AttachDbFilename=F:\website\doctor\App_Data\drreg.mdf;Integrated Security=True;User Instance=True");//3
DataTable dt = new DataTable();//4
protected void Page_Load(object sender, EventArgs e)
{
adp.Fill(dt);//5
SqlCommandBuilder str = new SqlCommandBuilder(adp);//6
}
protected void Button1_Click(object sender, EventArgs e)
{
Response.Redirect("home.aspx");
}
protected void Button2_Click(object sender, EventArgs e)
{
Response.Redirect("drnewreg.aspx");
}
protected void Button3_Click(object sender, EventArgs e)
{
try
{
DataRow[] dr = dt.Select("DOCTOR_ID='" + txtDrid.Text + "'");
if (dr[0]["PASSWORD"].ToString() == txtDrpass.Text)
{
Session["DOCTOR ID"] = dr[0]["DOCTOR_ID"].ToString();
Response.Redirect("patientlist.aspx");
}
else
{
lblError.Text = "Please enter valid password.....";
}
}
catch
{
lblError.Text = "Register First...";
}
}
}
0 Comments
Post a Comment