fredag 15. mai 2009

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();
}

Ingen kommentarer:

Legg inn en kommentar