Duomenu itraukimas i DB, per visual studio windows form i oracle.

Sveiki, iskilo tokia bega, nzn kaip itraukti nauja eilute duomenu i duomenu baze. Pvz ivedu vardas pavarde adresas miestas ir t.t. Ir paspaudus migtuka reikia kad ivestu duomenis i duomenu baze. Naudojama Visual studio 2010 windows form su C# ir duomenys keliami i oracle db.

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;

 

namespace baze

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

 

private void label1_Click(object sender, EventArgs e)

{

 

}

 

private void textBox1_TextChanged(object sender, EventArgs e)

{

 

}

 

private void textBox3_TextChanged(object sender, EventArgs e)

{

 

}

 

private void Kebulas_SelectedIndexChanged(object sender, EventArgs e)

{

 

}

 

private void textBox2_TextChanged(object sender, EventArgs e)

{

 

}

 

private void dateTimePicker1_ValueChanged(object sender, EventArgs e)

{

 

}

 

private void textBox4_TextChanged(object sender, EventArgs e)

{

 

}

 

private void Degalai_SelectedIndexChanged(object sender, EventArgs e)

{

 

}

 

private void textBox5_TextChanged(object sender, EventArgs e)

{

 

}

 

private void Form1_Load(object sender, EventArgs e)

{

// TODO: This line of code loads data into the 'dataSet1.NUOMA' table. You can move, or remove it, as needed.

this.nUOMATableAdapter.Fill(this.dataSet1.NUOMA);

// TODO: This line of code loads data into the 'dataSet1.AUTOMOBILIS' table. You can move, or remove it, as needed.

this.aUTOMOBILISTableAdapter.Fill(this.dataSet1.AUTOMOBILIS);

this.Kebulas.Items.Add("Sedanas");

this.Kebulas.Items.Add("Hečbekas");

this.Kebulas.Items.Add("Kupė");

this.Kebulas.Items.Add("Universalas");

this.Kebulas.Items.Add("Limuzinas");

this.Degalai.Items.Add("Benzinas");

this.Degalai.Items.Add("Benzinas/Dujos");

this.Degalai.Items.Add("Dyzelis");

this.Degalai.Items.Add("Dujos");

}

 

private void button1_Click(object sender, EventArgs e)

{

 

}

 

private void bindingSource1_CurrentChanged(object sender, EventArgs e)

{

 

}

 

private void button2_Click(object sender, EventArgs e)

{

new Form2 ().Show();

 

}

 

private void button3_Click(object sender, EventArgs e)

{

 

}

}

}

C#Linq+MSSQL DB

if (isValid)
           {
               try
               {
                   employee newEmpl = new employee();
                   DB.employees.InsertOnSubmit(newEmpl);
                   DB.SubmitChanges();
               }
               catch (Exception exc) { MessageBox.Show(exc.ToString(), "Error", MessageBoxButton.OK); }
           }

using System;
using System.Collections.Generic;
using System.Linq;
using DbLinq.Linq.Mapping;
using System.Data.OracleClient;

class OracleTest
{
static void Main(string[] args)
{
string connStr = “User Id=linq;Password=linq;Data Source=XE”;

Linq db = new Linq(new OracleConnection(connStr)); // Linq is the mapperclass created with DbMetal

Console.WriteLine(“Select and delete all temperatures:”);
var q1 = from p in db.Degrees select p;
//db.Degrees.RemoveAll(q1); // Not implemented 
Console.WriteLine(“Fired sql:”);
Console.WriteLine(db.GetQueryText(q1));
Console.WriteLine(“Result:”);
foreach (var v in q1)
{
Console.WriteLine(v.DEGKey + ” – ” + v.DEGDate + ” – ” + v.DEGCeLcIUs); // For some reason DbMetal makes a very cryptic property name
db.Degrees.DeleteOnSubmit(v);
}
db.SubmitChanges();
Console.WriteLine(“——”);

Console.WriteLine(“Select temperatures (none):”);
var q2 = from p in db.Degrees select p;
Console.WriteLine(“Fired sql:”);
Console.WriteLine(db.GetQueryText(q2));
Console.WriteLine(“Result:”);
Console.WriteLine(“DEGKEY – DEGDATE – DEGCELCIUS”);
foreach (var v in q2)
{
Console.WriteLine(v.DEGKey + ” – ” + v.DEGDate + ” – ” + v.DEGCeLcIUs); // For some reason DbMetal makes a very cryptic property name
}
Console.WriteLine(“——”);

Console.WriteLine(“Insert temperature 1:”);
Degrees a = new Degrees();
a.DEGKey = 1;
a.DEGDate = System.DateTime.Now;
a.DEGCeLcIUs = 1;
db.Degrees.InsertOnSubmit(a);
System.Threading.Thread.Sleep(5000);
Console.WriteLine(“Insert temperature 2:”);
Degrees b = new Degrees();
b.DEGKey = 2;
b.DEGDate = System.DateTime.Now;
b.DEGCeLcIUs = 2;
db.Degrees.InsertOnSubmit(b);
System.Threading.Thread.Sleep(5000);
Console.WriteLine(“Insert temperature 3:”);
Degrees c = new Degrees();
c.DEGKey = 3;
c.DEGDate = System.DateTime.Now;
c.DEGCeLcIUs = 3;
db.Degrees.InsertOnSubmit(c);

db.SubmitChanges();
Console.WriteLine(“——”);

Console.WriteLine(“Select all temperatures:”);
var q3 = from p in db.Degrees select p;
Console.WriteLine(“Fired sql:”);
Console.WriteLine(db.GetQueryText(q3));
Console.WriteLine(“Result:”);
Console.WriteLine(“DEGKEY – DEGDATE – DEGCELCIUS”);
foreach (var v in q3)
{
Console.WriteLine(v.DEGKey + ” – ” + v.DEGDate + ” – ” + v.DEGCeLcIUs); // For some reason DbMetal makes a very cryptic property name
}
Console.WriteLine(“——”);

Console.WriteLine(“Select all temperatures higher than 1 and add 5 to these:”);
var q4 = from p in db.Degrees where p.DEGCeLcIUs>1 select p;
Console.WriteLine(“Fired sql:”);
Console.WriteLine(db.GetQueryText(q4));
Console.WriteLine(“Result:”);
Console.WriteLine(“DEGKEY – DEGDATE – DEGCELCIUS”);
foreach (var v in q4)
{
Console.WriteLine(v.DEGKey + ” – ” + v.DEGDate + ” – ” + v.DEGCeLcIUs); // For some reason DbMetal makes a very cryptic property name
}
foreach (var v in q4)
{
v.DEGCeLcIUs+=5;
}
db.SubmitChanges();
Console.WriteLine(“——”);

Console.WriteLine(“Select all temperatures:”);
var q5 = from p in db.Degrees select p;
Console.WriteLine(“Fired sql:”);
Console.WriteLine(db.GetQueryText(q5));
Console.WriteLine(“Result:”);
Console.WriteLine(“DEGKEY – DEGDATE – DEGCELCIUS”);
foreach (var v in q5)
{
Console.WriteLine(v.DEGKey + ” – ” + v.DEGDate + ” – ” + v.DEGCeLcIUs); // For some reason DbMetal makes a very cryptic property name
}
Console.WriteLine(“——”);

}
}

paimt iš čia.