C# » dotnet4

Archive for the ‘dotnet4_eucsyd’ Category

connected disconnected mode

oktober 7, 2013 by admin | No Comments | Filed in ado.net, c# kode, dotnet4_eucsyd

ved web sites bruges mest connected, dvs der er kontakt med de RIGTIGE data i Databasen.

disconnected kan feks bruges til et winforms projekt hvor man arbejder lokalt og så ellers sender data til database med en update button.

I disconnected mode kan husker den selv at man måske både slette, insætter og updaterer forskellige felter.

Tags: connected mode, database, disconnected mode

CRUD ado.net eksempel

oktober 7, 2013 by admin | No Comments | Filed in ado.net, c# kode, dotnet4_eucsyd

create + read + update + delete = CRUD

Dette er winforms eksemplet

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms;

using System.Data.SqlClient;

namespace DisconnectedCRUD
{
public partial class Form1 : Form
{
SqlDataAdapter adapter;
DataSet kunderDS;

public Form1()
{
InitializeComponent();
dataGridView1.MultiSelect = false;
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;

LoadData();
}

public void LoadData()
{
string conString = @”Data Source=.sqlexpress;Initial Catalog=KundeDB;”;
conString += “Integrated Security=True”;

string sqlString = “SELECT * FROM Kunder”;

SqlConnection con = new SqlConnection(conString);
SqlCommand cmd = new SqlCommand(sqlString, con);

adapter = new SqlDataAdapter(cmd);
SqlCommandBuilder cb = new SqlCommandBuilder(adapter);
kunderDS = new DataSet();

adapter.Fill(kunderDS, “Kunder”);

cbKunder.DataSource = kunderDS.Tables[“Kunder”];
cbKunder.DisplayMember = “Navn”;
cbKunder.ValueMember = “ID”;

this.dataGridView1.DataSource = kunderDS.Tables[“Kunder”];
}

private void btnInsert_Click(object sender, EventArgs e)
{
DataRow myRow = kunderDS.Tables[“Kunder”].NewRow();
myRow[“Navn”] = txtKundenavn.Text;
myRow[“Adresse”] = txtAdresse.Text;
kunderDS.Tables[“Kunder”].Rows.Add(myRow);
adapter.Update(kunderDS, “Kunder”);

LoadData();
}

private void btnUpdate_Click(object sender, EventArgs e)
{
int item = dataGridView1.SelectedRows[0].Index;
kunderDS.Tables[“Kunder”].Rows[item][“Navn”] = txtKundenavn.Text;
kunderDS.Tables[“Kunder”].Rows[item][“Adresse”] = txtAdresse.Text;
adapter.Update(kunderDS, “Kunder”);

LoadData();
}

private void btnDelete_Click(object sender, EventArgs e)
{
int item = dataGridView1.SelectedRows[0].Index;
kunderDS.Tables[“Kunder”].Rows[item].Delete();
adapter.Update(kunderDS, “Kunder”);

LoadData();
}
}
}

Tags: adaptor.fill, SqlCommandBuilder, SqlDataAdapter

sqlconnection med parametre

januar 3, 2013 by admin | No Comments | Filed in c# kode, dotnet4_eucsyd

// string sqlString = "SELECT UserName FROM UserInfoTable";

SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand(“CreateMessage”, con);
cmd.CommandType = CommandType.StoredProcedure;

//input parametre til storaged procedure
SqlParameter param = new SqlParameter(“@MsgTitle”, SqlDbType.NChar, 20);
param.Value = msgTitle;
cmd.Parameters.Add(param);

param = new SqlParameter(“@MsgContent”, SqlDbType.NVarChar, 300);
param.Value = msgContent;
cmd.Parameters.Add(param);

param = new SqlParameter(“@UserID”, SqlDbType.Int, 4);
param.Value = userID;
cmd.Parameters.Add(param);
//kør

con.Open();
int localstatus = cmd.ExecuteNonQuery();
con.Close();

Tags: cmd, con.open, ExecuteNonQuer, param.value, SELECT, sqlconnection, sqlparameter

CRUD ado.net eksempel

december 22, 2012 by admin | No Comments | Filed in ado.net, c# kode, dotnet4_eucsyd

create + read + update + delete = CRUD

Dette er winforms eksempel på hvordan CRUD opsættes og bruges.

Eksemplet kan let overføres til feks ASP.NET, eller anden .NET ‘ting.

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms;

using System.Data.SqlClient;

namespace DisconnectedCRUD
{
public partial class Form1 : Form
{
SqlDataAdapter adapter;
DataSet kunderDS;

public Form1()
{
InitializeComponent();
dataGridView1.MultiSelect = false;
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;

LoadData();
}

public void LoadData()
{
string conString = @”Data Source=.\sqlexpress;Initial Catalog=KundeDB;”;
conString += “Integrated Security=True”;

string sqlString = “SELECT * FROM Kunder”;

SqlConnection con = new SqlConnection(conString);
SqlCommand cmd = new SqlCommand(sqlString, con);

adapter = new SqlDataAdapter(cmd);
SqlCommandBuilder cb = new SqlCommandBuilder(adapter);
kunderDS = new DataSet();

adapter.Fill(kunderDS, “Kunder”);

cbKunder.DataSource = kunderDS.Tables[“Kunder”];
cbKunder.DisplayMember = “Navn”;
cbKunder.ValueMember = “ID”;

this.dataGridView1.DataSource = kunderDS.Tables[“Kunder”];
}

LoadData();
}

private void btnDelete_Click(object sender, EventArgs e)
{
int item = dataGridView1.SelectedRows[0].Index;
kunderDS.Tables[“Kunder”].Rows[item].Delete();
adapter.Update(kunderDS, “Kunder”);

LoadData(); } } }