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>
<%@ 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();
}
}
}
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