using single gridview to display many tables from SQL

Question

Hi friends,

I have city_master,country_master etc tables in sql. I am loading data from these tables based on selection made (ie if city is selected data from city_master/if country is selected data from country_master) will be displayed. I also have to insert data,update,deleted from Gridview. Want to write methods in a .cs file to handle this. But not getting an idea how to do as i am just a beginner and not strong in OOPS. Plzz help

Have attached the file  .. plzz help

Answer 1

The file i attached redirects user to another post. So i am pasting the code behin and HTML source plzz oblige
===========================================================
HTML SOURCE:
<%@ Page Language="C#" MasterPageFile="~/Home.master" AutoEventWireup="true" CodeFile="frmAddress.aspx.cs" Inherits="frmAddress" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server"></asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
  <asp:Panel ID="pnldetails" runat="server" Width="800px">
  <h4 style="background-color:#FFB111; width:800px">
  <asp:Label ID="lbltitle" runat="server" Text="Label"></asp:Label>
  </h4>
  <asp:Panel ID="pnlAddress" runat="server">
  <asp:GridView ID="GVDetails" runat="server" AutoGenerateColumns="False"
  AutoGenerateEditButton="True" BackColor="White" CellPadding="3"
  GridLines="Vertical" PageSize="30" Width="700px"
  onpageindexchanging="GVDetails_PageIndexChanging"
  onrowcancelingedit="GVDetails_RowCancelingEdit"
  onrowdeleting="GVDetails_RowDeleting" onrowediting="GVDetails_RowEditing"
  onrowupdating="GVDetails_RowUpdating">
  <%--<Columns>
  <asp:BoundField DataField="ID" HeaderText="ID" ReadOnly="true" />
  <asp:BoundField DataField="Name" HeaderText="Name" />
  </Columns>--%>
  <HeaderStyle BackColor="#336699" ForeColor="White" />
  <AlternatingRowStyle BackColor="#FFCC66" />
  </asp:GridView>
  <asp:Button ID="btnAddRow" Text="Add New Row" runat="server"
  onclick="btnAddRow_Click" />
  </asp:Panel>
  </asp:Panel>
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="cphsubmenu" runat="server">
  <ul>
<li><a href="frmAddress.aspx?type=city">City</a></li>
<li><a href="frmAddress.aspx?type=category">Category</a></li>
<li><a href="frmAddress.aspx?type=state">State</a></li>
<li><a href="frmAddress.aspx?type=country">Country</a></li>
<li><a href="frmAddress.aspx?type=designation">Designation</a></li>
<li><a href="frmContacts.aspx">Address</a></li>
<li><a href="frmAddress.aspx"></a></li>
<li><a href="frmAddress.aspx"></a></li>

</ul>
</asp:Content>
=========================================================
CODE BEHIND
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using ERMS;

public partial class frmAddress : System.Web.UI.Page
{
  string menuType;
  GblDefinition obj = new GblDefinition();
  protected void Page_Load(object sender, EventArgs e)
  {
  menuType = Request.QueryString["type"];
  if (!Page.IsPostBack)
  {
  if (menuType == "city")
  {
  lbltitle.Text = "City Details";
 
  BoundField field = new BoundField();
  field.DataField = "cityid";
  field.HeaderText = "City ID";
  DataControlField col = field;
  GVDetails.Columns.Add(col);

  field = new BoundField();
  field.DataField = "cityname";
  field.HeaderText = "City";
  col = field;
  GVDetails.Columns.Add(col);

  DataSet ds1 = obj.LoadDataSet("Select * from city_master");
  GVDetails.DataSource = ds1.Tables[0];
  GVDetails.DataBind();
 
  }
  else if (menuType == "state")
  {
  lbltitle.Text = "State Details";
  BoundField field = new BoundField();
  field.DataField = "stateid";
  field.HeaderText = "State ID";
  DataControlField col = field;
  GVDetails.Columns.Add(col);

  field = new BoundField();
  field.DataField = "statename";
  field.HeaderText = "State";
  col = field;
  GVDetails.Columns.Add(col);


  DataSet ds2 = obj.LoadDataSet("select * from state_master");
  GVDetails.DataSource=ds2.Tables[0];
  GVDetails.DataBind();
  }
  else if(menuType=="country")
  {
  lbltitle.Text = "Country Details";
  BoundField field = new BoundField();
  field.HeaderText = "Country ID";
  field.DataField = "countryid";
  DataControlField col = field;
  GVDetails.Columns.Add(col);

  field = new BoundField();
  field.DataField = "countryname";
  field.HeaderText = "Country";
  col = field;
  GVDetails.Columns.Add(col);

  DataSet ds3 = obj.LoadDataSet("select * from country_master");
  GVDetails.DataSource=ds3.Tables[0];
  GVDetails.DataBind();
  }
  else if(menuType=="category")
  {
  lbltitle.Text = "Category Details";
  BoundField field = new BoundField();
  field.HeaderText = "Category ID";
  field.DataField = "categoryid";
  DataControlField col = field;
  GVDetails.Columns.Add(col);

  field = new BoundField();
  field.DataField = "categoryname";
  field.HeaderText = "Category";
  col = field;
  GVDetails.Columns.Add(col);

  DataSet ds4 = obj.LoadDataSet("select * from category_master");
  GVDetails.DataSource=ds4.Tables[0];
  GVDetails.DataBind();
  }
  else if(menuType=="designation")
  {
  lbltitle.Text = "Desination Details";
  BoundField field = new BoundField();
  field.HeaderText = "Designation ID";
  field.DataField = "designationid";
  DataControlField col = field;
  GVDetails.Columns.Add(col);

  field = new BoundField();
  field.HeaderText = "Designation";
  field.DataField = "designation";
  col = field;
  GVDetails.Columns.Add(col);

  DataSet ds5 = obj.LoadDataSet("select * from designation_master");
  GVDetails.DataSource=ds5.Tables[0];
  GVDetails.DataBind();
  }
  }
  }
  protected void btnAddRow_Click(object sender, EventArgs e)
  {
 
  ((LinkButton)GVDetails.Rows[0].Cells[0].Controls[0]).Text = "insert";
  }
  protected void GVDetails_RowDeleting(object sender, GridViewDeleteEventArgs e)
  {

  }
  protected void GVDetails_RowUpdating(object sender, GridViewUpdateEventArgs e)
  {

  }
  protected void GVDetails_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
  {
  GVDetails.EditIndex = -1;
  }
  protected void GVDetails_PageIndexChanging(object sender, GridViewPageEventArgs e)
  {
  GVDetails.PageIndex = e.NewPageIndex;
  }
  protected void GVDetails_RowEditing(object sender, GridViewEditEventArgs e)
  {
  GVDetails.EditIndex = e.NewEditIndex;
  }
}