How to bind two table in gridview in asp.net

Question

hello i want to bind two table in gridview and both table are same the problme is my database is not correct developed so i have only one solution is i have pass value by c# code in my query and get one by one table its good working for me I dont have permission to change database any thing so i just do my best effort in my c# code now i have two or more table save column like table1 jan feb mar ............................dec table2 jan feb mar .........................dec so how i bind these two table in one gridview or we can do if we add these two table in one dataset its possible so give me idea thanks

Dharmesh sharma · Answer

i dont your any sql ....... or diff table come its come in one code like DataTable dt = conn.Get_Menu_list(Session[res_ownerid].ToString()); DataSet ds = new DataSet(comment); if (dt != null && dt.Rows.Count > 0) { int col = dt.Columns.Count; for (int i = 0; i { DataRow dr = dt.Rows[i]; DataTable dtcomment = conn.Get_comment_report_menuwise(Convert.ToInt32(dr[restaurant_owner_id].ToString()) Convert.ToInt32(dr[id].ToString())); ds.Tables.Add(dtcomment); } } GridView6.DataSource = ds; GridView6.DataBind(); this code we do but some error here DataTable already belongs to another DataSet. so how to create a dynemic table name cose one table add and another table not add thanks

Satyapriya Nayak · Answer

Hi Dharmesh Untitled Page using System; 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; public partial class _Default : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; SqlCommand com; SqlDataAdapter sqlda; DataSet ds1; DataSet ds2; 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 table1 ; com = new SqlCommand(str con); sqlda = new SqlDataAdapter(com); ds1 = new DataSet(); sqlda.Fill(ds1); str = select * from table2 ; com = new SqlCommand(str con); sqlda = new SqlDataAdapter(com); ds2 = new DataSet(); sqlda.Fill(ds2); ds1.Merge(ds2); GridView1.DataSource = ds1.Tables[0].DefaultView; GridView1.DataBind(); con.Close(); } } Thanks

Pravin More · Answer

hi Dharmesh if both the tables have same structure then you can union them in query. select * from table1 union select * from table2 execute above query from your code.so you will get it in 1 dataset(datatable) bind it to gridview. Thanks Pravin.