Base de datos SQLite y C# con DB Browser for SQLite
En este video realizo un ejemplo de una aplicación de escritorio con C# y usando una base de datos SQLite y administrándola con DB Browser for SQLite
Código
--------------------------------------------------------------------------------------------------------------------------
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SQLite;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace SQLITEWMS
{
public partial class Form1 : Form
{
string textoConsulta;
public Form1()
{
InitializeComponent();
SQLiteConnection sqlite_conn;
sqlite_conn = Conexion();
//Insertar datos
InsertarDatos(sqlite_conn);
//Leer datos
ConsultarDatos(sqlite_conn);
//Mostrar datos
richTextBox1.Text = textoConsulta;
}
private SQLiteConnection Conexion()
{
SQLiteConnection sqlite_conn;
sqlite_conn = new SQLiteConnection("Data Source= miBase.db; Version = 3; New = True; Compress = True; ");
try
{
sqlite_conn.Open();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return sqlite_conn;
}
private void InsertarDatos(SQLiteConnection conn)
{
SQLiteCommand sqlite_cmd;
sqlite_cmd = conn.CreateCommand();
sqlite_cmd.CommandText = "INSERT INTO ITEMS (SKU, DESCRIPTION,BARCODE,UNIT) VALUES('SKU10','DECRIPCION DE SKU 3','0000000003','KG'); ";
sqlite_cmd.ExecuteNonQuery();
}
private void ConsultarDatos(SQLiteConnection conn)
{
SQLiteDataReader sqlite_datareader;
SQLiteCommand sqlite_cmd;
sqlite_cmd = conn.CreateCommand();
sqlite_cmd.CommandText = "SELECT * FROM ITEMS";
sqlite_datareader = sqlite_cmd.ExecuteReader();
while (sqlite_datareader.Read())
{
string myreader = sqlite_datareader.GetString(1);
textoConsulta += myreader + "\r\n";
}
conn.Close();
}
}
}
--------------------------------------------------------------------------------------------------------------------------
Comentarios
Publicar un comentario