jomgrg

Make your connection string, the following code will shows a standard MySQL connection string. using MySql.Data.MySqlClient; public static string GetConnectionString() { string connStr = String.Format("server={0};user id={1}; password={2}; database=yourdb; pooling=false", "yourserver", "youruser", "yourpass"); return connStr; } Then create an instance from MySql.Data.MySqlClient.MySqlConnection as shown below. MySql.Data.MySqlClient.MySqlConnection mycon = new MySqlConnection( GetConnectionString());Then …

Use Java script like Mouse Click, on mouse etc

Method also u pass that much parameters... then u wont get error..

You can use Pagesize property and set that.

how to insert data into 2 tables by using one sql query? 1.if there is no relation between two table. 2.if relation exist. One option : using stored procedure u can insert. BEGIN TRANSACTION DECLARE @DataID int INSERT INTO DataTable (Column1 ...) VALUES (....) SELECT @DataID = scope_identity() INSERT INTO …