using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Configuration; using System.Data; using System.Data.Sql; using System.Data.SqlClient; using System.Data.SqlTypes; namespace EDAIF { public partial class Loanmaster : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { //Page Load Begins if (!IsPostBack) { try { SqlConnection connect = new SqlConnection(); connect.ConnectionString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString; connect.Open(); SqlDataAdapter da = new SqlDataAdapter("SELECT * , BRANCH.BRN_NAME, TANK.TANK_NAME, SECTORS.[SECTOR NAME] FROM TANKMASTER LEFT JOIN BRANCH ON BRANCH.BRN_NO=LOANMASTER.BRN_nO LEFT JOIN SECTORS ON SECTORS.[SECTOR NUMBER]=LOANMASTER.SEC_NO LEFT JOIN TANK ON TANK.TANK_CODE=LOANMASTER.TANK_NO1 AND TANK.TANK_CODE=LOANMASTER.TANK_NO2 AND TANK.TANK_CODE=LOANMASTER.TANK_NO3", connect); DataSet ds = new DataSet(); da.Fill(ds, "TANK");
pre
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)