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