[es] - asp.net, ms access i datagrid problem!

milanvla
Srbija

Član broj: 11686
Poruke: 132
*.pat-pool.kg.sbb.co.yu.

Profil

asp.net, ms access i datagrid problem!

^{18.09.2005. u 09:58 - pre 226 meseci}

Pozdrav momci

imam jednu bazu u access-u sa tabelom people ID, FName, LName
nista posebno i zelim na aspx strani da u datagrid prikazem sadrzaj baze

ovo mi je code od index.aspx strane:

Code:

<%@ Page language="c#" Codebehind="index.aspx.cs" AutoEventWireup="false" Inherits="Nable_Soft.WebForm1" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
    <HEAD>
        <title>WebForm1</title>
        <meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
        <meta content="C#" name="CODE_LANGUAGE">
        <meta content="JavaScript" name="vs_defaultClientScript">
        <meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
    </HEAD>
    <body>
        <form id="Form1" method="post" runat="server">
            <asp:datagrid id="DataGrid1" runat="server" PageSize="3" AllowPaging="True" AutoGenerateColumns="False"
                AllowSorting="True" BackColor="#E0E0E0" BorderColor="Black" BorderStyle="Dashed" Font-Names="Arial"
                AllowCustomPaging="True">
                <Columns>
                    <asp:BoundColumn DataField="lastname" SortExpression="FName" HeaderText="First Name"></asp:BoundColumn>
                    <asp:BoundColumn DataField="firstname" SortExpression="LName" HeaderText="Last Name"></asp:BoundColumn>
                </Columns>
            </asp:datagrid></form>
    </body>
</HTML>

na stranici index.aspx.cs imam ovaj code:

Code:

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace Nable_Soft
{
    /// <summary>
    /// Summary description for WebForm1.
    /// </summary>
    public class WebForm1 : System.Web.UI.Page
    {
        public OleDbConnection      con;
        public OleDbDataAdapter      dAdapter;
        public DataSet              dSet;
        protected System.Web.UI.WebControls.DataGrid DataGrid1;
        public string conString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=data.mdb";

        private void InitializeComponent()
        {

        }

        private void Page_Load(object sender, System.EventArgs e)
        {
            // Put user code to initialize the page here
            con =new OleDbConnection(conString);

            con.Open();
            dAdapter = new OleDbDataAdapter();

            dAdapter.SelectCommand = new OleDbCommand("select FName,LName from people", con);
            dSet=new DataSet();

            //refreshes rows in the DataSet
            dAdapter.Fill(dSet);
            DataGrid1.DataSource = dSet;
            DataGrid1.DataMember = "people";
            DataGrid1.DataBind();

            con.Close();
        }
    }
}

ovo ne javlja nikakvu gresku ali ne uradi ono sto zelim da sadrzaj tabele FName i LName ispise u DataGrid

hvala na pomoci

pozdrav

http://www.menjamauto.com/

Odgovor na temu

negyxo
Aleksandar Perkuchin

Član broj: 29751
Poruke: 898
*.sksyu.net.

+171 Profil

Re: asp.net, ms access i datagrid problem!

^{18.09.2005. u 10:47 - pre 226 meseci}

Mislim da nesto fali

Ne vidim nigde OnInit u tvom index.aspx.cs

obicno ide ovako

Code:

#region Web Form Designer generated code
    override protected void OnInit(EventArgs e)
    {
        //
        // CODEGEN: This call is required by the ASP.NET Web Form Designer.
        //
        InitializeComponent();
        base.OnInit(e);
    }

    /// <summary>
    /// Required method for Designer support - do not modify
    /// the contents of this method with the code editor.
    /// </summary>
    private void InitializeComponent()
    {
        this.Load += new System.EventHandler(this.Page_Load);
    }
#endregion

Ovako imas samo funkciju Page_Load koja nista ne radi, odnosno verovatno radi ali se ne poziva nigde.
Mislim da ti je IDE nekako progutao ovo iznad. I ja sam primetio da se desava da nekad nestane, obicno je to kad caprkas nesto po kodu sto designer treba da odradi.

Odgovor na temu