Here is code:
conn.Open();
SqlCeCommand cmd = new SqlCeCommand("INSERT INTO tbl (no, col1, col2,
col3) VALUES ('10', 'something', '12/27/2012 04:21', 'someth')",
conn);
cmd.ExecuteNonQuery();
conn.Close();
problem is that this just doesn't work. It does't show any error
message but no data is inserted.
When I use some SELECT statement instead of INSERT it works fine (so I
guess db connection is good). When I take this command text into SQL
query editor it inserts data fine
( so I guess command syntax is fine).
Does anybody has any idea what may be the problem???
Thank you
--
You received this message because you are subscribed to the Google
Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML
Web Services,.NET Remoting" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en
or visit the group website at http://megasolutions.net
