-
大小: 331KB文件類型: .rar金幣: 2下載: 0 次發(fā)布日期: 2021-06-05
- 語言: C#
- 標(biāo)簽: c#??增刪改??窗體??datagridview??
資源簡介
c#窗體模式下對用封裝的方式對表格內(nèi)容實(shí)現(xiàn)增刪改操作,新手可以學(xué)一下.里面附有數(shù)據(jù)庫文件及使用說明。已經(jīng)通過測試。可以學(xué)習(xí)下

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Data.SqlClient;
using?sql;
namespace?bill
{
????public?class?yuju
????{
????????private?string?_name;
????????private?string?_pwd;
????????private?int?_uid;
????????public?string?name
????????{
????????????get?{?return?_name;?}
????????????set?{?_name?=?value;?}
????????}
????????public?string?pwd
????????{
????????????get?{?return?_pwd;?}
????????????set?{?_pwd?=?value;?}
????????}
????????public?int?uid
????????{
????????????get?{?return?_uid;?}
????????????set?{?_uid?=?value;?}
????????}
????????public?bool?add(yuju?yuju)
????????{
????????????string?querystring?=?“insert?into?[user]?values(‘“+yuju._name+“‘‘“+yuju._pwd+“‘)“;
????????????Class1?db?=?new?Class1();
????????????return?db.exec(querystring)?==?1;
????????}
????????public?bool?delete(yuju?yuju)
????????{
????????????string?querystring?=?“delete?from?[user]?where?uid=‘“+yuju._uid+“‘“;
????????????Class1?db?=?new?Class1();
????????????return?db.exec(querystring)?==?1;
????????}
????????public?bool?update(yuju?yuju)
????????{
????????????string?querystring?=?“update?[user]?set?name=‘“+yuju._name+“‘pwd=‘“+yuju._pwd+“‘where?uid=‘“+yuju._uid+“‘“;
????????????Class1?db?=?new?Class1();
????????????return?db.exec(querystring)?==?1;
????????}
????????public?SqlDataAdapter?get()
????????{
????????????string?querystring?=?“select?uid?as?用戶IDname?as?用戶名?pwd?as?密碼?from?[user]“;
????????????Class1?db?=?new?Class1();
????????????SqlDataAdapter?da?=?db.getda(querystring);
????????????return?da;
????????}
????}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????3145728??2010-06-25?12:09??Form增刪改操作\databa
?????文件????1048576??2010-06-25?12:09??Form增刪改操作\databa
?????文件???????2679??2010-06-22?19:02??Form增刪改操作\WindowsFormsApplication1\bill\bill.csproj
?????文件???????5120??2010-06-25?11:23??Form增刪改操作\WindowsFormsApplication1\bill\bin\Debug\bill.dll
?????文件??????15872??2010-06-25?11:23??Form增刪改操作\WindowsFormsApplication1\bill\bin\Debug\bill.pdb
?????文件???????4608??2010-06-22?19:02??Form增刪改操作\WindowsFormsApplication1\bill\bin\Debug\sql.dll
?????文件??????11776??2010-06-22?19:02??Form增刪改操作\WindowsFormsApplication1\bill\bin\Debug\sql.pdb
?????文件???????1188??2010-06-25?11:23??Form增刪改操作\WindowsFormsApplication1\bill\obj\Debug\bill.csproj.FileListAbsolute.txt
?????文件???????5120??2010-06-25?11:23??Form增刪改操作\WindowsFormsApplication1\bill\obj\Debug\bill.dll
?????文件??????15872??2010-06-25?11:23??Form增刪改操作\WindowsFormsApplication1\bill\obj\Debug\bill.pdb
?????文件???????6219??2010-06-25?11:23??Form增刪改操作\WindowsFormsApplication1\bill\obj\Debug\ResolveAssemblyReference.cache
?????文件???????1346??2010-06-22?18:22??Form增刪改操作\WindowsFormsApplication1\bill\Properties\AssemblyInfo.cs
?????文件???????1664??2010-06-25?11:22??Form增刪改操作\WindowsFormsApplication1\bill\yuju.cs
?????文件???????4608??2010-06-22?19:02??Form增刪改操作\WindowsFormsApplication1\sql\bin\Debug\sql.dll
?????文件??????11776??2010-06-22?19:02??Form增刪改操作\WindowsFormsApplication1\sql\bin\Debug\sql.pdb
?????文件???????1070??2010-06-22?18:38??Form增刪改操作\WindowsFormsApplication1\sql\Class1.cs
?????文件????????468??2010-06-22?19:02??Form增刪改操作\WindowsFormsApplication1\sql\obj\Debug\sql.csproj.FileListAbsolute.txt
?????文件???????4608??2010-06-22?19:02??Form增刪改操作\WindowsFormsApplication1\sql\obj\Debug\sql.dll
?????文件??????11776??2010-06-22?19:02??Form增刪改操作\WindowsFormsApplication1\sql\obj\Debug\sql.pdb
?????文件???????1344??2010-06-22?18:23??Form增刪改操作\WindowsFormsApplication1\sql\Properties\AssemblyInfo.cs
?????文件???????2532??2010-06-22?19:02??Form增刪改操作\WindowsFormsApplication1\sql\sql.csproj
?????文件????????353??2010-06-25?11:20??Form增刪改操作\WindowsFormsApplication1\WindowsFormsApplication1\app.config
?????文件???????5120??2010-06-25?11:23??Form增刪改操作\WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\bill.dll
?????文件??????15872??2010-06-25?11:23??Form增刪改操作\WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\bill.pdb
?????文件????2293760??2010-06-22?20:12??Form增刪改操作\WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\Databa
?????文件?????573440??2010-06-22?20:12??Form增刪改操作\WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\Databa
?????文件???????4608??2010-06-22?19:02??Form增刪改操作\WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\sql.dll
?????文件??????11776??2010-06-22?19:02??Form增刪改操作\WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\sql.pdb
?????文件??????12288??2010-06-25?12:08??Form增刪改操作\WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\WindowsFormsApplication1.exe
?????文件????????353??2010-06-25?11:20??Form增刪改操作\WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\WindowsFormsApplication1.exe.config
............此處省略54個文件信息
評論
共有 條評論