HOME Delphi C# Cookie Print ShellExecute SMTP SQL metaWeblog API file attachment SendMail SW_SHOW SW_HIDE GetVolumeInformation HttpCookie Java Print Dialog MailMessage TOSVERSIONINFO TidURI ShowWindow TPrintDialog SmtpMail Hard Disk Volume Name HDD Volume Lable Hard Disk Volume Lable HDD Volume Name Gradient Filled Form Hide Taskbar LIFO image upload by metaweblog API available memory size available memory Open URL OS Version Information Paint Form PC 켜져 있는 시간 알아내는 방법 PDF PDF Creation PDF Generation Animated Icon DLLImport Comma Separator Create PDF Decimal Separator Caption Bar Dequeue Desktop Wallpaper DISP_CHANGE_FAILED C# DLL Call DISP_CHANGE_SUCCESSFUL DLL Import GetWindowsVersion Enqueue EnumDisplaySettings FIFO File Association File Type available memory space 켜져있는시간 Comma GetSystemDefaultLangID

SQL.ZIP

How to download/grap web pages or XML document at internet website in Delphi XE?   (created at Jul 20, 2015)   145  

If you are considering Delphi XE as cross compiler for the multiple platforms such as Android, iOS, and Windows, you need to have the standard method to get web content such as the normal text, or XML document as a result of RESTful API.Delphi provides the...

SQL to Select a random row from a database table   (created at Jan 07, 2008)   74  

There are lots of ways to select a random record or row from a database table. Here are some example SQL statements that don't require additional application logic, but each database server requires different SQL syntax.Select a random row with MySQL: SELE...

Setting TQuery SQL Statement   (created at Aug 25, 2007)   6,404  

This source code sets the SQL String in Query1. As it fits on one line we just use SQL[0].The SQL statement finds all the fields from the Article table where the user_id field is equal to a varaible Text value dbtUser.Text.A better way would be to use Para...

Stack Tutorial In C#   (created at Aug 26, 2007)   63  

stack is a LIFO (Last In First Out) queue, so if you add two items and then ask for an item you would get the second item then the first item. To add items to the Stack you use Push method. This method takes an object of any type but to keep things simple ...

Queue Tutorial In C#   (created at Aug 26, 2007)   37  

Adding Items to the QueueTo add items to the Queue you use Enqueue method. This method takes an object of any type but to keep things simple lets just give it a string object: Queue q = new Queue();q.Enqueue("So");q.Enqueue("This");q.Enqueue("Is");q.Enqueu...

Create PDF Files On the Fly In C Sharp   (created at Aug 26, 2007)   56  

Creation of PDF Document in 5 easy stepsStep 1: First create an instance of document objectDocument myDocument= new Document(PageSize.A4.Rotate());Step 2: Now create a writer that listens to this doucment and writes the document to desired Stream.PdfWriter...

How to call Visual C/C++ implemented DLL functions in C# - Simple DLLImport   (created at Aug 26, 2007)   75  

Managed world is beautiful, I have all classes I want in FrameWork.. But what if I want call some unmanaged code? For instance, I have DLL written in C++, and want use it from C#. Let's look some code. Our DLL exports some function, in CDecl convention, th...

Send Email Using C#   (created at Aug 26, 2007)   118  

A code snippet,posted on the dotnet newsgroup,about how to send email using C#.<%@Import namespace="System.Web.Util"%>try{MailMessage MyMail = new MailMessage();MyMail.To = "who";MyMail.From = "you";MyMail.BodyFormat = MailFormat.Html;MyM...

How To Read And Write A Cookie   (created at Aug 26, 2007)   41  

A post on aspngbeta about readingwriting a cookie in C#//To setHttpCookie cookie;String UserID = "foo";cookie = new HttpCookie("UserID");cookie.Values.Add("UserID",UserID);Response.Cookies.Add(cookie);//To readHttpCookie cookie;cookie = Request.Cookies["Us...

Using C# With Cookies   (created at Aug 26, 2007)   79  

A code snippet posted on aspcs about accessing and writing cookies using C#./* Read shopper id from client cookie */public static bool GetCurrentShopperId(ref string id,System.Web.HttpRequest request){try{HttpCookie cookie = request.Cookies["iparts_pa"];if...

How Do I Remove The Application Icon From The Taskbar?   (created at Aug 25, 2007)   47  

To remove the icon from the taskbar, you need to call a Windows API call:BOOL ShowWindow(HWND hwnd,int nCmdShow);Delphi makes it very easy to use this command. All you need to do is supply the Application.handle and SW_HIDE to remove the icon from the task...

How To Show The Print Dialog And Print Text Files   (created at Aug 25, 2007)   71  

This code show an example of how to print a text of a RichEdit component.unit Unit1; interface uses   Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,   StdCtrls, ComCtrls; type   TForm1 = class(TForm)     ...

How To Make An Animated Application Icon   (created at Aug 25, 2007)   81  

Show how to create an animated icon in your programvar  icon1:Boolean; ... procedure TForm1.Timer1Timer(Sender: TObject); begin   if icon1=false then   begin     Application.icon:=Image1.Picture.Icon;      icon1:=tru...

How To Pass The Focus To The Next/prior Control   (created at Aug 25, 2007)   71  

