hi all
I have a problem to store data in a database created in VS 2008 Microsoft SQL Server Compact 3.5
I have my code where I keep
/////////////////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; 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