protected void login_Click(object sender, EventArgs e) { dboperation db = new dboperation(); string s = "select *from login where username='******' and password='******'"; DataTable dt = db.ret(s); if (dt.Rows.Count > 0) { Session["userid"] = dt.Rows[0][0].ToString(); string a = dt.Rows[0][3].ToString(); if (a == "Farmer") { Response.Redirect("farmerhome.aspx"); } else if (a == "AO") { string b = "select KID from AOS where aid=" + dt.Rows[0][0] + ""; DataTable d = db.ret(b); Session["kid"] = d.Rows[0][0].ToString(); Response.Redirect("agrihome.aspx"); } else { Response.Redirect("adminhome.aspx"); } } else { Response.Write("<script>alert('Incorrect password & username...')</script>"); } }
void grid1() { string a = "select * from cropdetails"; DataTable dt = db.ret(a); DataGrid1.DataSource = dt; DataGrid1.DataBind(); }
void grid() { string s = "select * from message"; DataTable dt = db.ret(s); DataGrid1.DataSource = dt; DataGrid1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string s = " select * from notification"; DataTable dt = db.ret(s); DataGrid1.DataSource = dt; DataGrid1.DataBind(); } }
public string notification() { string result = " "; string s = "select * from notification"; DataTable dt = op.ret(s); foreach (DataRow dr in dt.Rows) { result = dr[0].ToString() + "#" + dr[1].ToString() + "#" + dr[2].ToString() + "#" + dr[3].ToString() + "@" + result; } return(result); }
void grid() { string a = "select * from article"; DataTable dt = db.ret(a); DataGrid1.DataSource = dt; DataGrid1.DataBind(); }
protected void search_Click(object sender, EventArgs e) { string a = " select Landdetails.surveyno, Landdetails.area, Landdetails.type, farmer.Name, farmer.place, farmer.contactno, Landdetails.FID, farmer.FID from Landdetails inner join farmer ON Landdetails.FID = farmer.FID where Landdetails.KID=" + Session["kid"] + " and farmer.Name like '%" + fname.Text + "%'"; DataTable dt = db.ret(a); DataGrid1.DataSource = dt; DataGrid1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { MultiView1.SetActiveView(View1); string a = "select culturingmethod.cropid, cropdetails.cropname, culturingmethod.cultureingmethod, culturingmethod.weatherdetails from culturingmethod inner join cropdetails on culturingmethod.cropid = cropdetails.cropid"; DataTable dt = db.ret(a); DataGrid1.DataSource = dt; DataGrid1.DataBind(); string s = "select cropid ,cropname from cropdetails"; dt = db.ret(s); DropDownList1.DataTextField = "cropname"; DropDownList1.DataValueField = "cropid"; DropDownList1.DataSource = dt; DropDownList1.DataBind(); DropDownList1.Items.Insert(0, "select"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { MultiView1.SetActiveView(View1); string a = "select * from notification"; DataTable dt = db.ret(a); DataGrid1.DataSource = dt; DataGrid1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { MultiView1.SetActiveView(View1); string a = "select * from governmentpolicies"; DataTable dt = db.ret(a); DataGrid1.DataSource = dt; DataGrid1.DataBind(); string b = "select max(policyno) from governmentpolicies"; policy_no.Text = db.maxid(b).ToString(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { MultiView1.SetActiveView(View1); string s = "select KID , placename from krishibhavan"; DataTable dt = db.ret(s); DropDownList1.DataTextField = "placename"; DropDownList1.DataValueField = "KID"; DropDownList1.DataSource = dt; DropDownList1.DataBind(); DropDownList1.Items.Insert(0, "select"); string d = "select * from AOS"; dt = db.ret(d); DataGrid1.DataSource = dt; DataGrid1.DataBind(); for (int i = 1; i <= 31; i++) { DropDownList2.Items.Add(i.ToString()); DropDownList5.Items.Add(i.ToString()); DropDownList8.Items.Add(i.ToString()); } for (int i = 1; i <= 12; i++) { DropDownList3.Items.Add(i.ToString()); DropDownList6.Items.Add(i.ToString()); DropDownList9.Items.Add(i.ToString()); } for (int i = 1900; i <= 3000; i++) { DropDownList4.Items.Add(i.ToString()); DropDownList7.Items.Add(i.ToString()); DropDownList10.Items.Add(i.ToString()); } } }