Two table with relation in foreign key out grid view

Question

Table one product_mainid product_mainname Product_home country Table Two product_mainid product_subproduct product_price product_quantity Product_manufacture Here for example Table One product_mainname id =1 product_mainname = colgate Product_home country=India Table Two product_mainid foriegn key from table one product_subproduct=brush product_price=20rs product_quantity=10 Product_manufacture=india How to relate with primary and foriegn key and in one page while loading a page the second table will showing in grid view and the output after clicking the button will show the another grid view in bottom i will attach the output format for your convience.

newto net · Answer

Thanks for your quick help can you help me to step by step process buddy. So that i can understanding the process of your coding.

Satyapriya Nayak · Answer

Hi New to net Try this... Run the attachments. Untitled Page 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 System.Data.SqlClient; namespace WebApplication4 { public partial class first : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; SqlCommand com; string str; protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { bindgrid(); } } void bindgrid() { SqlConnection con = new SqlConnection(connStr); con.Open(); str = select * from t1; com = new SqlCommand(str con); SqlDataReader reader; reader = com.ExecuteReader(); GridView1.DataSource = reader; GridView1.DataBind(); reader.Close(); con.Close(); } } } Untitled Page 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 System.Data.SqlClient; namespace WebApplication4 { public partial class second : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; SqlCommand com; string str s1; protected void Page_Load(object sender EventArgs e) { SqlConnection con = new SqlConnection(connStr); con.Open(); s1 = Request.QueryString[0].ToString(); str = select * from t2 where product_mainid=' + s1 + '; com = new SqlCommand(str con); SqlDataReader reader; reader = com.ExecuteReader(); GridView2.DataSource = reader; GridView2.DataBind(); reader.Close(); con.Close(); } } } Thanks