Code:
String connString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Database1.mdf;Integrated Security=True;User Instance=True";
SqlConnection myConnect = new SqlConnection(connString);
myConnect.Open();
SqlCommand SqlCom = new SqlCommand();
SqlCom.Connection = myConnect;
string Current = monthCalendar1.SelectionStart.ToString();
SqlCom.Parameters.AddWithValue("@Datum", DateTime.Now);
SqlCom.Parameters.AddWithValue("@Vrednost", (float)(Convert.ToDouble(textBox2.Text)));
SqlCom.CommandText = "INSERT INTO AI1 (Datum, Vrednost) VALUES (@Datum,@Vrednost)";
SqlCom.ExecuteNonQuery();
SqlCom.Dispose();
myConnect.Close();
myConnect.Dispose();
String connString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Database1.mdf;Integrated Security=True;User Instance=True";
SqlConnection myConnect = new SqlConnection(connString);
myConnect.Open();
SqlCommand SqlCom = new SqlCommand();
SqlCom.Connection = myConnect;
string Current = monthCalendar1.SelectionStart.ToString();
SqlCom.Parameters.AddWithValue("@Datum", DateTime.Now);
SqlCom.Parameters.AddWithValue("@Vrednost", (float)(Convert.ToDouble(textBox2.Text)));
SqlCom.CommandText = "INSERT INTO AI1 (Datum, Vrednost) VALUES (@Datum,@Vrednost)";
SqlCom.ExecuteNonQuery();
SqlCom.Dispose();
myConnect.Close();
myConnect.Dispose();
Problem je sto kad unesem podatke on sve lepo unese i pokazuje kao da ih ima u tabeli, ali kad iskljucim program ili ponovo ukljucim podataka nema.Inace da napomenem da sam ovo radio u C# VS 2005 profesional.