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