Read Excel file and import data to sql

See more:

Silverlight5

Hi

I had added a openfile dialog for Importing Excel Files. I need to validate the input file like whether it has specified columns and atleast one row of data.

Is it possible to validate before saving the file to server ?
How to read the contents of excel file and export to datatable or dataset.

private void ImportButton_Click(object sender, RoutedEventArgs e)
{           
   OpenFileDialog openFileDialog = new OpenFileDialog();
   openFileDialog.Multiselect = false;
   openFileDialog.Filter = "Excel Files(*.xlsx)|*.xlsx";

   if (openFileDialog.ShowDialog() == true)
   {
      this.FileTextBox.Text = openFileDialog.File.Name;
      this.FileTextBox.IsReadOnly = true;
      FileStream myStream = openFileDialog.File.OpenRead();                  
   }
}