this shows me connection error in connection1.open()

this shows me connection error in connection1.open()

using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace WindowsApplication4 { public partial class Form1 : Form { //private System.Windows.Forms.TextBox textBox1; private System.Data.DataSet MODEL_1DataSet; private System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1; //private System.Data.OleDb.OleDbCommand selectcommand; //private System.Data.OleDb.OleDbCommand insertcommand; //private System.Data.OleDb.OleDbCommand updatecommand; //private System.Data.OleDb.OleDbCommand deletecommand; private System.Data.OleDb.OleDbConnection connection1; //private System.ComponentModel.Container components = null; public Form1() { InitializeComponent(); //using //(System.Data.OleDb.OleDbConnection connection1 = new System.Data.OleDb.OleDbConnection()) //{ // The insertSQL string contains a SQL statement that // inserts a new row in the source table. //OleDbCommand command = new OleDbCommand(insertSQL); // Set the Connection to the new OleDbConnection. // command.Connection = connection1; // Open the connection and execute the insert command. //try //{ connection1.Open(); //command.ExecuteNonQuery(); // } //catch (Exception ex) //{ // Console.WriteLine(ex.Message); // } // The connection is automatically closed when the // code exits the using block. } } private void Form1_Load(object sender, EventArgs e) { oleDbDataAdapter1.SelectCommand.CommandText = "SELECT Frame FROM Element Forces-Frames =" + comboBox1.AllowDrop; oleDbDataAdapter1.Fill(modeL_1DataSet1); Display(modeL_1DataSet1); textBox6.Text += "\r\nsuccessful\r\n"; } private void Display(DataSet dataset) { try { DataTable dataTable = dataset.Tables[ 0 ]; if (dataTable.Rows.Count != 0) { int record = (int)dataTable.Rows[0][0];

need to connect .xls files as a database connection... wat should i install for this purpose???? i'm geetin an error regarding ODBC connectivity...but i did complete installtion of VS2005

i need the information abt how to transfer the values from a particular file, which is in one form, to their respective text boxes which is other form

i need to access a file in one form and print the contents of the file to the textbox which is in other form....