Asp.net, Sqlite, Jquery,HTML 5, Sql Server,vb, C#, Javascript,Sugarcrm API, WCF ,WPF, WWF,MVC

Friday, November 9, 2012

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 :)

Monday, October 22, 2012

Print a div or grid in javascript

Hi *.*,

<title>Print Gridview Data in asp.net</title>

function PrintGridData() {

var prtGrid = document.getElementById('<%=gvUserInfo.ClientID %>');

prtGrid.border = 0;

var prtwin = window.open('', 'PrintGridViewData', 'left=100,top=100,width=1000,height=1000,tollbar=0,scrollbars=1,status=0,resizable=1');

prtwin.document.write(prtGrid.outerHTML);

prtwin.document.close();

prtwin.focus();

prtwin.print();

prtwin.close();

}

</script>

</head>

<body>

<div>

<b>Print Gridview Data</b><br /><br />

<asp:GridView ID="gvUserInfo" runat="server" >

</asp:GridView>

</div>

</form>

</body>

</html>

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

Asp.net, Sqlite, Jquery,HTML 5, Sql Server,vb, C#, Javascript,Sugarcrm API, WCF ,WPF, WWF,MVC

Pages

Friday, November 9, 2012

sample :: Bulk Copy in C#

Sample (basic) Transaction handling from code side

Monday, October 22, 2012

Print a div or grid in javascript

Total Pageviews

Translate