public void DeatilsOfCarOwner() { model m = new model(); m.open(); DataTable dt1 = m.edit("carregi", "contact='" + carownercontactno.Text + "'"); CarOwnerDeatilsRepeater.DataSource = dt1; CarOwnerDeatilsRepeater.DataBind(); m.close(); }
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(); }