using single gridview to display many tables from SQL

Question

Hi friends I have city_mastercountry_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 dataupdatedeleted 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

Nethra R S · Answer

The file i attached redirects user to another post. So i am pasting the code behin and HTML source plzz oblige =========================================================== HTML SOURCE: 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> --%> onclick=btnAddRow_Click /> City Category State Country Designation Address ========================================================= 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; } }