.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Checking existence of a record in sql database using IF EXIST and reporting outcome on asp page

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :ASP.Net


I have a page that inserts a record to an sql database and I would like to do the following:

(i) Check if a record already exist before trying do an insert

(ii) If a record exist, the page should be able to inform/display a message in a textbox informing the user that the record already exist.


I have seen a number of post on the internet that suggest that one possible solution is to write a sproc and use the T-sql IF EXIST function. However, I have NOT seen a complete code showing (a) how this can be done (b) how to call the sproc from an asp page (c) and MORE IMPORTANTLY how to display a message informing a user that a record already exist i.e. when the record already exist in the database.


Please have anyone got a complete working code that can achieve this preferably in c#?




View Complete Post

More Related Resource Links

How can i check if record already exist in sql-server database ...

How can i check if record already exist in sql-server database ...

Does this look correct for saving a file/ new record to a database


So thank you for all your help so far, So I think i got this right,
but would like for you all to look it over to see if there is any
areas I might run into trouble with:

//using asp.net mvc 2
the table (sql server 2005, using entities framework)
table fields
"Pattern_Media_GUID  uniqueid 
"Pattern_GUID  uniqueid
"Media varbinary(max)  
"height int
"Width int
"Media_Type String (50)

the form:
<h2> Add Media to this pattern</h2>
<% Html.EnableClientValidation(); %>
<% Html.BeginForm("AddMedia", "Pattern", new { id= Model.Pattern_Guid} , FormMethod.Post, new {enctype = "multipart/form-data"}); %>
    <%: Html.Label("height") %>
    <%: Html.TextBox("height") %>

    <%: Html.Label("width") %>
    <%: Html.TextBox("width") %>

    <%: Html.Label("Media") %>
    <input type="file" id="Media" name="Media" />
    <input type="submit" name=

Can this code be setup to run against the whole database instead of just 1 record at a time?


We have made some changes to this code to start capturing 1 new field of data and updating it as new records are added. But there is currently about 120,000 records more or less.. those records of course dont have the new field populated with anything..

We would like to run this logic that already in place and run it against the tables to update the fields 1 time. I think to make it easier, if it can be setup to expect the "valueTwo" variable, so that we can run it againt the individual codes instead of doing all the records at one time.. there are codes that only have a few records, so it would be best to test initially against the small code group.


            strSqual = "insert into trans (trans_type_name, trans_date,sys_id,mod_user_id,show_ind, remoteCode, techName) values('" & valueTwo & "','" & TransDate & "',"&strSystemID&", 1,'T', '" & dbQuote(strUser) & "', '" & strTechName & "')"        
            'get the new transaction_id out for just inserted alarm   
            strSqual = "select max(transaction_id) as transaction_id from trans"  
            set rst = getStaticRecordSet(strSqual)

Querying a db for existence of a record.


Can someone suggest, what is the best approach using linq to sql to do the following

1. Check if a row exists in a table for a given criteria and...

2. If it exists return a particular field value else return '0'.

Reporting services in 2008 r2 how to get a report in a print button click event in my c#.net page


how to  get a report in my c#.net page button lick event also steps to call a report from asp.net to reporting services


Thanks in advance

Crystal Report Asking for Database Authentication each time when I view Page.


Whenever I open my Crystal Report page, I am taken to the Database Authentication page where I am asked for

User name
Data Name

each time.

Is there a way to avoid this and I save these authentication in my page once.

I am using VS2005, C#.

Any Help will be appriciated.


How to reflecting database changes immediately on asp.net page


Hi Everyone.

I have a web site that is highly dependant on a SQL Server 2008 database.  I am using linq to sql to connect to the database and require the website to reflect database changes immediately.  Currently the changes are only reflected once a postback occurs and the database is requeried.

Is there a way to get the asp.net page(s) to be alerted of an database change and then to reflect it immediately, or within seconds, on the display?  I am aware that one can use the SQLDependency class and ADO.NET to do this, but am not aware of any linq to sql possibilities.

Any help will be greatly appreciated.


How to check if record is added in access database



I'm trying to put a registration page together in Visual Web Designer.

I would like to send a confirmation Email after someone is leaving his registration data and pressing the INSERT button.

The key fields in my database are: Email, Name, Surname, Address

Before I send the confirmation Email I would like to check if the email value entered in the form is realy added to the database.

Please for help in this matter. I was copy past already some C code in my page, therefore it will be fine if the code can be in C.

Again, I need help to:

- checking if record is realy added to database after pressing INSERT button

- setup the confirmation Email

Thank you in advance.


dynamically add record in page


I am creating page dynamically using this. I want to read the file, which is dynamically created and show content on page from database like 40 record in each page.

String root = Server.MapPath("~");
        String pgTemplate = root + "\\myPageTemplate.tmp";
        StringBuilder line = new StringBuilder();        
        using (StreamReader rwOpenTemplate = new StreamReader(pgTemplate))
            while (!rwOpenTemplate.EndOfStream)

        int ID = 0;
        string SaveFilePath = "";
        string SaveFileName = "";
        Random ran = new Ran

Get last record in a SQL database

