ASP.NET

string ConnectionStr = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended properties=\"Excel 8.0;HDR=YES\"", Location); 
using (OleDb.OleDbConnection Connection = new OleDb.OleDbConnection(ConnectionStr)) { 
    Connection.Open(); 
    //Create your worksheet using normal SQL 
    string CreateString = "CREATE TABLE..."; 
    using (OleDb.OleDbCommand Command = new OleDb.OleDbCommand(CreateString.ToString, Connection)) { 
        Command.ExecuteNonQuery(); 
    } 
    //More code here 
    Connection.Close(); 
}

Dim ConnectionStr As String = String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended properties=""Excel 8.0;HDR=YES""", Location) 
Using Connection As New OleDb.OleDbConnection(ConnectionStr) 
    Connection.Open() 
    Dim CreateString as String= "CREATE TABLE..." 'Create your worksheet using normal SQL
    Using Command As New OleDb.OleDbCommand(CreateString.ToString, Connection)
        Command.ExecuteNonQuery()
    End Using
    'More code here
    Connection.Close() 
End Using

Greg Chelstowski wrote:

You're a star

Christian Graus wrote:

It's hard when your question displays multiple levels of ignorance.

Robymon wrote:

while resizing it should not go the clarity, it should get good clarity.

private void button1_Click(object sender, System.EventArgs e)
{
int Result = 0;
Result = (int)MessageBox.Show("This is a Message box!",
"Message  Box",  MessageBoxButtons.YesNoCancel,
MessageBoxIcon.Information,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.DefaultDesktopOnly);
if (Result == (int)DialogResult.Yes)
{
textBox1.Text = "You clicked Yes";
}