using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;

namespace?__10
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????????this.Load?+=?new?EventHandler（Form1_Load）;
????????}
????????bool?IsBar（string?bar/*out?ErrMsg*/）
????????{
????????????//ErrMsg=““;
????????????if?（bar?==?““）
????????????{
????????????????MessageBox.Show（“條碼不能為空！““Error“）;
????????????????return?false;
????????????}
????????????try
????????????{
????????????????long?barcode?=?Convert.ToInt64（bar）;
????????????????if?（barcode?????????????????????return?false;
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????MessageBox.Show（“發生錯誤：“+ex.Message“錯誤信息“）;
????????????????return?false;
????????????}
????????????return?true;???
????????}
????????void?InitScreen（）
????????{
????????????textBox1.Text?=?““;
????????????textBox2.Text?=?““;
????????????textBox3.Text?=?““;
????????????textBox4.Text?=?““;
????????????textBox1.Focus（）;
????????}
????????private?void?button3_Click（object?sender?EventArgs?e）
????????{
????????????InitScreen（）;
????????}

????????private?void?button2_Click（object?sender?EventArgs?e）
????????{
????????????this.Close（）;
????????}
????????bool?IsBarExist（string?barcodeout?string?ErrMsg）
????????{
????????????ErrMsg?=?““;
????????????string?BAR;
????????????//try
????????????//{
????????????string?SqlConStr?=?“server=hjh-c070ea73e2c;?database=kskl;User?Id=sa;Password=123;“;
????????????????//string?SqlConStr?=?“data?source=192.168.1.102;?Initial?Catalog=kskl;User?Id=sa;Password=123;“;
????????????????SqlConnection?SqlCon?=?new?SqlConnection（SqlConStr）;
????????????????string?SqlStr?=?“select?GOODSUNIT.BARCODE?from?GOODSUNIT“;
????????????????SqlCommand?cmd?=?new?SqlCommand（SqlStr?SqlCon）;
????????????????SqlCon.Open（）;
????????????????SqlDataReader?SqlReader?=?cmd.ExecuteReader（）;
????????????????while?（SqlReader.Read（））
????????????????{
????????????????????BAR?=?（SqlReader[0].ToString（））;
????????????????????if?（BAR?==?barcode）
????????????????????{
????????????????????????return?true;
????????????????????}
????????????????????else
????????????????????{
????????????????????????continue;
????????????????????}
????????????????}
????????????//}
????????????/*catch?（Exception?ex）
????????????{
????????????????MessageBox.Show（“發生錯誤：?“?+?ex.Message）;
????????????????return?false;
????????????}*/
???????????//?finally
???????????//?{
????????????????SqlReader.Close（）;
????????????????SqlCon.Close（）;
????????????????ErrMsg?=?“條形碼不存在！，請重新輸入！“;
????????????//}
????????????return?false;
????????}
????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????string?BarCode?=?textBox1.Text;
????????????strin

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

?????文件???????3215??2007-08-10?11:28??C#鏈接SQL?Sever數據庫的簡單實例\8-10\8-10.csproj

?????文件??????24576??2007-08-10?17:23??C#鏈接SQL?Sever數據庫的簡單實例\8-10\bin\Debug\8-10.exe

?????文件??????28160??2007-08-10?17:23??C#鏈接SQL?Sever數據庫的簡單實例\8-10\bin\Debug\8-10.pdb

?????文件???????5632??2005-12-08?14:51??C#鏈接SQL?Sever數據庫的簡單實例\8-10\bin\Debug\8-10.vshost.exe

?????目錄??????????0??2007-08-10?11:29??C#鏈接SQL?Sever數據庫的簡單實例\8-10\bin\Debug

?????目錄??????????0??2007-08-10?11:25??C#鏈接SQL?Sever數據庫的簡單實例\8-10\bin

?????文件???????5273??2007-08-13?14:02??C#鏈接SQL?Sever數據庫的簡單實例\8-10\Form1.cs

?????文件???????8659??2007-08-10?15:40??C#鏈接SQL?Sever數據庫的簡單實例\8-10\Form1.Designer.cs

?????文件???????5814??2007-08-10?15:40??C#鏈接SQL?Sever數據庫的簡單實例\8-10\Form1.resx

?????文件????????247??2007-08-13?14:01??C#鏈接SQL?Sever數據庫的簡單實例\8-10\obj\8-10.csproj.FileList.txt

?????文件????????842??2007-08-10?17:21??C#鏈接SQL?Sever數據庫的簡單實例\8-10\obj\Debug\8-10.csproj.GenerateResource.Cache

?????文件??????24576??2007-08-10?17:23??C#鏈接SQL?Sever數據庫的簡單實例\8-10\obj\Debug\8-10.exe

?????文件??????28160??2007-08-10?17:23??C#鏈接SQL?Sever數據庫的簡單實例\8-10\obj\Debug\8-10.pdb

?????目錄??????????0??2007-08-10?11:25??C#鏈接SQL?Sever數據庫的簡單實例\8-10\obj\Debug\TempPE

?????文件????????180??2007-08-10?17:21??C#鏈接SQL?Sever數據庫的簡單實例\8-10\obj\Debug\__10.Form1.resources

?????文件????????180??2007-08-10?11:28??C#鏈接SQL?Sever數據庫的簡單實例\8-10\obj\Debug\__10.Properties.Resources.resources

?????目錄??????????0??2007-08-10?17:23??C#鏈接SQL?Sever數據庫的簡單實例\8-10\obj\Debug

?????目錄??????????0??2007-08-10?11:29??C#鏈接SQL?Sever數據庫的簡單實例\8-10\obj

?????文件????????463??2007-08-10?11:25??C#鏈接SQL?Sever數據庫的簡單實例\8-10\Program.cs

?????文件???????1162??2007-08-10?11:25??C#鏈接SQL?Sever數據庫的簡單實例\8-10\Properties\AssemblyInfo.cs

?????文件???????2863??2007-08-10?11:25??C#鏈接SQL?Sever數據庫的簡單實例\8-10\Properties\Resources.Designer.cs

?????文件???????5612??2007-08-10?11:25??C#鏈接SQL?Sever數據庫的簡單實例\8-10\Properties\Resources.resx

?????文件???????1088??2007-08-10?11:25??C#鏈接SQL?Sever數據庫的簡單實例\8-10\Properties\Settings.Designer.cs

?????文件????????249??2007-08-10?11:25??C#鏈接SQL?Sever數據庫的簡單實例\8-10\Properties\Settings.settings

?????目錄??????????0??2007-08-10?11:25??C#鏈接SQL?Sever數據庫的簡單實例\8-10\Properties

?????目錄??????????0??2007-08-13?14:02??C#鏈接SQL?Sever數據庫的簡單實例\8-10

?????文件????????901??2007-08-10?11:25??C#鏈接SQL?Sever數據庫的簡單實例\8-10.sln

????..A..H.?????12288??2007-08-13?14:02??C#鏈接SQL?Sever數據庫的簡單實例\8-10.suo

?????目錄??????????0??2007-08-10?11:25??C#鏈接SQL?Sever數據庫的簡單實例

-----------?---------??----------?-----??----

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