private void FillGrid() { DbCall objDB = new DbCall(); string sql = "SELECT * FROM CAT_MASTER"; DataSet dsSubj = objDB.ExecuteQuery(sql); if (dsSubj != null && dsSubj.Tables[0].Rows.Count > 0) { grdIns.DataSource = dsSubj.Tables[0]; grdIns.DataBind(); } }
private void FillGrid() { DbCall objDB = new DbCall(); objDB.set_conn1(1); string sql = "SELECT * FROM URL_MASTER WHERE CATEGORY = '" + cmbCat.SelectedItem.Text + "'"; DataSet dsSubj = objDB.ExecuteQuery(sql); string html = "<table border='1'><tr><td><b>Edit Record</b></td><td><b>Category</b></td><td><b>Url</b></td><td><b>Remarks</b></td><td><b>Added By</b></td><td><b>Added Date</b></td></tr>"; if (dsSubj != null && dsSubj.Tables[0].Rows.Count > 0) { foreach (DataRow drSubj in dsSubj.Tables[0].Rows) { html += "<tr>"; html += "<td><a href='UrlMaster.aspx?ROWNUM=" + drSubj["URLID"].ToString() + "'>" + drSubj["URLID"].ToString() + "</a></td>"; html += "<td>" + drSubj["CATEGORY"].ToString() + "</td>"; html += "<td><a target='_blank' href='" + drSubj["URL"].ToString() + "'>" + drSubj["URL"].ToString() + "</a></td>"; html += "<td>" + drSubj["REMARKS"].ToString() + "</td>"; html += "<td>" + drSubj["ADDED_BY"].ToString() + "</td>"; html += "<td>" + drSubj["ADDED_DATE"].ToString().Split(' ')[0] + "</td>"; html += "</tr>"; } } html += "</table>"; lblUrls.Text = html; //if (dsSubj != null && dsSubj.Tables[0].Rows.Count > 0) //{ // grdIns.DataSource = dsSubj.Tables[0]; // grdIns.DataBind(); //} //else //{ // grdIns.DataSource = null; // grdIns.DataBind(); //} }
protected void FillData() { DbCall objDB = new DbCall(); objDB.set_conn1(1); string rownum = "0"; if (Request.QueryString["ROWNUM"] != null) { rownum = Request.QueryString["ROWNUM"].ToString(); string sql = "SELECT * FROM URL_MASTER WHERE URLID = " + rownum; DataSet dsFac = objDB.ExecuteQuery(sql); if (dsFac != null && dsFac.Tables[0].Rows.Count > 0) { DataRow drFac = dsFac.Tables[0].Rows[0]; cmbCat.Text = drFac["CATEGORY"].ToString(); txtUrl.Text = drFac["URL"].ToString(); txtRem.Text = drFac["REMARKS"].ToString(); txtNam.Text = drFac["ADDED_BY"].ToString(); txtNam.Enabled = false; btnAdd.Enabled = false; btnUpdate.Enabled = true; btnDel.Enabled = true; } } else { txtNam.Enabled = true; btnAdd.Enabled = true; btnUpdate.Enabled = false; btnDel.Enabled = false; } }
protected void FillData() { DbCall objDB = new DbCall(); string rownum = "0"; if (Request.QueryString["ROWNUM"] != null) { rownum = Request.QueryString["ROWNUM"].ToString(); string sql = "SELECT * FROM CAT_MASTER WHERE CATID = " + rownum; DataSet dsFac = objDB.ExecuteQuery(sql); if (dsFac != null && dsFac.Tables[0].Rows.Count > 0) { DataRow drFac = dsFac.Tables[0].Rows[0]; txtCat.Text = drFac["CATEGORY"].ToString(); } } }
protected void PopulateDropDown() { cmbCat.Items.Clear(); DbCall objDB = new DbCall(); string sql = "SELECT * FROM CAT_MASTER"; DataSet dsDocs = objDB.ExecuteQuery(sql); if (dsDocs != null && dsDocs.Tables[0].Rows.Count > 0) { cmbCat.DataTextField = "CATEGORY"; cmbCat.DataValueField = "CATEGORY"; cmbCat.DataSource = dsDocs.Tables[0]; cmbCat.DataBind(); } if (Session["CATEGORY"] != null) { cmbCat.SelectedValue = Session["CATEGORY"].ToString(); } FillGrid(); }
protected void btnOpenAll_Click(object sender, EventArgs e) { DbCall objDB = new DbCall(); objDB.set_conn1(1); string sql = "SELECT * FROM URL_MASTER WHERE CATEGORY = '" + cmbCat.SelectedItem.Text + "'"; DataSet dsSubj = objDB.ExecuteQuery(sql); if (dsSubj != null && dsSubj.Tables[0].Rows.Count > 0) { int iFileCnt = 0; foreach (DataRow drSubj in dsSubj.Tables[0].Rows) { Page.ClientScript.RegisterStartupScript(this.GetType(), "Popup_File" + iFileCnt, "window.open('" + drSubj["URL"].ToString() + "','_blank');", true); iFileCnt += 1; //Response.Write("<script language='javascript'> window.open('" + drSubj["URL"].ToString() + "','_newtab');</script>"); //Thread.Sleep(1000); } } }
protected void btnAdd_Click(object sender, EventArgs e) { string param = ""; string row_num = "0"; string sql = ""; DbCall objDB = new DbCall(); if (Request.QueryString["ROWNUM"] == null) { row_num = "0"; sql = "SELECT * FROM CAT_MASTER WHERE CATEGORY = '" + txtCat.Text + "'"; DataSet dsDocs = objDB.ExecuteQuery(sql); if (dsDocs != null && dsDocs.Tables[0].Rows.Count > 0) { lblMessg.Text = "You have already added Category : " + txtCat.Text; return; } sql = "SELECT MAX(CATID)+1 FROM CAT_MASTER"; dsDocs = objDB.ExecuteQuery(sql); if (dsDocs != null && dsDocs.Tables[0].Rows.Count > 0) { row_num = dsDocs.Tables[0].Rows[0][0].ToString(); } else { row_num = "1"; } if (row_num == "") { row_num = "1"; } param += row_num + "~"; param += txtCat.Text + "~"; sql = "INSERT INTO CAT_MASTER (CATID, CATEGORY) VALUES({0}, '{1}')"; sql = String.Format(sql, param.Split('~')); int retval = objDB.ExecuteNonQuery(sql); if (retval == 1) { lblMessg.Text = "Category details added successfully"; Response.Write("<script language='javascript'> alert('Category details added successfully'); </script>"); FillGrid(); btnAdd.Enabled = false; } else { lblMessg.Text = "Error encountered, please try again"; Response.Write("<script language='javascript'> alert('Error encountered, please try again'); </script>"); } } }
protected void btnAdd_Click(object sender, EventArgs e) { string param = ""; string row_num = "0"; string sql = ""; DbCall objDB = new DbCall(); if (Request.QueryString["ROWNUM"] == null) { row_num = "0"; sql = "SELECT * FROM URL_MASTER WHERE CATEGORY = '" + cmbCat.SelectedItem.Text + "' AND URL = '" + txtUrl.Text + "'"; DataSet dsDocs = objDB.ExecuteQuery(sql); if (dsDocs != null && dsDocs.Tables[0].Rows.Count > 0) { lblMessg.Text = "You have already added Url: " + txtUrl.Text + " for category : " + cmbCat.SelectedItem.Text; return; } sql = "SELECT MAX(URLID)+1 FROM URL_MASTER"; dsDocs = objDB.ExecuteQuery(sql); if (dsDocs != null && dsDocs.Tables[0].Rows.Count > 0) { row_num = dsDocs.Tables[0].Rows[0][0].ToString(); } else { row_num = "1"; } if (row_num == "") { row_num = "1"; } param += row_num + "~"; param += cmbCat.SelectedItem.Text + "~"; param += txtUrl.Text + "~"; param += txtRem.Text + "~"; param += txtNam.Text + "~"; param += DateTime.Today.ToString("MM/dd/yyyy") + "~"; sql = "INSERT INTO URL_MASTER (URLID, CATEGORY, URL, REMARKS, ADDED_BY, ADDED_DATE) VALUES({0}, '{1}', '{2}', '{3}', '{4}', '{5}')"; sql = String.Format(sql, param.Split('~')); int retval = objDB.ExecuteNonQuery(sql); if (retval == 1) { lblMessg.Text = "Url details added successfully"; Response.Write("<script language='javascript'> alert('Url details added successfully'); </script>"); FillGrid(); btnAdd.Enabled = false; } else { lblMessg.Text = "Error encountered, please try again"; Response.Write("<script language='javascript'> alert('Error encountered, please try again'); </script>"); } } }