database
database
database
database
database
database database database database database database database database
database database
database
Go Back  Xtreme Visual Basic Talk > > > database


Reply
 
Thread Tools Display Modes
  #1  
Old 12-16-2003, 01:26 PM
shlx shlx is offline
Newcomer
 
Join Date: Dec 2003
Location: Sarajveo
Posts: 3
Default database


hi, i made a progy where i store some data.. the thing i need is this:
to make a file to store data in it ao whenever i type the same data i get a msg that the data is already satored...tnx
Reply With Quote
  #2  
Old 12-16-2003, 02:43 PM
gellerche gellerche is offline
Centurion
 
Join Date: Sep 2003
Location: Bloomington, IL
Posts: 168
Default

Quote:
Originally Posted by shlx
hi, i made a progy where i store some data.. the thing i need is this:
to make a file to store data in it ao whenever i type the same data i get a msg that the data is already satored...tnx



This is a general answer. I would suggest searching this forum on databases for more specific information.

1. Create a database
2. Create and open a connection in your application
3. Create a recordset
4. Check your database for duplicate data using code similar to this:

Code:
SQL = "Some SELECT clause to get the data you want" rs.Open SQL, cnn ' Where cnn is the connection you opened With rs If .EOF And .BOF Then ' Do nothing, the data doesn't exist Else MsgBox "This data already exists." End If .Close End With

Hope this helps,

Steve Geller
Reply With Quote
  #3  
Old 10-09-2017, 12:10 PM
shlx shlx is offline
Newcomer
 
Join Date: Dec 2003
Location: Sarajveo
Posts: 3
Default

hey, sorry for the "late" reply but thanks!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Backup database destress Database and Reporting 3 07-14-2003 01:04 AM
use Access to close another Access app strBean Word, PowerPoint, Outlook, and Other Office Products 20 12-20-2002 02:47 PM
Multi-user database problem TiKiMoN Database and Reporting 11 11-18-2002 11:28 AM
Database problem for database Guru`s cballe Database and Reporting 5 08-08-2002 02:24 AM
User-defined type not defined (im new) skript_kiddie General 8 06-16-2002 02:06 PM

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
database
database
database database
database
database
database database database database database database database
database
database
 
database
database
 
-->