C-Sharp

Executing Query C# with Example



 Like (0)  Dislike (0)

Executing Query C# with Example

using (SQLiteConnection conn = new SQLiteConnection(@"Data 
Source=data.db;Pooling=true;FailIfMissing=false")) 
{ 
conn.Open(); 
using (SQLiteCommand cmd = new SQLiteCommand(conn)) 
 

{ 
cmd.CommandText = "query"; 
using (SqlDataReader dr = cmd.ExecuteReader()) 
{ 
while(dr.Read()) 
{ 
//do stuff 
} 
} 
} 
} 
Note: Setting FailIfMissing to true creates the file data.db if missing. However, the file will be empty. So, any 
required tables have to be recreated.

0 Comment's

Comment Form

If opportunity doesn’t knock, build a door.⛩

Popular Post

WPF

How to Use Logger in WPF Application

C-Sharp

Update Specific Users Out of Oce Settings C# with Example

C-Sharp

Retrieve Specified User''s Out of O ce Settings C# with Example

C-Sharp

Large Object Heap compaction C# with Example

C-Sharp

Weak References C# with Example

C-Sharp

Source code in the view C# with Example