void griddoldur() { tbl_Kiralar kira = new tbl_Kiralar(); DateTime time = DateTime.Now; //string kiraDonemi = time.Year + "/" + time.Month; string kiraDonemi = ""; DataSet ds = kira.spKiraSorgula(kiraDonemi, false, "", true, true, 0, "spKiraSorgula"); grSorgula.DataSource = ds.Tables["tbl_Kira"]; grSorgula.Refresh(); }
private void btnAra_Click(object sender, EventArgs e) { /*tbl_Binalar bina = new tbl_Binalar(); * DataSet dataSet = new DataSet() ; * if (cmbDaireKapiNo.SelectedItem!=null) * { * int daireKapiNo = Convert.ToInt32(cmbDaireKapiNo.SelectedItem.ToString()); * dataSet = bina.spBinaSorgula(cmbBinaAdi.SelectedItem.ToString(), chkYetkili.Checked, daireKapiNo, "spBinaSorgula"); * } * else * dataSet = bina.spBinaSorgula(cmbBinaAdi.SelectedItem.ToString(), chkYetkili.Checked, 0, "spBinaSorgula"); * gridSorgulama.Columns.Clear(); * grSorgula.DataSource = dataSet.Tables["tbl_BinaMusteri"]; * grSorgula.Refresh();*/ tbl_Kiralar kira = new tbl_Kiralar(); bool kayitli = chkKayitli.Checked; string kiraDonemi = ""; if (cmbKiraDonemi.SelectedItem != null) { kiraDonemi = cmbKiraDonemi.SelectedItem.ToString(); } int daireKapiNo = 0; if (cmbDaireKapiNo.SelectedItem != null) { daireKapiNo = Convert.ToInt32(cmbDaireKapiNo.SelectedItem.ToString()); } string binaAdi = ""; if (cmbBinaAdi.SelectedItem != null) { binaAdi = cmbBinaAdi.SelectedItem.ToString(); } DataSet ds = kira.spKiraSorgula(kiraDonemi, chkKiraDurumu.Checked, binaAdi, chkYetkili.Checked, kayitli, daireKapiNo, "spKiraSorgula"); grSorgula.DataSource = ds.Tables["tbl_Kira"]; grSorgula.Refresh(); }