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;

????????}



????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2016-05-19?14:30??超市進銷存管理\
?????目錄???????????0??2016-05-19?14:30??超市進銷存管理\Myproject\
?????文件???????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
?????目錄???????????0??2016-05-19?14:30??超市進銷存管理\Myproject\Properties\
?????文件????????1184??2007-06-05?20:31??超市進銷存管理\Myproject\Properties\AssemblyInfo.cs
?????文件???????18405??2007-07-24?18:53??超市進銷存管理\Myproject\Properties\Resources.Designer.cs
?????文件???????20965??2007-07-24?18:53??超市進銷存管理\Myproject\Properties\Resources.resx
?????文件????????1684??2007-07-20?10:24??超市進銷存管理\Myproject\Properties\Settings.Designer.cs
?????文件?????????969??2006-06-18?10:16??超市進銷存管理\Myproject\Properties\Settings.settings
?????目錄???????????0??2008-07-19?14:19??超市進銷存管理\Myproject\Resources\
?????文件????????5097??2007-06-24?15:19??超市進銷存管理\Myproject\Resources\228378.jpg
?????文件????????5097??2007-06-23?18:39??超市進銷存管理\Myproject\Resources\2283781.jpg
?????文件???????20542??2007-06-24?16:39??超市進銷存管理\Myproject\Resources\33.png
?????文件???????10653??2007-06-24?15:27??超市進銷存管理\Myproject\Resources\37.png
?????文件???????10653??2007-06-23?20:00??超市進銷存管理\Myproject\Resources\371.png
?????文件???????10653??2007-06-23?20:00??超市進銷存管理\Myproject\Resources\372.png
?????文件???????28394??2007-07-01?16:31??超市進銷存管理\Myproject\Resources\635sdfsd.jpg
?????文件???????27759??2007-06-17?18:19??超市進銷存管理\Myproject\Resources\AquaBubble%20016.png
?????文件???????27759??2007-06-16?21:36??超市進銷存管理\Myproject\Resources\AquaBubble%200161.png
?????文件???????19344??2007-06-17?17:42??超市進銷存管理\Myproject\Resources\Aria.png
?????文件???????19344??2007-06-16?21:35??超市進銷存管理\Myproject\Resources\Aria1.png
?????文件????????5555??2007-06-19?18:44??超市進銷存管理\Myproject\Resources\Calendar.png
?????文件???????16846??2007-06-24?17:15??超市進銷存管理\Myproject\Resources\Documents%20%26%20Settings%20Folder.png
?????文件????????1188??2007-06-16?19:08??超市進銷存管理\Myproject\Resources\MemoryHeapSize.jpg
............此處省略284個文件信息