My data in not displaying in my grid

Hi Sumaira,

Run the attachments.


No need to create mainsurgery table.You create a relation in surg and patientsurgery table.

Add a column as patient surgery id in surg table.


Try this...


<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="surgery.aspx.cs" Inherits="Gridview_joins.surgery" %>





   


   

   

   
 
       
    
       
             
         
   
     
       
       
       

        

          
   
                     
        
   
                     
        
   
        

                      Width="91px">
             ecce
             lid
             yag
        
   
              
                      Height="16px" Width="101px">
             ecce-001
             lid-002
             yag-003
        
   
              
                      Height="16px" Width="101px">
             ecce
             lid
             yag
        
   
          
                      Width="49px" />
     
        
        

        

        

        
        
   
   

   

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 Gridview_joins
{
    public partial class surgery : System.Web.UI.Page
    {
        string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        SqlCommand com;
        SqlDataAdapter sqlda;
        DataSet ds;
        string str;
        protected void Page_Load(object sender, EventArgs e)
        {
            load_grid();
        }

        protected void Btn_add_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(connStr);
            con.Open();
            str = "insert into [surg]([surgery id],[patient surgery id],[surgery name],[charges],[type id],[type name])values('" + TextBox_surgery_id.Text + "','" + TextBox_patient_surgery_id.Text + "','" + DropDownList_surgery_name.Text + "','" + TextBox_surgery_charges.Text + "','" + DropDownList_surgery_type_id.SelectedItem.Text + "','" + DropDownList_surgery_type_name.SelectedItem.Text + "')";
            com = new SqlCommand(str, con);
            com.ExecuteNonQuery();
            con.Close();
            load_grid();
        }
        public void load_grid()
        {
            SqlConnection con = new SqlConnection(connStr);
            con.Open();
            str = "select * from [surg]";
            com = new SqlCommand(str, con);
            sqlda = new SqlDataAdapter(com);
            ds = new DataSet();
            sqlda.SelectCommand = com;
            sqlda.Fill(ds);
            GridView_show_surgery.DataSource = ds;
            GridView_show_surgery.DataBind();
        }

        protected void btn_show_Click(object sender, EventArgs e)
        {
            load_grid();
        }
    }
}


<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="patient_surgery.aspx.cs" Inherits="Gridview_joins.patient_surgery" %>





   


   

   

   
   
       
    
       
    
       
   
       
 
       
       

       

           
         
  
       
 
       

       
       
   

   

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 Gridview_joins
{
    public partial class patient_surgery : System.Web.UI.Page
    {
        string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        SqlCommand com;
        SqlDataAdapter sqlda;
        DataSet ds;
        string str;
        protected void Page_Load(object sender, EventArgs e)
        {
            load_grid();
        }

        protected void Btn_add_Click(object sender, EventArgs e)
        {

            SqlConnection con = new SqlConnection(connStr);
            con.Open();
            str = "insert into [patientsurgery]([patient surgery id],[pv id],[patient charges])values('" + TextBox_patient_surgery_id.Text + "','" + TextBox_pv_id.Text + "'," + TextBox_patient_charges.Text + ")";
            com = new SqlCommand(str, con);
            com.ExecuteNonQuery();
            con.Close();
            load_grid();

        }

        protected void Btn_show_Click(object sender, EventArgs e)
        {
            load_grid();
        }
        public void load_grid()
        {
            SqlConnection con = new SqlConnection(connStr);
            con.Open();
            str = "select * from [patientsurgery]";
            com = new SqlCommand(str, con);
            sqlda = new SqlDataAdapter(com);
            ds = new DataSet();
            sqlda.SelectCommand = com;
            sqlda.Fill(ds);
            GridView_patient_surgery.DataSource = ds;
            GridView_patient_surgery.DataBind();
        }
    }
}


<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Gridview_joins._Default" %>





   


   

   

   
   
   

   

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 Gridview_joins
{
    public partial class _Default : System.Web.UI.Page
    {
        string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        SqlCommand com;
        SqlDataAdapter sqlda;
        DataSet ds;
        string str;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                bindgrid();
            }
        }
        public void bindgrid()
        {

            SqlConnection con = new SqlConnection(connStr);
            con.Open();
       
            str = str = "select s.[surgery id],s.[patient surgery id],s.[surgery name],s.[charges],s.[type id],s.[type name],p.[pv id],p.[patient charges] from surg s inner join patientsurgery p on s.[patient surgery id]=p.[patient surgery id]";
            com = new SqlCommand(str, con);
            sqlda = new SqlDataAdapter(com);
            ds = new DataSet();
            sqlda.SelectCommand = com;
            sqlda.Fill(ds);
            GridView1.DataSource = ds;
            GridView1.DataBind();
            con.Close();

        }
    }
}



Thanks

hello sir;

i am sending my complete database file(code,erd,requirement diagram,db file).

regards
sumaira manzoor

Hi Sumaira,


There might not have any records in clinicMainsurgery table.


Can you please send me the tables with records.


Thanks

HI
Replace inner join to Left outer join.

& then check the result