Website development for marina intergrated with visual studio using C sharp formatting
Popeye Marina/boat.xml
101 ABC IT Skyline 102 BCA Business Abs 103 DDDD Business
Popeye Marina/cs.txt
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack == true) { Get_Xml(); } } void Get_Xml() { DataSet ds = new DataSet(); ds.ReadXml(Server.MapPath("~/Studentdata.xml")); if (ds != null && ds.HasChanges()) { XmlGridView.DataSource = ds; XmlGridView.DataBind(); } else { XmlGridView.DataBind(); } } // Step 7: Now, we perform the insert event by executing the code as shown below: protected void BtnInsert_Click(object sender, EventArgs e) { Insert_XML(); } void Insert_XML() { TextBox Stu_Id = XmlGridView.FooterRow.FindControl("TxtStuID") as TextBox; TextBox Stu_Name = XmlGridView.FooterRow.FindControl("TxtStuName") as TextBox; TextBox Stu_Course = XmlGridView.FooterRow.FindControl("TxtStuCourse") as TextBox; TextBox Stu_College = XmlGridView.FooterRow.FindControl("TxtStuCollege") as TextBox; XmlDocument MyXmlDocument = new XmlDocument(); MyXmlDocument.Load(Server.MapPath("~/student.xml")); XmlElement ParentElement = MyXmlDocument.CreateElement("Student"); XmlElement ID = MyXmlDocument.CreateElement("ID"); ID.InnerText = Stu_Id.Text; XmlElement Name = MyXmlDocument.CreateElement("Name"); Name.InnerText = Stu_Name.Text; XmlElement Course = MyXmlDocument.CreateElement("Course"); Course.InnerText = Stu_Course.Text; XmlElement College = MyXmlDocument.CreateElement("College"); College.InnerText = Stu_College.Text; ParentElement.AppendChild(ID); ParentElement.AppendChild(Name); ParentElement.AppendChild(Course); ParentElement.AppendChild(College); MyXmlDocument.DocumentElement.AppendChild(ParentElement); MyXmlDocument.Save(Server.MapPath("~/student.xml")); Get_Xml(); } // Step 8: Performing the Edit, Update and Delete operations: •Edit protected void XmlGridView_RowEditing(object sender, GridViewEditEventArgs e) { XmlGridView.EditIndex = e.NewEditIndex; Get_Xml(); } protected void XmlGridView_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { XmlGridView.EditIndex = -1; Get_Xml(); }• Update protected void XmlGridView_RowUpdating(object sender, GridViewUpdateEventArgs e) { int id = XmlGridView.Rows[e.RowIndex].DataItemIndex; TextBox Name = XmlGridView.Rows[e.RowIndex].FindControl("TxtEditStuName") as TextBox; TextBox Course = XmlGridView.Rows[e.RowIndex].FindControl("TxtEditStuCourse") as TextBox; TextBox College = XmlGridView.Rows[e.RowIndex].FindControl("TxtEditStuCollege") as TextBox; XmlGridView.EditIndex = -1; Get_Xml(); DataSet ds = XmlGridView.DataSource as DataSet; ds.Tables[0].Rows[id]["Name"] = Name.Text; ds.Tables[0].Rows[id]["Course"] = Course.Text; ds.Tables[0].Rows[id]["College"] = College.Text; ds.WriteXml(Server.MapPath("~/student.xml")); Get_Xml(); }• Delete protected void XmlGridView_RowDeleting(object sender, GridViewDeleteEventArgs e) { Get_Xml(); DataSet ds = XmlGridView.DataSource as DataSet; ds.Tables[0].Rows[XmlGridView.Rows[e.RowIndex].DataItemIndex].Delete(); ds.WriteXml(Server.MapPath("~/student.xml")); Get_Xml(); }
Popeye Marina/customer.xml
101 ABC IT Skyline 102 BCA Business Abs 103 DDDD Business
Popeye Marina/html.txt
<table> <tr> <td> <asp:GridView ID="XmlGridView" runat="server" AutoGenerateColumns="false" Height="247px" Width="795px" BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Vertical" ShowFooter="true" OnRowCancelingEdit="XmlGridView_RowCancelingEdit" OnRowDeleting="XmlGridView_RowDeleting" OnRowEditing="XmlGridView_RowEditing" OnRowUpdating="XmlGridView_RowUpdating"> <AlternatingRowStyle BackColor="#DCDCDC" /> <Columns> <asp:TemplateField HeaderText="ID"> <ItemTemplate> <asp:Label ID="LblStuID" runat="server" Text='<%# Bind("ID")%>'></asp:Label> </ItemTemplate> <FooterTemplate> <asp:TextBox ID="TxtStuID" runat="server"></asp:TextBox> </FooterTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Name"> <ItemTemplate> <asp:Label ID="LblStuName" runat="server" Text='<%# Bind("Name") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="TxtEditStuName" runat="server"></asp:TextBox> </EditItemTemplate> <FooterTemplate> <asp:TextBox ID="TxtStuName" runat="server"></asp:TextBox> </FooterTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Course"> <ItemTemplate> <asp:Label ID="LblStuCourse" runat="server" Text='<%# Bind("Course") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="TxtEditStuCourse" runat="server"></asp:TextBox> </EditItemTemplate> <FooterTemplate> <asp:TextBox ID="TxtStuCourse" runat="server"></asp:TextBox> </FooterTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="College"> <ItemTemplate> <asp:Label ID="LblStuCollege" runat="server" Text='<%# Bind("College") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="TxtEditStuCollege" runat="server"></asp:TextBox> </EditItemTemplate> <FooterTemplate> <asp:TextBox ID="TxtStuCollege" runat="server"></asp:TextBox> </FooterTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Operations"> <ItemTemplate> <asp:Button ID="BtnEdit" runat="server" CommandName="Edit" Text="Edit" /> <asp:Button ID="BtnDelete" runat="server" CommandName="Delete" Text="Delete" /> </ItemTemplate> <EditItemTemplate> <asp:Button ID="BthUpdate" runat="server" CommandName="Update" Text="Update" /> <asp:Button ID="BtnCancel" runat="server" CommandName="Cancel" Text="Cancel" /> </EditItemTemplate> <FooterTemplate> <asp:Button ID="BtnInsert" runat="server" Text="Insert" OnClick="BtnInsert_Click" /> </FooterTemplate> </asp:TemplateField> </Columns> <FooterStyle BackColor="#CCCCCC" ForeColor="Black" /> <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" /> <RowStyle BackColor="#EEEEEE" ForeColor="Black" /> <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" /> <SortedAscendingCellStyle BackColor="#F1F1F1" /> <SortedAscendingHeaderStyle BackColor="#0000A9" /> <SortedDescendingCellStyle BackColor="#CAC9C9" /> <SortedDescendingHeaderStyle BackColor="#000065" /> </asp:GridView> </td> </tr> </table> <table> <tr> <td> <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="false" Height="247px" Width="795px" BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Vertical" ShowFooter="true" OnRowCancelingEdit="XmlGridView_RowCancelingEdit" OnRowDeleting="XmlGridView_RowDeleting" OnRowEditing="XmlGridView_RowEditing" OnRowUpdating="XmlGridView_RowUpdating"> <AlternatingRowStyle BackColor="#DCDCDC" /> <Columns> <asp:TemplateField HeaderText="SlipID"> <ItemTemplate> <asp:Label ID="LblSlipID" runat="server" Text='<%# Bind("SlipID")%>'></asp:Label> </ItemTemplate> <FooterTemplate> <asp:TextBox ID="TxtSlipID" runat="server"></asp:TextBox> </FooterTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="SlipName"> <ItemTemplate> <asp:Label ID="LblSlipName" runat="server" Text='<%# Bind("SlipName") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="TxtEditSlipName" runat="server"></asp:TextBox> </EditItemTemplate> <FooterTemplate> <asp:TextBox ID="TxtSlipName" runat="server"></asp:TextBox> </FooterTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Operations"> <ItemTemplate> <asp:Button ID="BtnEdit" runat="server" CommandName="Edit" Text="Edit" /> <asp:Button ID="BtnDelete" runat="server" CommandName="Delete" Text="Delete" /> </ItemTemplate> <EditItemTemplate> <asp:Button ID="BthUpdate" runat="server" CommandName="Update" Text="Update" /> <asp:Button ID="BtnCancel" runat="server" CommandName="Cancel" Text="Cancel" /> </EditItemTemplate> <FooterTemplate> <asp:Button ID="BtnInsert" runat="server" Text="Insert" OnClick="BtnInsert_Click" /> </FooterTemplate> </asp:TemplateField> </Columns> <FooterStyle BackColor="#CCCCCC" ForeColor="Black" /> <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" /> <RowStyle BackColor="#EEEEEE" ForeColor="Black" /> <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" /> <SortedAscendingCellStyle BackColor="#F1F1F1" /> <SortedAscendingHeaderStyle BackColor="#0000A9" /> <SortedDescendingCellStyle BackColor="#CAC9C9" /> <SortedDescendingHeaderStyle BackColor="#000065" /> </asp:GridView> </td> </tr> </table> <table> <tr> <td> <asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="false" Height="247px" Width="795px" BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Vertical" ShowFooter="true" OnRowCancelingEdit="XmlGridView_RowCancelingEdit" OnRowDeleting="XmlGridView_RowDeleting" OnRowEditing="XmlGridView_RowEditing" OnRowUpdating="XmlGridView_RowUpdating"> <AlternatingRowStyle BackColor="#DCDCDC" /> <Columns> <asp:TemplateField HeaderText="ID"> <ItemTemplate> <asp:Label ID="LblStuID" runat="server" Text='<%# Bind("ID")%>'></asp:Label> </ItemTemplate> <FooterTemplate> <asp:TextBox ID="TxtStuID" runat="server"></asp:TextBox> </FooterTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Name"> <ItemTemplate> <asp:Label ID="LblStuName" runat="server" Text='<%# Bind("Name") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="TxtEditStuName" runat="server"></asp:TextBox> </EditItemTemplate> <FooterTemplate> <asp:TextBox ID="TxtStuName" runat="server"></asp:TextBox> </FooterTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Course"> <ItemTemplate> <asp:Label ID="LblStuCourse" runat="server" Text='<%# Bind("Course") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="TxtEditStuCourse" runat="server"></asp:TextBox> </EditItemTemplate> <FooterTemplate> <asp:TextBox ID="TxtStuCourse" runat="server"></asp:TextBox> </FooterTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="College"> <ItemTemplate> <asp:Label ID="LblStuCollege" runat="server" Text='<%# Bind("College") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="TxtEditStuCollege" runat="server"></asp:TextBox> </EditItemTemplate> <FooterTemplate> <asp:TextBox ID="TxtStuCollege" runat="server"></asp:TextBox> </FooterTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Operations"> <ItemTemplate> <asp:Button ID="BtnEdit" runat="server" CommandName="Edit" Text="Edit" /> <asp:Button ID="BtnDelete" runat="server" CommandName="Delete" Text="Delete" /> </ItemTemplate> <EditItemTemplate> <asp:Button ID="BthUpdate" runat="server" CommandName="Update" Text="Update" /> <asp:Button ID="BtnCancel" runat="server" CommandName="Cancel" Text="Cancel" /> </EditItemTemplate> <FooterTemplate> <asp:Button ID="BtnInsert" runat="server" Text="Insert" OnClick="BtnInsert_Click" /> </FooterTemplate> </asp:TemplateField> </Columns> <FooterStyle BackColor="#CCCCCC" ForeColor="Black" /> <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" /> <RowStyle BackColor="#EEEEEE" ForeColor="Black" /> <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" /> <SortedAscendingCellStyle BackColor="#F1F1F1" /> <SortedAscendingHeaderStyle BackColor="#0000A9" /> <SortedDescendingCellStyle BackColor="#CAC9C9" /> <SortedDescendingHeaderStyle BackColor="#000065" /> </asp:GridView> </td> </tr> </table> <table> <tr> <td> <asp:GridView ID="GridView4" runat="server" AutoGenerateColumns="false" Height="247px" Width="795px" BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Vertical" ShowFooter="true" OnRowCancelingEdit="XmlGridView_RowCancelingEdit" OnRowDeleting="XmlGridView_RowDeleting" OnRowEditing="XmlGridView_RowEditing" OnRowUpdating="XmlGridView_RowUpdating"> <AlternatingRowStyle BackColor="#DCDCDC" /> <Columns> <asp:TemplateField HeaderText="ID"> <ItemTemplate> <asp:Label ID="LblStuID" runat="server" Text='<%# Bind("ID")%>'></asp:Label> </ItemTemplate> <FooterTemplate> <asp:TextBox ID="TxtStuID" runat="server"></asp:TextBox> </FooterTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Name"> <ItemTemplate> <asp:Label ID="LblStuName" runat="server" Text='<%# Bind("Name") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="TxtEditStuName" runat="server"></asp:TextBox> </EditItemTemplate> <FooterTemplate> <asp:TextBox ID="TxtStuName" runat="server"></asp:TextBox> </FooterTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Course"> <ItemTemplate> <asp:Label ID="LblStuCourse" runat="server" Text='<%# Bind("Course") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="TxtEditStuCourse" runat="server"></asp:TextBox> </EditItemTemplate> <FooterTemplate> <asp:TextBox ID="TxtStuCourse" runat="server"></asp:TextBox> </FooterTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="College"> <ItemTemplate> <asp:Label ID="LblStuCollege" runat="server" Text='<%# Bind("College") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="TxtEditStuCollege" runat="server"></asp:TextBox> </EditItemTemplate> <FooterTemplate> <asp:TextBox ID="TxtStuCollege" runat="server"></asp:TextBox> </FooterTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Operations"> <ItemTemplate> <asp:Button ID="BtnEdit" runat="server" CommandName="Edit" Text="Edit" /> <asp:Button ID="BtnDelete" runat="server" CommandName="Delete" Text="Delete" /> </ItemTemplate> <EditItemTemplate> <asp:Button ID="BthUpdate" runat="server" CommandName="Update" Text="Update" /> <asp:Button ID="BtnCancel" runat="server" CommandName="Cancel" Text="Cancel" /> </EditItemTemplate> <FooterTemplate> <asp:Button ID="BtnInsert" runat="server" Text="Insert" OnClick="BtnInsert_Click" /> </FooterTemplate> </asp:TemplateField> </Columns> <FooterStyle BackColor="#CCCCCC" ForeColor="Black" /> <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" /> <RowStyle BackColor="#EEEEEE" ForeColor="Black" /> <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" /> <SortedAscendingCellStyle BackColor="#F1F1F1" /> <SortedAscendingHeaderStyle BackColor="#0000A9" /> <SortedDescendingCellStyle BackColor="#CAC9C9" /> <SortedDescendingHeaderStyle BackColor="#000065" /> </asp:GridView> </td> </tr> </table>
Popeye Marina/slip.xml
101 ABC IT Skyline 102 BCA Business Abs 103 DDDD Business
Popeye Marina/students.xml
101 ABC IT Skyline 102 BCA Business Abs 103 DDDD Business