如何防止重复数据进入数据库...如何检查文本框更改事件 [英] how to prevent duplication data enter in database...how to check on textbox change event
问题描述
我有一个文本框和一个标签... msg显示在标签中...
< asp:TextBox ID = txtChalan_No runat = server < span class =code-attribute> AutoPostBack = True > < / asp:TextBox >
< asp:Label ID = lblMsg runat = server 文本 = 标签 可见 = False > < ; / asp:标签 >
< asp:RequiredFieldValidator ID = RequiredFi eldValidator3 runat = server ControlToValidate = txtChalan_No
显示 = 无 ErrorMessage = 输入Chalan NO ValidationGroup = 验证 > < / asp:RequiredFieldValidator >
我的cs c颂歌,但它没有工作...通过错误..
<前lang =cs> 受保护 void txtChalan_No_TextChanged1( object sender,EventArgs e)
{
DataTable dtchk = gen.GetDataTable( SPChkChalan);
if (dtchk.Rows.Count > 0 )
{
lblMsg.Text = Chalan Number已经存在 跨度>;
}
else
{
lblMsg.Text = Chalan Number Available;
}
}
我的sql查询
ALTER PROCEDURE [dbo]。[SPChkChalan]
- 在此处添加存储过程的参数
@ CHAL_NO char ( 20 )
AS
BEGIN
- < span class =code-comment>添加SET NOCOUNT ON以防止额外的结果集
- 干扰SELECT语句。
SET NOCOUNT ON 跨度>;
- 在此处插入程序语句
选择 count(*)来自 DCNM 其中 CHAL_NO = @ CHAL_NO
END 在文本框中更改了事件你编写代码以获取您在文本框中输入的具有相同名称的数据。
这样的Sql查询:
从表中选择*,其中field1 ='TxtValue'
如果你得到带有此查询的数据在文本框中打印消息,如果没有则进行进一步处理。
可以更改
选择 count(*)来自 DCNM 其中 CHAL_NO = @ CHAL_NO
with
select count(*) from DCNM 其中 CHAL_NO 喜欢%@ CHAL_NO%
存储过程中的
i have one textbox and one label...msg display in label...
<asp:TextBox ID="txtChalan_No" runat="server" AutoPostBack="True"></asp:TextBox>
<asp:Label ID="lblMsg" runat="server" Text="Label" Visible="False"></asp:Label>
<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="txtChalan_No"
Display="None" ErrorMessage="Enter the Chalan NO" ValidationGroup="Validate"></asp:RequiredFieldValidator>
my cs code but it not working...through error..
protected void txtChalan_No_TextChanged1(object sender, EventArgs e)
{
DataTable dtchk = gen.GetDataTable("SPChkChalan");
if (dtchk.Rows.Count > 0)
{
lblMsg.Text = "Chalan Number Already there";
}
else
{
lblMsg.Text = "Chalan Number Available";
}
}
my sql query
ALTER PROCEDURE [dbo].[SPChkChalan]
-- Add the parameters for the stored procedure here
@CHAL_NO char(20)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
select count(*) from DCNM Where CHAL_NO=@CHAL_NO
END
On text box changed event you write code for getting data with same name which you are enter in text box.
Sql Query like this:
Select * from table where field1='TxtValue'
if you get data with this query print message at text box if not then go for further process.
can you change "select count(*) from DCNM Where CHAL_NO=@CHAL_NO
" with "select count(*) from DCNM Where CHAL_NO like % @CHAL_NO%
in your stored procedure
这篇关于如何防止重复数据进入数据库...如何检查文本框更改事件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!