数据集位置异常没有行 [英] dataset no row at position exception
问题描述
我的申请表中有两种表格.one 表单包含gridview,另一个表单包含文本框。当我点击gridview中的id列时,它从数据库中获取数据并以另一种形式填充到文本框中。如果没有记录 在数据库
中如何跳过那些记录。我得到了例外"数据集没有位置异常行"在第6行
in my application i have two forms .one form contains gridview and another form contains textboxes .when i click on id column in gridview it gets data from databse and populates into textboxes in another form .If there is no record in the database how to skip those records .i got exeception "dataset no row at position exception " at row6
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["EmpId"] != null)
{
userid = Request.QueryString["EmpId"];
ViewControlvalues();
Submit.Visible = false;
Cancel.Visible = true;
flip1();
}
if (Request.QueryString["Id"] != null)
{
userid = Request.QueryString["Id"];
EditControlvalues();
UpdateEmpTimesheet.Visible = true;
}
BindDropDownListData();
}
}
private void ViewControlvalues()
{
string Connection = System.Configuration.ConfigurationManager.ConnectionStrings["Conn"].ConnectionString;
SqlConnection cn = new SqlConnection(Connection);
cn.Open();
// SqlCommand cmd = new SqlCommand("select EmpName,StartDate,day,date,EndDate,Service,Venue,StartTime,EndTime,Breakfast,Lunch,Dinner,DailyTotal from EmpTimesheet where EmpId=" + userid, cn);
SqlCommand cmd = new SqlCommand("select EmpName,StartDate,EndDate,day,date,Service,Venue,StartTime,EndTime,Breakfast,Lunch,Dinner,DailyTotal,Total,StandardHrs,OverTimeHrs,OnsiteHrs,TravelHrs from EmpTimesheet where EmpId=@EmpId ", cn);
cmd.Parameters.Add("EmpId",userid);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds,"EmpTimesheet");
txt_EmpName.Text = ds.Tables["EmpTimesheet"].Rows[0][0].ToString();
// select EmpName,StartDate,day,date,EndDate,Service,Venue,StartTime,EndTime,Breakfast,Lunch,Dinner,DailyTotal
txt_StartDate.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[0][1]).ToString("MM/dd/yyyy");
txt_EndDate.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[0][2]).ToString("MM/dd/yyyy");
lnkBtnSun.Text = ds.Tables["EmpTimesheet"].Rows[0][3].ToString().Trim();
lbl_sun.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[0][4]).ToString("MM/dd/yyyy");
txt_ServiceSunday.Text = ds.Tables["EmpTimesheet"].Rows[0][5].ToString().Trim();
txt_SunVenue.Text = ds.Tables["EmpTimesheet"].Rows[0][6].ToString().Trim();
txt_SunStartTIme.Text = ds.Tables["EmpTimesheet"].Rows[0][7].ToString().Trim();
txt_SunEndTime.Text = ds.Tables["EmpTimesheet"].Rows[0][8].ToString().Trim();
txt_SunBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[0][9].ToString().Trim();
txt_SunLunch.Text = ds.Tables["EmpTimesheet"].Rows[0][10].ToString().Trim();
txt_SunDinner.Text = ds.Tables["EmpTimesheet"].Rows[0][11].ToString().Trim();
txt_SunServiceHrs.Text = ds.Tables["EmpTimesheet"].Rows[0][12].ToString().Trim();
lnkBtnMon.Text = ds.Tables["EmpTimesheet"].Rows[1][3].ToString().Trim();
lbl_Mon.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[1][4]).ToString("MM/dd/yyyy");
txt_ServiceMonday.Text = ds.Tables["EmpTimesheet"].Rows[1][5].ToString().Trim();
txt_MonVenue.Text = ds.Tables["EmpTimesheet"].Rows[1][6].ToString().Trim();
txt_MonStartEim.Text = ds.Tables["EmpTimesheet"].Rows[1][7].ToString().Trim();
txt_MonEndTime.Text = ds.Tables["EmpTimesheet"].Rows[1][8].ToString().Trim();
txt_MonBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[1][9].ToString().Trim();
txt_MonLun.Text = ds.Tables["EmpTimesheet"].Rows[1][10].ToString().Trim();
txt_MonDinner.Text = ds.Tables["EmpTimesheet"].Rows[1][11].ToString().Trim();
txt_MonServiceHrs.Text = ds.Tables["EmpTimesheet"].Rows[1][12].ToString().Trim();
lnkBtnTues.Text = ds.Tables["EmpTimesheet"].Rows[2][3].ToString().Trim();
lbl_Tue.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[2][4]).ToString("MM/dd/yyyy");
txt_ServiceTuesday.Text = ds.Tables["EmpTimesheet"].Rows[2][5].ToString().Trim();
txt_TueVenue.Text = ds.Tables["EmpTimesheet"].Rows[2][6].ToString().Trim();
txt_TueStartTime.Text = ds.Tables["EmpTimesheet"].Rows[2][7].ToString().Trim();
txt_TuesEndTime.Text = ds.Tables["EmpTimesheet"].Rows[2][8].ToString().Trim();
txt_TueBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[2][9].ToString().Trim();
txt_TueLunch.Text = ds.Tables["EmpTimesheet"].Rows[2][10].ToString().Trim();
txt_TueDinner.Text = ds.Tables["EmpTimesheet"].Rows[2][11].ToString().Trim();
txt_TueServiceHrs.Text = ds.Tables["EmpTimesheet"].Rows[2][12].ToString().Trim();
lnkBtnWed.Text = ds.Tables["EmpTimesheet"].Rows[3][3].ToString().Trim();
lbl_Wed.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[3][4]).ToString("MM/dd/yyyy");
txt_ServiceWednesday.Text = ds.Tables["EmpTimesheet"].Rows[3][5].ToString().Trim();
txt_WedVenue.Text = ds.Tables["EmpTimesheet"].Rows[3][6].ToString().Trim();
txt_WedStartTime.Text = ds.Tables["EmpTimesheet"].Rows[3][7].ToString().Trim();
txt_WedEndTime.Text = ds.Tables["EmpTimesheet"].Rows[3][8].ToString().Trim();
txt_WedBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[3][9].ToString().Trim();
txt_WedLunch.Text = ds.Tables["EmpTimesheet"].Rows[3][10].ToString().Trim();
txt_WedDinner.Text = ds.Tables["EmpTimesheet"].Rows[3][11].ToString().Trim();
txt_WedServiceHrs.Text = ds.Tables["EmpTimesheet"].Rows[3][12].ToString().Trim();
lnkBtnThurs.Text = ds.Tables["EmpTimesheet"].Rows[4][3].ToString().Trim();
lbl_Thu.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[4][4]).ToString("MM/dd/yyyy");
txt_ServiceThursday.Text = ds.Tables["EmpTimesheet"].Rows[4][5].ToString().Trim();
txt_ThursVenue.Text = ds.Tables["EmpTimesheet"].Rows[4][6].ToString().Trim();
txt_ThursStartTime.Text = ds.Tables["EmpTimesheet"].Rows[4][7].ToString().Trim();
txt_ThursEndTime.Text = ds.Tables["EmpTimesheet"].Rows[4][8].ToString().Trim();
txt_ThursBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[4][9].ToString().Trim();
txt_ThursLunch.Text = ds.Tables["EmpTimesheet"].Rows[4][10].ToString().Trim();
txt_ThursDinner.Text = ds.Tables["EmpTimesheet"].Rows[4][11].ToString().Trim();
txt_ThursServiceHrs.Text = ds.Tables["EmpTimesheet"].Rows[4][12].ToString().Trim();
lnkBtnFri.Text = ds.Tables["EmpTimesheet"].Rows[5][3].ToString().Trim();
lbl_Fri.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[5][4]).ToString("MM/dd/yyyy");
txt_ServiceFriday.Text = ds.Tables["EmpTimesheet"].Rows[5][5].ToString().Trim();
txt_FriVenue.Text = ds.Tables["EmpTimesheet"].Rows[5][6].ToString().Trim();
txt_FriStartTime.Text = ds.Tables["EmpTimesheet"].Rows[5][7].ToString().Trim();
txt_FriEndTime.Text = ds.Tables["EmpTimesheet"].Rows[5][8].ToString().Trim();
txt_FriBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[5][9].ToString().Trim();
txt_FriLunch.Text = ds.Tables["EmpTimesheet"].Rows[5][10].ToString().Trim();
txt_FriDinner.Text = ds.Tables["EmpTimesheet"].Rows[5][11].ToString().Trim();
txt_FriServiceHrs.Text = ds.Tables["EmpTimesheet"].Rows[5][12].ToString().Trim();
lnkBtnSat.Text = ds.Tables["EmpTimesheet"].Rows[6][3].ToString().Trim();
lbl_sat.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[6][4]).ToString("MM/dd/yyyy");
txt_ServiceSaturday.Text = ds.Tables["EmpTimesheet"].Rows[6][5].ToString().Trim();
txt_SatVenue.Text = ds.Tables["EmpTimesheet"].Rows[6][6].ToString().Trim();
txt_SatStartTime.Text = ds.Tables["EmpTimesheet"].Rows[6][7].ToString().Trim();
txt_SatEndTime.Text = ds.Tables["EmpTimesheet"].Rows[6][8].ToString().Trim();
txt_SatBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[6][9].ToString().Trim();
txt_SatLunch.Text = ds.Tables["EmpTimesheet"].Rows[6][10].ToString().Trim();
txt_SatDinner.Text = ds.Tables["EmpTimesheet"].Rows[6][11].ToString().Trim();
txt_SatServiceHRs.Text = ds.Tables["EmpTimesheet"].Rows[6][12].ToString().Trim();
txt_Total.Text = ds.Tables["EmpTimesheet"].Rows[6][13].ToString().Trim();
txt_standard.Text = ds.Tables["EmpTimesheet"].Rows[6][14].ToString().Trim(); ;
txt_OverTimeHrs.Text = ds.Tables["EmpTimesheet"].Rows[6][15].ToString().Trim(); ;
txt_OnsiteHrsmain.Text = ds.Tables["EmpTimesheet"].Rows[6][16].ToString().Trim(); ;
txt_TravelHrs_Timesheet.Text = ds.Tables["EmpTimesheet"].Rows[6][17].ToString().Trim(); ;
lnkBtnSun.Enabled = false;
lnkBtnMon.Enabled = false;
lnkBtnSat.Enabled = false;
lnkBtnTues.Enabled = false;
lnkBtnWed.Enabled = false;
lnkBtnThurs.Enabled = false;
lnkBtnFri.Enabled = false;
}
private void EditControlvalues()
{
string Connection = System.Configuration.ConfigurationManager.ConnectionStrings["Conn"].ConnectionString;
SqlConnection cn = new SqlConnection(Connection);
cn.Open();
// SqlCommand cmd = new SqlCommand("select EmpName,StartDate,day,date,EndDate,Service,Venue,StartTime,EndTime,Breakfast,Lunch,Dinner,DailyTotal from EmpTimesheet where EmpId=" + userid, cn);
SqlCommand cmd = new SqlCommand("select EmpName,StartDate,EndDate,day,date,Service,Venue,StartTime,EndTime,Breakfast,Lunch,Dinner,DailyTotal,Total,StandardHrs,OverTimeHrs,OnsiteHrs,TravelHrs from EmpTimesheet where EmpId=@EmpId ", cn);
cmd.Parameters.Add("EmpId", userid);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "EmpTimesheet");
txt_EmpName.Text = ds.Tables["EmpTimesheet"].Rows[0][0].ToString();
// select EmpName,StartDate,day,date,EndDate,Service,Venue,StartTime,EndTime,Breakfast,Lunch,Dinner,DailyTotal
txt_StartDate.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[0][1]).ToString("MM/dd/yyyy");
txt_EndDate.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[0][2]).ToString("MM/dd/yyyy");
lnkBtnSun.Text = ds.Tables["EmpTimesheet"].Rows[0][3].ToString().Trim();
lbl_sun.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[0][4]).ToString("MM/dd/yyyy");
txt_ServiceSunday.Text = ds.Tables["EmpTimesheet"].Rows[0][5].ToString().Trim();
txt_SunVenue.Text = ds.Tables["EmpTimesheet"].Rows[0][6].ToString().Trim();
txt_SunStartTIme.Text = ds.Tables["EmpTimesheet"].Rows[0][7].ToString().Trim();
txt_SunEndTime.Text = ds.Tables["EmpTimesheet"].Rows[0][8].ToString().Trim();
txt_SunBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[0][9].ToString().Trim();
txt_SunLunch.Text = ds.Tables["EmpTimesheet"].Rows[0][10].ToString().Trim();
txt_SunDinner.Text = ds.Tables["EmpTimesheet"].Rows[0][11].ToString().Trim();
txt_SunServiceHrs.Text = ds.Tables["EmpTimesheet"].Rows[0][12].ToString().Trim();
lnkBtnMon.Text = ds.Tables["EmpTimesheet"].Rows[1][3].ToString().Trim();
lbl_Mon.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[1][4]).ToString("MM/dd/yyyy");
txt_ServiceMonday.Text = ds.Tables["EmpTimesheet"].Rows[1][5].ToString().Trim();
txt_MonVenue.Text = ds.Tables["EmpTimesheet"].Rows[1][6].ToString().Trim();
txt_MonStartEim.Text = ds.Tables["EmpTimesheet"].Rows[1][7].ToString().Trim();
txt_MonEndTime.Text = ds.Tables["EmpTimesheet"].Rows[1][8].ToString().Trim();
txt_MonBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[1][9].ToString().Trim();
txt_MonLun.Text = ds.Tables["EmpTimesheet"].Rows[1][10].ToString().Trim();
txt_MonDinner.Text = ds.Tables["EmpTimesheet"].Rows[1][11].ToString().Trim();
txt_MonServiceHrs.Text = ds.Tables["EmpTimesheet"].Rows[1][12].ToString().Trim();
lnkBtnTues.Text = ds.Tables["EmpTimesheet"].Rows[2][3].ToString().Trim();
lbl_Tue.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[2][4]).ToString("MM/dd/yyyy");
txt_ServiceTuesday.Text = ds.Tables["EmpTimesheet"].Rows[2][5].ToString().Trim();
txt_TueVenue.Text = ds.Tables["EmpTimesheet"].Rows[2][6].ToString().Trim();
txt_TueStartTime.Text = ds.Tables["EmpTimesheet"].Rows[2][7].ToString().Trim();
txt_TuesEndTime.Text = ds.Tables["EmpTimesheet"].Rows[2][8].ToString().Trim();
txt_TueBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[2][9].ToString().Trim();
txt_TueLunch.Text = ds.Tables["EmpTimesheet"].Rows[2][10].ToString().Trim();
txt_TueDinner.Text = ds.Tables["EmpTimesheet"].Rows[2][11].ToString().Trim();
txt_TueServiceHrs.Text = ds.Tables["EmpTimesheet"].Rows[2][12].ToString().Trim();
lnkBtnWed.Text = ds.Tables["EmpTimesheet"].Rows[3][3].ToString().Trim();
lbl_Wed.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[3][4]).ToString("MM/dd/yyyy");
txt_ServiceWednesday.Text = ds.Tables["EmpTimesheet"].Rows[3][5].ToString().Trim();
txt_WedVenue.Text = ds.Tables["EmpTimesheet"].Rows[3][6].ToString().Trim();
txt_WedStartTime.Text = ds.Tables["EmpTimesheet"].Rows[3][7].ToString().Trim();
txt_WedEndTime.Text = ds.Tables["EmpTimesheet"].Rows[3][8].ToString().Trim();
txt_WedBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[3][9].ToString().Trim();
txt_WedLunch.Text = ds.Tables["EmpTimesheet"].Rows[3][10].ToString().Trim();
txt_WedDinner.Text = ds.Tables["EmpTimesheet"].Rows[3][11].ToString().Trim();
txt_WedServiceHrs.Text = ds.Tables["EmpTimesheet"].Rows[3][12].ToString().Trim();
lnkBtnThurs.Text = ds.Tables["EmpTimesheet"].Rows[4][3].ToString().Trim();
lbl_Thu.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[4][4]).ToString("MM/dd/yyyy");
txt_ServiceThursday.Text = ds.Tables["EmpTimesheet"].Rows[4][5].ToString().Trim();
txt_ThursVenue.Text = ds.Tables["EmpTimesheet"].Rows[4][6].ToString().Trim();
txt_ThursStartTime.Text = ds.Tables["EmpTimesheet"].Rows[4][7].ToString().Trim();
txt_ThursEndTime.Text = ds.Tables["EmpTimesheet"].Rows[4][8].ToString().Trim();
txt_ThursBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[4][9].ToString().Trim();
txt_ThursLunch.Text = ds.Tables["EmpTimesheet"].Rows[4][10].ToString().Trim();
txt_ThursDinner.Text = ds.Tables["EmpTimesheet"].Rows[4][11].ToString().Trim();
txt_ThursServiceHrs.Text = ds.Tables["EmpTimesheet"].Rows[4][12].ToString().Trim();
lnkBtnFri.Text = ds.Tables["EmpTimesheet"].Rows[5][3].ToString().Trim();
lbl_Fri.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[5][4]).ToString("MM/dd/yyyy");
txt_ServiceFriday.Text = ds.Tables["EmpTimesheet"].Rows[5][5].ToString().Trim();
txt_FriVenue.Text = ds.Tables["EmpTimesheet"].Rows[5][6].ToString().Trim();
txt_FriStartTime.Text = ds.Tables["EmpTimesheet"].Rows[5][7].ToString().Trim();
txt_FriEndTime.Text = ds.Tables["EmpTimesheet"].Rows[5][8].ToString().Trim();
txt_FriBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[5][9].ToString().Trim();
txt_FriLunch.Text = ds.Tables["EmpTimesheet"].Rows[5][10].ToString().Trim();
txt_FriDinner.Text = ds.Tables["EmpTimesheet"].Rows[5][11].ToString().Trim();
txt_FriServiceHrs.Text = ds.Tables["EmpTimesheet"].Rows[5][12].ToString().Trim();
lnkBtnSat.Text = ds.Tables["EmpTimesheet"].Rows[6][3].ToString().Trim(); //protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["EmpId"] != null)
{
userid = Request.QueryString["EmpId"];
ViewControlvalues();
Submit.Visible = false;
Cancel.Visible = true;
flip1();
}
if (Request.QueryString["Id"] != null)
{
userid = Request.QueryString["Id"];
EditControlvalues();
UpdateEmpTimesheet.Visible = true;
}
BindDropDownListData();
}
}
private void ViewControlvalues()
{
string Connection = System.Configuration.ConfigurationManager.ConnectionStrings["Conn"].ConnectionString;
SqlConnection cn = new SqlConnection(Connection);
cn.Open();
// SqlCommand cmd = new SqlCommand("select EmpName,StartDate,day,date,EndDate,Service,Venue,StartTime,EndTime,Breakfast,Lunch,Dinner,DailyTotal from EmpTimesheet where EmpId=" + userid, cn);
SqlCommand cmd = new SqlCommand("select EmpName,StartDate,EndDate,day,date,Service,Venue,StartTime,EndTime,Breakfast,Lunch,Dinner,DailyTotal,Total,StandardHrs,OverTimeHrs,OnsiteHrs,TravelHrs from EmpTimesheet where EmpId=@EmpId ", cn);
cmd.Parameters.Add("EmpId",userid);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds,"EmpTimesheet");
txt_EmpName.Text = ds.Tables["EmpTimesheet"].Rows[0][0].ToString();
// select EmpName,StartDate,day,date,EndDate,Service,Venue,StartTime,EndTime,Breakfast,Lunch,Dinner,DailyTotal
txt_StartDate.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[0][1]).ToString("MM/dd/yyyy");
txt_EndDate.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[0][2]).ToString("MM/dd/yyyy");
lnkBtnSun.Text = ds.Tables["EmpTimesheet"].Rows[0][3].ToString().Trim();
lbl_sun.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[0][4]).ToString("MM/dd/yyyy");
txt_ServiceSunday.Text = ds.Tables["EmpTimesheet"].Rows[0][5].ToString().Trim();
txt_SunVenue.Text = ds.Tables["EmpTimesheet"].Rows[0][6].ToString().Trim();
txt_SunStartTIme.Text = ds.Tables["EmpTimesheet"].Rows[0][7].ToString().Trim();
txt_SunEndTime.Text = ds.Tables["EmpTimesheet"].Rows[0][8].ToString().Trim();
txt_SunBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[0][9].ToString().Trim();
txt_SunLunch.Text = ds.Tables["EmpTimesheet"].Rows[0][10].ToString().Trim();
txt_SunDinner.Text = ds.Tables["EmpTimesheet"].Rows[0][11].ToString().Trim();
txt_SunServiceHrs.Text = ds.Tables["EmpTimesheet"].Rows[0][12].ToString().Trim();
lnkBtnMon.Text = ds.Tables["EmpTimesheet"].Rows[1][3].ToString().Trim();
lbl_Mon.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[1][4]).ToString("MM/dd/yyyy");
txt_ServiceMonday.Text = ds.Tables["EmpTimesheet"].Rows[1][5].ToString().Trim();
txt_MonVenue.Text = ds.Tables["EmpTimesheet"].Rows[1][6].ToString().Trim();
txt_MonStartEim.Text = ds.Tables["EmpTimesheet"].Rows[1][7].ToString().Trim();
txt_MonEndTime.Text = ds.Tables["EmpTimesheet"].Rows[1][8].ToString().Trim();
txt_MonBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[1][9].ToString().Trim();
txt_MonLun.Text = ds.Tables["EmpTimesheet"].Rows[1][10].ToString().Trim();
txt_MonDinner.Text = ds.Tables["EmpTimesheet"].Rows[1][11].ToString().Trim();
txt_MonServiceHrs.Text = ds.Tables["EmpTimesheet"].Rows[1][12].ToString().Trim();
lnkBtnTues.Text = ds.Tables["EmpTimesheet"].Rows[2][3].ToString().Trim();
lbl_Tue.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[2][4]).ToString("MM/dd/yyyy");
txt_ServiceTuesday.Text = ds.Tables["EmpTimesheet"].Rows[2][5].ToString().Trim();
txt_TueVenue.Text = ds.Tables["EmpTimesheet"].Rows[2][6].ToString().Trim();
txt_TueStartTime.Text = ds.Tables["EmpTimesheet"].Rows[2][7].ToString().Trim();
txt_TuesEndTime.Text = ds.Tables["EmpTimesheet"].Rows[2][8].ToString().Trim();
txt_TueBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[2][9].ToString().Trim();
txt_TueLunch.Text = ds.Tables["EmpTimesheet"].Rows[2][10].ToString().Trim();
txt_TueDinner.Text = ds.Tables["EmpTimesheet"].Rows[2][11].ToString().Trim();
txt_TueServiceHrs.Text = ds.Tables["EmpTimesheet"].Rows[2][12].ToString().Trim();
lnkBtnWed.Text = ds.Tables["EmpTimesheet"].Rows[3][3].ToString().Trim();
lbl_Wed.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[3][4]).ToString("MM/dd/yyyy");
txt_ServiceWednesday.Text = ds.Tables["EmpTimesheet"].Rows[3][5].ToString().Trim();
txt_WedVenue.Text = ds.Tables["EmpTimesheet"].Rows[3][6].ToString().Trim();
txt_WedStartTime.Text = ds.Tables["EmpTimesheet"].Rows[3][7].ToString().Trim();
txt_WedEndTime.Text = ds.Tables["EmpTimesheet"].Rows[3][8].ToString().Trim();
txt_WedBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[3][9].ToString().Trim();
txt_WedLunch.Text = ds.Tables["EmpTimesheet"].Rows[3][10].ToString().Trim();
txt_WedDinner.Text = ds.Tables["EmpTimesheet"].Rows[3][11].ToString().Trim();
txt_WedServiceHrs.Text = ds.Tables["EmpTimesheet"].Rows[3][12].ToString().Trim();
lnkBtnThurs.Text = ds.Tables["EmpTimesheet"].Rows[4][3].ToString().Trim();
lbl_Thu.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[4][4]).ToString("MM/dd/yyyy");
txt_ServiceThursday.Text = ds.Tables["EmpTimesheet"].Rows[4][5].ToString().Trim();
txt_ThursVenue.Text = ds.Tables["EmpTimesheet"].Rows[4][6].ToString().Trim();
txt_ThursStartTime.Text = ds.Tables["EmpTimesheet"].Rows[4][7].ToString().Trim();
txt_ThursEndTime.Text = ds.Tables["EmpTimesheet"].Rows[4][8].ToString().Trim();
txt_ThursBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[4][9].ToString().Trim();
txt_ThursLunch.Text = ds.Tables["EmpTimesheet"].Rows[4][10].ToString().Trim();
txt_ThursDinner.Text = ds.Tables["EmpTimesheet"].Rows[4][11].ToString().Trim();
txt_ThursServiceHrs.Text = ds.Tables["EmpTimesheet"].Rows[4][12].ToString().Trim();
lnkBtnFri.Text = ds.Tables["EmpTimesheet"].Rows[5][3].ToString().Trim();
lbl_Fri.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[5][4]).ToString("MM/dd/yyyy");
txt_ServiceFriday.Text = ds.Tables["EmpTimesheet"].Rows[5][5].ToString().Trim();
txt_FriVenue.Text = ds.Tables["EmpTimesheet"].Rows[5][6].ToString().Trim();
txt_FriStartTime.Text = ds.Tables["EmpTimesheet"].Rows[5][7].ToString().Trim();
txt_FriEndTime.Text = ds.Tables["EmpTimesheet"].Rows[5][8].ToString().Trim();
txt_FriBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[5][9].ToString().Trim();
txt_FriLunch.Text = ds.Tables["EmpTimesheet"].Rows[5][10].ToString().Trim();
txt_FriDinner.Text = ds.Tables["EmpTimesheet"].Rows[5][11].ToString().Trim();
txt_FriServiceHrs.Text = ds.Tables["EmpTimesheet"].Rows[5][12].ToString().Trim();
lnkBtnSat.Text = ds.Tables["EmpTimesheet"].Rows[6][3].ToString().Trim();
lbl_sat.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[6][4]).ToString("MM/dd/yyyy");
txt_ServiceSaturday.Text = ds.Tables["EmpTimesheet"].Rows[6][5].ToString().Trim();
txt_SatVenue.Text = ds.Tables["EmpTimesheet"].Rows[6][6].ToString().Trim();
txt_SatStartTime.Text = ds.Tables["EmpTimesheet"].Rows[6][7].ToString().Trim();
txt_SatEndTime.Text = ds.Tables["EmpTimesheet"].Rows[6][8].ToString().Trim();
txt_SatBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[6][9].ToString().Trim();
txt_SatLunch.Text = ds.Tables["EmpTimesheet"].Rows[6][10].ToString().Trim();
txt_SatDinner.Text = ds.Tables["EmpTimesheet"].Rows[6][11].ToString().Trim();
txt_SatServiceHRs.Text = ds.Tables["EmpTimesheet"].Rows[6][12].ToString().Trim();
txt_Total.Text = ds.Tables["EmpTimesheet"].Rows[6][13].ToString().Trim();
txt_standard.Text = ds.Tables["EmpTimesheet"].Rows[6][14].ToString().Trim(); ;
txt_OverTimeHrs.Text = ds.Tables["EmpTimesheet"].Rows[6][15].ToString().Trim(); ;
txt_OnsiteHrsmain.Text = ds.Tables["EmpTimesheet"].Rows[6][16].ToString().Trim(); ;
txt_TravelHrs_Timesheet.Text = ds.Tables["EmpTimesheet"].Rows[6][17].ToString().Trim(); ;
lnkBtnSun.Enabled = false;
lnkBtnMon.Enabled = false;
lnkBtnSat.Enabled = false;
lnkBtnTues.Enabled = false;
lnkBtnWed.Enabled = false;
lnkBtnThurs.Enabled = false;
lnkBtnFri.Enabled = false;
}
private void EditControlvalues()
{
string Connection = System.Configuration.ConfigurationManager.ConnectionStrings["Conn"].ConnectionString;
SqlConnection cn = new SqlConnection(Connection);
cn.Open();
// SqlCommand cmd = new SqlCommand("select EmpName,StartDate,day,date,EndDate,Service,Venue,StartTime,EndTime,Breakfast,Lunch,Dinner,DailyTotal from EmpTimesheet where EmpId=" + userid, cn);
SqlCommand cmd = new SqlCommand("select EmpName,StartDate,EndDate,day,date,Service,Venue,StartTime,EndTime,Breakfast,Lunch,Dinner,DailyTotal,Total,StandardHrs,OverTimeHrs,OnsiteHrs,TravelHrs from EmpTimesheet where EmpId=@EmpId ", cn);
cmd.Parameters.Add("EmpId", userid);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "EmpTimesheet");
txt_EmpName.Text = ds.Tables["EmpTimesheet"].Rows[0][0].ToString();
// select EmpName,StartDate,day,date,EndDate,Service,Venue,StartTime,EndTime,Breakfast,Lunch,Dinner,DailyTotal
txt_StartDate.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[0][1]).ToString("MM/dd/yyyy");
txt_EndDate.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[0][2]).ToString("MM/dd/yyyy");
lnkBtnSun.Text = ds.Tables["EmpTimesheet"].Rows[0][3].ToString().Trim();
lbl_sun.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[0][4]).ToString("MM/dd/yyyy");
txt_ServiceSunday.Text = ds.Tables["EmpTimesheet"].Rows[0][5].ToString().Trim();
txt_SunVenue.Text = ds.Tables["EmpTimesheet"].Rows[0][6].ToString().Trim();
txt_SunStartTIme.Text = ds.Tables["EmpTimesheet"].Rows[0][7].ToString().Trim();
txt_SunEndTime.Text = ds.Tables["EmpTimesheet"].Rows[0][8].ToString().Trim();
txt_SunBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[0][9].ToString().Trim();
txt_SunLunch.Text = ds.Tables["EmpTimesheet"].Rows[0][10].ToString().Trim();
txt_SunDinner.Text = ds.Tables["EmpTimesheet"].Rows[0][11].ToString().Trim();
txt_SunServiceHrs.Text = ds.Tables["EmpTimesheet"].Rows[0][12].ToString().Trim();
lnkBtnMon.Text = ds.Tables["EmpTimesheet"].Rows[1][3].ToString().Trim();
lbl_Mon.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[1][4]).ToString("MM/dd/yyyy");
txt_ServiceMonday.Text = ds.Tables["EmpTimesheet"].Rows[1][5].ToString().Trim();
txt_MonVenue.Text = ds.Tables["EmpTimesheet"].Rows[1][6].ToString().Trim();
txt_MonStartEim.Text = ds.Tables["EmpTimesheet"].Rows[1][7].ToString().Trim();
txt_MonEndTime.Text = ds.Tables["EmpTimesheet"].Rows[1][8].ToString().Trim();
txt_MonBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[1][9].ToString().Trim();
txt_MonLun.Text = ds.Tables["EmpTimesheet"].Rows[1][10].ToString().Trim();
txt_MonDinner.Text = ds.Tables["EmpTimesheet"].Rows[1][11].ToString().Trim();
txt_MonServiceHrs.Text = ds.Tables["EmpTimesheet"].Rows[1][12].ToString().Trim();
lnkBtnTues.Text = ds.Tables["EmpTimesheet"].Rows[2][3].ToString().Trim();
lbl_Tue.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[2][4]).ToString("MM/dd/yyyy");
txt_ServiceTuesday.Text = ds.Tables["EmpTimesheet"].Rows[2][5].ToString().Trim();
txt_TueVenue.Text = ds.Tables["EmpTimesheet"].Rows[2][6].ToString().Trim();
txt_TueStartTime.Text = ds.Tables["EmpTimesheet"].Rows[2][7].ToString().Trim();
txt_TuesEndTime.Text = ds.Tables["EmpTimesheet"].Rows[2][8].ToString().Trim();
txt_TueBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[2][9].ToString().Trim();
txt_TueLunch.Text = ds.Tables["EmpTimesheet"].Rows[2][10].ToString().Trim();
txt_TueDinner.Text = ds.Tables["EmpTimesheet"].Rows[2][11].ToString().Trim();
txt_TueServiceHrs.Text = ds.Tables["EmpTimesheet"].Rows[2][12].ToString().Trim();
lnkBtnWed.Text = ds.Tables["EmpTimesheet"].Rows[3][3].ToString().Trim();
lbl_Wed.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[3][4]).ToString("MM/dd/yyyy");
txt_ServiceWednesday.Text = ds.Tables["EmpTimesheet"].Rows[3][5].ToString().Trim();
txt_WedVenue.Text = ds.Tables["EmpTimesheet"].Rows[3][6].ToString().Trim();
txt_WedStartTime.Text = ds.Tables["EmpTimesheet"].Rows[3][7].ToString().Trim();
txt_WedEndTime.Text = ds.Tables["EmpTimesheet"].Rows[3][8].ToString().Trim();
txt_WedBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[3][9].ToString().Trim();
txt_WedLunch.Text = ds.Tables["EmpTimesheet"].Rows[3][10].ToString().Trim();
txt_WedDinner.Text = ds.Tables["EmpTimesheet"].Rows[3][11].ToString().Trim();
txt_WedServiceHrs.Text = ds.Tables["EmpTimesheet"].Rows[3][12].ToString().Trim();
lnkBtnThurs.Text = ds.Tables["EmpTimesheet"].Rows[4][3].ToString().Trim();
lbl_Thu.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[4][4]).ToString("MM/dd/yyyy");
txt_ServiceThursday.Text = ds.Tables["EmpTimesheet"].Rows[4][5].ToString().Trim();
txt_ThursVenue.Text = ds.Tables["EmpTimesheet"].Rows[4][6].ToString().Trim();
txt_ThursStartTime.Text = ds.Tables["EmpTimesheet"].Rows[4][7].ToString().Trim();
txt_ThursEndTime.Text = ds.Tables["EmpTimesheet"].Rows[4][8].ToString().Trim();
txt_ThursBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[4][9].ToString().Trim();
txt_ThursLunch.Text = ds.Tables["EmpTimesheet"].Rows[4][10].ToString().Trim();
txt_ThursDinner.Text = ds.Tables["EmpTimesheet"].Rows[4][11].ToString().Trim();
txt_ThursServiceHrs.Text = ds.Tables["EmpTimesheet"].Rows[4][12].ToString().Trim();
lnkBtnFri.Text = ds.Tables["EmpTimesheet"].Rows[5][3].ToString().Trim();
lbl_Fri.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[5][4]).ToString("MM/dd/yyyy");
txt_ServiceFriday.Text = ds.Tables["EmpTimesheet"].Rows[5][5].ToString().Trim();
txt_FriVenue.Text = ds.Tables["EmpTimesheet"].Rows[5][6].ToString().Trim();
txt_FriStartTime.Text = ds.Tables["EmpTimesheet"].Rows[5][7].ToString().Trim();
txt_FriEndTime.Text = ds.Tables["EmpTimesheet"].Rows[5][8].ToString().Trim();
txt_FriBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[5][9].ToString().Trim();
txt_FriLunch.Text = ds.Tables["EmpTimesheet"].Rows[5][10].ToString().Trim();
txt_FriDinner.Text = ds.Tables["EmpTimesheet"].Rows[5][11].ToString().Trim();
txt_FriServiceHrs.Text = ds.Tables["EmpTimesheet"].Rows[5][12].ToString().Trim();
lnkBtnSat.Text = ds.Tables["EmpTimesheet"].Rows[6][3].ToString().Trim();
//no row at position 6
lbl_sat.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[6][4]).ToString("MM/dd/yyyy");
txt_ServiceSaturday.Text = ds.Tables["EmpTimesheet"].Rows[6][5].ToString().Trim();
txt_SatVenue.Text = ds.Tables["EmpTimesheet"].Rows[6][6].ToString().Trim();
txt_SatStartTime.Text = ds.Tables["EmpTimesheet"].Rows[6][7].ToString().Trim();
txt_SatEndTime.Text = ds.Tables["EmpTimesheet"].Rows[6][8].ToString().Trim();
txt_SatBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[6][9].ToString().Trim();
txt_SatLunch.Text = ds.Tables["EmpTimesheet"].Rows[6][10].ToString().Trim();
txt_SatDinner.Text = ds.Tables["EmpTimesheet"].Rows[6][11].ToString().Trim();
txt_SatServiceHRs.Text = ds.Tables["EmpTimesheet"].Rows[6][12].ToString().Trim();
txt_Total.Text = ds.Tables["EmpTimesheet"].Rows[6][13].ToString().Trim();
txt_standard.Text = ds.Tables["EmpTimesheet"].Rows[6][14].ToString().Trim(); ;
txt_OverTimeHrs.Text = ds.Tables["EmpTimesheet"].Rows[6][15].ToString().Trim(); ;
txt_OnsiteHrsmain.Text = ds.Tables["EmpTimesheet"].Rows[6][16].ToString().Trim(); ;
txt_TravelHrs_Timesheet.Text = ds.Tables["EmpTimesheet"].Rows[6][17].ToString().Trim(); ;
lnkBtnSun.Enabled = true;
lnkBtnMon.Enabled = true;
lnkBtnSat.Enabled = true;
lnkBtnTues.Enabled = true;
lnkBtnWed.Enabled = true;
lnkBtnThurs.Enabled = true;
lnkBtnFri.Enabled = true;
}
lbl_sat.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[6][4]).ToString("MM/dd/yyyy");
txt_ServiceSaturday.Text = ds.Tables["EmpTimesheet"].Rows[6][5].ToString().Trim();
txt_SatVenue.Text = ds.Tables["EmpTimesheet"].Rows[6][6].ToString().Trim();
txt_SatStartTime.Text = ds.Tables["EmpTimesheet"].Rows[6][7].ToString().Trim();
txt_SatEndTime.Text = ds.Tables["EmpTimesheet"].Rows[6][8].ToString().Trim();
txt_SatBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[6][9].ToString().Trim();
txt_SatLunch.Text = ds.Tables["EmpTimesheet"].Rows[6][10].ToString().Trim();
txt_SatDinner.Text = ds.Tables["EmpTimesheet"].Rows[6][11].ToString().Trim();
txt_SatServiceHRs.Text = ds.Tables["EmpTimesheet"].Rows[6][12].ToString().Trim();
txt_Total.Text = ds.Tables["EmpTimesheet"].Rows[6][13].ToString().Trim();
txt_standard.Text = ds.Tables["EmpTimesheet"].Rows[6][14].ToString().Trim(); ;
txt_OverTimeHrs.Text = ds.Tables["EmpTimesheet"].Rows[6][15].ToString().Trim(); ;
txt_OnsiteHrsmain.Text = ds.Tables["EmpTimesheet"].Rows[6][16].ToString().Trim(); ;
txt_TravelHrs_Timesheet.Text = ds.Tables["EmpTimesheet"].Rows[6][17].ToString().Trim(); ;
lnkBtnSun.Enabled = true;
lnkBtnMon.Enabled = true;
lnkBtnSat.Enabled = true;
lnkBtnTues.Enabled = true;
lnkBtnWed.Enabled = true;
lnkBtnThurs.Enabled = true;
lnkBtnFri.Enabled = true;
}
lbl_sat.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[6][4]).ToString("MM/dd/yyyy"); txt_ServiceSaturday.Text = ds.Tables["EmpTimesheet"].Rows[6][5].ToString().Trim(); txt_SatVenue.Text = ds.Tables["EmpTimesheet"].Rows[6][6].ToString().Trim(); txt_SatStartTime.Text = ds.Tables["EmpTimesheet"].Rows[6][7].ToString().Trim(); txt_SatEndTime.Text = ds.Tables["EmpTimesheet"].Rows[6][8].ToString().Trim(); txt_SatBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[6][9].ToString().Trim(); txt_SatLunch.Text = ds.Tables["EmpTimesheet"].Rows[6][10].ToString().Trim(); txt_SatDinner.Text = ds.Tables["EmpTimesheet"].Rows[6][11].ToString().Trim(); txt_SatServiceHRs.Text = ds.Tables["EmpTimesheet"].Rows[6][12].ToString().Trim(); txt_Total.Text = ds.Tables["EmpTimesheet"].Rows[6][13].ToString().Trim(); txt_standard.Text = ds.Tables["EmpTimesheet"].Rows[6][14].ToString().Trim(); ; txt_OverTimeHrs.Text = ds.Tables["EmpTimesheet"].Rows[6][15].ToString().Trim(); ; txt_OnsiteHrsmain.Text = ds.Tables["EmpTimesheet"].Rows[6][16].ToString().Trim(); ; txt_TravelHrs_Timesheet.Text = ds.Tables["EmpTimesheet"].Rows[6][17].ToString().Trim(); ; lnkBtnSun.Enabled = true; lnkBtnMon.Enabled = true; lnkBtnSat.Enabled = true; lnkBtnTues.Enabled = true; lnkBtnWed.Enabled = true; lnkBtnThurs.Enabled = true; lnkBtnFri.Enabled = true; } lbl_sat.Text = Convert.ToDateTime(ds.Tables["EmpTimesheet"].Rows[6][4]).ToString("MM/dd/yyyy"); txt_ServiceSaturday.Text = ds.Tables["EmpTimesheet"].Rows[6][5].ToString().Trim(); txt_SatVenue.Text = ds.Tables["EmpTimesheet"].Rows[6][6].ToString().Trim(); txt_SatStartTime.Text = ds.Tables["EmpTimesheet"].Rows[6][7].ToString().Trim(); txt_SatEndTime.Text = ds.Tables["EmpTimesheet"].Rows[6][8].ToString().Trim(); txt_SatBreakfast.Text = ds.Tables["EmpTimesheet"].Rows[6][9].ToString().Trim(); txt_SatLunch.Text = ds.Tables["EmpTimesheet"].Rows[6][10].ToString().Trim(); txt_SatDinner.Text = ds.Tables["EmpTimesheet"].Rows[6][11].ToString().Trim(); txt_SatServiceHRs.Text = ds.Tables["EmpTimesheet"].Rows[6][12].ToString().Trim(); txt_Total.Text = ds.Tables["EmpTimesheet"].Rows[6][13].ToString().Trim(); txt_standard.Text = ds.Tables["EmpTimesheet"].Rows[6][14].ToString().Trim(); ; txt_OverTimeHrs.Text = ds.Tables["EmpTimesheet"].Rows[6][15].ToString().Trim(); ; txt_OnsiteHrsmain.Text = ds.Tables["EmpTimesheet"].Rows[6][16].ToString().Trim(); ; txt_TravelHrs_Timesheet.Text = ds.Tables["EmpTimesheet"].Rows[6][17].ToString().Trim(); ; lnkBtnSun.Enabled = true; lnkBtnMon.Enabled = true; lnkBtnSat.Enabled = true; lnkBtnTues.Enabled = true; lnkBtnWed.Enabled = true; lnkBtnThurs.Enabled = true; lnkBtnFri.Enabled = true; }
推荐答案
The Rows collection has a Count property. Wrap your code inside if statements that only execute if the row count says you have the row.
The Rows collection has a Count property. Wrap your code inside if statements that only execute if the row count says you have the row.
这篇关于数据集位置异常没有行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!