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 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); } } }