cn.Open();
cmd = new SqlCommand("select emi,period,installment from [advance details] where staffid = '" + TextBox21.Text + "' and advancetype = '"+"SWF Advance"+"'", cn);
rs = cmd.ExecuteReader();
if (rs.Read())
{
swftotinst = Convert.ToInt16(rs[1]);
swfinst = Convert.ToInt32(rs[2]);
}
when we pass the reader value , the value passed returns zero. pls help
rs[1] = 10; swftotinst = 0;
...
Go to the complete details ...