how to read .xls file format in c#.net using sql connection

Hi Brunda,






   Ya i have executed that query after checking all my if conditions....

hi  thanks for t reply....but i have a doubt... Why do people use oledb to read EXCEL , cant we use sqlconnection ???


 i have to read file in such a way i have shown below... Below shown is the .docx file read format.. Same way i have to read .xls, .xlsx and pdf file format...after reading the file i have to save that file content in my folder.



if (extn.Equals(".docx"))
            {
                Microsoft.Office.Interop.Word.ApplicationClass oWordApp = new Microsoft.Office.Interop.Word.ApplicationClass();
                object fileName = Server.MapPath("uploads/" + filename);
                object readOnly = true;
                object isVisible = false;
                object missing = System.Reflection.Missing.Value;
                //Word.ApplicationClass oWordApp = new Word.ApplicationClass();

                Microsoft.Office.Interop.Word.Document oWordDoc = oWordApp.Documents.Open(ref fileName, ref missing, ref readOnly, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref isVisible, ref missing, ref missing, ref missing, ref missing);

                //oWordDoc.Activate();

                oWordDoc.ActiveWindow.Selection.WholeStory();

                oWordDoc.ActiveWindow.Selection.Copy();
                string txt = oWordDoc.Content.Text;
                query = "INSERT INTO Fileupload([category],[subcategory],[uid],[oid],[up_name],[demo1],[keyword],[fdata],[aflag],sizebyte) VALUES('" + dropcategory.SelectedValue + "','" + DropDownList1.SelectedValue + "','" + Session["user_id"].ToString() + "','" + txtOwnerId.SelectedItem + "','" + fname + "','" + demo1.Text + "','" + key + "','" + txt + "',1,'" + size + "')  ";
            }

Dear i develop this may this help you

http://www.c-sharpcorner.com/Blogs/8808/how-to-open-excel-file-in-datagridview.aspx