Пример #1
0
    public void DeatilsOfCarOwner()
    {
        model m = new model();

        m.open();
        DataTable dt1 = m.edit("carregi", "contact='" + carownercontactno.Text + "'");

        CarOwnerDeatilsRepeater.DataSource = dt1;
        CarOwnerDeatilsRepeater.DataBind();
        m.close();
    }
Пример #2
0
    public void DeatilsOfCarOwner()
    {
        model m = new model();

        m.open();
        //int carid = 0;

        //SqlDataReader drr1 = m.getLastRecord("carid", "ServiceOrderMaster", "serviceordermasterid");
        //if (drr1.HasRows)
        //{
        //    drr1.Read();
        //    carid = Convert.ToInt32(drr1["carid"]);
        //    drr1.Close();


        //}
        DataTable dt1 = m.multipleTableQuery("carregi.*", "(carregi INNER JOIN ServiceOrderMaster ON ServiceOrderMaster.carid=carregi.carid)", "ServiceOrderMaster.refno = '" + ref_no + "' and (ServiceOrderMaster.isdelete='1' and carregi.isdelete='1')");

        CarOwnerDeatilsRepeater.DataSource = dt1;
        CarOwnerDeatilsRepeater.DataBind();
        m.close();
    }