using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlServerCe;
using System.IO;
using System.Collections;
using System.Data;
using System.Drawing;
using System.Windows.Forms;
using System.ComponentModel;
using DeviceApplication5.DataAccess;
namespace DeviceApplication5.Business
{
class NoteDB
{
private DataGrid Notedgrid;
private BindingSource Bding;
public NoteDB()
{
}
public NoteDB(BindingSource bds, DataGrid dgrid)
{
Notedgrid = dgrid;
Bding = bds;
}
public DataSet GetNoteData()
{
CommonDB cdb = new CommonDB();
string Sql = "select * from Notes";
DataSet Ds = cdb.GetDataSet(Sql, "Notes");
return Ds;
}
public int InsertNoteData(Notes ns)
{
CommonDB cdb = new CommonDB();
string Sql = "insert into Notes(NoteID,Author,Age,Phone,Address,PostCard)values(@noteid,@author,@age,@phone,@address,@postcard)";
SqlCeParameter[] paras = new SqlCeParameter[6];
paras[0] = new SqlCeParameter("@noteid", ns.NoteID);
paras[1] = new SqlCeParameter("@author", ns.Author);
paras[2] = new SqlCeParameter("@age", ns.Age);
paras[3] = new SqlCeParameter("@address", ns.Address);
paras[4] = new SqlCeParameter("@phone", ns.Phone);
paras[5] = new SqlCeParameter("@postcard", ns.PostCard);
return cdb.ExcuteSql(Sql, paras);
}
public int UpdateNoteDataByNotID(Notes ns)
{
CommonDB cdb = new CommonDB();
string Sql = "update Notes set Author=@author,Age=@age,Phone=@phone,Address=@address,PostCard=@postcard where NoteID=@noteid";
SqlCeParameter[] paras = new SqlCeParameter[6];
paras[0] = new SqlCeParameter("@author", ns.Author);
paras[1] = new SqlCeParameter("@age", ns.Age);
paras[2] = new SqlCeParameter("@address", ns.Address);
paras[3] = new SqlCeParameter("@phone", ns.Phone);
paras[4] = new SqlCeParameter("@postcard", ns.PostCard);
paras[5] = new SqlCeParameter("@noteid", ns.NoteID);
return cdb.ExcuteSql(Sql, paras);
}
public int DeleteNoteDataByNotID(string Noteid)
{
CommonDB cdb = new CommonDB();
string Sql = "delete Notes where NoteID=@noteid";
SqlCeParameter[] paras = new SqlCeParameter[1];
paras[0] = new SqlCeParameter("@noteid", Noteid);
return cdb.ExcuteSql(Sql, paras);
}
public void UpdateGird()
{
DataSet Ds = GetNoteData();
Bding.DataSource = Ds.Tables[0].DefaultView;
Notedgrid.DataSource = Bding;
}
}
}
C# wince5.0下的插入、删除、更新源码
最新推荐文章于 2020-10-16 16:29:53 发布