protected void BindGvE() { conn.Open(); string strSelectCmd = "SELECT * FROM View_Tna_Plan WHERE PO_Ship_Date is NULL AND (Emb='Y') AND ActiveOrder='1' AND TnAapproved IS NOT NULL AND TnaByrNm = '" + ddlbuyerE.SelectedItem.Value + "'order by ord_no,po_xfactory ASC"; SqlDataAdapter da = new SqlDataAdapter(strSelectCmd, conn); DataSet ds = new DataSet(); da.Fill(ds); if (ds.Tables[0].Rows.Count == 0) { ds.Tables[0].Rows.Add(ds.Tables[0].NewRow()); GvE.DataSource = ds; GvE.DataBind(); int columncount = GvE.Rows[0].Cells.Count; GvE.Rows[0].Cells.Clear(); GvE.Rows[0].Cells.Add(new TableCell()); GvE.Rows[0].Cells[0].ColumnSpan = columncount; GvE.Rows[0].Cells[0].Text = ""; } else { //Search Option-RUS ViewState["dtOrderE"] = ds.Tables[0]; //Search Option-RUS GvE.DataSource = ds; GvE.DataBind(); } }
//Search Option-RUS protected void btnSearchE_Click(object sender, EventArgs e) { DataTable dtOrderE = (DataTable)ViewState["dtOrderE"]; DataView dvOrderE = dtOrderE.DefaultView; dvOrderE.RowFilter = "ord_no like '" + txtSearchE.Text + "%'"; GvE.DataSource = dvOrderE; GvE.DataBind(); }