如何将数据插入Sql Compact Server [英] How Do I Insert Data To Sql Compact Server

问题描述

我开发了一个代码来插入数据到sql compact服务器？

i have developed a code for insert data to sql compact server?

string connetionString = null;

            connetionString = "Data Source=stockDb.sdf";

            using (SqlCeConnection con = new SqlCeConnection(connetionString))
            {
                //
                // Open the SqlConnection.
                //
                con.Open();
                //
                // The following code uses an SqlCommand based on the SqlConnection.
                //

                string sqlquery = ("insert into Enquiry(userName,cusName,cusContact,subDate,reqDate,moreDetails,tktType,noPax,firstStatus,secStatus,thirdStatus)Values(@uName,@cName,@cContact,@sDate,@rDate,@mDetails,@tType,@nPax,@fStatus,@sStatus,@tStatus)");

                SqlCeCommand command = new SqlCeCommand(sqlquery, con);


                    string submitDate = sDate.Value.ToString("yyyy-MM-dd");
                    string requireDate = mDate.Value.ToString("yyyy-MM-dd");
                    int value = Convert.ToInt32(Cus_PaxNo.Text);

                    command.Parameters.AddWithValue("@uName", Loginlbl.Text);
                    command.Parameters.AddWithValue("@cName", Cus_Name.Text);
                    command.Parameters.AddWithValue("@cContact", Cus_Contact.Text);
                    command.Parameters.AddWithValue("@sDate", submitDate);
                    command.Parameters.AddWithValue("@rDate", requireDate);
                    command.Parameters.AddWithValue("@mDetails", Cus_Details.Text);
                    command.Parameters.AddWithValue("@tType", Cus_TicketType.Text);
                    command.Parameters.AddWithValue("@nPax", value);
                    command.Parameters.AddWithValue("@fStatus", Cus_FirstStatus.Text);
                    command.Parameters.AddWithValue("@sStatus", Cus_SecondStatus.Text);
                    command.Parameters.AddWithValue("@tStatus", Cus_ThirdStatus.Text);
                    command.ExecuteNonQuery();

                        MessageBox.Show("Password Accepted");
           }

这段代码给我一个错误说法？



System.Data.SqlserverCe.Dll中的System.Data.SqlServerCe.SqlCeException类型的未处理异常

this code gave me an error saying?

An unhandled exception of type 'System.Data.SqlServerCe.SqlCeException'occured in System.Data.SqlserverCe.Dll

推荐答案

Hhhmmm ...代码似乎看起来像好的，带2个小笔记：



1）连接字符串未满，请看这里： http://www.connectionstrings.com/sql-server-compact/ [ ^ ]

正确的连接字符串是：数据源= MyData.sdf;持久安全信息=假;



2）将此替换为：

Hhhmmm... code seems to look OK with 2 small notes:

1) connection string is not full, see here: http://www.connectionstrings.com/sql-server-compact/[^]
Proper connection string is: Data Source=MyData.sdf;Persist Security Info=False;

2) Replace this:

string submitDate = sDate.Value.ToString("yyyy-MM-dd");
string requireDate = mDate.Value.ToString("yyyy-MM-dd");

with：

with:

DateTime submitDate = sDate.Value;
DateTime requireDate = mDate.Value;

因为日期时间数据类型必须作为日期时间插入而不是字符串！

请参阅： SQL Server CE中支持的数据类型 [ ^ ]



试试！

because datetime data type must be inserted as datetime not string!
See: Data Types Supported in SQL Server CE[^]

Try!

这篇关于如何将数据插入Sql Compact Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！