Shows how to activate the next or prior control in a formnext control: SendMessage(Form1.Handle, WM_NEXTDLGCTL, 0, 0); prior control: SendMessage(Handle, WM_NEXTDLGCTL, 1, 0);

How To Make Rounded Windows   (created at Aug 25, 2007)   52  

Create a different form in your application...procedure TForm1.FormCreate(Sender:TObject);  var    region: HRgn;  begin    region:=CreateEllipticRgn(1,1,200,200);    SetWindowRgn(handle, region, true);  end;

How To Get Windows Uptime   (created at Aug 25, 2007)   66  

Find how long Windows has been working...function UpTime: string; const ticksperday : integer = 1000 * 60 * 60 * 24; ticksperhour : integer = 1000 * 60 * 60; ticksperminute : integer = 1000 * 60; tickspersecond : integer = 1000; var  t : longword; &nb...

How To Find Out Total And Available Memory   (created at Aug 25, 2007)   45  

Get the total and available memory in your system. (Total free memory space in your system)procedure TForm1.Button1Click(Sender: TObject); var   memory:TMemoryStatus; begin   memory.dwLength:=sizeof(memory);   GlobalMemoryStatus(memory); &nb...

How To Change The System Time   (created at Aug 25, 2007)   57  

This code shows how to set the system time to another value.procedure TForm1.Button1Click(Sender: TObject); var    systemtime : TSystemTime;    NewTime:string; begin    NewTime:='13:58:00';    DateTimeToSystemTime( D...

How To Get The Windows OS Version   (created at Aug 25, 2007)   61  

 Identify the Windows version of your systemfunction GetWindowsVersion : string;  var    OsVinfo   : TOSVERSIONINFO;    HelpStr   : array[0..50] of char;  begin    ZeroMemory(@OsVinfo,sizeOf(OsVinfo));...

How To Change The Desktop Wallpaper   (created at Aug 25, 2007)   50  

Change the wallpaper of your system by codeuses    Registry, WinProcs;  procedure SetWallpaper(               sWallpaperBMPPath : String;               bTile : boolean );&...

How To Get The Windows Language   (created at Aug 25, 2007)   58  

Obtains the language that Windows is using.function Language:string;  var    sLangID:LangID;    sLanguage: array [0..100] of char;  begin    sLangID:=GetSystemDefaultLangID;    VerLanguageName(sLangID,sLang...

How To Make A Gradient Filled Form   (created at Aug 25, 2007)   50  

Show how to paint a form in a different way...procedure TForm1.FormPaint(Sender: TObject); var   Row, Ht: Word;   IX: Integer; begin   iX :=200 ;   Ht:=(ClientHeight + 512) div 256;   for Row := 0 to 512 do   begin   &nbs...

How can I hide the caption bar on a form?   (created at Aug 25, 2007)   42  

To hide the caption bar you need to override on of the default form methods CreateParams (this also exists for other objects).The CreateParams method initializes a window-creation parameter record passed in the Params parameter (ref:Delphi Help).Go to the ...

How To Send An E-mail By Code   (created at Aug 25, 2007)   41  

Use this function to send an e-mail through your program. You must have the component TNMSMTP from FastNet tools. This component is included in Delphi 4-5 Professional and Enterpriseprocedure TForm1.Button1Click(Sender: TObject); begin   NMSMTP1.Host ...

How To Open Url In Default Webbrowser   (created at Aug 25, 2007)   52  

Use this function to open your browser with a given URL.uses    shellapi;  ....  procedure TForm1.Label1Click(Sender:TObject);  begin    shellexecute(handle,'open','http://www.swissdelphicenter.ch', nil,nil,sw_show); ...

How To Check If A Soundcard Is Installed   (created at Aug 25, 2007)   57  

Use this code to verify if a soundcard is installed in your systemuses mmsystem;  ...  function Soundkarte:Boolean;  begin    Result := WaveOutGetNumDevs >0;  end;

How To Change Screen Resolution   (created at Aug 25, 2007)   96  

Change the resolution of your screen.Actually I've ever used this function for TV-based software development, because of TV-resolution.{ The function NewRes can have the following result: DISP_CHANGE_SUCCESSFUL The settings change was successful. DISP_CHAN...

How To Force The Correct Decimal Separator   (created at Aug 25, 2007)   41  

Some English speaking countries use the "point" as decimal separator, while the rest of the world is using the "comma". How can you make sure that the user will press the correct key when entering a number with a decimal fraction? With the code in this exa...

How To Register Own File Types   (created at Aug 25, 2007)   70  

Use the registry to register your own filetypeuses registry; procedure TForm1.RegisterFileType(prefix:String; exepfad:String); var   reg:TRegistry; begin   reg:=TRegistry.Create;   reg.RootKey:=HKEY_CLASSES_ROOT;  

How To Get Volume Name   (created at Aug 25, 2007)   44  

Obtains the volume name of a indicated drivefunction VolumeName(Laufwerk: Char): string; var max, Flags: DWORD;     Buf: array [0..MAX_PATH] of Char; begin  try   GetVolumeInformation(PChar(Laufwerk + ':'), Buf, sizeof(Buf), nil, max, F...