Show "registration successfully" after saving or modifying the timer

Can you help me fix the code ..

In addition, I want to display with the timer the phrase "registration successfully" after saving or modifying

<%@ Page Language="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="<%$ ConnectionStrings:TblLoginConnectionString %>" 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();
}
}
}
}

Delete these lines completely

class="auto-style3" colspan="2">
"SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TblLoginConnectionString %>" 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();
}

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

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.

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

This is how the error appears

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

GridView1.DataSource= cmd.ExecuteNonQuery();
GridView1.DataBind();
}

class="auto-style3" colspan="2">
"SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TblLoginConnectionString %>" OnSelecting="SqlDataSource1_Selecting" SelectCommand="SELECT DISTINCT * FROM [tblUser]">

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.

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";
}

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
Delete these lines completely
    class="auto-style3" colspan="2">
        "SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TblLoginConnectionString %>" 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();

        }
+2
Rijwan Ansari5y ago
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
0
Sachin Singh5y ago
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.
+2
Sachin Singh5y ago
open your aspx page and delete sqldatasource in the header of Grid. the error will be resolved.
0
salim ali5y ago
This is how the error appears

0
Sachin Singh5y ago
yes , with connection in the grid it was tbluser so in codebehind i used the same.
0
salim ali5y ago
1. GridView1.DataSource= cmd.ExecuteNonQuery();
2. GridView1.DataBind();
4. }
Would you be datasource = tblUser

??
0