Create, Insert, Update, Delete using Dataset/TableAdapters

[Arkie]

You can perform CRUD operations on a microsoft sql server (2005+) using the class below, i haven't try/catched the two dropdownlist's but if you want you can write this:

try{
//code here
}
catch(Exception ee){
}
and copy/paste the code in the dropdownlist in the try block.

Code

GeSHi (csharp):
using System;
using System.Data;
using System.Configuration;
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 _Default : System.Web.UI.Page
{
    int i = 1;
 
    protected void Page_Load(object sender, EventArgs e)
    {
        PersoonDataSetTableAdapters.PersonenTableAdapter Adapter = new PersoonDataSetTableAdapters.PersonenTableAdapter();
 
        if (Page.IsPostBack)
        {
            Label1.Text = "postback? " + Page.IsPostBack;
        }
        if (!Page.IsPostBack)
        {
            DropDownList1.DataBind();
            DropDownList1.Items.Insert(0, " ");
            DropDownList2.DataBind();
            DropDownList2.Items.Insert(0, " ");
            Label1.Text = "postback? " + Page.IsPostBack;
        }
        TextBox6.Enabled = false;
        TextBox7.Enabled = false;
 
 
        TextBox1.Enabled = false;
        TextBox9.Enabled = false;
        TextBox10.Enabled = false;
        Button1.Enabled = false;
        Button3.Enabled = false;
    }
 
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        try
        {
            PersoonDataSetTableAdapters.PersonenTableAdapter Adapter = new PersoonDataSetTableAdapters.PersonenTableAdapter();
            int value = int.Parse(DropDownList1.SelectedValue);
 
            TextBox1.Text = "" + Adapter.GetPersoonID(value)[0].PersoonID;
            TextBox9.Text = Adapter.GetPersoonID(value)[0].Naam;
            TextBox10.Text = Adapter.GetPersoonID(value)[0].Geslacht;
 
           Label2.Text = Adapter.GetPersoonID(value)[0].Naam;
            Button1.Enabled = true;
 
 
        }
        catch (Exception ee)
        {
 
        }
 
    }
 
    protected void Button2_Click(object sender, EventArgs e)
    {
        PersoonDataSetTableAdapters.PersonenTableAdapter Adapter = new PersoonDataSetTableAdapters.PersonenTableAdapter();
        try
        {
            Adapter.InsertPersoon((Adapter.GetPersoon().Rows.Count + i), TextBox3.Text, TextBox4.Text);
            i = 0;
        }
        catch (Exception ee)
        {
            verhoogIDmetEen();
            Button2_Click(null, null);
        }
 
        refreshPage();
    }
 
    private void verhoogIDmetEen()
    {
        i++;
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        int value = int.Parse(TextBox5.Text);
        PersoonDataSetTableAdapters.PersonenTableAdapter Adapter = new PersoonDataSetTableAdapters.PersonenTableAdapter();
        TextBox5.Text = "" + Adapter.GetPersoonID(value)[0].PersoonID;
        Adapter.Update(TextBox6.Text, TextBox7.Text, value);
        Button3.Enabled = false;
        refreshPage();
    }
 
    protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
    {
 
        PersoonDataSetTableAdapters.PersonenTableAdapter Adapter = new PersoonDataSetTableAdapters.PersonenTableAdapter();
        int value = int.Parse(DropDownList2.SelectedValue);
 
        TextBox5.Text = "" + Adapter.GetPersoonID(value)[0].PersoonID;
        TextBox6.Text = Adapter.GetPersoonID(value)[0].Naam;
        TextBox7.Text = Adapter.GetPersoonID(value)[0].Geslacht;
 
        Label2.Text = Adapter.GetPersoonID(value)[0].Naam;
 
 
 
        TextBox6.Enabled = true;
        TextBox7.Enabled = true;
        Button2.Enabled = true;
        Button3.Enabled = true;     
    }
 
    public void refreshPage()
    {
        string scriptString = "<script language=JavaScript>window.location.href=window.location.href </script>";
        if (!Page.ClientScript.IsClientScriptBlockRegistered(scriptString))
        {
            Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "script", scriptString);
        }
    }
 
    protected void Button1_Click(object sender, EventArgs e)
    {
 
        PersoonDataSetTableAdapters.PersonenTableAdapter Adapter = new PersoonDataSetTableAdapters.PersonenTableAdapter();
        Adapter.DeletePersoonID(int.Parse(TextBox1.Text));
 
        refreshPage();
    }
 
    protected void GridView3_SelectedIndexChanged(object sender, EventArgs e)
    {
        try
        {
            PersoonDataSetTableAdapters.PersonenTableAdapter Adapter = new PersoonDataSetTableAdapters.PersonenTableAdapter();
 
            int gridValue = int.Parse(GridView3.SelectedRow.Cells[1].Text);
            int value = Adapter.GetPersoonID(gridValue)[0].PersoonID;
 
            TextBox5.Text = "" + Adapter.GetPersoonID(value)[0].PersoonID;
            TextBox6.Text = Adapter.GetPersoonID(value)[0].Naam;
            TextBox7.Text = Adapter.GetPersoonID(value)[0].Geslacht;
 
            TextBox1.Text = "" + Adapter.GetPersoonID(value)[0].PersoonID;
            TextBox9.Text = Adapter.GetPersoonID(value)[0].Naam;
            TextBox10.Text = Adapter.GetPersoonID(value)[0].Geslacht;
 
            DropDownList1.Enabled = false;
            DropDownList2.Enabled = false;
 
            TextBox6.Enabled = true;
            TextBox7.Enabled = true;
            Button1.Enabled = true;
            Button3.Enabled = true;
        }
        catch (Exception ee)
        {
 
        }
    }
    protected void TextBox1_TextChanged(object sender, EventArgs e)
    {
 
    }
}
 
Created by GeSHI 1.0.7.20

Create, Insert, Update, Delete using Dataset/TableAdapters