protected void grdContact_RowUpdating(object sender, GridViewUpdateEventArgs e) { ContactTableAdapter contact = new ContactTableAdapter(); //bool flag = false; int index = GridView1.EditIndex; GridViewRow row = GridView1.Rows[index]; TextBox id = row.FindControl("TextBox1") as TextBox; TextBox roomno = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox2"); TextBox floorno = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox3"); TextBox timefrom = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox4"); TextBox timeto = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox5"); //TextBox txtName = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtName"); //CheckBox chkActive = // (CheckBox)GridView1.Rows[e.RowIndex].FindControl("chkActive"); //DropDownList cmbType = // (DropDownList)GridView1.Rows[e.RowIndex].FindControl("cmbType"); //DropDownList ddlSex = // (DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlSex"); //if (chkActive.Checked) flag = true; else flag = false; contact.Update(Convert.ToInt32(id.Text), Convert.ToInt32(roomno.Text), Convert.ToInt32(floorno.Text), Convert.ToInt32(timefrom.Text), Convert.ToInt32(timeto.Text)); GridView1.EditIndex = -1; FillGrid(); }
/* * protected void OnRowDataBound(object sender, GridViewRowEventArgs e) * { * if (e.Row.RowType == DataControlRowType.DataRow) * { * //Find the DropDownList in the Row * DropDownList ddlCountries = (e.Row.FindControl("ddlCountries") as DropDownList); * ddlCountries.DataSource = GetData("SELECT * from numbers"); * ddlCountries.DataTextField = "timefromddl"; * ddlCountries.DataValueField = "timefromddl"; * ddlCountries.DataBind(); * * //Add Default Item in the DropDownList * ddlCountries.Items.Insert(0, new ListItem("Please select")); * * //Select the Country of Customer in DropDownList * string country = (e.Row.FindControl("lbltimefrom") as Label).Text; * ddlCountries.Items.FindByValue(country).Selected = true; * } * } */ protected void grdContact_RowCommand(object sender, GridViewCommandEventArgs e) { ContactTableAdapter contact = new ContactTableAdapter(); //bool flag = false; if (e.CommandName.Equals("Insert")) { //TextBox txtNewName = // (TextBox)GridView1.FooterRow.FindControl("txtNewName"); //CheckBox chkNewActive = // (CheckBox)GridView1.FooterRow.FindControl("chkNewActive"); //DropDownList cmbNewType = // (DropDownList)GridView1.FooterRow.FindControl("cmbNewType"); //DropDownList ddlNewSex = // (DropDownList)GridView1.FooterRow.FindControl("ddlNewSex"); //if (chkNewActive.Checked) flag = true; else flag = false; TextBox id = (TextBox)GridView1.FooterRow.FindControl("insertid"); //TextBox roomno = (TextBox)GridView1.FooterRow.FindControl("insertroomno"); DropDownList roomno = (DropDownList)GridView1.FooterRow.FindControl("insertroomno"); // TextBox floorno = (TextBox)GridView1.FooterRow.FindControl("insertfloorno"); DropDownList floorno = (DropDownList)GridView1.FooterRow.FindControl("insertfloorno"); TextBox timefrom = (TextBox)GridView1.FooterRow.FindControl("inserttimefrom"); TextBox timeto = (TextBox)GridView1.FooterRow.FindControl("inserttimeto"); //TextBox txtName = (TextBox)GridView1.HeaderRow.FindControl("txtName"); //contact.Insert(txtNewName.Text, ddlNewSex.SelectedValue, // cmbNewType.SelectedValue, flag); contact.Insert(Convert.ToInt32(id.Text), Convert.ToInt32(roomno.SelectedValue.ToString()), Convert.ToInt32(floorno.SelectedValue.ToString()), Convert.ToInt32(timefrom.Text), Convert.ToInt32(timeto.Text)); FillGrid(); } }
protected void grdContact_RowDeleting(object sender, GridViewDeleteEventArgs e) { string bookingid = GridView1.DataKeys[e.RowIndex].Values["bookingid"].ToString(); ContactTableAdapter contact = new ContactTableAdapter(); int id = Convert.ToInt32(bookingid); contact.Delete(id); FillGrid(); }
public void FillGrid() { ContactTableAdapter contact = new ContactTableAdapter(); DataSet contacts = contact.GetData("select id,roomno,floorno,timefrom,timeto,bookingid from booking"); if (contacts.Tables[0].Rows.Count > 0) { GridView1.DataSource = contacts; GridView1.DataBind(); } else { contacts.Tables[0].Rows.Add(contacts.Tables[0].NewRow()); GridView1.DataSource = contacts; GridView1.DataBind(); int TotalColumns = GridView1.Rows[0].Cells.Count; GridView1.Rows[0].Cells.Clear(); GridView1.Rows[0].Cells.Add(new TableCell()); GridView1.Rows[0].Cells[0].ColumnSpan = TotalColumns; GridView1.Rows[0].Cells[0].Text = "No Record Found"; } }
protected void grdContact_RowDataBound(object sender, GridViewRowEventArgs e) { //ContactTypeTableAdapter contactType = new ContactTypeTableAdapter(); //DataTable contactTypes = contactType.GetData(); //if (e.Row.RowType == DataControlRowType.DataRow) //{ // Label lblType = (Label)e.Row.FindControl("lblType"); // if (lblType != null) // { // int typeId = Convert.ToInt32(lblType.Text); // lblType.Text = (string)contactType.GetTypeById(typeId); // } // DropDownList cmbType = (DropDownList)e.Row.FindControl("cmbType"); // if (cmbType != null) // { // cmbType.DataSource = contactTypes; // cmbType.DataTextField = "TypeName"; // cmbType.DataValueField = "Id"; // cmbType.DataBind(); // cmbType.SelectedValue = // grdContact.DataKeys[e.Row.RowIndex].Values[1].ToString(); // } //} //if (e.Row.RowType == DataControlRowType.Footer) //{ // DropDownList cmbNewType = (DropDownList)e.Row.FindControl("cmbNewType"); // cmbNewType.DataSource = contactTypes; // cmbNewType.DataBind(); //} if (e.Row.RowType == DataControlRowType.DataRow) { string bookingid = Convert.ToString(DataBinder.Eval(e.Row.DataItem, "bookingid")); Button lnkbtnresult = (Button)e.Row.FindControl("ButtonDelete"); if (lnkbtnresult != null) { lnkbtnresult.Attributes.Add("onclick", "javascript:return deleteConfirm('" + bookingid + "')"); } } if (e.Row.RowType == DataControlRowType.Footer) { DropDownList ddList = (DropDownList)e.Row.FindControl("insertfloorno"); ContactTableAdapter contact = new ContactTableAdapter(); //return DataTable havinf department data DataTable dt = contact.GetFloors(); ddList.DataSource = dt; ddList.DataTextField = "floorno"; ddList.DataValueField = "floorno"; ddList.DataBind(); //DataRowView dr = e.Row.DataItem as DataRowView; //ddList.SelectedValue = dr["insertroomno"].ToString(); } //ContactTableAdapter contact = new ContactTableAdapter(); //if (e.Row.RowType == DataControlRowType.DataRow) //{ //GridView1.DataBind(); //Find the DropDownList in the Row //if (Convert.ToInt32(e.Row.Cells[0].Text) < 10000) //{ // e.Row.BackColor = System.Drawing.Color.AliceBlue; //} //} }