Purpose

Usage

Generating Data table

DataTabletable=newDataTable();table.Columns.Add("ID");table.Columns.Add("Name");for(inti=0;i<100;i++){table.Rows.Add((i+1).ToString(),RandomString(10));}

Import lib

usingMySQLBulkIU;

Create connection string

stringconnectionString="Server=localhost;Database=test;Uid=root;Pwd=1234;";

Bulk Insert

//BulkToMySQL(DataTable dt, string tableName, string ConnectionString)/* -------------------------key note----------------------------             *             * dt               = datatable with values to be updated.             * tableName        = Table name to be updated in Database.             * ConnectionString = MySql Connection String             *             * */boolresult=BulkInsert.BulkToMySQL(table,"test_bulk",connectionString);if(result)MessageBox.Show("Data Insert Successfully");

Bulk Update

//UpdateBulkToMySQL(DataTable dt, string tableName, string valueColumn, string conditionColumn, string ConnectionString)/* -------------------------key note----------------------------             *             * dt              = datatable with values to be updated.             * tableName       = Table name to be updated in Database.             * Value_Column    = column name to be updated.             * conditionColumn = column name used to write 'WHERE' condition             * ConnectionString= MySQL connection string             * */boolresult=BulkUpdate.UpdateBulkToMySQL(table,"test_bulk","Name","ID",connectionString);

Dependencies

Contribute