Database

Delete a User from adatabase in Sql Server 2000

Delete a User from adatabase in Sql Server 2000 procedure TForm1.Button1Click(Sender: TObject); begin ADOCommand1.CommandText := ‘Use DataBaseName’; ADOCommand1.Execute; ADOCommand1.CommandText := ‘Exec SP_DropUser ‘ + QuotedStr(‘Username’); ADOCommand1.Execute; end;

Database

Add a user into a database in Sql Server 2000

Add a user into a database in Sql Server 2000 procedure TForm1.Button1Click(Sender: TObject); begin ADOCommand1.CommandText := ‘Use DataBaseName’; ADOCommand1.Execute; ADOCommand1.CommandText := ‘Exec SP_AddUser ‘ + QuotedStr(‘Username’); ADOCommand1.Execute; end;

Database

Connect To Sql Server 2000

Connect To Sql Server 2000 procedure TForm1.Button1Click(Sender: TObject); begin ADOConnection1.ConnectionString := ‘Server=Hostname;DataBase=DatabaseName’; ADOConnection1.Open(‘UserName’, ‘Password’); ADOConnection1.Connected := True; end; {* For Any Information Mail Me * Mail : Mostafa@Touska.Co.ir0

Database

Add a User’s Login in Sql Server 2000

Add a User’s Login in Sql Server 2000 procedure TForm1.Button1Click(Sender: TObject); begin ADOConnection1.Connected := True; ADOCommand1.CommandText := ‘Exec SP_AddLogin ‘ + QuotedStr(‘UserName’) + ‘,’ + QuotedStr(‘Password’) + ‘,’ + QuotedStr(‘Database Name’) + ‘,’ + QuotedStr(‘English’) […]

Database

Adapt DateTime values for SQL-Server or Access formats

{——————————————————————— Dieser Tip ist als Verbesserung zum ursprünglichen Artikel http://www.swissdelphicenter.ch/de/showcode.php?id=1423 gedacht. Die folgende Funktionen wandeln einen DateTime Wert (unabhنngig vom eingestelltem Datumsformat) in einen für den SQL-Server verstنndlichen String um. ———————————————————————- Please also take a […]

File Recovery

UndeleteMyFiles Pro

UndeleteMyFiles Pro It may sound like a pay-for edition, but it is absolutely free and comes with a collection of tools for data recovery, including File Rescue, Media Recover, Deleted File Search, Emergency Disk Image, […]

File Recovery

CD Recovery Toolbox

Designed to recover data from damaged CDs and DVDs. If they are scratched or smudged or faded, but there is still some readable data on the disk, this is a tool that can bring back […]

File Recovery

Puran File Recovery

Puran File Recovery Another tool that goes after deleted files and brings them back from the dead. There is a portable version that can be put on a flashdrive or bootable disk like BartPE, and […]

File Recovery

Puran Data Recovery

This tool can read files from damaged physical media, like corrupted flash or scratched optical drives. If your operating system can show the files, then this tool will read them off, ignoring any bad sectors […]

File Recovery

SoftPerfect File Recovery

Also from EaseUS, this tool can restore deleted files from FAT and NTFS partitions on fixed and removable media. It is a self-contained executable and runs on everything from XP through Windows 8. Features Restores […]

File Recovery

EaseUS MobiSaver Free

This tool offers hope for mobile devices too, with a free data recovery tool for both iOS and Android platforms. This app can recover specific data types from iOS devices and most files from Android […]

File Recovery

Data Recovery Wizard

This tool can recover data that has been deleted, formatted, or from drives that have been corrupted. The free version has a 2GB cap, but often the data you are trying to save is much […]

File Recovery

Wise Data Recovery

A freeware application to recover data from hard drives and removable media. It is simple to use and fast to find data, making it an excellent choice when you need your files back quickly. Features […]

File Recovery

TestDisk file recovery software

  Software designed to recover lost partitions or repair drives that are no longer bootable. It can repair most file systems (NTFS, FAT, EXT) and also recover data from deleted partitions. OpenSource, it can run […]

File Recovery

WinHex file recovery software

A multitasker that includes a disk editor, imaging software, encryption and checksumming, format converter, and more. It is more targeted towards investigation and forensics than simple data recover, and has several different levels of licensing, […]

File Recovery

Active UNERASER file recovery software

This tool can be used to recover data lost due to damaged, formatted, or deleted partitions and includes several other tools including a partition manager, a disk monitor, and more. Features Recovers both 32-bit and […]

File Recovery

Unformat file recovery software

  For all your external drive needs, Unformat can recover entire disks including external USB, thumb drives, and SD cards that you’ve accidentally deleted. Features Restores formatted HDD, SSD, memory cards, and USB flash drives. […]

File Recovery

NTFS Data Recovery Toolkit

Built specifically for NTFS volumes, this toolkit includes a disk editor, partition manager, and recovery tools. It also has great instructions on how to use each tool. Features Comes in manual and automatic modes for […]

File Recovery

Active UNDELETE file recovery software

This tool can run on Windows and recover data from non-Windows file systems including Linux Ext#, UFS, EFS, and HFS+. Features Supports all types of storage media. Recovers many file formats such as docs, videos, […]

File Recovery

Active Partition Recovery

  This tool can help you to recover a formatted or repartitioned drive in its entirety. It can also fix lost MBR and GPTs and can read from VMware virtual disk images. Features Restores lost […]

File Recovery

Active File Recovery

This is probably the first tool to try, as it can handle undeletes, deletes that bypass the Recycle Bin, formatted or corrupted files, lost partitions, and more. Features Efficient and easy-to-use, even if your PC […]

File Recovery

ADRC Data Recovery Software Tools

This suite of tools includes undelete, copy, raw copy, imaging, and boot sector repair. Features Supports many drives and file formats. Uses a simple GUI, thereby making it ideal for novices as well. Gives you […]

Uncategorized

PC INSPECTOR Smart Recovery

Also free, Smart Recovery is a tool focused on recovery files from external media, like flash drives and SD cards. It’s a bit older than File Recovery, but still works great and can handle proprietary […]

File Recovery

PC INSPECTOR File Recovery

Completely free, PC INSPECTOR File Recovery is a great recovery tool for Windows systems. It can recognize data types even when the header is missing, so you can recover from deletions, formatting, or even total […]

File Recovery

Recuva file recovery software

With both free and pay editions, Recuva is an incredibly powerful tool for recovering data from Linux and Window partitions. With support for all Windows versions from XP through Windows 8.1, this is a great […]

Database

Scroll within a DBGrid

Here is tip how to scroll DBGrid private OldGridProc: TWndMethod; procedure GridWindowProc(var Message: TMessage); //… procedure TForm1.FormCreate(Sender: TObject); begin OldGridProc := DBGrid1.WindowProc; DBGrid1.WindowProc := GridWindowProc; end; procedure TForm1.GridWindowProc(var Message: TMessage); var Pos: SmallInt; begin OldGridProc(Message); […]

Database

Make a HTML and TXT report component

Make a HTML and TXT report component unit LittleReport; interface uses Windows, Messages, SysUtils, Classes, DB, Graphics; const FAuthor = ‘Simone Di Cicco’; FVersion = ‘1.0’; type TLittleReport = class(TComponent) protected FDataSet: TDataSet; FWidth: Integer; […]

Database

Create a Dataset lookup field at runtime

example: create lookup field (string, size: 50) at runtime with TStringField.Create(YourDataSet) do begin FieldName := ‘FieldName’; FieldKind := fkLookup; DataSet := YourDataSet; Name := DataSet.Name + FieldName; KeyFields := ‘YourKeyFields’; LookupDataSet := YourLookupDataSet; LookupKeyFields := […]