<asp:GridView runat="server" ID="grdContact" AutoGenerateColumns="False" DataKeyNames="IdCustomer" DataSourceID="SqlDataSource1"> <Columns> <asp:BoundField DataField="CustomerName" ControlStyle-CssClass="td1 th1" HeaderText="name" SortExpression="CustomerName" /> <asp:BoundField DataField="CustomerPhone" ControlStyle-CssClass="td1 th1" HeaderText="phone" SortExpression="CustomerPhone" /> <asp:BoundField DataField="CustomerAdress" ControlStyle-CssClass="td1 th1" HeaderText="adress" SortExpression="CustomerAdress" /> <asp:BoundField DataField="CustomerMail" ControlStyle-CssClass="td1 th1" HeaderText="mail" SortExpression="CustomerMail" /> <asp:BoundField DataField="CustomerBirthDay" ControlStyle-CssClass="td1 th1" HeaderText="birthday" SortExpression="CustomerBirthDay" /> </Columns> </asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\ADMIN\source\repos\TOPjob\DalTJ\App_Data\Database.mdf;Integrated Security=True;MultipleActiveResultSets=True;Application Name=EntityFramework" ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM [Customers] WHERE ([CustomerCompany] = @CustomerCompany)"> <SelectParameters> <asp:Parameter DefaultValue="1000" Name="CustomerCompany" Type="Int32" /> </SelectParameters> </asp:SqlDataSource>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)