Sqlite 添加、查询
发布时间:2020-12-12 19:40:57 所属栏目:百科 来源:网络整理
导读:using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using CommonClassLibary; using System.Data.SQLite; name
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using CommonClassLibary;
using System.Data.SQLite;
namespace TEST
{
public partial class FrmSQLite : Form
{
string databaseName = string.Empty;
string con = string.Empty;
public FrmSQLite()
{
InitializeComponent();
databaseName = AppDomain.CurrentDomain.BaseDirectory + "sam_db.sam";
con = string.Format("Data Source={0};password=sam",databaseName);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender,EventArgs e)
{
string sql = @"insert into DataBaseInfo ([DBAddress],[DBName],[DBUserName],[DBUserPwd])
values (@dbAddress,@dbName,@dbUser,@dbPwd)";
SQLiteParameter[] para = new SQLiteParameter[4];
for (int i = 0; i < para.Length; i++) { para[i] = new SQLiteParameter(); } para[0].ParameterName = "@dbAddress"; para[0].DbType = DbType.String; para[0].Direction = ParameterDirection.Input; para[0].Value = txt_dbAdress.Text; para[1].ParameterName = "@dbName"; para[1].DbType = DbType.String; para[1].Direction = ParameterDirection.Input; para[1].Value = txt_dbName.Text; para[2].ParameterName = "@dbUser"; para[2].DbType = DbType.String; para[2].Direction = ParameterDirection.Input; para[2].Value = txt_dbUser.Text; para[3].ParameterName = "@dbPwd"; para[3].DbType = DbType.String; para[3].Direction = ParameterDirection.Input; para[3].Value = txt_dbPwd.Text; CommonClassLibary.SQLHelper.SQLiteHelper.ExecuteNonQuery(con,sql,CommandType.Text,para); } //查询 private void button2_Click(object sender,EventArgs e) { string strSql = "select * from DataBaseInfo "; DataTable DT= CommonClassLibary.SQLHelper.SQLiteHelper.ExecuteDataSet(con,strSql,CommandType.Text).Tables[0]; this.dataGridView1.DataSource = DT; } } } (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |