/// <summary> /// All The Methods That are used in coding /// </summary> #region Methods public void getplan() { DataTable dt = new DataTable(); var result = context.sp_planall(); dt = helper.LINQToDataTable(result); DataRow row1 = dt.Rows[0]; string rowValue = row1["plan_name"].ToString(); string rowValue4 = row1["price"].ToString(); string rowValue7 = row1["duration"].ToString(); DataRow row2 = dt.Rows[1]; string rowValue2 = row2["plan_name"].ToString(); string rowValue5 = row2["price"].ToString(); string rowValue8 = row2["duration"].ToString(); DataRow row3 = dt.Rows[2]; string rowValue3 = row3["plan_name"].ToString(); string rowValue6 = row3["price"].ToString(); string rowValue9 = row3["duration"].ToString(); lblName1.Text = rowValue; lblName2.Text = rowValue2; lblName3.Text = rowValue3; lblPrice1.Text = rowValue4; lblPrice2.Text = rowValue5; lblPrice3.Text = rowValue6; lblDuration1.Text = rowValue7; lblDuration2.Text = rowValue8; lblDuration3.Text = rowValue9; }