Sitter och leker lite med code behind, men jag får det inte att funka.
Skulle bli glad om nån vill ge mig lite hjälp på vägen! :OO
Compiler Error Message: CS0246: The type or namespace name 'dgrAllNames' could not be found (are you missing a using directive or an assembly reference?)
[b][red]Line 20: dgrAllNames.DataSource = cmd.ExecuteReader([/red][/b]
[b]main_cb.aspx:[/b]
<%@ Page Language="c#" %>
<%@ Register TagPrefix="UserControl" TagName="Header" Src="header.ascx" %>
<html>
<head>
</head>
<body>
<form runat="server">
<UserControl:Header id="UserControl1" runat="server"></UserControl:Header>
</form>
</body>
</html>
[b]header.ascx:[/b]
<%@ Control Language="c#" Inherits="HeaderClass" Src="header_CB.cs" %>
<asp:DataGrid id="dgrAllNames" HorizontalAlign="Center" CellPadding="3" Runat="server"></asp:DataGrid>
[b]header_CB.cs:[/b]
using System;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Collections;
using System.Data;
using System.Data.Odbc;
public class HeaderClass : UserControl {
private const string ConnStr = "Driver={MySQL ODBC 3.51 Driver};" +
"Server=localhost;Database=accounts;uid=root;pwd=;option=3";
protected override void OnInit(EventArgs e) {
base.OnInit(e);
using(OdbcConnection con = new OdbcConnection(ConnStr))
using(OdbcCommand cmd = new OdbcCommand("SELECT * FROM names", con)) {
con.Open();
[b][red]dgrAllNames.DataSource = cmd.ExecuteReader([/red][/b]
CommandBehavior.CloseConnection |
CommandBehavior.SingleResult);
dgrAllNames.DataBind();
}
}
}
bifogar filerna om det finns intresse av att testköra