private void getFarInfoonLoad() { try { GridLandRecord.DataSource = null; GridLandRecord.DataBind(); //SqlObj = new SqlString(ComObj); string strsql = "SELECT FRG.DistNo_LRMP DistID_LRMP, FRG.Tehsile_ID as TehsileID,FRG.Village_Code as Vcode, LRVM.Villagename as village ,FRG.FarmerId as FarmerId ,FRG.FarmerName as FarmerName,FRG.FatherHusName as FarmerFatHUS, FRG.Gram_Panchayat, FRG.PatwariHalkaNo, LRTM.Tehsilname as Tehsil, LRDM .Distname as Distname,FRG.Mobileno Mobileno, FRG.Category Category , FRG.RinPustikaNo as RinPustikaNo, FRG.Farmer_EID_UID_No as EIDUIDNo, FRG.Farmer_BankName as Bankname, FRG.Farmer_BankAccountNo as AccNo, FRG.Procured_SocietyID, FRG.Procured_Dist_ID, FRG.Procured_Place as PrcPlace , FRG.Col_MaxQty,Category.Category ,CONVERT(VARCHAR(15), FRG.CropDep_Date, 106) as CropDepDate FROM FarmerRegistration FRG left join LR_VillageMaster LRVM on FRG.DistNo_LRMP=LRVM.Distno and FRG.Tehsile_ID=LRVM.Tehsilno and FRG.Village_Code=LRVM.Villageno left join LR_TehsilMaster LRTM on FRG.Tehsile_ID =LRTM.Distno and FRG.Tehsile_ID=LRTM.Tehsilno left join LR_DistrictMaster LRDM on FRG.DistNo_LRMP =LRDM.Distno left join Category on Category.Category_ID=FRG.Category where FRG.DistNo_LRMP='" + DDL_Dist.SelectedItem.Value.ToString() + "' order by FarmerId"; con.Open(); cmd = new SqlCommand(strsql, con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds, "farInfo"); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { GridLandRecord.DataSource = ds.Tables[0]; GridLandRecord.DataBind(); } } } catch (Exception ex) { Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('" + ex.Message + "'); </script> "); } }
protected void GridLandRecord_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { int i = e.RowIndex; if (GridLandRecord.Rows.Count < 1) { ViewState["ckstat"] = "Delete"; } ((DataTable)Session["dt1"]).Rows[i].Delete(); ((DataTable)Session["dt1"]).AcceptChanges(); GridLandRecord.DataSource = (DataTable)Session["dt1"]; GridLandRecord.DataBind(); } catch (Exception ex) { Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('" + ex.Message + "'); </script> "); } }
protected void btn_LandReocord_Click(object sender, EventArgs e) { if (ddl_GridVillage.SelectedIndex > 0 && ddl_GridCrop.SelectedIndex > 0 && txt_Grid_KhasaraNo.Text != "" && txt_Grid_rakaba.Text != "" && txt_Grid_RKBSinchit.Text != "" && txt_Grid_RKBASinchit.Text != "" && txt_Grid_AchinchitQty.Text != "" && txt_Grid_AsinchitQty.Text != "" && txt_Grid_PrcQty.Text != "") { if (ddl_LandType.SelectedValue.ToString() == "Sikami") { if (txt_MoolBhoSwamiName.Text == "" || txt_Grid_MoolRinPustikaNo.Text == "") { Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('मूल भूमि स्वामी से संबन्धित विवरण भरीये .... '); </script> "); return; } } if (Session["dt1"] == null) { Dt1 = CreateTable(); Session["dt1"] = Dt1; } DataRow dr = ((DataTable)Session["dt1"]).NewRow(); ((DataTable)Session["dt1"]).AcceptChanges(); if (ddl_GridVillage.SelectedIndex != 0) { dr["VillageName"] = ddl_GridVillage.SelectedItem.Text; dr["Village_ID"] = ddl_GridVillage.SelectedValue; } else { dr["VillageName"] = ""; dr["Village_ID"] = ""; } if (ddl_GridCrop.SelectedIndex != 0) { dr["crop_Name"] = ddl_GridCrop.SelectedItem.Text; dr["Crop_Id"] = ddl_GridCrop.SelectedValue; } else { dr["crop_Name"] = ""; dr["Crop_Id"] = ""; } dr["MoolBhoSwami"] = txt_MoolBhoSwamiName.Text.Trim(); dr["BhoSwamiRinPustikaNo"] = txt_Grid_MoolRinPustikaNo.Text.Trim(); dr["khasarano"] = txt_Grid_KhasaraNo.Text.Trim(); dr["rakba"] = txt_Grid_rakaba.Text.Trim(); dr["Rakba_crop_sinchit"] = txt_Grid_RKBSinchit.Text.Trim(); dr["Rakba_crop_asinchit"] = txt_Grid_RKBASinchit.Text.Trim(); dr["Rakba_crop_sinchit_qty"] = txt_Grid_AchinchitQty.Text.Trim(); dr["Rakba_crop_asinchit_qty"] = txt_Grid_AsinchitQty.Text.Trim(); dr["Procured_qty"] = txt_Grid_PrcQty.Text.Trim(); dr["LandType"] = ddl_LandType.SelectedValue; ((DataTable)Session["dt1"]).Rows.Add(dr); ((DataTable)Session["dt1"]).AcceptChanges(); GridLandRecord.DataSource = (DataTable)Session["dt1"]; GridLandRecord.DataBind(); txt_MoolBhoSwamiName.Text = ""; txt_Grid_MoolRinPustikaNo.Text = ""; txt_Grid_KhasaraNo.Text = ""; txt_Grid_rakaba.Text = ""; txt_Grid_RKBSinchit.Text = ""; txt_Grid_RKBASinchit.Text = ""; txt_Grid_AchinchitQty.Text = ""; txt_Grid_AsinchitQty.Text = ""; txt_Grid_PrcQty.Text = ""; } else { Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('भूमि से संबन्धित सभी विवरण भरीये .... '); </script> "); } }