//Grid protected void BindGvYD() { conn.Open(); string strSelectCmd = "SELECT * FROM View_Tna_Plan WHERE PO_Ship_Date is NULL AND (Yd='Y' OR YdSolid='Y') AND ActiveOrder='1' AND TnAapproved IS NOT NULL AND TnaByrNm = '" + dlbuyerYD.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()); GvYD.DataSource = ds; GvYD.DataBind(); int columncount = GvYD.Rows[0].Cells.Count; GvYD.Rows[0].Cells.Clear(); GvYD.Rows[0].Cells.Add(new TableCell()); GvYD.Rows[0].Cells[0].ColumnSpan = columncount; GvYD.Rows[0].Cells[0].Text = ""; } else { //Search Option-RUS ViewState["dtOrder"] = ds.Tables[0]; //Search Option-RUS GvYD.DataSource = ds; GvYD.DataBind(); } }
//Search Option-RUS protected void btnSearch_Click(object sender, EventArgs e) { DataTable dtOrder = (DataTable)ViewState["dtOrder"]; DataView dvOrder = dtOrder.DefaultView; dvOrder.RowFilter = "ord_no like '" + txtSearch.Text + "%'"; GvYD.DataSource = dvOrder; GvYD.DataBind(); }