Display data in a gridview based on two tables using asp.net

Question

I have two tables EmpDeptEMP                          DEPTEmpNoPKEY            IdFKEY to EmpnoFname                       LocationLname                        Date Mname I want to display Gridview columns like this EFnameELnameDdate based on IdoRDisplay EFnameELnamebased ob IdDate I have two tables EmpDeptEMP                          DEPTEmpNoPKEY            IdFKEY to EmpnoFname                       LocationLname                        Date Mname I want to display Gridview c

RkHirpara · Accepted Answer

As Per your need and as you mentiond the two scenarios can be programmed by following queries1based on Idselect EFnameELnameDdatefrom EMP Einner join DEPT Don EEmpNo  DID2based on Id Dateselect EFnameELnamefrom EMP Einner join DEPT Don EEmpNo  DIDwhere DId  Id and Ddate  Date

RkHirpara · Answer

Hi Mandla Please refer the following article carefullyUsing Parameterized queries to prevent SQL Injection Attacks in SQL Server

Display data in a gridview based on two tables using asp.net

Company

Explore

Follow us

Contact Us