private void BindGridView() { SqlConnection con1 = new SqlConnection(_ConnStr); //where RFQ_UserID = '" + Session["M_Subscriber_UserID"].ToString() + "' con1.Open(); SqlCommand cmd = new SqlCommand("select RFQ_Slno,RFQ_Number,RFQ_Company,RFQ_CreationDate,RFQ_OriginCountry,RFQ_DestinationCountry,RFQ_OriginAirport,RFQ_DestinationAirport,RFQ_NumberofPackages,RFQ_TotalGrwt,RFQ_TotalVolwt,RFQ_TotalChwt,RFQ_PickupAddress,RFQ_DeliveryAddress,RFQ_PickupDate,RFQ_ReqTT,RFQ_QuoteDueBy,RFQ_Commodity,RFQ_HandlingInfo,RFQ_UserID,RFQ_Timestamp,RFQ_Submit,RFQ_ExpectedPrice from RFQ where RFQ_UserID = '" + Session["M_Subscriber_UserID"].ToString() + "' ", con1); SqlDataAdapter darfq = new SqlDataAdapter(cmd); DataSet dsrfq = new DataSet(); darfq.Fill(dsrfq); GridViewRfq.DataSource = dsrfq; GridViewRfq.DataBind(); lbltotalcount.Text = GridViewRfq.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 RFQ where RFQ_UserID = '" + Session["M_Subscriber_UserID"].ToString() + "' order by RFQ_Number "; 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); GridViewRfq.DataSource = dTable; GridViewRfq.DataBind(); } }
private void BindGrid() { String constr = ConfigurationManager.ConnectionStrings["CrudConnection"].ConnectionString; using (SqlConnection con = new SqlConnection(constr)) { using (SqlCommand cmd = new SqlCommand()) { cmd.CommandText = "select RFQ_Slno,RFQ_Number,RFQ_Company,RFQ_CreationDate,RFQ_OriginCountry,RFQ_DestinationCountry,RFQ_OriginAirport,RFQ_DestinationAirport,RFQ_NumberofPackages,RFQ_TotalGrwt,RFQ_TotalVolwt,RFQ_TotalChwt,RFQ_PickupAddress,RFQ_DeliveryAddress,RFQ_PickupDate,RFQ_ReqTT,RFQ_QuoteDueBy,RFQ_Commodity,RFQ_HandlingInfo,RFQ_ExpectedPrice,RFQ_UserID,RFQ_Timestamp,RFQ_ExpectedPrice,RFQ_Submit from RFQ WHERE RFQ_Number LIKE '%'+@RFQ_Number+'%' AND RFQ_UserID = '" + Session["M_Subscriber_UserID"].ToString() + "' "; cmd.Connection = con; cmd.Parameters.AddWithValue("@RFQ_Number", txtSearch.Text.Trim()); DataTable dt = new DataTable(); using (SqlDataAdapter sda = new SqlDataAdapter(cmd)) { sda.Fill(dt); GridViewRfq.DataSource = dt; GridViewRfq.DataBind(); } } } }