Please, follow this: [Creating a SQL Server Linked Server to SQLite to Import Data](https://www.mssqltips.com/sqlservertip/3087/creating-a-sql-server-linked-server-to-sqlite-to-import-data/)

thank you very much I am always looking for the solution of my problem. I hope to escape

here is the code: { setConnection(); sql_con.Open(); sql_cmd = sql_con.CreateCommand(); string CommandText = "select * from InfoCode"; DB = new SQLiteDataAdapter(CommandText, sql_con); DS.Reset(); CrystalReportImprimCode x = new CrystalReportImprimCode(); DBset dt = new DBset(); DB.Fill(dt.InfoCode); x.SetDataSource((DataTable)dt.InfoCode); crystalReportViewer1.ReportSource = x; crystalReportViewer1.Refresh(); sql_con.Close(); }

My pleasure, I love the site and you are working hard on it, the least I can do for the service provided is to give back what I can.

I completely agree with you. In fact, there are ORMs that allow set based operations (the WHERE part of a LINQ select can very well be used in an update).

Ahmed, an Android application has an "Internal" data area - that is, an area within the Android file system where data used by that application alone resides. An app's sqlite DB lives in this area. You say that you want the DB to exist in the "root" area. In that case you're talking about "External" storage. It's called external because it is outside the app's assigned part of the file system. Most applications, that aren't part of the system, do NOT access External storage, and to do so an app requires special permissions that are not granted by default. Can you explain more about what problem you're trying to solve by wanting to put your DB in External storage? There may be a more conventional and easier way to achieve your aims.

You already posted this question at help me - Visual Basic Discussion Boards[^]. Please do not repost.

Where is the connectionstring? I do not see anything that references your database-file. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

As I said: it was a bad, rushed example. I will continue to accept bads on that. "There are three kinds of lies: lies, damned lies and statistics." - Benjamin Disraeli

Post the code at the place suggested by OriginalGriff

Not sure if I understood your issue completely. Since you want to let the user edit the texts, you opted for storing them in a database instead of resx files, but still want to use resx files for development, isn't it? I'd suggest to get rid of those resx files here, handle the localization completely in the database (I think software translation shops can handle that, too), thus no need to feed them from the files into the database.

Is it a CSV file? Do you actually need to import it into a database, or can you simply process the file to get the desired numbers? "One man's wage rise is another man's price increase." - Harold Wilson "Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons "You can easily judge the character of a man by how he treats those who can do nothing for him." - James D. Miles

Wrong place, try http://www.codeproject.com/Questions/ask.aspx[^]. But you need to add much more detail, or use Google to find what you are looking for.

There is no general rule how to format quoted text. The example posted by Nelek might impair the readability and should be used only for short text. The CodeProject Plagiarism FAQ[^] explains how to properly reference quotes and uses italic text. Common format options are italic, indenting, and enclosing by double quotes: Italic (HTML <i>): Quoted text Indented (HTML <blockquote>): Quoted text Double quoted (use <quot> for the characters when editing offline): "Quoted text"

OK, I understand. Well, so far in code I got what I wanted out of it. I just need to log the error in the database so I can conclude that the email was sent to the Cbeyond mail servers, and it's out of my hands. 'This is the new sendEngine Dim sE As New SendEngine() sE.SendEmailAsync(smtpClient, mailMessage, 5) AddHandler sE.SendEmailCompleted, _ Sub(sender As Object, e As SendEmailCompletedEventArgs) Console.WriteLine(e.Error) If (e.Error IsNot Nothing) Then model.Error\_Text = e.Error.HResult model.Error\_Text = e.Error.Message.ToString model.TimeStamp\_Error = DateTime.Now() ef\_model\_smtp\_resend.Write\_Smtp\_Send\_Record(model) End If End Sub Thanks for the help Richard! It would of taken me days to figure out the handler.

Well first off, SQLite doesn't support automatic database creation, you have to manually create the database. So I added that add-in to my Firefox and created the database. I'm wondering if this is worth the time. This program uses old Dbase IV or Foxpro database files, and I wanted to use something faster and more modern for a new program feature that stores all the emails sent in the database, so if one fails it can be resent. This kicked my butt, but I don't get an error anymore. I couldn't figure out the App.Config part the way the bulk of examples showed, but I did figure out how to point the database to a network drive via code in the Application, and pass it to EF6 DAL. So in case your looking for an example of how to point SQLite to a network drive without hard coding the path, this is it, well I think it is, until something better comes along. I apologize in advance for this being in VB. All the examples where in C# My project has 3 modules, because it's getting too large in size. Main Project EXE Data Access Layer DLL Entity DLL I went back and stripped out the SQLite from the main project and Entity DLL and just installed it in the DAL DLL. Then just made references for SQLite back to the DAL. Then stripped out the SQLite and EF stuff in the App.Configs of DLL's So in the DBContext class in my DAL, I added the conn string to use in New() Public Class ameContext Inherits DbContext Public Shared Property DefaultConnectionFactory As IDbConnectionFactory Public Sub New(ByVal conString As String) '<< I added the conn string to use MyBase.New(conString) 'SQLite doesn't support auto database creation Entity.Database.SetInitializer(Of ameContext)(Nothing) End Sub End NameSpace Then I added a SQLiteConfiguration File to my DAL Class, which gets called from the DBContext above. Imports System.Data.SQLite Imports System.Data.SQLite.EF6 Imports System.Linq Imports System.Text Imports System.Data.Entity.Core.Common Imports AccountMate_DAL Namespace System.Data.SQLite.Entity Public Class SQLiteConfiguration Inherits DbConfiguration Public Sub New() SetProviderFactory("System.Data.SQLite", SQLiteFactory.Instance) SetProviderFactory("System.Data.SQLite.EF6", SQLiteProvid