Generate query from excel sheet

How to write query from excel sheet.it is a very simple method to write query from excel sheet.for example.="insert into tablename(code,startdate,enddate,miniamt,amount,type,active) values('"&A1&"','2010-5-24','2011-5-23',300,30,'$',1)"green text show you this is excel sheet column na...

Read More

Error: Failed to access IIS metabase

This is error occurs when you have installed IIS after installing Microsoft Visual Studio. So to overcome this error you can either run aspnet_regiis utility or re-install .net framework.If you have installed IIS over .net framework 2.0 then you have to run this utility from following folder.C:\Windows\Microsoft.Net\Framework\v2.0.50727\aspnet_regiis...

Read More

Import contact from mail service using asp.net with php

First Download openinviter from http://openinviter.com/download.php and edit example.php to adjust it for your needs Just like, below php file (example). !--php include('openinviter.php'); $inviter=new OpenInviter(); $oi_services=$inviter->getPlugins(); if...

Read More

Convert Array To DataTable in .NET

public static DataTable GetDataTableFromArray(object[] array){ DataTable dataTable = new DataTable(); dataTable.LoadDataRow(array, true);//Pass array object to LoadDataRow method return dataTabl...

Read More

Export Data into CSV file using Asp.net

How to use below code.First create one default.aspx page and add below code into code behind file.using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;public partial class _Default : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e) { string[]...

Read More