DotNetCentral

Parameterizing javascript functions in template fields

2012-07-17T14:50:00.002+05:30

BulkImport of Excel File/Flat File/CSV file into SQL Server Database

2011-05-12T23:39:00.000+05:30

Below code snippet is to import data from Excel to a Dataset

string strExcelFilename = txtExcelFilename.Text;
//Use Microsoft JET OLEDB Provider

string strConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" + @"Data Source=" + strExcelFilename + ";" + @"Extended Properties=" + Convert.ToChar(34).ToString() + @"Excel 8.0;HDR=YES" + Convert.ToChar(34).ToString();

OleDbConnection objCon = new OleDbConnection(strConnectionString);

try
{
objCon.Open();

//By default spreadsheet first sheet will be sheet1 unless it is renamed
string strExcelSheetName = "ExcelSheetName";

string strSQL = "SELECT * FROM [" + strExcelSheetName + "$" + "]";
OleDbDataAdapter objoleAdapter = new OleDbDataAdapter(strSQL, objCon);
objoleAdapter.Fill(ds, "tblImportedData");

SqlBulkCopy bulkCopy = new SqlBulkCopy("Server=ServerName;Database=test;Trusted_Connection=True;",SqlBulkCopyOptions.TableLock); bulkCopy.DestinationTableName = "Destination Table Name";

bulkCopy.WriteToServer(ds.Tables[0]);
}
catch (Exception ex)
{
Response.Write(ex.Message);
return;
}

RSS Reader - Online News Reader - NewsGator

2011-04-29T15:29:00.000+05:30

RSS Reader - Online News Reader - NewsGator

2011-04-21T17:34:00.000+05:30

Useful URL convering the topics like Google SEO,WebmasterWorld Supporters, Social Media, Facebook, Marketing,Twitter,JavaScript and AJAX, HTML, CSS, Databases, Content Management,RSS,ATOM and Related Technologies, Blogging SEO, Blog Software and Blog Administration,Marketing and BizDev, Sitemaps, Meta Data, and robots.txt and many more at http://www.webmasterworld.com/home.htm

How to print a DIV content from a HTML table

2011-04-18T14:33:00.000+05:30

Javascript function for printing DIV content from ASP.NET/PHP/ any HTML, etc.

function CallPrint(strid)

{
var prtContent = document.getElementById(strid);
window.document.write(prtContent.innerHTML);
window.document.close();
window.print();
history.back();
}

Call the javascript function as
OnClientClick="CallPrint('divPrintMessages')"
Hope this will help you....

HTC SmartPhone Emulator

2010-08-10T08:19:00.000+05:30

Mobile Sence - mobile9 Updated on 15th April 2011

Light on HL7

2010-07-30T08:30:00.000+05:30

HL7 Messaging Fundamentals

Developing Secure Applications

2010-07-21T22:51:00.000+05:30

Developing Secure Applications and Defending Against Common Attacks

About CSRF

2010-07-21T22:01:00.000+05:30

Every Web Developer Should Know

Web application vulnerabilities

2010-07-21T21:53:00.000+05:30

Hot or Not: Web application vulnerabilities - SC Magazine US

iPhone Stuff

2010-07-15T22:59:00.000+05:30