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???