asardeen

I want to display username in the top of all page. Below is my code . protected void Page_Load(object sender, EventArgs e) { } protected void btnLogin_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString); con.Open(); SqlCommand cmd = new SqlCommand("select * from Userman where Username =@username and Password=@password", …

I am exporting data from excel and show it in gridview and when I click submit, it needs to be updated in existing table. Below is my excel data S.No. RequestID Subdivision No Parcel No CUID Status Remarks 1 5 42 55 55 Open Pending I have successfully exported and …

I want to export the excel data and show it in gridview. And I want to update the existing table i sql using Gridview data Below is my code for exporting from Excel protected void btnUpload_Click(object sender, EventArgs e) { //Coneection String by default empty string ConStr = ""; //Extantion …

Below is my registration page and it is allowing duplicate values in the DB. Could you please help me where am going wrong private void ExecuteInsert(string UserName, string Password) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString); string sql = "INSERT INTO UserMan (UserName, Password) VALUES " + " (@UserName,@Password)"; try { …