aspxpage.cs:--
---------------------
protected void Page_Load(object sender, EventArgs e)
{
string userID = string.Empty;
if (Session["UserID"] != null && Session["UserID"] != "")
{
LPOBJ.L_UserID = Convert.ToString(Session["UserID"]);
UPOBJ.U_UserType = Convert.ToInt32(Session["UserType"]);
}
else
{
Response.Redirect("~/Login.aspx?ReturnUrl=" + Request.Url.PathAndQuery.Replace("&", "^"));
}
if (!IsPostBack)
{
SqlDataReader drCategory;
drCategory = ABLOBJ.GetDistinctCategories();
if (drCategory.HasRows)
{
while (drCategory.Read())
{
ddlCategory.Items.Add(drCategory.GetString(0));
}
}
drCategory.Dispose();
drCategory.Close();
SqlDataReader drAreas;
drAreas = ABLOBJ.GetTotalAreas(LPOBJ);
if (drAreas.HasRows)
{
while (drAreas.Read())
{
ddlArea.Items.Add(drAreas.GetString(0));
}
}
drAreas.Close();
}
}
private void GetData()
{
dsShowListings = ABLOBJ.GetBusinessListingsByCompanyName(LPOBJ);
GVListings.DataSource = dsShowListings;
GVListings.DataBind();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
LPOBJ.L_CompanyName = txtCompanyName.Text.Trim();
GetData();
}
protected void GVListings_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
LPOBJ.L_YPID = (int)GVListings.DataKeys[e.RowIndex].Value;
int i = ABLOBJ.DeleteListings(LPOBJ, UPOBJ);
if (i > 0)
{
Result("Deleted Successfully");
}
else
{
Result("Some Problem has occured.");
}
LPOBJ.L_CompanyName = txtCompanyName.Text.Trim();
GetData();
}
protected void GVListings_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GVListings.PageIndex = e.NewPageIndex;
GVListings.DataSource = Session["Result"];
GVListings.DataBind();
}
public void Result(string resMsg)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("<script type = 'text/javascript'>");
sb.Append("window.onload=function(){");
sb.Append("alert('");
sb.Append(resMsg);
sb.Append("')};");
sb.Append("</script>");
Page.RegisterClientScriptBlock("send_mailss", sb.ToString());
}
protected void lnkCustDetails_Click(object sender, EventArgs e)
{
// Fetch the customer id
LinkButton lb = sender as LinkButton;
string custID = lb.Text;
LPOBJ.L_YPID = Convert.ToInt32(custID);
// Connection
lblCustValue.Text = custID;
// Show the modalpopupextender
ModalPopupExtender1.Show();
}
Regards,
Bhanu Prakash Bysani
Bhanubysani, if this helps please login to Mark As Answer. | Alert Moderator