#include
using namespace std;

int main()
{
const float PI = 3.1415926;
int r = 0; float cir = 0;
cout << "Skriv radius: ";
cin >> r;
cir = 2 * r * PI;
cout <<>
system("pause");
return 0;
}

c++

#include

using namespace std;
int main(){ int x= 10; int y= 3;

string message = "Data type table";

string apndMessage = "welcome to the "; string totalMessage = "";

totalMessage = apndMessage + message;

cout <<>

/*cout << x = " << x << " y = " << y << endl; cout << " y = " << x+y << endl; cout << " y = " << x-y << endl; cout << " y = " << x*y << endl; cout << " y =" ">

system ("pause");

return 0; }

DEV c++

http://norwegian.toggle.com/lv/software/download/kl7863.htm

C:\Program Files\Microsoft SDKs\Windows\v6.0A\bin


gacutil.exe

I've installed a dll in the GAC (gacutil /i Employee.dll
gacutil -I MySql.Data.dll


MySql.Data.Dll

Stored Procedures

http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson07.aspx

http://www.c-sharpcorner.com/UploadFile/pk_khuman/ManagedStoredProceduresUsingCSharp02182007232059PM/ManagedStoredProceduresUsingCSharp.aspx


http://www.programmingado.net/a-133/Fetching-MySQL-data-through-stored-procedures.aspx

DELIMITER $$
DROP PROCEDURE IF EXISTS `db_test`.`City_GetByCountry`$$
CREATE PROCEDURE `db_test`.`City_GetByCountry` (p_in_country_id int)
BEGIN
select * from city where country_id=p_in_country_id;
END$$
DELIMITER ;

public DataTable GetDataSP_MySQL(long in_country_id)
{
MySql.Data.MySqlClient.MySqlConnection oConn = new MySql.Data.MySqlClient.MySqlConnection();
oConn.ConnectionString = "Database=sakila;Data Source=192.168.10.4;User id=stefan;Password=pekka"; oConn.Open();
DataSet oDataSet = new System.Data.DataSet("tab1");
//Get data
MySql.Data.MySqlClient.MySqlCommand command = new MySql.Data.MySqlClient.MySqlCommand("City_GetByCountry", oConn);
command.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("?p_in_country_id", DbType.Int32));
// Now, add a value to it and later execute the command as usual.
command.Parameters[0].Value = in_country_id;
command.CommandType = CommandType.StoredProcedure;
MySql.Data.MySqlClient.MySqlDataAdapter oAdapter =
new MySql.Data.MySqlClient.MySqlDataAdapter(command);
oAdapter.Fill(oDataSet, "tab1");
DataTable dt = oDataSet.Tables["tab1"];
oConn.Close();

return dt;
}


http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html

mysql> delimiter //
mysql> CREATE PROCEDURE simpleproc (OUT param1 INT)
-> BEGIN
-> SELECT COUNT(*) INTO param1 FROM t;
-> END//
Query OK, 0 rows affected (0.00 sec)
mysql> delimiter ;
mysql> CALL simpleproc(@a);
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT @a;
+------+
@a
+------+
3
+------+
1 row in set (0.00 sec)

Private Class properties

FORM1

namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button2_Click(object sender, EventArgs e)
{
HappyBirthday HB;
HB = new HappyBirthday();
string returB;
HB.MyProperty = "glenn";
returB = HB.MyProperty;
MessageBox.Show(returB);
}
}
}

Class

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace WindowsFormsApplication1
{
class HappyBirthday
{
private string getMessage(string givenName)
{
return "happy Birthday" + givenName;
}
private string birthdayMessage;

public string MyProperty
{
get { return birthdayMessage; }
set { birthdayMessage = getMessage(value); }
}
}
}

call metode from class

FORM1

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 WindowsFormsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
HappyBirthday birthdayMessage;
birthdayMessage = new HappyBirthday();
MessageBox.Show(birthdayMessage.getMessage());
}
}
}

CLASS

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace WindowsFormsApplication1
{
class HappyBirthday
{
public string getMessage()
{
return "happy Birthday";
}
}
}

Good turtorial

http://www.homeandlearn.co.uk/csharp/csharp.html http://www.homeandlearn.co.uk/csharp/csharp.htmlhttp://www.homeandlearn.co.uk/csharp/csharp.htmlhttp://www.homeandlearn.co.uk/csharp/csharp.htmlhttp://www.homeandlearn.co.uk/csharp/csharp.htmlhttp://www.homeandlearn.co.uk/csharp/csharp.html
http://www.homeandlearn.co.uk/csharp/csharp.html
http://www.homeandlearn.co.uk/csharp/csharp.html
http://www.homeandlearn.co.uk/csharp/csharp.html

http://www.homeandlearn.co.uk/csharp/csharp.html
http://www.homeandlearn.co.uk/csharp/csharp.html
http://www.homeandlearn.co.uk/csharp/csharp.html

http://www.homeandlearn.co.uk/csharp/csharp.htmlhttp://www.homeandlearn.co.uk/csharp/csharp.htmlhttp://www.homeandlearn.co.uk/csharp/csharp.html
http://www.homeandlearn.co.uk/csharp/csharp.html
http://www.homeandlearn.co.uk/csharp/csharp.html
http://www.homeandlearn.co.uk/csharp/csharp.html
http://www.homeandlearn.co.uk/csharp/csharp.html
http://www.homeandlearn.co.uk/csharp/csharp.html

function test

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 function_test
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
public void bluX()
{
if (this.BackColor == Color.Blue)
{
this.BackColor = Color.Black;
}
else
{
this.BackColor = Color.Blue;
}
}
private void button1_Click(object sender, EventArgs e)
{
bluX();
}

}
}

http://www.codeproject.com/KB/database/sql_in_csharp.aspx

http://www.codeproject.com/KB/database/sql_in_csharp.aspx

Example:
Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

myServerAddressm would be the IP of the server.myDataBase would be the name of the database on the server.myUsername and myPassword would be the user account in the database server.

http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Studio_.NET_2005/Q_23016900.html

SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["SecurityServerConnStr"]);

and your config should be the following





http://www.experts-exchange.com/Microsoft/Development/Visual_Studio_Express/Q_24167406.html

SELECT * FROM saker Where dato Between '04.05.2009' and'10.05.2009'

SELECT* FROM saker Where dato Between '04.05.2009' and'10.05.2009' AND brukernavn = 'glennj'

SELECT * FROM saker Where dato Between '04.05.2009' and'10.05.2009' AND brukernavn = 'glennj' OR brukernavn = 'henrya'

------------------
SELECT antallnye + antallgamle FROM saker Where dato Between '04.05.2009' and'10.05.2009' AND brukernavn = 'glennj' OR brukernavn = 'henrya'

-------------------------------

funker ikke
SELECT antallnye + antallgamle, (select antallgamle FROM saker Where dato Between '04.05.2009' and'05.05.2009' AND brukernavn = 'glennj') FROM saker Where dato Between '04.05.2009' and'05.05.2009' AND brukernavn = 'glennj'

SELECT (antallnye + antallgamle - (select antallnye FROM saker Where dato = '05.19.2009') ), dato FROM saker Where brukernavn = 'glennj' AND dato = '05.18.2009'

data =
______________antallnye___antallgamle_______løst
18.05.2009______6________9_______________4
19.05.2009 _____11________5_______________-4
20.05.2009 _____20_______11_______________


funker
--------------------------------
SELECT brukernavn, (antallnye + antallgamle - (select antallnye FROM saker Where dato = '05.19.2009' AND brukernavn = 'glennj' ) )as løst, dato FROM saker Where brukernavn = 'glennj' AND dato = '05.18.2009'
--------------------------------

ny spørring
---------------------------------
SELECT brukernavn, (antallnye + antallgamle - (select antallnye FROM saker Where dato = '05.19.2009' AND brukernavn = 'glennj' ) )as løst, dato FROM saker Where brukernavn = 'glennj' or brukernavn = ' henrya 'AND dato = '05.18.2009'

resultalt

	GLENNJ	4	18.05.2009
	GLENNJ	5	19.05.2009
	GLENNJ	19	20.05.2009

-------------------------------------------

Bruker IN funker må ha IN verdi inni ( )

SELECT brukernavn, (antallnye + antallgamle - (select antallnye FROM saker Where dato IN ('05.19.2009') AND brukernavn IN ('glennj') ) )as løst, dato FROM saker Where brukernavn IN ('glennj') AND dato IN ('05.18.2009')

------------------------------------------

private void button39_Click(object sender, EventArgs e)
{

DialogResult result = MessageBox.Show("vil du legge data in i Database?", "ja eller nei", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);

if (result == DialogResult.Yes)
{
MessageBox.Show("Da er det lagret!!");
}
else if (result == DialogResult.No)
{
MessageBox.Show("Ikke savet!!");
}

add binding source
dbBindingSource = bindnge source1
dbGridview = grid1

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 database_v3
{
public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
}
private void Form2_Load(object sender, EventArgs e)
{
string strCon = "Data Source=.\\SQLEXPRESS;AttachDbFilename=DataDirectory\\sakerDB.mdf;Integrated Security=True;User Instance=True";
string strSQL = "SELECT Brukernavn, antallnye + antallall AS Expr1, Dato FROM test_1";
SqlDataAdapter dataAdapter = new SqlDataAdapter(strSQL, strCon);
SqlCommandBuilder commandBuilder = new SqlCommandBuilder(dataAdapter);
// Populate a new data table and bind it to the BindingSource.
DataTable table = new DataTable();
table.Locale = System.Globalization.CultureInfo.InvariantCulture;
dataAdapter.Fill(table);
dbBindSource.DataSource = table;
// Resize the DataGridView columns to fit the newly loaded content.
dbGridView.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
// finally bind the data to the grid
dbGridView.DataSource = dbBindSource;
}
private void button1_Click(object sender, EventArgs e)
{
}
private void bindingSource1_CurrentChanged(object sender, EventArgs e)
{
}
}
}

SQL query tool

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace database_v3
{
public partial class frmSQLTester : Form
{
public frmSQLTester()
{
InitializeComponent();
}
SqlConnection booksConnection;
private void frmSQLTester_Load(object sender, EventArgs e)
{
booksConnection = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=DataDirectory\\sakerDB.mdf;Integrated Security=True;User Instance=True");
}
private void frmSQLTester_FormClosing(object sender, FormClosingEventArgs e)
{
booksConnection.Close();
booksConnection.Dispose();
}
private void btnTest_Click(object sender, EventArgs e)
{
SqlCommand resultsCommand = null;
SqlDataAdapter resultsAdapter = new SqlDataAdapter();
DataTable resultsTable = new DataTable();
try
{
// establish command object and data adapter
resultsCommand = new SqlCommand(txtSQLTester.Text, booksConnection);
resultsAdapter.SelectCommand = resultsCommand;
resultsAdapter.Fill(resultsTable);
// bind grid view to data table
grdSQLTester.DataSource = resultsTable;
lblRecords.Text = resultsTable.Rows.Count.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error in Processing SQL", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
resultsCommand.Dispose();
resultsAdapter.Dispose();
resultsTable.Dispose();
}
}
}

MySQL

Prompt Meaning
mysql> Ready for new command.
-> Waiting for next line of multiple-line command.
'> Waiting for next line, waiting for completion of a string that began with a single quote (“'”).
"> Waiting for next line, waiting for completion of a string that began with a double quote (“"”). `> Waiting for next line, waiting for completion of an identifier that began with a backtick (“`”).
/*> Waiting for next line, waiting for completion of a comment that began with /*.
________________________________________________
________________________________________________

mysql> SELECT VERSION(), CURRENT_DA

+------------------+--------------+
VERSION() CURRENT_DATE
+------------------+--------------+
5.1.34-community 2009-05-16
+------------------+--------------+
1 row in set (0.00 sec)
________________________________________________
________________________________________________
mysql> SELECT SIN(PI()/4), (4+1)*5;
+------------------+---------+
SIN(PI()/4) (4+1)*5
+------------------+---------+
0.70710678118655 25
+------------------+---------+
1 row in set (0.02 sec
________________________________________________
________________________________________________
mysql> SELECT VERSION(); SELECT NOW();
+-----------------+
VERSION()
+-----------------+
5.1.34-community
+-----------------+
1 row in set (0.00 sec)
+---------------------+
NOW()
+---------------------+
2009-05-16 11:17:49
+---------------------+
1 row in set (0.00 sec)
________________________________________________
________________________________________________
mysql> SELECT
-> USER()
-> ,
-> CURRENT_DATE;
+---------------+--------------+
USER() CURRENT_DATE
+---------------+--------------+
root@localhost 2009-05-16
+---------------+--------------+
________________________________________________
________________________________________________
mysql> SELECT * FROM my_table WHERE name = 'Smith AND age <>
'> `c
'> \c
'> '\c
mysql>
________________________________________________
mysql> SHOW DATABASES;
+----------+
Database
+----------+
mysql
test
tmp
+----------+

________________________________________________
________________________________________________

mysql> CREATE DATABASE menagerie;

mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
-> species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);

mysql> SHOW TABLES;
+---------------------+
Tables in menagerie
+---------------------+
pet
+---------------------+

mysql> DESCRIBE pet;
+---------+-------------+------+-----+---------+-------+
Field Type Null Key Default Extra
+---------+-------------+------+-----+---------+-------+
name varchar(20) YES NULL
owner varchar(20) YES NULL
species varchar(20) YES NULL
sex char(1) YES NULL
birth date YES NULL
death date YES NULL
+---------+-------------+------+-----+---------+-------+

________________________________________________
________________________________________________

in text file use /N for NULL an TAB to space between values

name owner species sex birth death

Fluffy Harold cat f 1993-02-04 \N

Claws Gwen cat m 1994-03-17 \N

Buffy Harold dog f 1989-05-13 \N

Fang Benny dog m 1990-08-27 \N

Bowser Diane dog m 1979-08-31 1995-07-29

Chirpy Gwen bird f 1998-09-11 \N

Whistler Gwen bird \N 1997-12-09 \N

Slim Benny snake m 1996-04-29 \N

save to c:\temp\pet.txt

mysql> LOAD DATA LOCAL INFILE 'c:/temp/pet.txt' INTO TABLE pet;
Query OK, 9 rows affected, 10 warnings (0.02 sec)Records: 9
Deleted: 0 Skipped: 0 Warnings: 10

mysql> INSERT INTO pet -> VALUES ('Puffball','Diane','hamster','f','1999-03-30',NULL);
Query OK, 1 row affected (0.01 sec)

________________________________________________
________________________________________________

Retrieving Information from a Table

The SELECT statement is used to pull information from a table. The general form of the statement is:

SELECT what_to_select
FROM which_table
WHERE conditions_to_satisfy;

what_to_select indicates what you want to see. This can be a list of columns, or * to indicate “all columns.”

which_table indicates the table from which you want to retrieve data.

The WHERE clause is optional. If it is present, conditions_to_satisfy specifies one or more conditions that rows must satisfy to qualify for retrieval.

________________________________________________
________________________________________________

mysql> SELECT * FROM pet;
+----------+--------+---------+------+------------+------------+
name owner species sex birth death
+----------+--------+---------+------+------------+------------+
Fluffy Harold cat f 1993-02-04 NULL
Claws Gwen cat m 1994-03-17 NULL
Buffy Harold dog f 1989-05-13 NULL
Fang Benny dog m 1990-08-27 NULL
Bowser Diane dog m 1979-08-31 1995-07-29
Chirpy Gwen bird f 1998-09-11 NULL
Whistler Gwen bird NULL 1997-12-09 NULL
Slim Benny snake m 1996-04-29 NULL
Puffball Diane hamster f 1999-03-30 NULL
+----------+--------+---------+------+------------+------------+

________________________________________________
________________________________________________

Delete info i table

mysql> DELETE FROM pet;
________________________________________________
________________________________________________

change value in Birth to 1989-08-31

mysql> UPDATE pet SET birth = '1989-08-31' WHERE name = 'Bowser';
________________________________________________
________________________________________________

mysql> SELECT * FROM pet WHERE name = 'Bowser';
+--------+-------+---------+------+------------+------------+
name owner species sex birth death
+--------+-------+---------+------+------------+------------+
Bowser Diane dog m 1989-08-31 1995-07-29
+--------+-------+---------+------+------------+------------+
________________________________________________
________________________________________________

mysql> SELECT * FROM pet WHERE birth >= '1998-1-1';
+----------+-------+---------+------+------------+-------+
name owner species sex birth death
+----------+-------+---------+------+------------+-------+
Chirpy Gwen bird f 1998-09-11 NULL
Puffball Diane hamster f 1999-03-30 NULL
+----------+-------+---------+------+------------+-------________________________________________________
________________________________________________

mysql> SELECT * FROM pet WHERE species = 'dog' AND sex = 'f';
+-------+--------+---------+------+------------+-------+
name owner species sex birth death
+-------+--------+---------+------+------------+-------+
Buffy Harold dog f 1989-05-13 NULL
+-------+--------+---------+------+------------+-------+

________________________________________________
________________________________________________

mysql> SELECT * FROM pet WHERE species = 'snake' OR species = 'bird';
+----------+-------+---------+------+------------+-------+
name owner species sex birth death
+----------+-------+---------+------+------------+-------+
Chirpy Gwen bird f 1998-09-11 NULL
Whistler Gwen bird NULL 1997-12-09 NULL
Slim Benny snake m 1996-04-29 NULL
+----------+-------+---------+------+------------+-------+

________________________________________________
________________________________________________

mysql> SELECT * FROM pet WHERE (species = 'cat' AND sex = 'm')
-> OR (species = 'dog' AND sex = 'f');
+-------+--------+---------+------+------------+-------+
name owner species sex birth death
+-------+--------+---------+------+------------+-------+
Claws Gwen cat m 1994-03-17 NULL
Buffy Harold dog f 1989-05-13 NULL
+-------+--------+---------+------+------------+-------+

________________________________________________
________________________________________________

mysql> SELECT owner FROM pet;
+--------+
owner
+--------+
Harold
Gwen
Harold
Benny
Diane
Gwen
Gwen
Benny
Diane
+--------+

mysql> SELECT DISTINCT owner FROM pet;
+--------+
owner
+--------+
Benny
Diane
Gwen
Harold
+--------+

________________________________________________

mysql> SELECT name, species, birth FROM pet
-> WHERE species = 'dog' OR species = 'cat';
+--------+---------+------------+
name species birth
+--------+---------+------------+
Fluffy cat 1993-02-04
Claws cat 1994-03-17
Buffy dog 1989-05-13
Fang dog 1990-08-27
Bowser dog 1989-08-31
+--------+---------+------------+

________________________________________________

mysql> SELECT name, birth FROM pet ORDER BY birth;
+----------+------------+
name birth
+----------+------------+
Buffy 1989-05-13
Bowser 1989-08-31
Fang 1990-08-27
Fluffy 1993-02-04
Claws 1994-03-17
Slim 1996-04-29
Whistler 1997-12-09
Chirpy 1998-09-11
Puffball 1999-03-30
+----------+------------+

________________________________________________
________________________________________________

mysql> SELECT name, birth FROM pet ORDER BY birth DESC;
+----------+------------+
name birth
+----------+------------+
Puffball 1999-03-30
Chirpy 1998-09-11
Whistler 1997-12-09
Slim 1996-04-29
Claws 1994-03-17
Fluffy 1993-02-04
Fang 1990-08-27
Bowser 1989-08-31
Buffy 1989-05-13
+----------+------------+

________________________________________________
________________________________________________

mysql> SELECT name, species, birth FROM pet
-> ORDER BY species, birth DESC;
+----------+---------+------------+
name species birth
+----------+---------+------------+
Chirpy bird 1998-09-11
Whistler bird 1997-12-09
Claws cat 1994-03-17
Fluffy cat 1993-02-04
Fang dog 1990-08-27
Bowser dog 1989-08-31
Buffy dog 1989-05-13
Puffball hamster 1999-03-30
Slim snake 1996-04-29
+----------+---------+------------+

________________________________________________
________________________________________________

mysql> SELECT name, birth, CURDATE(),
-> (YEAR(CURDATE())-YEAR(birth))
-> - (RIGHT(CURDATE(),5) AS age
-> FROM pet;
+----------+------------+------------+------+
name birth CURDATE() age
+----------+------------+------------+------+
Fluffy 1993-02-04 2003-08-19 10
Claws 1994-03-17 2003-08-19 9
Buffy 1989-05-13 2003-08-19 14
Fang 1990-08-27 2003-08-19 12
Bowser 1989-08-31 2003-08-19 13
Chirpy 1998-09-11 2003-08-19 4
Whistler 1997-12-09 2003-08-19 5
Slim 1996-04-29 2003-08-19 7
Puffball 1999-03-30 2003-08-19 4
+----------+------------+------------+------+

mysql> SELECT name, birth, CURDATE(),
-> (YEAR(CURDATE())-YEAR(birth))
-> - (RIGHT(CURDATE(),5) AS age
-> FROM pet ORDER BY age;
+----------+------------+------------+------+
name birth CURDATE() age
+----------+------------+------------+------+
Chirpy 1998-09-11 2003-08-19 4
Puffball 1999-03-30 2003-08-19 4
Whistler 1997-12-09 2003-08-19 5
Slim 1996-04-29 2003-08-19 7
Claws 1994-03-17 2003-08-19 9
Fluffy 1993-02-04 2003-08-19 10
Fang 1990-08-27 2003-08-19 12
Bowser 1989-08-31 2003-08-19 13
Buffy 1989-05-13 2003-08-19 14
+----------+------------+------------+------+

mysql> SELECT name, birth, CURDATE(),
-> (YEAR(CURDATE())-YEAR(birth))
-> - (RIGHT(CURDATE(),5) AS age
-> FROM pet ORDER BY name;
+----------+------------+------------+------+
name birth CURDATE() age
+----------+------------+------------+------+
Bowser 1989-08-31 2003-08-19 13
Buffy 1989-05-13 2003-08-19 14
Chirpy 1998-09-11 2003-08-19 4
Claws 1994-03-17 2003-08-19 9
Fang 1990-08-27 2003-08-19 12
Fluffy 1993-02-04 2003-08-19 10
Puffball 1999-03-30 2003-08-19 4
Slim 1996-04-29 2003-08-19 7
Whistler 1997-12-09 2003-08-19 5
+----------+------------+------------+------+

________________________________________________
________________________________________________

mysql> SELECT name, birth, death,
-> (YEAR(death)-YEAR(birth)) - (RIGHT(death,5) AS age
-> FROM pet WHERE death IS NOT NULL ORDER BY age;
+--------+------------+------------+------+
name birth death age
+--------+------------+------------+------+
Bowser 1989-08-31 1995-07-29 5
+--------+------------+------------+------+

________________________________________________
________________________________________________

MySQL provides several functions for extracting parts of dates, such as YEAR(), MONTH(), and DAYOFMONTH(). MONTH() is the appropriate function here.

mysql> SELECT name, birth, MONTH(birth) FROM pet;
+----------+------------+--------------+
name birth MONTH(birth)
+----------+------------+--------------+
Fluffy 1993-02-04 2
Claws 1994-03-17 3
Buffy 1989-05-13 5
Fang 1990-08-27 8
Bowser 1989-08-31 8
Chirpy 1998-09-11 9
Whistler 1997-12-09 12
Slim 1996-04-29 4
Puffball 1999-03-30 3
+----------+------------+--------------+

________________________________________________
________________________________________________

mysql> SELECT * FROM pet WHERE name LIKE 'b%';
+--------+--------+---------+------+------------+------------+
name owner species sex birth death
+--------+--------+---------+------+------------+------------+
Buffy Harold dog f 1989-05-13 NULL
Bowser Diane dog m 1989-08-31 1995-07-29
+--------+--------+---------+------+------------+------------+

mysql> SELECT * FROM pet WHERE name LIKE '%fy';
+--------+--------+---------+------+------------+-------+
name owner species sex birth death
+--------+--------+---------+------+------------+-------+
Fluffy Harold cat f 1993-02-04 NULL
Buffy Harold dog f 1989-05-13 NULL
+--------+--------+---------+------+------------+-------+

mysql> SELECT * FROM pet WHERE name LIKE '%w%';
+----------+-------+---------+------+------------+------------+
name owner species sex birth death
+----------+-------+---------+------+------------+------------+
Claws Gwen cat m 1994-03-17 NULL
Bowser Diane dog m 1989-08-31 1995-07-29
Whistler Gwen bird NULL 1997-12-09 NULL
+----------+-------+---------+------+------------+------------+

To find names containing exactly five characters, use five instances of the “_” pattern character: mysql> SELECT * FROM pet WHERE name LIKE '_____';
+-------+--------+---------+------+------------+-------+
name owner species sex birth death
+-------+--------+---------+------+------------+-------+
Claws Gwen cat m 1994-03-17 NULL
Buffy Harold dog f 1989-05-13 NULL
+-------+--------+---------+------+------------+-------+

To find names beginning with “b”, use “^” to match the beginning of the name:

mysql> SELECT * FROM pet WHERE name REGEXP '^b';

To find names ending with “fy”, use “$” to match the end of the name:

mysql> SELECT * FROM pet WHERE name REGEXP 'fy$';

To find names containing exactly five characters, use “^” and “$” to match the beginning and end of the name, and five instances of “.” in between:

mysql> SELECT * FROM pet WHERE name REGEXP '^.....$';

________________________________________________
________________________________________________

mysql> SELECT COUNT(*) FROM pet;
+----------+
COUNT(*)
+----------+
9
+----------+

mysql> SELECT owner, COUNT(*) FROM pet GROUP BY owner;
+--------+----------+
owner COUNT(*)
+--------+----------+
Benny 2
Diane 2
Gwen 3
Harold 2
+--------+----------+

mysql> SELECT species, COUNT(*) FROM pet GROUP BY species;
+---------+----------+
species COUNT(*)
+---------+----------+
bird 2
cat 2
dog 3
hamster 1
snake 1
+---------+----------+

mysql> SELECT sex, COUNT(*) FROM pet GROUP BY sex;
+------+----------+
sex COUNT(*)
+------+----------+
NULL 1
f 4
m 4

mysql> SELECT species, sex, COUNT(*) FROM pet GROUP BY species, sex;
+---------+------+----------+
species sex COUNT(*)
+---------+------+----------+
bird NULL 1
bird f 1
cat f 1
cat m 1
dog f 1
dog m 2
hamster f 1
snake m 1
+---------+------+----------+

________________________________________________
________________________________________________

________________________________________________
________________________________________________

________________________________________________
________________________________________________

input to database

private void button3_Click(object sender, EventArgs e)
{
string connection = "Data Source=.\\SQLEXPRESS; AttachDbFilename=\\\\xxx\\felles\\xxx\\Drift\\NOC\\xxx\\sakerDB.mdf; Integrated Security=True; Connect Timeout=30; User Instance=True; Asynchronous Processing=true";
//sakerConnection = new SqlConnection("Data Source=.\\SQLEXPRESS; AttachDbFilename=C:\\Documents and Settings\\glennj\\Mine dokumenter\\Visual Studio 2008\\Projects\\database_v3\\database_v3\\sakerDB.mdf; Integrated Security=True; Connect Timeout=30; User Instance=True; ");

SqlConnection newCon = new SqlConnection(connection);

newCon.Open();

SqlCommand insertCommand = new SqlCommand("INSERT INTO glennj(Dato, Nye_T, Allerede_T) VALUES ('" + dateTimePicker1.Value + "')('"+textBox1.Text+"')('"+ textBox2.Text + "')", newCon);

insertCommand.BeginExecuteNonQuery();
}

text num edit

private void textBox1_TextChanged(object sender, EventArgs e)
{
textBox1.KeyPress += new KeyPressEventHandler(Form1_KeyPress);

decimal sum = decimal.Parse(textBox1.Text) + decimal.Parse(textBox2.Text);
label1.Text = sum.ToString();
}

private void Form1_KeyPress(object sender, KeyPressEventArgs e)
{
if (((e.KeyChar < '0') || (e.KeyChar > '9')) && (e.KeyChar!=(char)Keys.Back))
e.Handled = true;
}

only allow text in textbox

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.Text.RegularExpressions;

namespace numbox_test
{


public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
Regex FormatControl = new Regex(@"\D");
private void textBox1_TextChanged(object sender, EventArgs e)
{
if (FormatControl.IsMatch(textBox1.Text))
{
textBox1.Text = "";
MessageBox.Show("Only numeric format would be accepted");
}

}

database

private void dataF1_Load(object sender, EventArgs e)
{
label1.Text = DateTime.Now.ToString("d");
glennjTableAdapter1.Fill(this.database1DataSet11.glennj);
henryaTableAdapter1.Fill(this.database1DataSet11.henrya);
}
private void button1_Click(object sender, EventArgs e)
{
bindingSource1.EndEdit();
glennjTableAdapter1.Update(database1DataSet11.glennj.Rows.Add(label1.Text, textBox1.Text, textBox2.Text));
henryaTableAdapter1.Update(database1DataSet11.henrya.Rows.Add(label1.Text, textBox3.Text, textBox4.Text));
}
//setter ny dato p† label//
private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
{
label1.Text = dateTimePicker1.Value.ToString("d");
}

radiobutton code

private void rdo_CheckedChanged(object sender, System.EventArgs e)
{
RadioButton rdo = sender as RadioButton;
if (rdo.Checked)
{
switch (rdo.Text)
{
case "Bottom":
this.Edge = AppBarEdges.Bottom;
break;
case "Top":
this.Edge = AppBarEdges.Top;
break;
case "Left":
this.Edge = AppBarEdges.Left;
break;
case "Right":
this.Edge = AppBarEdges.Right;
break;
case "Float":
this.Edge = AppBarEdges.Float;
break;
}
}
}

Auto drawing text from text file.

<------------------------------------------------------------------>
first i made the software, but it kept drawing ontop of it self all teh time, so a added clear.

graphicsObj.Clear(Color.Aqua);

and its workig just fine :):):)
<------------------------------------------------------------------>


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 test_drawing
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
//text variablelen
public string teXt;
public void Form1_Load(object sender, EventArgs e)
{
}
//tegne ned texten
public void Form1_Paint(object sender, PaintEventArgs e)
{
}
//timed ticker updater
private void timer1_Tick(object sender, EventArgs e)
{
string file_name = "c:\\temp\\test.txt";
{
System.IO.StreamReader objReader;
objReader = new System.IO.StreamReader(file_name);
//textBox1.Text = objReader.ReadToEnd();
teXt = objReader.ReadToEnd();
objReader.Close();
}
System.Drawing.Graphics graphicsObj;
graphicsObj = this.CreateGraphics();
graphicsObj.Clear(Color.Aqua);
Font myFont = new System.Drawing.Font("Helvetica", 40, FontStyle.Italic);
Brush myBrush = new SolidBrush(System.Drawing.Color.Red);
graphicsObj.DrawString(teXt, myFont, myBrush, 30, 30);
}
}
}

Working with text files

// 1) Write to a text file
public void WriteToFile(string file)
{
//create a TextWriter then open the file
TextWriter writer = new StreamWriter(file);
//now write the date to the file
writer.WriteLine(DateTime.Now);
//close the writer
writer.Close();
}

// 2) Read a single line from text file
public void readALine(string file)
{
//create a new TextReader then open the file
TextReader reader = new StreamReader(file);
//read a single line from the file
reader.ReadLine();
}

// 3) Read entire file into a variable then
// return the contenxt
public string ReadWholeFile(string file)
{
//create a string variable to hold the file contents
string fileContents;
//create a new TextReader then open the file
TextReader reader = new StreamReader(file);
//loop through the entire file
while (reader.Peek() != -1)
{
//add each line to the fileContents variable
fileContents += reader.ReadLine().ToString();
}
//close the reader
reader.Close()
//return the results
return fileContents;
}

easy xml creation

<----------------------------------------->
easy xml creation
<----------------------------------------->

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

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

private void button1_Click(object sender, EventArgs e)
{
XmlDocument xmldoc = new XmlDocument();
XmlNode xmlRoot, xmlNode;
xmlRoot = xmldoc.CreateElement("Root");

xmldoc.AppendChild(xmlRoot);
xmlNode = xmldoc.CreateElement("Child");
xmlRoot.AppendChild(xmlNode);
xmlNode.InnerText = "This is the first Child";
// you can also take a textbox instead of the text like this;
// xmlNode.InnerText = TextBox1.Text;

xmlNode = xmldoc.CreateElement("Child2");
xmlRoot.AppendChild(xmlNode);
xmlNode.InnerText = "This is the second Child";

xmlNode = xmldoc.CreateElement("Child3");
xmlRoot.AppendChild(xmlNode);
xmlNode.InnerText = "This is the third Child";
// you can make as many childs as you want
string filename = @"c:\" + DateTime.Now.Day + DateTime.Now.Month + DateTime.Now.Year + ".xml";
// i wanted the date as the filename, so i can see when it was created
// of course you can change it to:
// string filename = @"c:\NewXML" + ".xml" or @"c:\whatever" + ".xml"

xmldoc.Save(filename);
}
}
}

-------------------------------------------------------->
after som testing i finlay foud out how to make it auto update from the file..
i added bothe metods in the tiker obj
-------------------------------------------------------->

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 test_drawing
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
//text variablelen
public string teXt;
public void Form1_Load(object sender, EventArgs e)
{

string file_name = "c:\\test.txt";
{
System.IO.StreamReader objReader;
objReader = new System.IO.StreamReader(file_name);
//textBox1.Text = objReader.ReadToEnd();
teXt = objReader.ReadToEnd();
objReader.Close();
}
}
//tegne ned texten
public void Form1_Paint(object sender, PaintEventArgs e)
{
}
//timed ticker updater
private void timer1_Tick(object sender, EventArgs e)
{
string file_name = "c:\\temp\\test.txt";
{
System.IO.StreamReader objReader;
objReader = new System.IO.StreamReader(file_name);
//textBox1.Text = objReader.ReadToEnd();
teXt = objReader.ReadToEnd();
objReader.Close();
}
System.Drawing.Graphics graphicsObj;
graphicsObj = this.CreateGraphics();
Font myFont = new System.Drawing.Font("Helvetica", 40, FontStyle.Italic);
Brush myBrush = new SolidBrush(System.Drawing.Color.Red);
graphicsObj.DrawString(teXt, myFont, myBrush, 30, 30);
}
}
}

public void Form1_Paint(object sender, PaintEventArgs e)
{
////Graphics surface;
//Graphics surface = this.CreateGraphics();
//Font drawFont = new Font("Arial", 20);
//SolidBrush drawBrush = new SolidBrush(Color.Black);
//StringFormat drawFormat = new StringFormat();
//drawFormat.FormatFlags = StringFormatFlags.DirectionRightToLeft;
//surface.DrawString(teXt , drawFont, drawBrush, 220.0f, 50.0f, drawFormat);
System.Drawing.Graphics graphicsObj;
graphicsObj = this.CreateGraphics();
Font myFont = new System.Drawing.Font("Helvetica", 40, FontStyle.Italic);
Brush myBrush = new SolidBrush(System.Drawing.Color.Red);
graphicsObj.DrawString(teXt, myFont, myBrush, 30, 30);

count time..

//get actual time
DateTime startTime = DateTime.Now;

// do something

// get difference as time span
TimeSpan span = DateTime.Now.Subtract(startTime);
// create message box
MessageBox.Show(string.Format("The operation took {0} seconds", span.TotalSeconds));

.------------------------------.

using System;
using System.Diagnostics;

static void Main(string[] args)
{
StopWatch s = new StopWatch();

// Start the stopwatch
s.Start();

// Call your search method here
MySearch();

// Stop the stopwatch
s.Stop();

// Get the elapsed time as a TimeSpan value.
TimeSpan ts = stopWatch.Elapsed;

MessageBox.Show ("Your search took {0} seconds to return data", ts.TotalSeconds );

}
---------------------------------------------------

private void ShowDateSystemLogErrors_Click(object sender, EventArgs e)
{
DateTime dt = dateTimePicker1.Value;
// Change to hourglass whilst working
this.Cursor = Cursors.WaitCursor;

try
{
Stopwatch stopwatch = new Stopwatch();
// start the stopwatch
stopwatch.Start();

// Complete the search and return a list
this.SystemLogErrorsView.DataSource = this._Errors.GetByDate(dt);

// stop the stopwatch
stopwatch.Stop();

// Get the elapsed time as a TimeSpan value
TimeSpan ts = stopwatch.Elapsed;

// Timewatch string formatting
string elapsedTime = String.Format("{0:00}:{1:00}:{2:00}", ts.Hours, ts.Minutes, ts.Seconds / 10);
MessageBox.Show(string.Format("The Search Took {0} to Complete", elapsedTime));
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}

// Change back to arrow cursor
this.Cursor = Cursors.Default;
}

simpel variabel creation test, tested how to add somting to memory.

<----------------->
this is a test i did for the EvE beta tool to find out how to creat one of the formulasfor memory calculation
<----------------->

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 box_add_test
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
// Variabel deklerasjon for klassen
public int sum1;
private void button1_Click(object sender, EventArgs e)
{
decimal sum1 = new decimal(0.25) - ((new decimal(0.05) * (decimal.Parse(textBox19.Text.Trim()))));
label47.Text = sum1.ToString();
{
decimal sum2 = decimal.Parse(textBox9.Text) + (decimal.Parse(textBox9.Text) * sum1) + (decimal.Parse(textBox9.Text) * decimal.Parse(label48.Text));
textBox39.Text = sum2.ToString();
}
}
private void textBox19_TextChanged(object sender, EventArgs e)
{
}
private void label48_Click(object sender, EventArgs e)
{
}
}
}

Ticker editer

<---------------------->
to edit the ticker running i created this form to creat xml files
<---------------------->

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 Ticker_edit_V2
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
System.IO.StreamReader reader = new System.IO.StreamReader("\\\\148.140.26.109\\Ticker\\ticker.xml");
string strAllFile = reader.ReadToEnd().Replace("\r\n", "\n").Replace("\n\r", "\n");
string[] arrLines = strAllFile.Split(new char[] { '\n' });
textBox1.Text = arrLines[4];
textBox2.Text = arrLines[13];
textBox3.Text = arrLines[22];
textBox4.Text = arrLines[31];
reader.Close();
}


private void button2_Click(object sender, EventArgs e)
{
this.Close();
}
private void label1_Click(object sender, EventArgs e)
{
string file_name = "\\\\148.140.26.109\\Ticker\\ticker.xml";
string messageText1;
string messageText2;
string messageText3;
string messageText4;
string messageText5;
string messageText6;
string messageText7;
string messageText8;
string messageText9;
messageText1 = "";
messageText2 = "

";
messageText3 = "

";
messageText4 = "";
messageText5 = "";
messageText6 = "";
messageText7 = "";
messageText8 = "";
messageText9 = " ";
System.IO.StreamWriter objWriter;
objWriter = new System.IO.StreamWriter(file_name, false);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox1.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox1.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox1.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox1.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox1.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox1.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.Close();
MessageBox.Show("Da er 1 linje lagret og ticker updatet");
}
private void label2_Click(object sender, EventArgs e)
{
string file_name = "\\\\148.140.26.109\\Ticker\\ticker.xml";
string messageText1;
string messageText2;
string messageText3;
string messageText4;
string messageText5;
string messageText6;
string messageText7;
string messageText8;
string messageText9;
messageText1 = "";
messageText2 = "

";
messageText3 = "

";
messageText4 = "";
messageText5 = "";
messageText6 = "";
messageText7 = "";
messageText8 = "";
messageText9 = " ";
System.IO.StreamWriter objWriter;
objWriter = new System.IO.StreamWriter(file_name, false);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox1.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox2.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox1.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox2.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox1.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox2.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox1.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox2.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.Close();
MessageBox.Show("Da er 2 linje lagret og ticker updatet");
}
private void label3_Click(object sender, EventArgs e)
{
string file_name = "\\\\148.140.26.109\\Ticker\\ticker.xml";
string messageText1;
string messageText2;
string messageText3;
string messageText4;
string messageText5;
string messageText6;
string messageText7;
string messageText8;
string messageText9;
messageText1 = "";
messageText2 = "

";
messageText3 = "

";
messageText4 = "";
messageText5 = "";
messageText6 = "";
messageText7 = "";
messageText8 = "";
messageText9 = " ";
System.IO.StreamWriter objWriter;
objWriter = new System.IO.StreamWriter(file_name, false);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox1.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox2.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox3.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox1.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox2.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox3.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox1.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox2.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox3.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.Close();
MessageBox.Show("Da er 3 linje lagret og ticker updatet");
}
private void label4_Click(object sender, EventArgs e)
{
string file_name = "\\\\148.140.26.109\\Ticker\\ticker.xml";
string messageText1;
string messageText2;
string messageText3;
string messageText4;
string messageText5;
string messageText6;
string messageText7;
string messageText8;
//string messageText9;
messageText1 = "";
messageText2 = "

";
messageText3 = "

";
messageText4 = "";
messageText5 = "";
messageText6 = "";
messageText7 = "";
messageText8 = "";
//messageText9 = "";
System.IO.StreamWriter objWriter;
objWriter = new System.IO.StreamWriter(file_name, false);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox1.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox2.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox3.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox4.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox1.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox2.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox3.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.WriteLine(messageText1);
objWriter.WriteLine(messageText2);
objWriter.WriteLine(messageText3);
objWriter.WriteLine(messageText4);
objWriter.WriteLine(textBox4.Text);
objWriter.WriteLine(messageText5);
objWriter.WriteLine(messageText6);
objWriter.WriteLine(messageText7);
objWriter.WriteLine(messageText8);
objWriter.Close();
MessageBox.Show("Da er 4 linje lagret og ticker updatet");
}

private void label6_Click_1(object sender, EventArgs e)
{
Form2 f2 = new Form2();
f2.Show();
}
}
}

Directory monitor

<------------------------->
this is a directory monior i created for work to kil and restart a app when chnges in a file is detected.
<------------------------->

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Configuration;
using System.IO;
using System.Diagnostics;
namespace TickerMonitor
{
///

/// Summary description for DirectoryMonitor.
///

public class DirectoryMonitorForm : System.Windows.Forms.Form
{
private static string Path="";
private static string Filter="";
private static bool IncludeSubs=false;
private System.IO.FileSystemWatcher FileMonitor;
private System.Windows.Forms.Label Label1;
private System.Windows.Forms.Button ButtonStart;
private System.Windows.Forms.TextBox directoryToMonitor;
///

/// Required designer variable.
///

private System.ComponentModel.Container components = null;
public DirectoryMonitorForm()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
//
// TODO: Add any constructor code after InitializeComponent call
//
}
///

/// Clean up any resources being used.
///

protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows Form Designer generated code
///

/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///

private void InitializeComponent()
{
this.FileMonitor = new System.IO.FileSystemWatcher();
this.ButtonStart = new System.Windows.Forms.Button();
this.Label1 = new System.Windows.Forms.Label();
this.directoryToMonitor = new System.Windows.Forms.TextBox();
((System.ComponentModel.ISupportInitialize)(this.FileMonitor)).BeginInit();
this.SuspendLayout();
//
// FileMonitor
//
this.FileMonitor.EnableRaisingEvents = true;
this.FileMonitor.NotifyFilter = System.IO.NotifyFilters.FileName;
this.FileMonitor.SynchronizingObject = this;
this.FileMonitor.Renamed += new System.IO.RenamedEventHandler(this.FileMonitor_OnRenamed);
this.FileMonitor.Deleted += new System.IO.FileSystemEventHandler(this.FileMonitor_Changed);
this.FileMonitor.Created += new System.IO.FileSystemEventHandler(this.FileMonitor_Changed);
this.FileMonitor.Changed += new System.IO.FileSystemEventHandler(this.FileMonitor_Changed);
//
// ButtonStart
//
this.ButtonStart.BackColor = System.Drawing.Color.Gray;
this.ButtonStart.Location = new System.Drawing.Point(80, 73);
this.ButtonStart.Name = "ButtonStart";
this.ButtonStart.Size = new System.Drawing.Size(64, 23);
this.ButtonStart.TabIndex = 0;
this.ButtonStart.Text = "Start";
this.ButtonStart.UseVisualStyleBackColor = false;
this.ButtonStart.Click += new System.EventHandler(this.ButtonStart_Click);
//
// Label1
//
this.Label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.Label1.Location = new System.Drawing.Point(25, 3);
this.Label1.Name = "Label1";
this.Label1.Size = new System.Drawing.Size(173, 24);
this.Label1.TabIndex = 2;
this.Label1.Text = "Tiker forandring monitor";
this.Label1.TextAlign = System.Drawing.ContentAlignment.TopCenter;
//
// directoryToMonitor
//
this.directoryToMonitor.Location = new System.Drawing.Point(28, 30);
this.directoryToMonitor.Name = "directoryToMonitor";
this.directoryToMonitor.Size = new System.Drawing.Size(170, 20);
this.directoryToMonitor.TabIndex = 3;
this.directoryToMonitor.Text = "C:\\noc_beta\\Ticker\\ticker.xml";
//
// DirectoryMonitorForm
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.BackColor = System.Drawing.Color.Black;
this.ClientSize = new System.Drawing.Size(224, 108);
this.Controls.Add(this.directoryToMonitor);
this.Controls.Add(this.Label1);
this.Controls.Add(this.ButtonStart);
this.ForeColor = System.Drawing.Color.Yellow;
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedToolWindow;
this.Name = "DirectoryMonitorForm";
this.Text = "Ticker Monitor";
this.Load += new System.EventHandler(this.DirMon_Load);
((System.ComponentModel.ISupportInitialize)(this.FileMonitor)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
#endregion
///

/// The main entry point for the application.
///

[STAThread]
static void Main()
{
Application.Run(new DirectoryMonitorForm());
}

private void FileMonitor_OnRenamed(object source, RenamedEventArgs e)
{
// Specify what is done when a file is renamed.
string originalname = e.OldFullPath;
string renamed = e.FullPath;
MessageBox.Show("File: "+originalname+" renamed to "+renamed, e.OldName+" Renamed");
}
private void FileMonitor_Changed(object sender, System.IO.FileSystemEventArgs e)
{
string ChangeType = e.ChangeType.ToString();
////display a message box for the appropriate changetype.
//if (ChangeType=="Created")
//{
// //MessageBox.Show("File: " + e.FullPath + " " + e.ChangeType, e.Name+" Created");
//}
//else if(ChangeType=="Deleted")
//{
// //MessageBox.Show("File: " + e.FullPath + " " + e.ChangeType, e.Name+" Deleted");
//}
//else
if(ChangeType=="Changed")
{
// killer vist oppe
Process[] processes = Process.GetProcessesByName("NOC_Ticker");
foreach (Process p in processes)
{
//p.CloseMainWindow();
p.Kill();;
}
System.Diagnostics.Process.Start(@"C:\noc_beta\Ticker\NOC_Ticker.appref-ms");
}
}

private void ButtonStart_Click(object sender, System.EventArgs e)
{
{
//get the configuration properties from the form.
Path = directoryToMonitor.Text;
}
//Set the properties on the monitor.
FileMonitor.Path = "C:\\temp\\";
FileMonitor.Filter = Filter.ToString();
FileMonitor.IncludeSubdirectories = IncludeSubs;
FileMonitor.NotifyFilter = NotifyFilters.LastAccess NotifyFilters.LastWrite
NotifyFilters.FileName NotifyFilters.DirectoryName;
//Begin monitoring.
FileMonitor.EnableRaisingEvents = true;
}
private void ButtonStop_Click(object sender, System.EventArgs e)
{
//Begin monitoring.
FileMonitor.EnableRaisingEvents = false;
}
private void DirMon_Load(object sender, System.EventArgs e)
{
}
}
}

EvE online manufacturing tool.

<------------------------------->
This is a Game Manufacturing tool i created for EvE online
<------------------------------->

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 EvE.Properties;
using System.Globalization;

namespace EvE
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
// Properties verdier// Save sett //
private void verdi_nummer1(object sender, EventArgs e)
{
Properties.Settings.Default.verdi_nummer1 = textBox1.Text;
Properties.Settings.Default.Save();
}
private void verdi_nummer2(object sender, EventArgs e)
{
Properties.Settings.Default.verdi_nummer2 = textBox2.Text;
Properties.Settings.Default.Save();
}
private void verdi_nummer3(object sender, EventArgs e)
{
Properties.Settings.Default.verdi_nummer3 = textBox3.Text;
Properties.Settings.Default.Save();
}
private void verdi_nummer4(object sender, EventArgs e)
{
Properties.Settings.Default.verdi_nummer4 = textBox4.Text;
Properties.Settings.Default.Save();
}
private void verdi_nummer5(object sender, EventArgs e)
{
Properties.Settings.Default.verdi_nummer5 = textBox5.Text;
Properties.Settings.Default.Save();
}
private void verdi_nummer6(object sender, EventArgs e)
{
Properties.Settings.Default.verdi_nummer6 = textBox6.Text;
Properties.Settings.Default.Save();
}
private void verdi_nummer7(object sender, EventArgs e)
{
Properties.Settings.Default.verdi_nummer7 = textBox7.Text;
Properties.Settings.Default.Save();
}
private void verdi_nummer8(object sender, EventArgs e)
{
Properties.Settings.Default.verdi_nummer8 = textBox8.Text;
Properties.Settings.Default.Save();
}
private void verdi_nummer9(object sender, EventArgs e)
{
Properties.Settings.Default.verdi_nummer9 = textBox9.Text;
Properties.Settings.Default.Save();
}
private void verdi_nummer10(object sender, EventArgs e)
{
Properties.Settings.Default.verdi_nummer10 = textBox10.Text;
Properties.Settings.Default.Save();
}
private void verdi_nummer11(object sender, EventArgs e)
{
Properties.Settings.Default.verdi_nummer11 = textBox11.Text;
Properties.Settings.Default.Save();
}
private void verdi_nummer12(object sender, EventArgs e)
{
Properties.Settings.Default.verdi_nummer12 = textBox12.Text;
Properties.Settings.Default.Save();
}
private void verdi_nummer13(object sender, EventArgs e)
{
Properties.Settings.Default.verdi_nummer13 = textBox13.Text;
Properties.Settings.Default.Save();
}
private void verdi_nummer14(object sender, EventArgs e)
{
Properties.Settings.Default.verdi_nummer14 = textBox14.Text;
Properties.Settings.Default.Save();
}
private void verdi_nummer15(object sender, EventArgs e)
{
Properties.Settings.Default.verdi_nummer15 = textBox15.Text;
Properties.Settings.Default.Save();
}
private void verdi_nummer16(object sender, EventArgs e)
{
Properties.Settings.Default.verdi_nummer16 = textBox16.Text;
Properties.Settings.Default.Save();
}
private void verdi_nummer17(object sender, EventArgs e)
{
Properties.Settings.Default.verdi_nummer17 = textBox17.Text;
Properties.Settings.Default.Save();
}
private void verdi_nummer18(object sender, EventArgs e)
{
Properties.Settings.Default.verdi_nummer18 = textBox18.Text;
Properties.Settings.Default.Save();
}
private void verdi_nummer19(object sender, EventArgs e)
{
Properties.Settings.Default.verdi_nummer19 = textBox19.Text;
Properties.Settings.Default.Save();
}
private void verdi_nummer20(object sender, EventArgs e)
{
Properties.Settings.Default.verdi_nummer20 = textBox20.Text;
Properties.Settings.Default.Save();
}
private void verdi_nummer21(object sender, EventArgs e)
{
Properties.Settings.Default.verdi_nummer21 = textBox21.Text;
Properties.Settings.Default.Save();
}
//-----------------------------------------------------------//
//-----------------------------------------------------------//
// SpecialProperties verdier //
private void verdi_nummer01(object sender, EventArgs e)
{
SpecialSettings.Default.verdi_nummer01 = textBox1.Text;
}
private void verdi_nummer02(object sender, EventArgs e)
{
SpecialSettings.Default.verdi_nummer02 = textBox2.Text;
}
private void verdi_nummer03(object sender, EventArgs e)
{
SpecialSettings.Default.verdi_nummer03 = textBox3.Text;
}
private void verdi_nummer04(object sender, EventArgs e)
{
SpecialSettings.Default.verdi_nummer04 = textBox4.Text;
}
private void verdi_nummer05(object sender, EventArgs e)
{
SpecialSettings.Default.verdi_nummer05 = textBox5.Text;
}
private void verdi_nummer06(object sender, EventArgs e)
{
SpecialSettings.Default.verdi_nummer06 = textBox6.Text;
}
private void verdi_nummer07(object sender, EventArgs e)
{
SpecialSettings.Default.verdi_nummer07 = textBox7.Text;
}
private void verdi_nummer08(object sender, EventArgs e)
{
SpecialSettings.Default.verdi_nummer08 = textBox8.Text;
}
private void verdi_nummer09(object sender, EventArgs e)
{
SpecialSettings.Default.verdi_nummer09 = textBox9.Text;
}
private void verdi_nummer010(object sender, EventArgs e)
{
SpecialSettings.Default.verdi_nummer010 = textBox10.Text;
}
private void verdi_nummer011(object sender, EventArgs e)
{
SpecialSettings.Default.verdi_nummer011 = textBox11.Text;
}
private void verdi_nummer012(object sender, EventArgs e)
{
SpecialSettings.Default.verdi_nummer012 = textBox12.Text;
}
private void verdi_nummer013(object sender, EventArgs e)
{
SpecialSettings.Default.verdi_nummer013 = textBox13.Text;
}
private void verdi_nummer014(object sender, EventArgs e)
{
SpecialSettings.Default.verdi_nummer014 = textBox14.Text;
}
private void verdi_nummer015(object sender, EventArgs e)
{
SpecialSettings.Default.verdi_nummer015 = textBox15.Text;
}
private void verdi_nummer016(object sender, EventArgs e)
{
SpecialSettings.Default.verdi_nummer016 = textBox16.Text;
}
private void verdi_nummer017(object sender, EventArgs e)
{
SpecialSettings.Default.verdi_nummer017 = textBox17.Text;
}
private void verdi_nummer018(object sender, EventArgs e)
{
SpecialSettings.Default.verdi_nummer018 = textBox18.Text;
}
private void verdi_nummer019(object sender, EventArgs e)
{
SpecialSettings.Default.verdi_nummer01 = textBox1.Text;
}
private void verdi_nummer020(object sender, EventArgs e)
{
SpecialSettings.Default.verdi_nummer020 = textBox20.Text;
}
private void verdi_nummer021(object sender, EventArgs e)
{
SpecialSettings.Default.verdi_nummer021 = textBox21.Text;
}
//-----------------------------------------------------------//
//-----------------------------------------------------------//
//Form load//
private void Form1_Load(object sender, EventArgs e)
{
textBox1.Text = Properties.Settings.Default.verdi_nummer1;
textBox2.Text = Properties.Settings.Default.verdi_nummer2;
textBox3.Text = Properties.Settings.Default.verdi_nummer3;
textBox4.Text = Properties.Settings.Default.verdi_nummer4;
textBox5.Text = Properties.Settings.Default.verdi_nummer5;
textBox6.Text = Properties.Settings.Default.verdi_nummer6;
textBox7.Text = Properties.Settings.Default.verdi_nummer7;
textBox8.Text = Properties.Settings.Default.verdi_nummer8;
textBox9.Text = Properties.Settings.Default.verdi_nummer9;
textBox10.Text = Properties.Settings.Default.verdi_nummer10;
textBox11.Text = Properties.Settings.Default.verdi_nummer11;
textBox12.Text = Properties.Settings.Default.verdi_nummer12;
textBox13.Text = Properties.Settings.Default.verdi_nummer13;
textBox14.Text = Properties.Settings.Default.verdi_nummer14;
textBox15.Text = Properties.Settings.Default.verdi_nummer15;
textBox16.Text = Properties.Settings.Default.verdi_nummer16;
textBox17.Text = Properties.Settings.Default.verdi_nummer17;
textBox18.Text = Properties.Settings.Default.verdi_nummer18;
textBox19.Text = Properties.Settings.Default.verdi_nummer19;
textBox20.Text = Properties.Settings.Default.verdi_nummer20;
textBox21.Text = Properties.Settings.Default.verdi_nummer21;
if (string.IsNullOrEmpty(textBox1.Text))
{
textBox1.Text = SpecialSettings.Default.verdi_nummer01;
}
if (string.IsNullOrEmpty(textBox2.Text))
{
textBox2.Text = SpecialSettings.Default.verdi_nummer02;
}
if (string.IsNullOrEmpty(textBox3.Text))
{
textBox3.Text = SpecialSettings.Default.verdi_nummer03;
}
if (string.IsNullOrEmpty(textBox4.Text))
{
textBox4.Text = SpecialSettings.Default.verdi_nummer04;
}
if (string.IsNullOrEmpty(textBox5.Text))
{
textBox5.Text = SpecialSettings.Default.verdi_nummer05;
}
if (string.IsNullOrEmpty(textBox6.Text))
{
textBox6.Text = SpecialSettings.Default.verdi_nummer06;
}
if (string.IsNullOrEmpty(textBox7.Text))
{
textBox7.Text = SpecialSettings.Default.verdi_nummer07;
}
if (string.IsNullOrEmpty(textBox8.Text))
{
textBox8.Text = SpecialSettings.Default.verdi_nummer08;
}
if (string.IsNullOrEmpty(textBox9.Text))
{
textBox9.Text = SpecialSettings.Default.verdi_nummer09;
}
if (string.IsNullOrEmpty(textBox10.Text))
{
textBox10.Text = SpecialSettings.Default.verdi_nummer010;
}
if (string.IsNullOrEmpty(textBox11.Text))
{
textBox11.Text = SpecialSettings.Default.verdi_nummer011;
}
if (string.IsNullOrEmpty(textBox12.Text))
{
textBox12.Text = SpecialSettings.Default.verdi_nummer012;
}
if (string.IsNullOrEmpty(textBox13.Text))
{
textBox13.Text = SpecialSettings.Default.verdi_nummer013;
}
if (string.IsNullOrEmpty(textBox14.Text))
{
textBox14.Text = SpecialSettings.Default.verdi_nummer014;
}
if (string.IsNullOrEmpty(textBox15.Text))
{
textBox15.Text = SpecialSettings.Default.verdi_nummer015;
}
if (string.IsNullOrEmpty(textBox16.Text))
{
textBox16.Text = SpecialSettings.Default.verdi_nummer016;
}
if (string.IsNullOrEmpty(textBox17.Text))
{
textBox17.Text = SpecialSettings.Default.verdi_nummer017;
}
if (string.IsNullOrEmpty(textBox18.Text))
{
textBox18.Text = SpecialSettings.Default.verdi_nummer018;
}
if (string.IsNullOrEmpty(textBox19.Text))
{
textBox19.Text = SpecialSettings.Default.verdi_nummer019;
}
if (string.IsNullOrEmpty(textBox20.Text))
{
textBox20.Text = SpecialSettings.Default.verdi_nummer020;
}
if (string.IsNullOrEmpty(textBox21.Text))
{
textBox21.Text = SpecialSettings.Default.verdi_nummer021;
}
}
public int sum1;
public int sum2;
public int sum3;
public int sum4;
public int sum5;
public int sum6;
public int sum7;
public int sum8;
public int sum9;
public int sum10;
public int sum11;
public int sum12;
public int sum13;
public int sum14;
private void button1_Click_1(object sender, EventArgs e)
{
//alle Matrial utregninger Mineral Priser * units//
//Trit add
if (textBox1.Text.Trim() != string.Empty && textBox9.Text.Trim() != string.Empty)
{
textBox1.Text = textBox1.Text.Replace(".", ",");
//textBox1.Text = textBox1.Text.Replace("","0");
}
// pyer add
if (textBox2.Text.Trim() != string.Empty && textBox10.Text.Trim() != string.Empty)
{
textBox2.Text = textBox2.Text.Replace(".", ",");
}
//mex add
if (textBox3.Text.Trim() != string.Empty && textBox11.Text.Trim() != string.Empty)
{
textBox3.Text = textBox3.Text.Replace(".", ",");
}
//iso add
if (textBox4.Text.Trim() != string.Empty && textBox12.Text.Trim() != string.Empty)
{
textBox4.Text = textBox4.Text.Replace(".", ",");
}
//noc add
if (textBox5.Text.Trim() != string.Empty && textBox13.Text.Trim() != string.Empty)
{
textBox5.Text = textBox5.Text.Replace(".", ",");
}
// zyd add
if (textBox6.Text.Trim() != string.Empty && textBox14.Text.Trim() != string.Empty)
{
textBox6.Text = textBox6.Text.Replace(".", ",");
}
//mega add
if (textBox7.Text.Trim() != string.Empty && textBox15.Text.Trim() != string.Empty)
{
textBox7.Text = textBox7.Text.Replace(".", ",");
}
//morp add
if (textBox8.Text.Trim() != string.Empty && textBox16.Text.Trim() != string.Empty)
{
textBox8.Text = textBox8.Text.Replace(".", ",");
}
//^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^//
//^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^//
//// Profit utregning
//{
// decimal sum = decimal.Parse(textBox20.Text.Trim()) * decimal.Parse(textBox21.Text.Trim());
// label30.Text = sum.ToString();
//}
//{
// decimal sum = decimal.Parse(label30.Text.Trim()) - decimal.Parse(textBox17.Text.Trim()) * decimal.Parse(label20.Text.Trim());
// label32.Text = sum.ToString();
//}
//decimal sum = decimal.Parse(textBox18.Text.Trim()) * decimal.Parse(label20.Text.Trim());
decimal sum2 = (10 / (1 + decimal.Parse(textBox18.Text.Trim())) / 100);
label48.Text = sum2.ToString("0.00000");
//production lvl utregning//
decimal sum1 = new decimal(0.25) - ((new decimal(0.05) * (decimal.Parse(textBox19.Text.Trim()))));
label47.Text = sum1.ToString();
//%Total Wastage%//
{
decimal sum = decimal.Parse(label48.Text) * 100;
label37.Text = sum.ToString("0.00");
}
//----------------------------------------------------------------//
// her summeres alt samme opp med og ta hensyn til production lvl //
//----------------------------------------------------------------//
decimal sum3 = decimal.Parse(textBox9.Text) + (decimal.Parse(textBox9.Text) * sum1) + (decimal.Parse(textBox9.Text) * sum2);
textBox39.Text = sum3.ToString();
decimal sum4 = decimal.Parse(textBox10.Text) + (decimal.Parse(textBox10.Text) * sum1) + (decimal.Parse(textBox10.Text) * sum2);
textBox40.Text = sum4.ToString();
decimal sum5 = decimal.Parse(textBox11.Text) + (decimal.Parse(textBox11.Text) * sum1) + (decimal.Parse(textBox11.Text) * sum2);
textBox41.Text = sum5.ToString();
decimal sum6 = decimal.Parse(textBox12.Text) + (decimal.Parse(textBox12.Text) * sum1) + (decimal.Parse(textBox12.Text) * sum2);
textBox42.Text = sum6.ToString();
decimal sum7 = decimal.Parse(textBox13.Text) + (decimal.Parse(textBox13.Text) * sum1) + (decimal.Parse(textBox13.Text) * sum2);
textBox43.Text = sum7.ToString();
decimal sum8 = decimal.Parse(textBox14.Text) + (decimal.Parse(textBox14.Text) * sum1) + (decimal.Parse(textBox14.Text) * sum2);
textBox44.Text = sum8.ToString();
decimal sum9 = decimal.Parse(textBox15.Text) + (decimal.Parse(textBox15.Text) * sum1) + (decimal.Parse(textBox15.Text) * sum2);
textBox45.Text = sum9.ToString();
decimal sum10 = decimal.Parse(textBox16.Text) + (decimal.Parse(textBox16.Text) * sum1) + (decimal.Parse(textBox16.Text) * sum2);
textBox46.Text = sum10.ToString();
//^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^//
//^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^//
////-------------------------------------------------//
//// her ganges pris med total mineral boxen *skult?*//
////-------------------------------------------------//
//{
// decimal sum = decimal.Parse(textBox1.Text.Trim()) * decimal.Parse(textBox39.Text.Trim());
// label11.Text = sum.ToString();
//}
//{
// decimal sum = decimal.Parse(textBox2.Text.Trim()) * decimal.Parse(textBox40.Text);
// label13.Text = sum.ToString();
//}
//{
// decimal sum = decimal.Parse(textBox3.Text.Trim()) * decimal.Parse(textBox41.Text);
// label14.Text = sum.ToString();
//}
//{
// decimal sum = decimal.Parse(textBox4.Text.Trim()) * decimal.Parse(textBox42.Text.Trim());
// label15.Text = sum.ToString();
//}
//{
// decimal sum = decimal.Parse(textBox5.Text.Trim()) * decimal.Parse(textBox43.Text.Trim());
// label16.Text = sum.ToString();
//}
//{
// decimal sum = decimal.Parse(textBox6.Text.Trim()) * decimal.Parse(textBox44.Text.Trim());
// label17.Text = sum.ToString();
//}
//{
// decimal sum = decimal.Parse(textBox7.Text.Trim()) * decimal.Parse(textBox45.Text.Trim());
// label18.Text = sum.ToString();
//}
//{
// decimal sum = decimal.Parse(textBox8.Text.Trim()) * decimal.Parse(textBox46.Text.Trim());
// label19.Text = sum.ToString();
//}
////^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^//
////^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^//
//her addes alle mat priser sammen.
decimal sum12 = (sum3 * decimal.Parse(textBox1.Text)) + (sum4 * decimal.Parse(textBox2.Text)) + (sum5 * decimal.Parse(textBox3.Text)) + (sum6 * decimal.Parse(textBox4.Text)) + (sum7 * decimal.Parse(textBox5.Text)) + (sum8 * decimal.Parse(textBox6.Text)) + (sum9 * decimal.Parse(textBox7.Text)) + (sum10 * decimal.Parse(textBox8.Text));
label20.Text = sum12.ToString("### ### ### ###");
// her legges total og runs sammen
decimal sum13 = decimal.Parse(textBox17.Text.Trim()) * sum12;
label25.Text = sum13.ToString("### ### ### ###");
// Profit utregning
decimal sum14 = decimal.Parse(textBox20.Text.Trim()) * decimal.Parse(textBox21.Text.Trim());
label30.Text = sum14.ToString();
decimal sum15 = sum14 - decimal.Parse(textBox17.Text.Trim()) * sum12;
label32.Text = sum15.ToString("### ### ### ###");
}
private void button2_Click(object sender, EventArgs e)
{
Form2 F2 = new Form2();
F2.Show();
}
private void button3_Click(object sender, EventArgs e)
{
Form3 F3 = new Form3();
F3.Show();
}
private void button4_Click(object sender, EventArgs e)
{
textBox1.Text = SpecialSettings.Default.verdi_nummer01;
textBox2.Text = SpecialSettings.Default.verdi_nummer02;
textBox3.Text = SpecialSettings.Default.verdi_nummer03;
textBox4.Text = SpecialSettings.Default.verdi_nummer04;
textBox5.Text = SpecialSettings.Default.verdi_nummer05;
textBox6.Text = SpecialSettings.Default.verdi_nummer06;
textBox7.Text = SpecialSettings.Default.verdi_nummer07;
textBox8.Text = SpecialSettings.Default.verdi_nummer08;
textBox9.Text = SpecialSettings.Default.verdi_nummer09;
textBox10.Text = SpecialSettings.Default.verdi_nummer010;
textBox11.Text = SpecialSettings.Default.verdi_nummer011;
textBox12.Text = SpecialSettings.Default.verdi_nummer012;
textBox13.Text = SpecialSettings.Default.verdi_nummer013;
textBox14.Text = SpecialSettings.Default.verdi_nummer014;
textBox15.Text = SpecialSettings.Default.verdi_nummer015;
textBox16.Text = SpecialSettings.Default.verdi_nummer016;
textBox17.Text = SpecialSettings.Default.verdi_nummer017;
textBox18.Text = SpecialSettings.Default.verdi_nummer018;
textBox19.Text = SpecialSettings.Default.verdi_nummer019;
textBox20.Text = SpecialSettings.Default.verdi_nummer020;
textBox21.Text = SpecialSettings.Default.verdi_nummer021;
}
private void button5_Click(object sender, EventArgs e)
{
Form2 F2 = new Form2();
F2.Show();
}
private void comboBox1_DropDown(object sender, EventArgs e)
{
if (comboBox1.Items.Contains("Wildcards"))
comboBox1.Items.Remove("Wildcards");
}

}
}

