在C#智能设备中连接数据库Microsoft SQL Server Compact 3.5 sql [英] connect to database Microsoft SQL Server Compact 3.5 sql in C# smart devices
问题描述
大家
我在将数据存储到VS 2008中创建的数据库中时遇到问题Microsoft SQL Server Compact 3.5
I have a problem to store data in a database created in VS 2008 Microsoft SQL Server Compact 3.5
我的代码保存在哪里
///////////////// inicio guardar
/////////////////inicio guardar
            // cadena de conexion
          string partDir = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly()。GetName()。CodeBase);
          string partBD = System.IO.Path.Combine(partDir," embarque.sdf");
          string connectionstring = string.Empty;
          connectionstring = string.Format(@" Data Source = {0}; Password ='root'",partBD);
            // File.Delete(" embarque.sdf");
            // string connString =" Data Source ='embarque.sdf'; LCID = 1033;  密码= root;加密= TRUE;" ;; $
            // objeto de conexion
          SqlCeConnection con = new SqlCeConnection(connectionstring); //" Data Source =; Persist Security Info = True");
            con.Open();
            SqlCeCommand agregar = con.CreateCommand();
            // comando sql
            agregar.CommandText =" INSERT INTO ENVIO值(@ RAID,@ NPARTE,@ CANTIDAD,@ VENTANA,@ LIDER,@ FECHA)" ;;
            // con.Open();
            试试
            {
$
                foreach(dt.Rows中的DataRow行)
                {
                    agregar.Parameters.Clear();
$
                    agregar.Parameters.AddWithValue(" @ RAID",Convert.ToString(row [" Raid"]。ToString()));
                    agregar.Parameters.AddWithValue(" @ NPARTE",Convert.ToString(row [" Nparte"]。ToString()));
                    agregar.Parameters.AddWithValue(" @ CANTIDAD",Convert.ToString(row [" Cantidad"]。ToString()));
                    agregar.Parameters.AddWithValue(" @ VENTANA",Convert.ToString(row [" Ventana"]。ToString()));
                    agregar.Parameters.AddWithValue(" @LIDER",Convert.ToString(row [" Lider"]。ToString()));
                    agregar.Parameters.AddWithValue(" @ FECHA",Convert.ToString(row [" Fecha"]。ToString()));
$
                    agregar.ExecuteNonQuery();
                }
                MessageBox.Show(" Datos Agregados");
            }
            catch(例外情况)
            {
                MessageBox.Show(" Error al Agregar");
            }
            finally
            {
                con.Close();
            }
$
            /////////////// fin
//cadena de conexion
string partDir = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
string partBD = System.IO.Path.Combine(partDir, "embarque.sdf");
string connectionstring = string.Empty;
connectionstring = string.Format(@"Data Source = {0}; Password ='root'", partBD);
//File.Delete("embarque.sdf");
// string connString = "Data Source='embarque.sdf'; LCID=1033; Password = root; Encrypt = TRUE;";
//objeto de conexion
SqlCeConnection con = new SqlCeConnection(connectionstring);//"Data Source = ;Persist Security Info=True");
con.Open();
SqlCeCommand agregar = con.CreateCommand();
//comando sql
agregar.CommandText = "INSERT INTO ENVIO values(@RAID,@NPARTE,@CANTIDAD,@VENTANA,@LIDER,@FECHA)";
//con.Open();
try
{
foreach (DataRow row in dt.Rows)
{
agregar.Parameters.Clear();
agregar.Parameters.AddWithValue("@RAID", Convert.ToString(row["Raid"].ToString()));
agregar.Parameters.AddWithValue("@NPARTE", Convert.ToString(row["Nparte"].ToString()));
agregar.Parameters.AddWithValue("@CANTIDAD", Convert.ToString(row["Cantidad"].ToString()));
agregar.Parameters.AddWithValue("@VENTANA", Convert.ToString(row["Ventana"].ToString()));
agregar.Parameters.AddWithValue("@LIDER", Convert.ToString(row["Lider"].ToString()));
agregar.Parameters.AddWithValue("@FECHA", Convert.ToString(row["Fecha"].ToString()));
agregar.ExecuteNonQuery();
}
MessageBox.Show("Datos Agregados");
}
catch (Exception ex)
{
MessageBox.Show("Error al Agregar");
}
finally
{
con.Close();
}
///////////////fin
但是我做了一个打开数据库的路径错误
but I make an error of the path to open the database
推荐答案
错误是什么,在哪一行上它会发生吗?
What is the error and on which line does it occur?
这篇关于在C#智能设备中连接数据库Microsoft SQL Server Compact 3.5 sql的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!