Hvorfor virker mit datagrid ikke
Jeg prøver ganske simpelt at knytte en tabel til et datagrid og få vist dette på min aspx-side.Problemet er bare at der intet bliver vist...Hverken fejl eller noget. Kun min knap og min label. Hvad gør jeg forkert?
Mvh. Bumle90
/*********DBHandler******************/
using System;
using System.Data;
using System.Data.OleDb;
//X:\A502\udvikling\Cert2004\Tempcertdat.mdb
namespace WebApplication1
{
/// <summary>
/// Summary description for DBhandler.
/// </summary>
public class DBhandler
{
private string connectionstring;
private OleDbConnection conn;
public DBhandler(string dbpath) //kaster alle exceptions videre
{
connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+@"dbpath";
conn = new OleDbConnection(@connectionstring);//@ betyder at \ ikke er escapechar
}
public DataSet fetch(string sql)
{
//System.Collections.ArrayList servernames=new System.Collections.ArrayList();
DataSet dataset= new DataSet();
try
{
//OleDbCommand cmd = new OleDbCommand(sql,conn);
OleDbDataAdapter myAdapter = new OleDbDataAdapter( sql, conn );
conn.Open();
myAdapter.Fill(dataset);
}
catch(Exception ex)
{
//MessageBox.Show(ex.Message);
}
return dataset;
}
public bool insert()
{
return true;
}
public int delete_update(string sql)
{
int retval;
conn = new OleDbConnection(connectionstring);
OleDbCommand cmd = new OleDbCommand(sql,conn);
conn.Open();
retval=cmd.ExecuteNonQuery();
conn.Close();
return retval;
}
}
}
/*************WebForm1.aspx.cs**********/
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
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 WebApplication1
{
/// <summary>
/// Summary description for WebForm1.
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
protected Label resultLabel;
protected Button triggerButton;
protected DataGrid tbldata;
private void Page_Load(object sender, System.EventArgs e)
{
try
{
WebApplication1.DBhandler db=new WebApplication1.DBhandler(@"X:\A502\udvikling\Cert2004\Tempcertdat.mdb");
System.Data.DataSet dataset=db.fetch("SELECT * FROM T_CertifilatNoegle");
tbldata.DataSource=dataset.Tables["T_CertifilatNoegle"];
tbldata.DataBind();
//tbldata.
}
catch(Exception myexc)
{
resultLabel.Text=myexc.Message;
}
// Put user code to initialize the page here
}
#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.triggerButton.Click += new System.EventHandler(this.triggerButton_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void triggerButton_Click(object sender, System.EventArgs e)
{
resultLabel.Text = "Button clicked!";
}
}
}
/**********Webform1.aspx*************/
<%@ Page language="c#" Codebehind="WebForm1.aspx.cs" AutoEventWireup="false" Inherits="WebApplication1.WebForm1" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>WebForm1</title>
<meta content="True" name="vs_snapToGrid">
<meta content="True" name="vs_showGrid">
<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:label id="resultLabel" Runat="server"></asp:label><br>
<asp:button id="triggerButton" Text="Click me" Runat="server"></asp:button>
<asp:DataGrid Runat="server" ID="tbldata" /></form>
</body>
</HTML>
