currently i am using SQL Server table in one of my application.
But, my client asking me to change the table to excel file or ini file which is located in server path.
the reason is to change to excel or ini file is, my client doesn't have access to change the name of the value in table.
Table structure is below.
EmpNo Sub1 Sub2 Sub3 Sub4
1 100 200 400 500
2 200 300 400 500
3 400 500 300 400
instead of the above table client's want to maintain in excel which need to be read from the folder.
see my sql code.
SqlCommand cmd = new SqlCommand(@"select Sub1,Sub2,Sub3 where Empno=@EmpNo", sqlcon);
cmd.Parameters.Add("@EmpNo", SqlDbType.NVarChar).Value = cmbEmp.SelectedItem.ToString();
the same i want to convert and read from excel or ini.
How to change..?