sql ce 3.5 not comment data after insert it by code in c#

Question

 

SqlCeCommand   Cmd = sqlscript.connect.CreateCommand();
            try
            {
                if (sqlscript.connect.State == ConnectionState.Closed)
                {
                    sqlscript.connect.Open();
                }
               

                Cmd.CommandType = CommandType.Text;//
                Cmd.CommandText =
@"insert into task_tb (id,type_task,date_year,date_month,date_day)
             values('"+id.Text +"','"
             +type.Text.Trim()+"','"
             +year.SelectedItem+"','"
             +int.Parse(month.SelectedValue.ToString())+"','"
             +day.SelectedItem+"')";
  Cmd.ExecuteNonQuery();

 data no store in database please help me

Answer 1

Hi Sayer,

I think you're posting in the wrong forum. SqlCE is not supported for Windows Store apps.

If you can give more information about the type of application you are writing and for which platform you are writing it we can help you find the correct forum.

--Rob

Answer 2

 I am sorry ,

 i used windows application form C#

 

 can you get me like of forum that talked about windows application form C#

Answer 3

Look at the database file in your bin/debug folder, you will most likely see the data there.

The correct forum is "SQL Server Compact" btw

---

Please mark as answer, if this was it. Visit my SQL Server Compact blog