GET DATA FROM MULTIPLES TABLE IN ONE FORM USING C#

Question

ASSALAM-O-ALIKUM TO ALL OF YOU; SIR MY QUESTION IS HOW WE CAN GET DATA FROM MULTIPLES TABLE IN ONE FORM USING C#. FOR EXAMPLE I HAVE THREE DIFFERENT TABLES ONE IS SURGERY (SURGERY IDSURGERY NAME CHARGES SURGERY TYPE ID) SECOND IS SURGERY TYPE (SURGERY TYPE ID SURGERY TYPE NAME) THIRD IS PATIENT SURGERY (SURGERY IDPATIENT VISIT IDCHARGES). SO I WANT DATA OF THESE TABLES IN MY MAIN SURGERY FORM . REGARDS SUMAIRA MANZOOR

Satyapriya Nayak · Answer

Hi Sumaira 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 Gridview_three_columns { 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) { SqlConnection con = new SqlConnection(connStr); con.Open(); str = Select s.[SURGERY ID]s.[SURGERY NAME]s.CHARGESst.[SURGERY TYPE ID]st.[SURGERY TYPE NAME]ps.[PATIENT VISIT ID]ps.CHARGES From SURGERY s inner join SURGERYTYPE st on st.[SURGERY TYPE ID] = s.[SURGERY TYPE ID] inner join PATIENTSURGERY ps on ps.[SURGERY ID] = s.[SURGERY ID]; com = new SqlCommand(str con); sqlda = new SqlDataAdapter(com); ds = new DataSet(); sqlda.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); con.Close(); } } } Thanks

Arjun Walmiki · Answer

try this query u get 2 table data if u feth right way let me know SELECT SURGERY.SURGERY ID SURGERY.SURGERY NAMESURGERY.CHARGESSURGERY TYPE.SURGERY TYPE NAME SURGERY TYPE ID FROM SURGERY INNER JOIN SURGERY TYPE ON SURGERY.SURGERY TYPE ID=SURGERY TYPE.SURGERY TYPE ID;

sumaira manzoor hussain khan · Answer

hello sir; there is error occur in my code. can you check my code . i am sending a screen shot.

sumaira manzoor hussain khan · Answer

hello sir; this is a good answer. but sir i want to know you wrote s.[SURGERY ID]s.[SURGERY NAME]s.CHARGES. and so on. sir is it a store procedure . can you explain how we can use this. regards sumaira manzoor

Prabhu Raja · Answer

Hi Hope this Will help you. Select s.SurgeryName s.Charges st.SurgeryTypeName ps.PatientVisitID ps.Charges From Surgery s inner join SurgeryType st on st.surgeryTypeID = s.SurgeryTypeID inner join PatientSurgery ps on ps.surgeryID = s.SurgeryID

sumaira manzoor hussain khan · Answer

hello sir; is it necessary we use store procedure with join query. we can use simple statement with join query. sir my requirement is : i want to get data from multiple tables in one table using csharp. store procedure with join or simple statement with join can fullfil my requirement or not.

Vilas Gite · Answer

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable{mso-style-name:Table Normal;mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:Calibrisans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:Times New Roman;mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;} Hi Mam Please refer for more details http://www.java2s.com/Code/SQL/Join/JOINthreetableswithconditions.htm Thanks!

sumaira manzoor hussain khan · Answer

hi; can you elaborate your code. because i am not getting ur answer

Satyapriya Nayak · Answer

Hi Sumaira Those are aliases There are two types of aliases that are used most frequently: column alias and table alias. Please refer the below link http://www.1keydata.com/sql/sqlalias.html Thanks

sumaira manzoor hussain khan · Answer

hello sir; why you used psst and so on. is it a property.

Datta Kharad · Answer

Hi sSQL=Select s.SurgeryName s.Charges st.SurgeryTypeName ps.PatientVisitId ps.Charges From SURGERY s INNER JOIN SURGERYTYPE st on s.SurgeryTypeId=st.SurgeryTypeId JOIN PATIENTSURGERY ps on s.SurgeryId=ps.SurgeryId;

Pravin More · Answer

hi sumaira do this by executing this below query from your code... select ps.PatientvisutIDs.SurgeryNameps.Chargesst.Surgerytypename from SURGERY s (nolock) join surgeryType st (nolock) on s.surgerytypeID=st.surgerytypeID join PatientSurgery ps (nolock) on ps.surgeryID=s.surgeryID Note:-change columns in select query according to you need Thanks Pravin.