السلام عليكم
تعلمت
في الوين فورم C#
والان asp.NET
هل نيتطليع كتابة كود ربط القاعدة
CLASS في C#
وعرض البيانات
CLASS في C#
{
protected void Page_Load(object sender, EventArgs e)
{
AccessBDManager C_Connection = new AccessBDManager(@"\Gest_Stock.mdb");
System.Data.DataSet DSDeces = C_Connection.DataAllView("select * from Fournisseur ", "Fournisseur");
C_Connection.Free();
TextBox1.DataBinding.Add("text", DSDeces, "Fournisseur.RaisonSociale");
Grid_List.DataSource = DSDeces.Tables["Fournisseur"];
}
public partial class groupeiacp_aspx : System.Web.UI.Page
لقد استعملة هدا
ولا النتية
------------------------
هل يجب كتابة
ID="AccessDataSource1"
runat="server"
DataFile="~/App_Code/Data/Gest_Stock.mdb"
OnSelecting="AccessDataSource1_Selecting"
SelectCommand="SELECT [CodeFournisseur], [RaisonSociale], [Rue], [Ville], [CodePostal], [TelFour], [FaxFour], [NoClientIACP], [DelaiLivraison], [NomCommercial], [TelCommercial], [Commentaires], [Email], [Rue2], [NomLivreur], [TelLivreur], [Indact] FROM [Fournisseur]">
</asp:AccessDataSource>
</div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="CodeFournisseur" DataMember="DefaultView" DataSourceID="AccessDataSource1" AllowPaging="True">
<Columns>
<asp:BoundField DataField="CodeFournisseur" HeaderText="CodeFournisseur" ReadOnly="True" SortExpression="CodeFournisseur" />
<asp:BoundField DataField="RaisonSociale" HeaderText="RaisonSociale" SortExpression="RaisonSociale" />
<asp:BoundField DataField="Rue" HeaderText="Rue" SortExpression="Rue" />
<asp:BoundField DataField="Ville" HeaderText="Ville" SortExpression="Ville" />
<asp:BoundField DataField="CodePostal" HeaderText="CodePostal" SortExpression="CodePostal" />
<asp:BoundField DataField="TelFour" HeaderText="TelFour" SortExpression="TelFour" />
<asp:BoundField DataField="FaxFour" HeaderText="FaxFour" SortExpression="FaxFour" />
<asp:BoundField DataField="NoClientIACP" HeaderText="NoClientIACP" SortExpression="NoClientIACP" />
<asp:BoundField DataField="DelaiLivraison" HeaderText="DelaiLivraison" SortExpression="DelaiLivraison" />
<asp:BoundField DataField="NomCommercial" HeaderText="NomCommercial" SortExpression="NomCommercial" />
<asp:BoundField DataField="TelCommercial" HeaderText="TelCommercial" SortExpression="TelCommercial" />
<asp:BoundField DataField="Commentaires" HeaderText="Commentaires" SortExpression="Commentaires" />
<asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />
<asp:BoundField DataField="Rue2" HeaderText="Rue2" SortExpression="Rue2" />
<asp:BoundField DataField="NomLivreur" HeaderText="NomLivreur" SortExpression="NomLivreur" />
<asp:BoundField DataField="TelLivreur" HeaderText="TelLivreur" SortExpression="TelLivreur" />
<asp:BoundField DataField="Indact" HeaderText="Indact" SortExpression="Indact" />
</Columns>
</asp:GridView>
<asp:AccessDataSource