Don't know if this is the right SQL section, but... using VBE, how do you SQL for the last record in the database?Thanks.

Single-page restore/recover in an online database

I am working with SQL Server 2008 64-bit (10.0.2531) on Windows Server Datacenter 2008 SP2 (64-bit). The problems I am having almost certainly stem from my lack of understanding of how SQL Server's transaction log is handled during recoveries. I am using this document as a rough guide. Here' what I am doing: 1. I intentionally corrupt a single data page in a normal table, so that I can practice single-page recovery. 2. I attempt to read the corrupt block in SQL. As expected I receive an error. 1> select top 10 firstname from ds2.dbo.customers 2> go Msg 824, Level 24, State 2, Server IP-0AF647E0, Line 1 SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 4:896; actual 3:0). It occurred during a read of page (4:896) in database ID 5 at offset 0x00000000700000 in file 'C:\sql\dbfiles\cust1.ndf'. Additional messages in the SQL Server error log or system event log may provide more detail. 3. I take a log tail backup before I do anything to try to fix the corruption: 1> backup log ds2 to disk = 'c:\sqlbackup\ds2.bak' with norecovery 2> go Processed 5 pages for database 'ds2', file 'ds_log' on file 1. BACKUP LOG successfully processed 5 pages in 0.041 seconds (0.857 MB/sec). 4. I  restore the corrupt page from backup: 1> restore database ds2 page='4:896' 2> from disk='c:\sqlbackup\ds2.bak' 3> with norecovery 4&

Reporting Services Add-In for MOSS2007 : Unable to connect to the database Error at "Set Server Defa

Dear Expert, I've succesfully install the Add-In + configure the reporting services (integrated mode) + activate the features on my MOSS2007. As we know by activating this at my Central Admin, i'm able to see "Reporting Services" under my Application Management as below:   1) Manage Integration Setting   ---> My report url : http://servername:808/ReportServer (Trusted Account) 2) Grand Database Access --->  My setting : <servername> with default instance  3) Set Server Defaults ---> Area that i receive an error "Unable to connect to database" Anybody here have a same experience? please assist me, Thanks in Advanced My Note: OS : Windows Server 2008 Enterprise x64bit (SP2) SQL : SQL 2005 with latest Service Pack (SP3)  My Error Log: <Header>   <Product>Microsoft SQL Server Reporting Services Version 9.00.4035.00</Product>   <Locale>en-US</Locale>   <TimeZone>Malay Peninsula Standard Time</TimeZone>   <Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__08_04_2010_10_51_59.log</Path>   <SystemName>SEINE</SystemName>   <OSName>Microsoft Windows NT 6.0.6002 Service Pack 2</OSName>   <OSVersion>6.0.6002.131072</OS

SQLServerAgent could not be started (reason: Startup error: The 'msdb' database does not exist)

After installing Service pack 3 for Microsoft SQL Server 2005 the SQLServerAgent wont start: From SQLAGENT.OUT: 2010-08-30 17:10:08 - ! [298] SQLServer Error: 208, Invalid object name 'sys.configurations'. [SQLSTATE 42S02] (DisableAgentXPs) 2010-08-30 17:10:08 - ! [298] SQLServer Error: 208, Invalid object name 'master.dbo.sysdatabases'. [SQLSTATE 42S02] 2010-08-30 17:10:08 - ! [000] Startup error: The 'msdb' database does not exist 2010-08-30 17:10:08 - ! [298] SQLServer Error: 208, Invalid object name 'sys.configurations'. [SQLSTATE 42S02] (DisableAgentXPs) 2010-08-30 17:10:08 - ? [098] SQLServerAgent terminated (normally)

I need help with the syntax for passing a record field value from SSRS to an asp page

I have tried several variations without success.  Here is where I am now.  The goal is from inside Report Manager report, link to an asp page with a filed value. This is from the expression line of the Jump to URL entry. Also I am trying to open a new page http://www.whereever.com/CSSurvey01.asp?RecordID=" & Fields!respid.Value            

SQL Reporting Services - Page X of XX counts in header

I have searched high and low for how to calculate page numbering in the header where the global values do not apply.   I have a report that generates 300+ invoices and I need the page numbers to reflect page x of xx for that invoice only.  My report page breaks for each customer invoice.  I have found code to get the page number in the header and I have found code to get the total pages in the body.  These two solutions cannot be combined.    Has anyone found a workaround in code behind or some other method?I would appreciate any guidance.   Side note: thank you all for all your postings and solutions.  They have been highly valuable as I am new to SSRS.

List does not exist The page you selected contains a list that does not exist. It may have been de

Hello All,   We are facing an error in our MOSS 2007 internet site.   We are unable to access the root site ,however all other site collections created using manged path under the root site are accessible.   The home page of the root site i.e http://servername/pages/default.aspx  navigates to custom error page , where as application pages like settings.aspx ,viewlsts.aspx throw below mentioned error   "List does not exist  The page you selected contains a list that does not exist.  It may have been deleted by another user" As a workaround , we tried restoring the rootsite from back up file (.dat) ,but we get the same error (mentioned above).   Content database is very much present and database server has good enough memory.   Any suggestions for this would be of great help.  
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend