I HAVE EXCEL FILE LIKE BELOW .....
| Jan'13 | Feb'13 | Mar'13 | Apr'13 | TOTAL 2013 | |||||||
| Branch Name | code | Sales Qty. | Sales Value | Sales Qty. | Sales Value | Sales Qty. | Sales Value | Sales Qty. | Sales Value | Sales Qty. | Sales Value |
| s.v.cs branh | AED | 12 | 1,000 | 10 | 2,000 | 40 | 3,000 | 40 | 500 | 102 | 6,500 |
| yuot brach | AED3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| xxx | |||||||||||
| xxxyyy | |||||||||||
i want to insert above values in sql using asp.net
i have sql table like below
| Branch Name | code | date | SalesQty | SalesValues | ||
| s.v.cs branh | AED | jan'13 | 12 | 1000 | ||
| Feb'13 | 10 | 2000 |
plz write charp code ..........
using dataset ..
iam using below query to insert but iam unable to select date,salesqty,salesvalues in excel sheet
string sql = "INSERT INTO branch (BranchName,code,...................................................)";
sql += "VALUES('" + columns[0] + "','" + columns[1] + "','" + columns[2] + "')";
plz help me???
Vinodh NarayananPosted Jan 4, 2015, 11:17 PM
http://www.c-sharpcorner.com/Blogs/46869/import-excel-data-to-database-using-C-Sharp.aspx
Please mark if accepted as answer.
Saber ShaikhPosted Jan 4, 2015, 11:12 PM
http://www.codeproject.com/Tips/752981/Import-Data-from-Excel-File-to-Database-Table-in-A
This My Blog : http://aspnettutorialscode.blogspot.in/