I’m new in asp.net. and I’m am creating a simple Shoe Store Billing Management System. I want to know how to fire textbox validate event. Just like as we do in windows app textbox validate event. I have lost of shoes in my shoes table. And there is two column in table ShoseCode and ShoseDesc. When I enter the ShoseCode in txt_ShoseCode and if this ShoseCode is already exist in ShoseCode Column. So this txt_ShoseCode retrieve information from database. Or if this cant retrieve so just show the message like “This Shoes Code already exist” or something like this.
And I'm using asp:Panel (ModalPopupExtender). Because of AutoPostBack="True" in txt_ShoseCode the value is remove in txt_ShoseCode when I fire txt_ShoseCode_TextChanged event. And I also don't know how to use javascript or jquery for this.
Thanks in Advance
'
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="WebApplication1.WebForm1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<title>Untitled Page</title>
<script type="text/javascript">
function Display(ShoseCode) {
alert(ShoseCode + ':::ShoseCode');
if (alert) {
window.location = 'WebForm1.aspx';
}
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<br />
<asp:Label ID="Labelcheck"
Text="Please enter any ShoseCode to be verified from the database"
runat="server" BackColor="#FFFF99"
Width="197px" ForeColor="#FF3300"></asp:Label>
<asp:TextBox ID="txt_ShoseCode" runat="server" Width="197px"
AutoPostBack="True" ontextchanged="txt_ShoseCode_TextChanged"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ControlToValidate="txt_ShoseCode" ErrorMessage="*ShoseCode Required"></asp:RequiredFieldValidator>
<br />
<asp:Timer ID="Timer1" runat="server" Interval="10000" ontick="Timer1_Tick">
</asp:Timer>
<asp:Label ID="lblMessage" runat="server" BackColor="#FF3300"
ForeColor="Black"></asp:Label>
<asp:Label ID="Label1" runat="server" Text="Label" Visible="False"></asp:Label>
</div>
</form>
</body>
</html>
'
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace WebApplication1
{
public partial class WebForm1 : System.Web.UI.Page
{
string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlCommand com;
string str;
protected void Page_Load(object sender, EventArgs e)
{
}
public void ShoseCode_check()
{
SqlConnection con = new SqlConnection(connStr);
con.Open();
str = "select count(*)from tblShoes where ShoesCode ='" + txt_ShoseCode.Text + "'";
com = new SqlCommand(str, con);
int count = Convert.ToInt32(com.ExecuteScalar());
if (count > 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "ShowSuccess", "javascript:Display('" + txt_ShoseCode.Text + "')", true);
lblMessage.Text = "This Shoes Code already exist";
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "ShowSuccess", "javascript:Display('" + txt_ShoseCode.Text + "')", true);
lblMessage.Text = "This Shoes Code does not exist";
}
}
protected void txt_ShoseCode_TextChanged(object sender, EventArgs e)
{
ShoseCode_check();
}
protected void Timer1_Tick(object sender, EventArgs e)
{
Label1.Text = DateTime.Now.ToString();
}
}
}
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…