Läsa databas och visa data i grid
======================================================================
<%@ Page Language="C#" AutoEventWireup="true" Debug="true" CodeFile="db2.aspx.cs" Inherits="kurser_prog10_net_lektion6_db_db2" %>
Untitled Page
Code behind
===========================
using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class kurser_prog10_net_lektion6_db_db2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == true)
{
}
else
{
// Databaskoppling
string pathDb = MapPath("..").ToString() + "\\db\\skivor2.mdb";
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + pathDb;
string strSql = "select * from artister order by id_artist desc";
OleDbConnection conn = new OleDbConnection(strConn);
OleDbDataAdapter da = new OleDbDataAdapter(strSql, conn);
DataSet _ds = new DataSet();
da.Fill(_ds, "artister");
gridSkivor.DataSource = _ds.Tables["artister"];
gridSkivor.DataBind();
}
}
}
Lägga in ny post
===================================================================================
<%@ Page Language="C#" AutoEventWireup="true" Debug="true" CodeFile="nytt.aspx.cs" Inherits="kurser_prog10_net_lektion6_db_nytt" %>
Nytt
Code behind
===========================
using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class kurser_prog10_net_lektion6_db_nytt : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btSend_Click(object sender, EventArgs e)
{
string pathDb = MapPath("..").ToString() + "\\db\\skivor2.mdb";
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + pathDb;
string strSql = "insert into artister (fldFnamn, fldEnamn) values ('" + tbFnamn.Text + "','" + tbEnamn.Text + "')";
OleDbConnection conn = new OleDbConnection(strConn);
OleDbCommand command = new OleDbCommand(strSql, conn);
command.Connection.Open();
int nqSvar;
try
{
nqSvar = command.ExecuteNonQuery();
lbError.Text = nqSvar.ToString();
}
catch
{
lbError.Text = "Fel vid sändande av SQL-sats " + strSql;
}
finally
{
command.Connection.Close();
}
}
}
Uppdatera - klassversion
=====================================================================
using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class kurser_prog10_net_lektion6_db_klassDb : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string strSql = "insert into artister (fldFnamn, fldEnamn) values ('Patric', 'Svärd')";
skickaSql ide = new skickaSql(lbDebug, strSql, MapPath("..").ToString());
}
}
public partial class skickaSql
{
public skickaSql(Label lb, String strSql, String mapPath)
{
string pathDb = mapPath + "\\db\\skivor2.mdb";
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + pathDb;
lb.Text = strConn + "
" + strSql;
OleDbConnection conn = new OleDbConnection(strConn);
OleDbCommand command = new OleDbCommand(strSql, conn);
command.Connection.Open();
int nqSvar;
try
{
nqSvar = command.ExecuteNonQuery();
lb.Text = nqSvar.ToString();
}
catch
{
lb.Text = "Fel vid sändande av SQL-sats " + strSql;
}
finally
{
command.Connection.Close();
}
}
}
Code behind
======================================
using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class kurser_prog10_net_lektion6_db_klassDb : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string strSql = "insert into artister (fldFnamn, fldEnamn) values ('Patric', 'Svärd')";
skickaSql ide = new skickaSql(lbDebug, strSql, MapPath("..").ToString());
}
}
public partial class skickaSql
{
public skickaSql(Label lb, String strSql, String mapPath)
{
string pathDb = mapPath + "\\db\\skivor2.mdb";
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + pathDb;
lb.Text = strConn + "
" + strSql;
OleDbConnection conn = new OleDbConnection(strConn);
OleDbCommand command = new OleDbCommand(strSql, conn);
command.Connection.Open();
int nqSvar;
try
{
nqSvar = command.ExecuteNonQuery();
lb.Text = nqSvar.ToString();
}
catch
{
lb.Text = "Fel vid sändande av SQL-sats " + strSql;
}
finally
{
command.Connection.Close();
}
}
}