Inappropriate display of alert box

krishna

SOLVED CLOSED ACTIVE ANSWERED
User: krishna
Posted: on May 08, 2013 01:55 AM
Forum: ASP.Net Web Forms
Answer: 1
Views: 3922

sir i am having a textbox which accepts the election id.

i want to check if the election id exists in the database or not.

if it doesn't exist i want to throw an alert message.

If it exists i want to display it in the grid view.

but for every correct as well as incorrect entry it is showing the alert box.

below is my code please tell the necessary changes to be made.

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.Configuration;
using System.Data.SqlClient;


public partial class searchu : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
    protected void Page_Load(object sender, EventArgs e)
    {
        con.Open();
    }
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
     

        SqlCommand cmd1 = new SqlCommand("select ElectionId from users", con);
        SqlDataReader reader = cmd1.ExecuteReader();
        while (reader.Read())
        {
            string eid = reader["ElectionId"].ToString();
            if (eid == TextBox1.Text)
            {
                SqlDataSource SqlDataSource1 = new SqlDataSource();
                this.Page.Controls.Add(SqlDataSource1);
                SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
                SqlDataSource1.SelectCommand = "SELECT * FROM users WHERE ElectionId ='" + this.TextBox1.Text.Trim() + "'";
                this.GridView1.DataSource = SqlDataSource1;
                this.GridView1.DataBind();
                this.GridView1.Visible = true;
            }
            else
            {
                string script = "window.onload = function() { alert('This user does not exist!'); }";
                ClientScript.RegisterStartupScript(this.GetType(), "alert", script, true);
            }
        }
    }
}

Anujgrew...

0 4

Reply
ANSWER
User: Anujgrewal
Replied: on May 09, 2013 04:09 AM
Report

I have made sample for you.It might help you.

HTML Code

<asp:TextBox ID="txtElectionId" runat="server">
        </asp:TextBox>
        <asp:Button ID="btnShow" runat="server" Text="Show" OnClick="btnShow_Click" />
        <asp:GridView ID="gvShowData" runat="server" AutoGenerateColumns="False">
            <Columns>
                <asp:BoundField HeaderText="ElectionID" DataField="ElectionId" />
                <asp:BoundField HeaderText="LastName" DataField="LastName" />
                <asp:BoundField HeaderText="FirstName" DataField="FirstName" />
                <asp:BoundField HeaderText="City" DataField="Cit" />
            </Columns>
        </asp:GridView>

Code

  private DataTable CheckData()
        {
            int electionId = Convert.ToInt32(txtElectionId.Text.Trim());
            using (SqlConnection con = new SqlConnection(@"Data Source = 192.168.0.1\SQL2005;Initial Catalog=Northwind;User Id = sa; Password = pass@123"))
            {
                using (SqlCommand cmd = new SqlCommand("SELECT * From Users Where ElectionId = " + electionId, con))
                {
                    using (SqlDataAdapter da = new SqlDataAdapter())
                    {
                        DataTable dt = new DataTable();
                        da.SelectCommand = cmd;
                        da.Fill(dt);
                        return dt;
                    }
                }
            }
        }
        protected void btnShow_Click(object sender, EventArgs e)
        {
            DataTable dtShow = this.CheckData();
            if (dtShow.Rows.Count > 0)
            {
                gvShowData.Visible = true;
                gvShowData.DataSource = dtShow;
                gvShowData.DataBind();
            }
            else
            {
                string script = "window.onload = function() { alert('This user does not exist!'); }";
                ClientScript.RegisterStartupScript(this.GetType(), "alert", script, true);
            }

        }

Namespaces

using System;
using System.Data.SqlClient;
using System.Data;

Inappropriate display of alert box

Company

Explore

Follow us

Contact Us