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 drnewreg : 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 btnNewreg_Click(object sender, EventArgs e)
{
DataRow dr = dt.NewRow();
dr["CHAMBER_NO"] = ddlChamberno.Text;
dr["DOCTOR_NAME"] = txtDoctorname.Text;
dr["DOCTOR_ID"] = txtDoctorid.Text;
dr["DOCTOR_DESCRIPTION"] = txtDescription.Text;
dr["DOCTOR_TYPE"] = ddlType.Text;
dr["DOCTOR_SHIFT"] = ddlShift.Text;
dr["DOCTOR_OFFDAY"] = ddlOffday.Text;
dr["DOCTOR_ADDRESS"] = txtAddress.Text;
dr["DOCTOR_FEES"] = txtFees.Text;
dr["LOCATION"] = ddlLocation.Text;
dr["MOB_NO"] = txtMobileno.Text;
dr["DOB"] = txtDob.Text;
dr["PASSWORD"] = txtPassword.Text;
dt.Rows.Add(dr);//8
adp.Update(dt);//9
}
protected void txtPassword_TextChanged(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
Response.Redirect("home.aspx");
}
}
0 Comments
Post a Comment