Try this
private void Import_Click(object sender, EventArgs e)
{
string excelcon = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\test.xls; Extended Properties=""Excel 8.0;HDR=YES;""";
SqlConnection sqlcon = new SqlConnection();
sqlcon.ConnectionString = ConfigurationManager.AppSettings["con"];
sqlcon.Open();
OleDbConnection sSourceConnection = new OleDbConnection(excelcon);
using (sSourceConnection)
{
string sql = string.Format("Select [Name],[Age] FROM [{0}]", "Sheet1$");
OleDbCommand command = new OleDbCommand(sql, sSourceConnection);
sSourceConnection.Open();
using (OleDbDataReader dr = command.ExecuteReader())
{
while (dr.Read())
{
string query = "insert into details values (@name,@age)";
SqlCommand cmd = new SqlCommand(query, sqlcon);
cmd.Parameters.AddWithValue("@name", dr[0].ToString());
cmd.Parameters.AddWithValue("@age", dr[1].ToString());
cmd.ExecuteNonQuery();
}
MessageBox.Show("Done");
}
}
}
Add connection string in app.config file