如何避免从ASP到SQL插入重复记录? [英] how to avoid inserting duplicate records from asp to sql ?

问题描述

您好，我创建了存储过程来避免重复的条目，但是我不知道如何在业务类中提供代码.任何人都可以建议我.

这是我的sp

hi i created stored procedure to avoid duplicate entries but i dont knw how to give code in business class..can any one suggest me.

this my sp

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go




ALTER PROCEDURE [dbo].[usp_InsertBuild]
@BuildNo varchar(50),
@StartDate varchar(50),
@EndDate varchar(50),
 @Success bit output, 
@msg varchar(50) output  


AS
BEGIN
if not exists(select * from tblBuild where BuildNo=@BuildNo) 
begin
set @Success=1
set @msg=''Successfully Saved''      



insert into tblBuild(BuildNo,StartDate,EndDate)
 values(@BuildNo,@StartDate,@EndDate)
end
else  begin
set @Success=0           
set @msg=''Build Number already exists, Cannot Save'' 
END end

这是我的aspx.cs代码..

here is my aspx.cs code..

protected void imgbtnSave_Click(object sender, ImageClickEventArgs e)
   {
       InsertAllPL iaPL = new InsertAllPL();
       iaPL.BuildNo = txtBNo.Text;
       iaPL.StartDate = txtSDate.Text;
       iaPL.EndDate = txtEndDate.Text;

       InsertAllBLL iaBLL = new InsertAllBLL();
       iaBLL.InsertBuild(iaPL);

       //lblMessage.Text = "Record Added SuccessFully";
       divMessage.Visible = true;
       txtBNo.Text = "";
       txtSDate.Text = "";
       txtEndDate.Text = "";
   }

推荐答案

您只需使用以下代码将输出参数值分配给lblMessage

u just assign output parameter value to lblMessage using following code

string msg =sqlCmd.Parameters["@Success"].Value;
    return msg;

签入btnSaveclick事件

check in btnSaveclick event

if(msg=="1")
     lblMessage.Text="Successfully Saved";
   else
     lblMessage.Text="Build Number already exists, Cannot Save";

希望对您有帮助
祝您好运

hope it will help
best luck

您可以在业务类中使用功能强大的LInQ查询.这是在插入之前获取重复记录的示例代码.

You can use powerful LInQ query in business class. Here is the sample code to fetch the duplicate records before insert.

var dbData = from x in db.tblBuild
                       where x.Sucess != 0
                       group x by x.BuildNo into g
                       let ct = g.Count()
                       orderby ct
                       where ct > 1
                       select new
                            {   
                                BuildNo = g.First().BuildNo,
                                StartDate = g.First().StartDate,
                                EndDate = g.First().EndDate,
                                Success = g.First().Success,
                                msg = g.First().msg,
                            };

这篇关于如何避免从ASP到SQL插入重复记录?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！