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

Question

Hi friends,

i want to read .xls, xlsx, file format (using c#.net with sql connection) and have to save that file content into my folder.

Any1 help me please...

Thanks In ADVANCE...........................

sathish kumar · Answer

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

brunda k · Answer

As the question was about "how to read .xls file format in c#.net using sql connection" Assuming that the excel file is already stored in Sql server and to read it ........ here we can use sqlconnection In the Code provided, where is the last line "query" been executed?

sathish kumar · Answer

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 + "') "; }

brunda k · Answer

http://www.aspsnippets.com/Articles/Save-and-Retrieve-Files-from-SQL-Server-Database-using-ASP.Net.aspx

Kunal Vaishya · Answer

Dear i develop this may this help you http://www.c-sharpcorner.com/Blogs/8808/how-to-open-excel-file-in-datagridview.aspx

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

Answers (5)