proggen.org

Code: Alles auswählen

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.SqlServerCe;

namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            // TODO: Diese Codezeile lädt Daten in die Tabelle "versuch_DatenbankDataSet.Personen". Sie können sie bei Bedarf verschieben oder entfernen.
            this.personenTableAdapter.Fill(this.versuch_DatenbankDataSet.Personen);
            Rumprobieren Ausfuehren = new Rumprobieren();
            Ausfuehren.ConnectListAndSaveSQLCompactExample();
        }
    }
    abstract class MeineMethoden
    {
        public void ConnectListAndSaveSQLCompactExample()
        {
            // Create a connection to the file ....sdf in the program folder
            string dbfile = new System.IO.FileInfo(System.Reflection.Assembly.GetExecutingAssembly().Location).DirectoryName + "\\Versuch_Datenbank.sdf";
            SqlCeConnection connection = new SqlCeConnection("datasource=" + dbfile);

            // Read all rows from the table test_table into a dataset (note, the adapter automatically opens the connection)
            SqlCeDataAdapter adapter = new SqlCeDataAdapter("select * from Personen", connection);

            //
            // habe auch das probiert: 
            // adapter.InsertCommand = new SqlCeCommand("INSERT INTO Personen",connection);
            // habe auch noch das probiert: SqlCeCommand blabla = adapter.InsertCommand;
            //

            DataSet data = new DataSet();
            adapter.Fill(data);

            // Add a row to the test_table (assume that table consists of a text column)
            data.Tables[0].Rows.Add(new object[] { "New row added by code" });

            // Save data back to the databasefile
            adapter.Update(data);

            // Close 
            connection.Close();
        }
    }
    class Rumprobieren : MeineMethoden
    {
        static void nochirgendwas()
        {
            Rumprobieren Ausfuehren = new Rumprobieren();
            Ausfuehren.ConnectListAndSaveSQLCompactExample();
        }
    }
}

Code: Alles auswählen

public class DbOp
	{
		private string table;
		private MySqlConnection con;
		private string login = 
				"SERVER=localhost;" +
				"DATABASE=test;" +
				"UID=root;" +
				"Password=;";
		private MySqlDataAdapter adapter;
		private string opString;
		
		public DbOp(string table_name)
		{
			table = table_name;
			//opString = "select * from " + table;
			opString = "select name.name, test.name from name, test where name.verweis = test.id";
			con = new MySqlConnection(login);
			adapter = new MySqlDataAdapter(opString, con);
			initCommands();
		}
		public void Fill(ref DataTable tabelle)
		{
			adapter.Fill(tabelle);
		}
		public void Fill(ref DataSet set)
		{
			adapter.Fill(set);
		}
		public void Update(ref DataTable tabelle)
		{
			
			adapter.Update(tabelle);
			//MessageBox.Show(tabelle.Rows[tabelle.Rows.Count-1][1].ToString());
		}
		public void Update(ref DataRow[] row)
		{
			adapter.Update(row);
		}
		private void initCommands()
		{
			/*
			adapter.InsertCommand = new MySqlCommand("Insert into test(id, name) values(@id, @name)", con);
			adapter.InsertCommand.Parameters.Add("@id", MySqlDbType.Int32);
			adapter.InsertCommand.Parameters.Add("@name", MySqlDbType.Text, 65535, "name");
			*/
			string insert_string = "BEGIN; INSERT INTO test(name) VALUES(@name); INSERT INTO name (name, verweis)  VALUES(@name1,LAST_INSERT_ID()); COMMIT;";
			//adapter.InsertCommand = new MySqlCommand("insert into " + table + "(name) values(@name)", con);
			adapter.InsertCommand = new MySqlCommand(insert_string, con);
			adapter.InsertCommand.Parameters.Add("@name", MySqlDbType.Text, 65535, "name");
			adapter.InsertCommand.Parameters.Add("@name1", MySqlDbType.Text, 65535, "name1");
		}
		
	}