Jun 28, 2008

SQL-SCRIPT eSnips Folder

www.esnips.com: They are providing 5GB free storage facility. This is my web storage also, you can download Self Hypnosis and Relaxation Machine, SQLToolbelt, Sinhala Fonts, rapidshare.de downloader, power iso 3.2+crack, Lyrics for english songs, HiddenDesktopInclKeyMaker, Foot Reflexology, font tamil, deskman-powertoysetup, AtomicAlarmClockCracked, uif2iso, RSDirect_Download_v1.14, Password_hacker_BBs, npp.4.8.2.Installer, FancyLogonDesktop-1.0.2, Best_Hacking_Tools_-85in1- and you can run SQl SCRIPTS IN VB/vb.net

Jun 23, 2008

Calling Win32 Api from C# - csharp

Though .Net classes are vast and versatile at time you will have to resort to Win32 API calls for accomplishing certain tasks.

The following code shows a simple example of invoking a Win32 api.

The best way to use Win32 apis is to encapsulate it in a class module.
The namespace for COM interop is System.Runtime.InteropServices.
The method name should have DllImport attribute specifying the name of the dll. Here the dll is user32. Other dlls are Gdi and Kernel.

using System;
using System.Collection.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace WindowsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void cmdtam_Klik(object sender, EventArgs e)
{
string cstr;
cstr = "data source=jery;initial catalog=latihan;uid=sa;pwd=sri";
SqlConnection con1 = new SqlConnection(cstr);
con1.Open();
SqlCommand com1 = new SqlCommand();
com1.Connection = con1;
com1.CommandType = CommandType.Text;
com1.CommandText = "select * from customer"
DataSet ds1 = new DataSet();
SqlDataAdapter adp1 = new SqlDataAdapter(com1);
adp1.Fill(ds1,"customer");
grd1.DataMember = "customer";
con1.Close();
}
}
}

Dislay Data on datagrid - csharp

using System;
using System.Collection.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace WindowsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void cmdtam_Klik(object sender, EventArgs e)
{
string cstr;
cstr = "data source=jery;initial catalog=latihan;uid=sa;pwd=sri";
SqlConnection con1 = new SqlConnection(cstr);
con1.Open();
SqlCommand com1 = new SqlCommand();
com1.Connection = con1;
com1.CommandType = CommandType.Text;
com1.CommandText = "select * from customer"
DataSet ds1 = new DataSet();
SqlDataAdapter adp1 = new SqlDataAdapter(com1);
adp1.Fill(ds1,"customer");
grd1.DataMember = "customer";
con1.Close();
}
}
}

Writing to EventLog - csharp

//Add to the textbox's KeyPress event
private void txtBox_KeyPress(object sender, KeyPressEventArgs e)
{
if (!System.Text.RegularExpressions.Regex.IsMatch(e.KeyChar.ToString(), "\\d+"))
e.Handled = true;
}

Numbers-Only Textbox - csharp

//Add to the textbox's KeyPress event
private void txtBox_KeyPress(object sender, KeyPressEventArgs e)
{
if (!System.Text.RegularExpressions.Regex.IsMatch(e.KeyChar.ToString(), "\\d+"))
e.Handled = true;
}

SQL Server 2005 Express Edition Feature Tour

SQL Server 2005 Express Edition Feature Tour

Microsoft SQL Server: What's New in SQL Server 2005

Microsoft SQL Server: What's New in SQL Server 2005

Microsoft SQL Server: Top 30 Features of SQL Server 2005

Microsoft SQL Server: Top 30 Features of SQL Server 2005: "Discover how SQL Server 2005 will benefit you with the new and enhanced abilities and features described on this page."

Introduction to Service Broker

Introduction to Service Broker:Sql server2005

WebGyver - Tools and Resources for Successful Web Design, Web Development, Web Applications and Web Business Marketing

WebGyver - Tools and Resources for Successful Web Design, Web Development, Web Applications and Web Business Marketing

Ajaxload - Ajax loading gif generator

Ajaxload - Ajax loading gif generator: Animation Generator

After needed an animated loading .gif image for a recent Ajax application I did some quick Google searching and came across a fantastic site: http://www.ajaxload.info/

Ajaxload allows you to generate your own animated Ajax loading images with a few simple click. Starting from a number of animation templates you can then choose a background and foreground colour for your new loading .gif. After 30 seconds of playing around, see some of my examples below:

Ajax loader

Ajax loader

Ajax loader

Fantastic, yet simple. This is the way all websites you should be, well done Ajaxload.

Jun 17, 2008

SQL, database, informix, oracle, SQL Server,Free source code for the taking. Over five million lines of programs.

SQL, database, informix, oracle, SQL Server,Free source code for the taking. Over five million lines of programs.

.Net Programming and Tutorials - CoderSource.net

.Net Programming and Tutorials - CoderSource.net : C#

Scrolling Text on a Form using label control

Scrolling Text on a Form using label control:C#

C# .Net Delegates and events

C# .Net Delegates and events

Using Error Provider Control in Windows Forms and C#

Using Error Provider Control in Windows Forms and C#

Executing external applications using Process class

Executing external applications using Process class: C#

Sending emails in C#

Sending emails in C#

Creating custom windows forms in C# with images

Creating custom windows forms in C# with images

Creating a Splash Screen in C#

Creating a Splash Screen in C#

Google Answers: Microsoft Visual C# Method: External

Google Answers: Microsoft Visual C# Method: External: grab text from outside exe

Win32 Window Handler in C#

Win32 Window Handler in C#: This is an extension of the WindowHandler-class I posted 2 weeks ago. This one is able to close, minimize, maximize and "normalize" windows of external applications.

Finding and Listing Processes in C#

Finding and Listing Processes in C#

ASP 101 - Samples

ASP 101 - Samples

Freelance Programming

Freelance Programming

How to AutoSize the DropDown portion of a ComboBox

How to AutoSize the DropDown portion of a ComboBox

Reading and Writing XML Documents

Reading and Writing XML Documents

Auto create database connection string using INI by c#

Auto create database connection string using INI by c#