Test Drawing Text from file

<--------------------------->

this code gets a text form a file on c:\ then draws it on the form
<--------------------------->

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 test_drawing
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
public string teXt;
private void timer1_Tick(object sender, EventArgs e)
{
string file_name = "c:\\test.txt";
if (System.IO.File.Exists(file_name) == true)
{
System.IO.StreamReader objReader;
objReader = new System.IO.StreamReader(file_name);
//textBox1.Text = objReader.ReadToEnd();
teXt = objReader.ReadToEnd();
objReader.Close();
}
else
{
MessageBox.Show("ingen slik fil" + file_name);
}
}
public void Form1_Load(object sender, EventArgs e)
{
//string file_name = "c:\\test.txt";
//if (System.IO.File.Exists(file_name) == true)
//{
// System.IO.StreamReader objReader;
// objReader = new System.IO.StreamReader(file_name);
// //textBox1.Text = objReader.ReadToEnd();
// teXt = objReader.ReadToEnd();
// objReader.Close();
//}
//else
//{
// MessageBox.Show("ingen slik fil" + file_name);
//}
}
public void Form1_Paint(object sender, PaintEventArgs e)
{
//Graphics surface;
Graphics surface = this.CreateGraphics();
Font drawFont = new Font("Arial", 20);
SolidBrush drawBrush = new SolidBrush(Color.Black);
StringFormat drawFormat = new StringFormat();
drawFormat.FormatFlags = StringFormatFlags.DirectionRightToLeft;
surface.DrawString(teXt , drawFont, drawBrush, 220.0f, 50.0f, drawFormat);
}

}
}