public partial class PagesUser_WelcomeUser : System.Web.UI.Page { string name; string mail; SqlConnection conn = new SqlConnection(@"Data Source=.\sqlexpress;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\OnlineLibrary.mdf;Integrated Security=True"); protected void Page_Load(object sender, EventArgs e) { name = Page.User.Identity.Name; //SqlDataAdapter adpmail = new SqlDataAdapter("select UserName,Email from aspnet_Membership M join aspnet_Users U on M.UserId=U.UserId where U.UserName='" + name + "'", conn); //DataSet dsmail = new DataSet(); //adpmail.Fill(dsmail, "Library_user"); //mail = dsmail.Tables[0].Rows[0]["Email"].ToString(); //txtMail.Text = mail; } protected void btnsubmit_Click(object sender, EventArgs e) { pnlForm.Visible = false; btnsubmit.Visible = false; try { conn.Open(); SqlCommand insert = new SqlCommand("Insert Library_User values('" + name + "','" + txtName.Text + "', " + txtAge.Text + ",'" + txtDesignation.Text + "','" + txtMail.Text + "','" + txtPhone.Text + "','" + txtAddress.Text + "','" + txtDD.Text + "')", conn); int insertRecord = insert.ExecuteNonQuery(); if (insertRecord >= 1) { lblMsg.Text = "congradulation...your details have been registered"; } else { lblMsg.Text = "Records not entered. Try again..!!!"; lblMsg.Visible = true; } conn.Close(); } catch { lblMsg.Text = "Your Records have been already entered. Please proceed..."; lblMsg.Visible = true; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)