Hele webformen:
<%@ Page language="c#" Codebehind="maillist_config.aspx.cs" AutoEventWireup="false" Inherits="emotor.builder.maillist.maillist_config" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title></title>
</HEAD>
<body>
<form id="maillist_config" method="post" runat="server">
<asp:DropDownList id="dropID" runat="server"></asp:DropDownList>
<asp:ImageButton id="btnNavigate" runat="server" OnClick="dp_Click"></asp:ImageButton>
<br><br>
<asp:DataList id="dl" runat="server">
<ItemTemplate>
<table border="0" cellpadding="3" cellspacing="0">
<tr>
<td>Mail Server: <asp:textbox id="tbMailServer" Text='<%#DataBinder.Eval ( Container, "DataItem.mailServer" )%>' runat="server"></asp:TextBox></td>
</tr>
<tr>
<td>Email: <asp:textbox id="tbEmail" Text='<%#DataBinder.Eval ( Container, "DataItem.emailAddress" )%>' runat="server"></asp:TextBox></td>
</tr>
<tr>
<td>Velkomst mail: <asp:textbox id="tbWelcomeMsg" Text='<%#DataBinder.Eval ( Container, "DataItem.messageWelcome" )%>' runat="server" TextMode="MultiLine"></asp:TextBox></td>
</tr>
<tr>
<td><asp:imagebutton id="btnUpdate" runat="server" EnableViewState="False"></asp:ImageButton><br>
<asp:LinkButton id=LinkButton1 runat="server" OnClick="tb_Update">LinkButton</asp:LinkButton></td>
</tr>
</table>
</ItemTemplate>
</asp:DataList>
</form>
</body>
</HTML>
hele codebehind
using System;
using System.Collections;
using System.ComponentModel;
using System.Configuration;
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;
using CoreLab.MySql;
// Class maillist_config in emotor.builder.maillist
namespace emotor.builder.maillist {
public class maillist_config : System.Web.UI.Page {
// Web Controls used
protected System.Web.UI.WebControls.TextBox tbEmail;
protected System.Web.UI.WebControls.TextBox tbWelcomeMsg;
protected System.Web.UI.WebControls.TextBox tbMailServer;
protected System.Web.UI.WebControls.ImageButton btnUpdate;
protected System.Web.UI.WebControls.DataList dl;
protected System.Web.UI.WebControls.DropDownList dropID;
protected System.Web.UI.WebControls.ImageButton btnNavigate;
// SQL Query
public string SqlString;
// MySql Path
public string ConnectionString = ConfigurationSettings.AppSettings["MySqlSource"].ToString();
// Page Load
private void Page_Load(object sender, System.EventArgs e) {
if (!(IsPostBack)) {
// Run Functions
dp_Bind();
tb_Bind();
}
}
// General MySql Connection
public CoreLab.MySql.MySqlConnection OpenMySqlConnection () {
CoreLab.MySql.MySqlConnection Conn = new CoreLab.MySql.MySqlConnection();
Conn.ConnectionString = ConnectionString;
return Conn;
}
// Bind textboxes
protected void tb_Bind() {
// Set SQL SELECT Query
string strID = Request.QueryString["id"];
SqlString = "SELECT * FROM mailconfig WHERE id = '"+ strID +"'";
// Create and fill DataAdapter object
CoreLab.MySql.MySqlConnection Conn = OpenMySqlConnection();
Conn.Open();
CoreLab.MySql.MySqlDataAdapter objDataAdapter = new CoreLab.MySql.MySqlDataAdapter(SqlString,Conn);
Conn.Close();
// Fill DataSet from DataAdapter
DataSet ds = new DataSet();
objDataAdapter.Fill(ds);
// Bind DataSet to DataList
dl.DataSource = ds;
dl.DataBind();
}
// Bind DropDownList
protected void dp_Bind() {
// Set SQL SELECT Query
SqlString = "SELECT * FROM mailconfig";
// Create and fill DataAdapter object
CoreLab.MySql.MySqlConnection Conn = OpenMySqlConnection();
Conn.Open();
CoreLab.MySql.MySqlDataAdapter objDataAdapter = new CoreLab.MySql.MySqlDataAdapter(SqlString,Conn);
Conn.Close();
// Fill DataSet from DataAdapter
DataSet ds = new DataSet();
objDataAdapter.Fill(ds);
// Bind DataSet to DropDownList
dropID.DataTextField = "maillistTitle";
dropID.DataValueField = "id";
dropID.DataSource = ds;
dropID.DataBind();
dropID.Items.Insert(0,"-- Vælg en mailing liste --");
//dropID.Attributes.Add("onchange", "jumpMenu('this',this)") ;
}
// Event based on DropDownList value
protected void dp_Click(object sender, ImageClickEventArgs e) {
Response.Redirect("maillist_config.aspx?id=" + dropID.SelectedItem.Value);
}
// Updates Textboxes
protected void tb_Update(object sender, System.EventArgs e) {
// Set command and conn
CoreLab.MySql.MySqlConnection Conn = OpenMySqlConnection();
// Set SQL Query
string strID = Request.QueryString["id"];
//SqlString = "UPDATE mailconfig SET mailServer = '"+tbMailServer.Text+"', emailAddress = '"+tbEmail.Text+"', messageWelcome = '"+tbWelcomeMsg.Text+"' WHERE id = '"+ strID +"'";
SqlString = "UPDATE mailconfig SET mailServer = '"+((TextBox)FindControl("tbMailServer")).Text+"', emailAddress = '"+((TextBox)FindControl("tbEmail")).Text+"', messageWelcome = '"+((TextBox)FindControl("tbWelcomeMsg")).Text+"' WHERE id = '"+ strID +"'";
Response.Write(SqlString);
// Create Command object
MySqlCommand objCommand = new MySqlCommand(SqlString, Conn);
//Execute command
Conn.Open();
objCommand.ExecuteNonQuery();
Conn.Close();
// Rebind
dp_Bind();
}
#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
}
}
