Show "registration successfully" after saving or modifying the timer

Question

Can you help me fix the code .. In addition, I want to display with the timer the phrase "registration successfully" after saving or modifying "C#" AutoEventWireup= "true" CodeBehind= "Dashbord.aspx.cs" Inherits= "Login.Dashbord" %> "http://www.w3.org/1999/xhtml" > "server" > "text/css" > .auto-style1 { width: 100%; } .auto-style2 { } .auto-style3 { margin-left: 120px; } .auto-style4 { width: 22px; height: 27px; margin-left: 120px; } .auto-style5 { height: 27px; } .auto-style6 { margin-left: 120px; } "form1" runat= "server" > class = "auto-style1" > class = "auto-style2" colspan= "2" > Save/Update class = "auto-style6" > "Label2" runat= "server" Font-Bold= "True" ForeColor= "#33CC33" Text= "Register Successfully" > class = "auto-style4" >Name class = "auto-style5" > "TextBox2" runat= "server" Width= "175px" > class = "auto-style6" >Password "TextBox3" runat= "server" Width= "174px" > class = "auto-style6" > class = "auto-style3" colspan= "2" > "GridView1" runat= "server" AllowPaging= "True" AutoGenerateColumns= "False" DataKeyNames= "ID" DataSourceID= "SqlDataSource1" OnSelectedIndexChanged= "GridView1_SelectedIndexChanged" Width= "663px" > "ID" HeaderText= "ID" InsertVisible= "False" ReadOnly= "True" SortExpression= "ID" /> "EMPNAME" HeaderText= "EMPNAME" SortExpression= "EMPNAME" /> "PASSWORD" HeaderText= "PASSWORD" SortExpression= "PASSWORD" /> "True" /> class = "auto-style3" colspan= "2" > "SqlDataSource1" runat= "server" ConnectionString= " " OnSelecting= "SqlDataSource1_Selecting" SelectCommand= "SELECT DISTINCT * FROM [tblUser]" > class = "auto-style6" colspan= "2" > "Label1" runat= "server" Text= "Label" Visible= "False" > "Button1" runat= "server" OnClick= "Button1_Click" Text= "Save" Width= "115px" /> "Button2" runat= "server" OnClick= "Button2_Click" Text= "Serach" Width= "115px" /> "Button3" runat= "server" OnClick= "Button3_Click" Text= "Update" Width= "106px" /> "Button4" runat= "server" OnClick= "Button4_Click" Text= "Delete" Width= "113px" /> using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; namespace Login { public partial class Dashbord : System.Web.UI.Page { protected void Page_Load( object sender, EventArgs e) { } protected void Button1_Click( object sender, EventArgs e) { SqlConnection cn = new SqlConnection( "Data Source=DESKTOP-KH76KMV;Initial Catalog=TblLogin;Integrated Security=True" ); SqlCommand cmd = new SqlCommand( "insert into tblUser (EMPNAME,PASSWORD) values (@EMPNAME,@PASSWORD)" , cn); cn.Open(); cmd.Parameters.AddWithValue( "EMPNAME" , TextBox2.Text); cmd.Parameters.AddWithValue( "PASSWORD" , TextBox3.Text); cmd.ExecuteNonQuery(); cn.Close(); } protected void Button2_Click( object sender, EventArgs e) { SqlConnection cn = new SqlConnection( "Data Source=DESKTOP-KH76KMV;Initial Catalog=TblLogin;Integrated Security=True" ); cn.Open(); DataTable dt = new DataTable(); SqlDataAdapter sd = new SqlDataAdapter( "select EMPNAME,PASSWORD from tblUser where EMPNAME= '" +TextBox2.Text+ "'" , cn); sd.Fill(dt); if (dt.Rows.Count > 0) { TextBox2.Text=Convert.ToString(dt.Rows[0][ "EMPNAME" ]); TextBox3.Text=Convert.ToString(dt.Rows[0][ "PASSWORD" ]); } //using (SqlDataReader da=cmd.ExecuteReader()) //{ // if (da.Read()) // { // TextBox2.Text = da.["EMPNAME"].ToString(); // TextBox3.Text = da["PASSWORD"].ToString(); // } // else // { // Label1.Text = "Not found"; // } //} } protected void Button3_Click( object sender, EventArgs e) { SqlConnection cn = new SqlConnection( "Data Source=DESKTOP-KH76KMV;Initial Catalog=TblLogin;Integrated Security=True" ); SqlCommand cmd = new SqlCommand( "Update tblUser set PASSWORD=@PASSWORD where EMPNAME=@EMPNAME" , cn); cn.Open(); cmd.Parameters.AddWithValue( "EMPNAME" , TextBox2.Text); cmd.Parameters.AddWithValue( "PASSWORD" , TextBox3.Text); cmd.ExecuteNonQuery(); cn.Close(); } protected void Button4_Click( object sender, EventArgs e) { SqlConnection cn = new SqlConnection( "Data Source=DESKTOP-KH76KMV;Initial Catalog=TblLogin;Integrated Security=True" ); SqlCommand cmd = new SqlCommand( "Delete from tblUser where EMPNAME=@EMPNAME" , cn); cn.Open(); TextBox2.Text = "" ; TextBox3.Text = "" ; cmd.ExecuteNonQuery(); } ////protected void Timer1_Tick(object sender, EventArgs e) //{ //} protected void GridView1_SelectedIndexChanged( object sender, EventArgs e) { SqlConnection cn = new SqlConnection( "Data Source=DESKTOP-KH76KMV;Initial Catalog=TblLogin;Integrated Security=True" ); cn.Open(); DataTable dt = new DataTable(); SqlDataAdapter sd = new SqlDataAdapter( "select EMPNAME,PASSWORD from tblUser where EMPNAME= '" + TextBox2.Text + "'" , cn); sd.Fill(dt); if (dt.Rows.Count > 0) { GridView1.DataSource = tblUser; GridView1.DataBind(); } } } }

Sachin Singh · Answer

Delete these lines completely class = "auto-style3" colspan= "2" > "SqlDataSource1" runat= "server" ConnectionString= " " OnSelecting= "SqlDataSource1_Selecting" SelectCommand= "SELECT DISTINCT * FROM [tblUser]" > and bind grid from code behind and call in page load event. page_Load(EventArgs e) { BindGrid() ; } private void BindGrid() { SqlConnection cn = new SqlConnection( "Data Source=DESKTOP-KH76KMV;Initial Catalog=TblLogin;Integrated Security=True" ); SqlCommand cmd = new SqlCommand( "select *from tblUser " , cn); cn.Open(); GridView1.DataSource= cmd.ExecuteNonQuery(); GridView1.DataBind(); }

Sachin Singh · Answer

see carefully "GridView1" runat= "server" AllowPaging= "True" AutoGenerateColumns= "False" DataKeyNames= "ID" DataSourceID= "SqlDataSource1" OnSelectedIndexChanged= "GridView1_SelectedIndexChanged" Width= "663px" > in above lines delete the red marked thing means ( DataSourceID= "SqlDataSource1" ) from aspx page in Gridview.

Sachin Singh · Answer

keep the lable text null in the aspx page and set it from code behind on Save and Update class = "auto-style1" > class = "auto-style2" colspan= "2" > Save/Update class = "auto-style6" > "Label2" runat= "server" Font-Bold= "True" ForeColor= "#33CC33" Text= "" > class = "auto-style4" >Name class = "auto-style5" > "TextBox2" runat= "server" Width= "175px" > class = "auto-style6" >Password "TextBox3" runat= "server" Width= "174px" > class = "auto-style6" > protected void Button1_Click(object sender, EventArgs e) { SqlConnection cn = new SqlConnection( "Data Source=DESKTOP-KH76KMV;Initial Catalog=TblLogin;Integrated Security=True" ); SqlCommand cmd = new SqlCommand( "insert into tblUser (EMPNAME,PASSWORD) values (@EMPNAME,@PASSWORD)" , cn); cn.Open(); cmd.Parameters.AddWithValue( "EMPNAME" , TextBox2.Text); cmd.Parameters.AddWithValue( "PASSWORD" , TextBox3.Text); cmd.ExecuteNonQuery(); cn.Close(); Label2.Text= "Saved Successfully" ; } protected void Button3_Click(object sender, EventArgs e) { SqlConnection cn = new SqlConnection( "Data Source=DESKTOP-KH76KMV;Initial Catalog=TblLogin;Integrated Security=True" ); SqlCommand cmd = new SqlCommand( "Update tblUser set PASSWORD=@PASSWORD where EMPNAME=@EMPNAME" , cn); cn.Open(); cmd.Parameters.AddWithValue( "EMPNAME" , TextBox2.Text); cmd.Parameters.AddWithValue( "PASSWORD" , TextBox3.Text); cmd.ExecuteNonQuery(); cn.Close(); Label2.Text= "Updated Successfully" ; }

Rijwan Ansari · Answer

First hide the Label12 in page load as shown: protected void Page_Load(object sender, EventArgs e) { if(!IsPostBack()) { Label2.Visible = false ; } } Then show it in Button1_Click and Button3_Click as shown: protected void Button1_Click(object sender, EventArgs e) { SqlConnection cn = new SqlConnection( "Data Source=DESKTOP-KH76KMV;Initial Catalog=TblLogin;Integrated Security=True" ); SqlCommand cmd = new SqlCommand( "insert into tblUser (EMPNAME,PASSWORD) values (@EMPNAME,@PASSWORD)" , cn); cn. Open (); cmd.Parameters.AddWithValue( "EMPNAME" , TextBox2.Text); cmd.Parameters.AddWithValue( "PASSWORD" , TextBox3.Text); cmd.ExecuteNonQuery(); cn. Close (); Label2.Visible = True ; } protected void Button3_Click(object sender, EventArgs e) { SqlConnection cn = new SqlConnection( "Data Source=DESKTOP-KH76KMV;Initial Catalog=TblLogin;Integrated Security=True" ); SqlCommand cmd = new SqlCommand( "Update tblUser set PASSWORD=@PASSWORD where EMPNAME=@EMPNAME" , cn); cn. Open (); cmd.Parameters.AddWithValue( "EMPNAME" , TextBox2.Text); cmd.Parameters.AddWithValue( "PASSWORD" , TextBox3.Text); cmd.ExecuteNonQuery(); cn. Close (); Label2.Visible = True ; } Then again hide it rest all the functions: Button2_Click and Button4_Click as shown protected void Button2_Click(object sender, EventArgs e) { SqlConnection cn = new SqlConnection( "Data Source=DESKTOP-KH76KMV;Initial Catalog=TblLogin;Integrated Security=True" ); cn. Open (); DataTable dt = new DataTable(); SqlDataAdapter sd = new SqlDataAdapter( "select EMPNAME,PASSWORD from tblUser where EMPNAME= '" +TextBox2.Text+ "'" , cn); sd.Fill(dt); if (dt. Rows . Count > 0) { TextBox2.Text= Convert .ToString(dt. Rows [0][ "EMPNAME" ]); TextBox3.Text= Convert .ToString(dt. Rows [0][ "PASSWORD" ]); } Label12.Visible = false ; } protected void Button4_Click(object sender, EventArgs e) { SqlConnection cn = new SqlConnection( "Data Source=DESKTOP-KH76KMV;Initial Catalog=TblLogin;Integrated Security=True" ); SqlCommand cmd = new SqlCommand( "Delete from tblUser where EMPNAME=@EMPNAME" , cn); cn. Open (); TextBox2.Text = "" ; TextBox3.Text = "" ; cmd.ExecuteNonQuery(); Label12.Visible = false ; } This will solve your problem. Regards Rijwan

Sachin Singh · Answer

open your aspx page and delete sqldatasource in the header of Grid. the error will be resolved.

salim ali · Answer

This is how the error appears

Sachin Singh · Answer

yes , with connection in the grid it was tbluser so in codebehind i used the same.

salim ali · Answer

GridView1.DataSource= cmd.ExecuteNonQuery(); GridView1.DataBind(); } Would you be datasource = tblUser ??

salim ali · Answer

class = "auto-style3" colspan= "2" > "SqlDataSource1" runat= "server" ConnectionString= " " OnSelecting= "SqlDataSource1_Selecting" SelectCommand= "SELECT DISTINCT * FROM [tblUser]" > Also here it tells me there is an error

Kiran Mohanty · Answer

css .successfully-saved { color: #FFFFFF; text-align: center; -webkit-transition: opacity 3s ease- in - out ; -moz-transition: opacity 3s ease- in - out ; -ms-transition: opacity 3s ease- in - out ; -o-transition: opacity 3s ease- in - out ; opacity: 1; } Add this class to the label if you wish to see some slidding effect.