Introducing MathCap for Asp.Net [ Math Captcha Plugin ]

MathCap is a plugin for .net application and its a 100% effective and easy to use.the more you understand on a deep look.

Here i shared is the base version of Mathcap 1.0.0. More feature are coming on a newer versions.

How it use?

add mathcapp dll reference

invoke the namespace on the webpage using MathCapcha;

Add the below code
                var bitmapImage = new Capcha();
                var properties = new MathCapchaProperties();
now customise the properties

now get the response and point to image control, using below code.

               var imgur = bitmapImage.CreateThumbnail(properties);
 
               img.Src = imgur.bmpImageSource; 

               Response.Write(imgur.answer);

Output

NOTE: In near by future itself 'm planning to make it a control but before that i need to add some cool feature that by i made it like this :)

DOWNLOAD dll From here

If u had any trouble just ask, Happy to help u :)
Stay Tune...
Have a nice day... 'N happy Coding :)

Remove Duplicate Row from datatable in c#

As i was also unaware of this feature until i read as answer in fourms.asp.net (link). Previously i was achieved by using lambda expression.Now no need to those just one line code :)

DataTable dt = new DataTable

        {

            Columns ={

                {"Myid",typeof(int)},

                {"Name"},

                {"Address"}

                }

        };

        dt.Rows.Add(1, "Arun Aravind", "Kollam");

        dt.Rows.Add(1, "Arun Aravind", "Kollam");

        dt.Rows.Add(2, "Arun Aravind", "Kollam");

        dt.Rows.Add(2, "Arun Aravind", "Kollam");

        dt.Rows.Add(3, "Arun Aravind", "Kollam");

        dt = dt.DefaultView.ToTable(false, "Address", "Name", "Myid");

Output

If u had any trouble just ask, Happy to help u :)
Stay Tune... Have a nice day... 'N happy Coding :)

Convert a datatable to Json c#

Hi *.*,
I'm so happy today to introduce this.Last day by noon i got a crazy idea to create own json converter. i don't have a plan or an architecture how it goes, where to start. all what i had is a json string :). I finished that by 2 hr 50 min. :)

For the reusability of the code i created that by extension method. and i named the class JsonExtensionMethod class goes below.

public static class JsonExtensionMethod

{

Optional parameter and Named Argument in asp.net c#

Optional parameter and Named Argument in asp.net c#

I viewed in few blogs they are passing parameter to methods by comma separated null value and also in particular where parameter defined. By 3.5 or 4.0 (not clear) .net introduced Optional parameter and Named Argument.

Bulk Copy with Transaction Control in Asp.net c#

 Sample Code for Bulk Copy with Transaction Control in Asp.net c#

sqlConnection conn = db.CreateConnection();  // Create a new connection

// For Command cmd

db.AddInParameter(cmd, "@CFirstName", DbType.String, dt.Rows[i][j].ToString()); j++;

// adding new parameter Blah Blah Blah

db.AddInParameter(cmd, "@CLastName", DbType.String, dt.Rows[i][j].ToString()); j++;

// adding new parameter Blah Blah Blah

db.AddInParameter(cmd, "@CTitle", DbType.String, dt.Rows[i][j].ToString()); j++;

//adding new parameter Blah Blah Blah

SQLTransaction trx = conn.BeginTransaction(); // Begin Transcation

cmd.Transaction = trx; // Adding transcation to command

try

{

db.ExecuteNonQuery(cmd, trx); // passing transcation to sql

datatable dtdata = dataList();

System.Data.SqlClient.SqlBulkCopy oSqlBulkCopy = new System.Data.SqlClient.SqlBulkCopy((SqlConnection)trx.Connection, SqlBulkCopyOptions.TableLock, (SqlTransaction)trx);

oSqlBulkCopy.DestinationTableName = "EscalationIssues";

oSqlBulkCopy.WriteToServer(dtdata);

trx.Commit();// Commit transcation

conn.Close();

oSqlBulkCopy.Close();

}

Catch(sqlexception sqlex)

{

Trx.rollback(); // Roll back Transcation

}

Public datatable dataList()

{

DataTable dtdata = new DataTable();

dtdata.Columns.Add("EscalationIssueId", typeof(Guid));  //Primary key

dtdata.Columns.Add("EscalationId", typeof(Int32));

dtdata.Columns.Add("IssueId", typeof(Int32));

dtdata.Columns.Add("CreatedOn", typeof(DateTime));

dtdata.Columns.Add("CreatedBy", typeof(string));

for (int k = 0; k < 10; k++)

{

DataRow dr = dtdata.NewRow();

dr["EscalationIssueId"] = new Guid();

dr["EscalationId"] = Convert.ToInt32(escaltionID);

dr["IssueId"] = Convert.ToInt32(lsulist[k]);

dr["CreatedOn"] = DateTime.Now;

dr["CreatedBy"] = "Arun Aravind";

dtdata.Rows.Add(dr);

}

}

}

