public void bindRepeater()
{
try
{
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand("STP_ManageImageGallery", sqlcon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "BindDetails");
cmd.Parameters.AddWithValue("@Categoryid", ddlCategory.SelectedValue);
da.SelectCommand = cmd;
da.Fill(dt);
lblCategoryName.Text = ddlCategory.SelectedItem.Text;
if (dt != null && dt.Rows.Count > 0)
{
RepDetails.DataSource = dt;
RepDetails.DataBind();
btnDelete.Visible = true;
}
else
{
RepDetails.DataSource = new DataTable();
RepDetails.DataBind();
btnDelete.Visible = false;
}
}
catch (Exception Ex)
{
Ex.ToString();
}
}
protected void BindRepeaterData()
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from abc order by postedDate desc", con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
RepDetails.DataSource = ds;
RepDetails.DataBind();
con.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = new SqlCommand("select Goods_Name,Quantity,Unit,minimum_stock from Goods_Data where Quantity <= minimum_stock", con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
RepDetails.DataSource = ds;
RepDetails.DataBind();
con.Close();
}
protected void BindRepeaterData()
{
getcon();
SqlCommand cmd = new SqlCommand("select tbl_newsnevents.newsnevents_title,tbl_newsnevents.newsnevents_description,tbl_newsnevents.newsnevents_datentime,tbl_registration.registration_fname+' '+tbl_registration.registration_lname as name from tbl_newsnevents inner join tbl_registration on tbl_registration.registration_id=tbl_newsnevents.registration_id where tbl_newsnevents.newsnevents_status='approved' order By tbl_newsnevents.newsnevents_datentime desc", con);
DataTable ds = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
if (ds.Rows.Count > 0)
{
RepDetails.DataSource = ds;
RepDetails.DataBind();
}
con.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["d"] != null)
{
stDS = new DataSet();
// docno.InnerHtml = txtDocno.Text.Trim();
stDS = Other.Dashboard.Get_OrderValuation(Convert.ToInt32(Request.QueryString["d"].ToString().Trim()), Convert.ToInt32(Request.QueryString["sd"].ToString().Trim()), Convert.ToInt32(Request.QueryString["zd"].ToString().Trim()), Convert.ToDateTime(Request.QueryString["fd"].ToString().Trim()), Convert.ToDateTime(Request.QueryString["td"].ToString().Trim()));
RepDetails.DataSource = stDS.Tables[0];
RepDetails.DataBind();
lblsuperzone.Text = stDS.Tables[2].Rows[0]["SuperZoneName"].ToString();
lblTotalGrAmount.Text = string.Format("{0:0.00}", Convert.ToDecimal(stDS.Tables[3].Rows[0]["TotalGrossAmount"].ToString()));
lblTotalNtAmount.Text = string.Format("{0:0.00}", Convert.ToDecimal(stDS.Tables[3].Rows[0]["TotalNetAmount"].ToString()));
}
}
private void BindMoreAnnouncement()
{
DataSet dsSelect = new DataSet();
dsSelect = this.BAL_Announcement.BAL_SelectAnnouncementBySchoolID(Convert.ToInt32(this.Session["SchoolID"]), "SelectAll");
gvAnnouncementDetails.DataSource = dsSelect;
if (dsSelect.Tables.Count > (int)EnumFile.AssignValue.Zero)
{
GridViewOperations GrvOperation = new GridViewOperations();
GrvOperation.BindGridWithSorting(this.gvAnnouncementDetails, dsSelect, this.SortField, this.SortDirection);
RepDetails.DataSource = dsSelect;
RepDetails.DataBind();
}
else
{
gvAnnouncementDetails.DataSource = null;
gvAnnouncementDetails.DataBind();
}
}
protected void BindRepeaterData()
{
var ownerusername = Request.QueryString["username"].ToString();
WallInfo wi = new WallInfo("", ownerusername, "", "");
DataSet ds = wiDAO.fetchWallInfo(wi);
if (ds.Tables[0].Rows.Count > 0)
{
RepDetails.Visible = true;
RepDetails.DataSource = ds;
RepDetails.DataBind();
}
else
{
RepDetails.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = new SqlCommand("select distinct goods_name,unit_of_goods, ((select sum(g_add_use_quantity) from goods_add where g_add_gid=t1.gid)-((select sum(use_quantity) from goods_use where ugid=t1.gid))) as qnt from Goods t1 inner join goods_use on (gid=ugid) inner join goods_add on (gid=g_add_gid) where ( ( (select sum(g_add_use_quantity) from goods_add where g_add_gid=t1.gid) - (select sum(use_quantity) from goods_use where ugid=t1.gid) ) <= (minimum_quantity)) group by gid,goods_name,unit_of_goods", con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
RepDetails.DataSource = ds;
RepDetails.DataBind();
con.Close();
//con.Open();
//SqlCommand cmd2 = new SqlCommand("select gid,goods_name,unit_of_goods, ((select sum(g_add_use_quantity) from goods_add where g_add_gid=gid)-((select sum(use_quantity) from goods_use where ugid=gid))) as qnt2 from Goods", con);
//DataSet ds2 = new DataSet();
//SqlDataAdapter da2 = new SqlDataAdapter(cmd2);
//da2.Fill(ds2);
//Repeater1.DataSource = ds2;
//Repeater1.DataBind();
//con.Close();
}
//Bind Data to Repeater Control
protected void BindRepeaterData()
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from Repeater_Table Order By PostedDate desc", con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
RepDetails.Visible = true;
RepDetails.DataSource = ds;
RepDetails.DataBind();
}
else
{
RepDetails.Visible = false;
}
con.Close();
}
void bindRepeater()
{
try
{
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand("STP_ManageImageCategory", sqlcon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "BindImageCategory");
da.SelectCommand = cmd;
da.Fill(dt);
if (dt != null && dt.Rows.Count > 0)
{
RepDetails.DataSource = dt;
RepDetails.DataBind();
}
}
catch (Exception Ex)
{
Ex.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["d"] != null)
{
stDS = new DataSet();
if (Request.QueryString["fd"] != null && Request.QueryString["td"] != null)
{
// docno.InnerHtml = txtDocno.Text.Trim();
stDS = Other.Dashboard.Get_SalesAnalysisReport(Convert.ToInt32(Request.QueryString["d"].ToString().Trim()), Convert.ToInt32(Request.QueryString["sd"].ToString().Trim()), Convert.ToDateTime(Request.QueryString["fd"].ToString()), Convert.ToDateTime(Request.QueryString["td"].ToString()));
RepDetails.DataSource = stDS.Tables[0];
RepDetails.DataBind();
lblsuperzone.Text = stDS.Tables[2].Rows[0]["SuperZoneName"].ToString();
}
else
{
stDS = Other.Dashboard.Get_SalesAnalysisReport(Convert.ToInt32(Request.QueryString["d"].ToString().Trim()), Convert.ToInt32(Request.QueryString["sd"].ToString().Trim()));
RepDetails.DataSource = stDS.Tables[0];
RepDetails.DataBind();
lblsuperzone.Text = stDS.Tables[2].Rows[0]["SuperZoneName"].ToString();
}
}
}
