protected void btnView_OnClick(object sender, EventArgs e)
{
if (ddlsearch.SelectedValue == "IMID")
{
lblGridTitle.Text = "IMID: " + txtName.Text.ToString() + " Session:" + lblHiddenSeason.Text.ToString();
query = "select SNo,CourierType,Name,SendTo,City,State,CourierService,Weight,Amount,Date,CourierSerialno from CourierRD where Session='" + lblHiddenSeason.Text.ToString() + "' and Name='" + txtName.Text.ToString() + "'";
fillGrid(query);
}
else if (ddlsearch.SelectedValue == "CourierService")
{
lblGridTitle.Text = ddlCourier.SelectedValue.ToString() + " Session:" + lblHiddenSeason.Text.ToString();
query = "select SNo,CourierType,Name,SendTo,City,State,CourierService,Weight,Amount,Date,CourierSerialno from CourierRD where Session='" + lblHiddenSeason.Text.ToString() + "' and CourierService='" + ddlCourier.SelectedValue.ToString() + "'";
fillGrid(query);
}
else if (ddlsearch.SelectedValue == "RefrenceNo")
{
lblGridTitle.Text = "Reference No: " + txtNo.Text.ToString();
query = "select SNo,CourierType,Name,SendTo,City,State,CourierService,Weight,Amount,Date,Consignmentno from CourierRD where CourierSerialno='" + txtNo.Text.ToString() + "'";
fillGrid(query);
}
else if (ddlsearch.SelectedValue == "ConsignmentNo")
{
lblGridTitle.Text = "Consignment No. " + txtNo.Text.ToString();
query = "select SNo,CourierType,Name,SendTo,City,State,CourierService,Weight,Amount,Date,CourierSerialno from CourierRD where ConsignmentNo='" + txtNo.Text.ToString() + "'";
fillGrid(query);
}
GridCourier.Focus();
}
private void fillGrid(string qry)
{
SqlDataAdapter ad = new SqlDataAdapter(qry, con);
DataSet ds = new DataSet();
ad.Fill(ds);
GridCourier.DataSource = ds;
GridCourier.DataBind();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridCourier.PageIndex = e.NewPageIndex;
GridCourier.DataBind();
}
