public void GetArtikelByNavisionID() { string CS = ConfigurationManager.ConnectionStrings["LagerLogistikConnectionString"].ToString(); using (SqlConnection connection = new SqlConnection(CS)) { connection.Open(); SqlCommand command = new SqlCommand("Here is the Query for example select Id =@Id", connection); command.Parameters.AddWithValue("Id ", TextSearch.Text); DataTable dt = new DataTable(); SqlDataAdapter adapter = new SqlDataAdapter(command); adapter.Fill(dt); GridArtikel_Information.DataSource = dt; GridArtikel_Information.DataBind(); } }
<script type="text/javascript"> </script> <div class="row"> <div class="col-lg-12 align-self-end "> <div class="form-group"> <asp:Button ID="BtnSuche" CssClass="btn btn-primary btn-block" AutoPostBack="true" OnClick="Title_SetFocus_Click" runat="server" Text="Suche" /> </div> </div> </div> <div class="col-lg-12"> <asp:TextBox ID="TextSearch" CssClass="form-control" runat="server"></asp:TextBox> </div> <div class="row" style="margin-top: 10px;"> <dx:ASPxGridView ID="GridArtikel_Information" AutoGenerateColumns="false" EnableRowsCache="true" KeyFieldName="NavisionID" SettingsPager-PageSize="15" SettingsPager-Mode="ShowPager" Width="100%" runat="server"> <Settings ShowHeaderFilterButton="true" /> <Columns> <dx:GridViewCommandColumn ShowNewButtonInHeader="false" ShowEditButton="false" Visible="false"> </dx:GridViewCommandColumn> <dx:GridViewDataColumn Caption="Barcode" FieldName="Barcode"> </dx:GridViewDataColumn> <dx:GridViewDataColumn Caption="P_Name" FieldName="P_Name"> </dx:GridViewDataColumn> <dx:GridViewDataColumn Caption="NavisionID" FieldName="NavisionID"> </dx:GridViewDataColumn> <dx:GridViewDataColumn Caption="P_KreditorNr" FieldName="P_KreditorNr"> </dx:GridViewDataColumn> <dx:GridViewDataColumn Caption="Farbe" FieldName="Farbe"> </dx:GridViewDataColumn> <dx:GridViewDataColumn Caption="Größe" FieldName="Größe"> </dx:GridViewDataColumn> <dx:GridViewDataColumn Caption="Unit_Name" FieldName="Unit_Name"> </dx:GridViewDataColumn> <dx:GridViewDataColumn Caption="Lagername" FieldName="Lagername"> </dx:GridViewDataColumn> <dx:GridViewDataColumn Caption="IstAufgebaut" FieldName="IstAufgebaut"> </dx:GridViewDataColumn> </Columns> <SettingsEditing Mode="PopupEditForm" /> </dx:ASPxGridView> </div>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)