Adding A Record (Sql Server 2005 Compact Edition and Visual Studio 2005 C#)
-
I am using Sql Server 2005 Compact Edition as a database and I can't seem to get this thing to add a simple record... I run the a simple Insert statement and the Table is still empty. I get no error code or anything... Has anyone else been able to add records to a Compact Edition table in Visual Studio 2005 using C#??? Here is my code... INSERT INTO TimeZone (state, abbrev, tzone) VALUES (@p1, @p2, @p3) Now the one thing that isn't showing is my primary key field which is "tzid". But it is autonumbered. I fill in the values in code for @p1, @p2, @p3. When I open up the TimeZone table, it is empty... Any help would be appreciated. Thanks
-
I am using Sql Server 2005 Compact Edition as a database and I can't seem to get this thing to add a simple record... I run the a simple Insert statement and the Table is still empty. I get no error code or anything... Has anyone else been able to add records to a Compact Edition table in Visual Studio 2005 using C#??? Here is my code... INSERT INTO TimeZone (state, abbrev, tzone) VALUES (@p1, @p2, @p3) Now the one thing that isn't showing is my primary key field which is "tzid". But it is autonumbered. I fill in the values in code for @p1, @p2, @p3. When I open up the TimeZone table, it is empty... Any help would be appreciated. Thanks
I've no experience with CE but are you able to execture your query with your parameters from a Management Studio?
-
I am using Sql Server 2005 Compact Edition as a database and I can't seem to get this thing to add a simple record... I run the a simple Insert statement and the Table is still empty. I get no error code or anything... Has anyone else been able to add records to a Compact Edition table in Visual Studio 2005 using C#??? Here is my code... INSERT INTO TimeZone (state, abbrev, tzone) VALUES (@p1, @p2, @p3) Now the one thing that isn't showing is my primary key field which is "tzid". But it is autonumbered. I fill in the values in code for @p1, @p2, @p3. When I open up the TimeZone table, it is empty... Any help would be appreciated. Thanks
please put your code over here
Best Regards ----------------- Abhijit Jana Check Out My Latest Article Java.NET : Integration of Java and .NET[^] "Success is Journey it's not a destination"