If u had any trouble just ask, Happy to help u :)
Stay Tune... Have a nice day... 'N happy Coding :)

sample :: Bulk Copy in C#

DataTable dtdata = new DataTable();

dtdata.Columns.Add("EscalationIssueId", typeof(Guid));  //Primary key

dtdata.Columns.Add("EscalationId", typeof(Int32));

dtdata.Columns.Add("IssueId", typeof(Int32));

dtdata.Columns.Add("CreatedOn", typeof(DateTime));

dtdata.Columns.Add("CreatedBy", typeof(string));

for (int k = 0; k < 10; k++)

{

DataRow dr = dtdata.NewRow();

dr["EscalationIssueId"] = new Guid();

dr["EscalationId"] = Convert.ToInt32(escaltionID);

dr["IssueId"] = Convert.ToInt32(lsulist[k]);

dr["CreatedOn"] = DateTime.Now;

dr["CreatedBy"] = "Arun Aravind";

dtdata.Rows.Add(dr);

}

}

System.Data.SqlClient.SqlBulkCopy oSqlBulkCopy = new System.Data.SqlClient.SqlBulkCopy((System.Data.SqlClient.SqlConnection)conn);

conn.Open();

oSqlBulkCopy.DestinationTableName = destinationTableName;

oSqlBulkCopy.WriteToServer(sourceDataTable);

conn.Close();

oSqlBulkCopy.Close();

 


If u had any trouble just ask, Happy to help u :)
Stay Tune...
 Have a nice day... 'N happy Coding :)

Sample (basic) Transaction handling from code side

Hi *,*,

Sample (basic) Transaction handling from code side

sqlConnection conn = db.CreateConnection();  // Create a new connection

// For Command cmd

db.AddInParameter(cmd, "@CFirstName", DbType.String, dt.Rows[i][j].ToString()); j++;

// adding new parameter Blah Blah Blah

db.AddInParameter(cmd, "@CLastName", DbType.String, dt.Rows[i][j].ToString()); j++;

// adding new parameter Blah Blah Blah

db.AddInParameter(cmd, "@CTitle", DbType.String, dt.Rows[i][j].ToString()); j++;

//adding new parameter Blah Blah Blah

// For Command cmd1

db.AddInParameter(cmd1, "@CFirstName", DbType.String, dt.Rows[i][j].ToString()); j++;

// adding new parameter Blah Blah Blah

db.AddInParameter(cmd1, "@CLastName", DbType.String, dt.Rows[i][j].ToString()); j++;

// adding new parameter Blah Blah Blah

db.AddInParameter(cmd1, "@CTitle", DbType.String, dt.Rows[i][j].ToString()); j++;

//adding new parameter Blah Blah Blah

SQLTransaction trx = conn.BeginTransaction(); // Begin Transcation

cmd.Transaction = trx; // Adding transcation to command

cmd1.Transaction = trx; // Adding transcation to command

try

{

db.ExecuteNonQuery(cmd, trx); // passing transcation to sql

db.ExecuteNonQuery(cmd1, trx); // passing transcation to sql

trx.Commit(); // Commit transcation

}

Catch(sqlexception sqlex)

{

Trx.rollback(); // Roll back Transcation

}

 


If u had any trouble just ask, Happy to help u :)
Stay Tune...
Have a nice day... 'N happy Coding :)