using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data;
using?System.Data.SqlClient;

namespace?Chulicheng
{
????public?class?mer
????{
????????SqlConnection?con?=?new?SqlConnection（“server=（local）;uid=sa;pwd=sa;database=student“）;
????????public?bool?insertReun（string?sql）
????????{
???????????
????????????SqlCommand?comm?=?new?SqlCommand（sqlcon）;
????????????con.Open（）;
????????????if?（comm.ExecuteNonQuery（）?>?0）
????????????{
????????????????return?true;
????????????}
????????????else
????????????{
????????????????return?false;
????????????}
????????
????????}
????????public?DataSet?SelectReun（string?sql）
????????{

????????????try
????????????{
????????????????SqlDataAdapter?da?=?new?SqlDataAdapter（sql?this.con）;

????????????????DataSet?ds?=?new?DataSet（）;
????????????????da.Fill（ds）;
????????????????return?ds;
????????????}
????????????catch?（Exception）
????????????{
????????????????
????????????????throw;
????????????}
????????
????????}
????????public?bool?DeleteReun（string?sql）
????????{
????????????SqlCommand?comm?=?new?SqlCommand（sqlcon）;
????????????con.Open（）;
????????????if?（comm.ExecuteNonQuery（）?>?0）
????????????{
????????????????return?true;
????????????}
????????????else
????????????{
????????????????return?false;
????????????}
????????}

????????public?bool?UpdateReun（string?sqlSqlParameter[]?param）
????????{
????????????SqlCommand?comm?=?new?SqlCommand（sqlcon）;
????????????comm.Parameters.AddRange（param）;
????????????con.Open（）;
????????????if?（comm.ExecuteNonQuery（）?>?0）
????????????{
????????????????return?true;

????????????}
????????????else
????????????{
????????????????return?false;
????????????}
????????
????????}

????????public?bool?SelectReud（string?sql）
????????{

????????????SqlCommand?comm?=?new?SqlCommand（sql?con）;
?????????????con.Open（）;

?????????????return?（int）comm.ExecuteScalar（）?>?0???true?:?false;

????????}



????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件??????16384??2007-07-20?09:54??超市進銷存管理\chulicheng\bin\Debug\chulicheng.dll

?????文件??????13824??2007-07-20?09:54??超市進銷存管理\chulicheng\bin\Debug\chulicheng.pdb

?????文件???????1954??2007-07-04?14:26??超市進銷存管理\chulicheng\Chulicheng.csproj

?????文件???????2021??2007-07-19?19:13??超市進銷存管理\chulicheng\mer.cs

?????文件????????146??2007-07-26?09:44??超市進銷存管理\chulicheng\obj\Chulicheng.csproj.FileList.txt

?????文件??????16384??2007-07-20?09:54??超市進銷存管理\chulicheng\obj\Debug\chulicheng.dll

?????文件??????13824??2007-07-20?09:54??超市進銷存管理\chulicheng\obj\Debug\chulicheng.pdb

?????文件??????16384??2007-07-20?18:28??超市進銷存管理\chulicheng\obj\Debug\Refactor\chulicheng.dll

?????文件???????1323??2007-07-04?14:00??超市進銷存管理\chulicheng\Properties\AssemblyInfo.cs

?????文件???????3638??2004-08-28?07:49??超市進銷存管理\dbpilot.ico

?????文件????????393??2006-06-18?10:16??超市進銷存管理\Myproject\app.config

?????文件??????16384??2007-07-20?09:54??超市進銷存管理\Myproject\bin\Debug\chulicheng.dll

?????文件??????13824??2007-07-20?09:54??超市進銷存管理\Myproject\bin\Debug\chulicheng.pdb

?????文件????1675264??2007-07-26?09:44??超市進銷存管理\Myproject\bin\Debug\Myproject.exe

?????文件????????393??2006-06-18?10:16??超市進銷存管理\Myproject\bin\Debug\Myproject.exe.config

?????文件?????499200??2007-07-26?09:44??超市進銷存管理\Myproject\bin\Debug\Myproject.pdb

?????文件???????5632??2005-12-08?14:51??超市進銷存管理\Myproject\bin\Debug\Myproject.vshost.exe

?????文件????????393??2006-06-18?10:16??超市進銷存管理\Myproject\bin\Debug\Myproject.vshost.exe.config

?????文件??????16384??2007-07-20?09:54??超市進銷存管理\Myproject\bin\Debug\yewucheng.dll

?????文件??????13824??2007-07-20?09:54??超市進銷存管理\Myproject\bin\Debug\yewucheng.pdb

?????文件??????10996??2007-07-20?10:24??超市進銷存管理\Myproject\CrystalReport1.cs

?????文件??????32768??2006-06-18?10:18??超市進銷存管理\Myproject\CrystalReport1.rpt

?????文件??????62955??2007-07-20?10:24??超市進銷存管理\Myproject\DataSet1.Designer.cs

?????文件????????381??2006-06-18?10:23??超市進銷存管理\Myproject\DataSet1.xsc

?????文件??????23072??2006-06-18?10:23??超市進銷存管理\Myproject\DataSet1.xsd

?????文件????????854??2006-06-18?10:23??超市進銷存管理\Myproject\DataSet1.xss

?????文件??????26471??2007-07-25?18:44??超市進銷存管理\Myproject\Myproject.csproj

?????文件????????219??2006-06-18?10:23??超市進銷存管理\Myproject\Myproject.csproj.user

?????文件??????32768??2006-06-18?10:18??超市進銷存管理\Myproject\obj\Debug\Myproject.CrystalReport1.rpt

?????文件???????6232??2007-07-26?09:44??超市進銷存管理\Myproject\obj\Debug\Myproject.csproj.GenerateResource.Cache

............此處省略288個文件信息