private void BindGridView()
{
SqlConnection con1 = new SqlConnection(_ConnStr);
con1.Open();
SqlCommand cmd = new SqlCommand("select *from ShipmentDetailsSeller where userid = '" + Session["M_Subscriber_UserID"].ToString() + "' ", con1);
SqlDataAdapter daseller = new SqlDataAdapter(cmd);
DataSet dsseller = new DataSet();
daseller.Fill(dsseller);
GridViewSeller.DataSource = dsseller;
GridViewSeller.DataBind();
lbltotalcount.Text = GridViewSeller.Rows.Count.ToString();
con1.Close();
}
protected void Refresh(object sender, ImageClickEventArgs e)
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = _ConnStr;
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from ShipmentDetailsSeller order by shipmentnumber";
cmd.CommandType = System.Data.CommandType.Text;
DataTable dTable = new DataTable();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlDataReader dReader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
dTable.Load(dReader);
GridViewSeller.DataSource = dTable;
GridViewSeller.DataBind();
}
}
private void BindGrid()
{
String constr = ConfigurationManager.ConnectionStrings["CrudConnection"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "SELECT shipmentnumber,creationdate,customer_M_Company_Name,numberofpackages,grossweight,chargeableweight,hawb,hawbdate,mawb,mawbdate,airline,flightnumber,etd,eta,atd,ata,delivered,delivery,receivedbyname,receivermobileno,receiveremailid,ShipmentRFQ_Number FROM ShipmentDetailsSeller WHERE shipmentnumber LIKE '%'+@shipmentnumber+'%' OR customer_M_Company_Name LIKE '%'+@customer_M_Company_Name+'%' OR numberofpackages LIKE '%'+@numberofpackages+'%' OR hawb LIKE '%'+@hawb+'%' OR mawb LIKE '%'+@mawb+'%' OR airline LIKE '%'+@airline+'%' OR flightnumber LIKE '%'+@flightnumber+'%' OR delivered LIKE '%'+@delivered+'%' OR receivedbyname LIKE '%'+@receivedbyname+'%' OR receivermobileno LIKE '%'+@receivermobileno+'%' OR receiveremailid LIKE '%'+@receiveremailid+'%' ";
cmd.Connection = con;
cmd.Parameters.AddWithValue("@shipmentnumber", txtSearch.Text.Trim());
cmd.Parameters.AddWithValue("@customer_M_Company_Name", txtSearch.Text.Trim());
cmd.Parameters.AddWithValue("@numberofpackages", txtSearch.Text.Trim());
cmd.Parameters.AddWithValue("@grossweight", txtSearch.Text.Trim());
cmd.Parameters.AddWithValue("@chargeableweight", txtSearch.Text.Trim());
cmd.Parameters.AddWithValue("@hawb", txtSearch.Text.Trim());
cmd.Parameters.AddWithValue("@mawb", txtSearch.Text.Trim());
cmd.Parameters.AddWithValue("@airline", txtSearch.Text.Trim());
cmd.Parameters.AddWithValue("@flightnumber", txtSearch.Text.Trim());
cmd.Parameters.AddWithValue("@delivered", txtSearch.Text.Trim());
cmd.Parameters.AddWithValue("@receivedbyname", txtSearch.Text.Trim());
cmd.Parameters.AddWithValue("@receivermobileno", txtSearch.Text.Trim());
cmd.Parameters.AddWithValue("@receiveremailid", txtSearch.Text.Trim());
cmd.Parameters.AddWithValue("@userid", Session["M_Subscriber_UserID"]);
cmd.Parameters.AddWithValue("@SellerTimestamp", DateTime.Now);
cmd.Parameters.AddWithValue("@ShipmentRFQ_Number", txtrfqnumber.Text);
DataTable dt = new DataTable();
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
sda.Fill(dt);
GridViewSeller.DataSource = dt;
GridViewSeller.DataBind();
}
}
}
}
