資源簡介
C#連接局域網sql2005或2008數據庫

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
//Download?by?http://www.codefans.net
using?System.Data.SqlClient;
namespace?Case05_12
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1()
????????{
????????????InitializeComponent();
????????}
????????private?void?button1_Click(object?sender?EventArgs?e)
????????{
????????????try
????????????{
????????????????//生成連接數據庫字符串
????????????????string?ConStr?=?“server=(local);user?id=myzf;pwd=123456;database=MysqlData“;
????????????????//定義SqlConnection對象實例??
????????????????SqlConnection?con?=?new?SqlConnection(ConStr);
????????????????//定義Select查詢語句
????????????????string?SqlStr?=?“select?*?from?應付賬“;
????????????????SqlDataAdapter?ada?=?new?SqlDataAdapter(SqlStr?con);
????????????????DataSet?ds?=?new?DataSet();????//定義DataSet對象實例
????????????????ada.Fill(ds);
????????????????//連接數據表格,顯示數據??
????????????????this.dataGridView1.DataSource?=?ds.Tables[0].DefaultView;
????????????}
????????????catch
????????????{
????????????????return;
????????????}
????????}
????????private?void?button2_Click(object?sender?EventArgs?e)
????????{
????????????this.Close();
????????????Application.Exit();
????????}
????}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????3764??2008-06-11?21:25??C#連接局域網sql數據庫\Backup\Case05_12\Case05_12.csproj
?????文件???????1460??2011-01-02?19:42??C#連接局域網sql數據庫\Backup\Case05_12\Form1.cs
?????文件???????5004??2008-06-11?21:27??C#連接局域網sql數據庫\Backup\Case05_12\Form1.Designer.cs
?????文件???????5814??2008-06-11?21:27??C#連接局域網sql數據庫\Backup\Case05_12\Form1.resx
?????文件????????527??2011-01-02?19:42??C#連接局域網sql數據庫\Backup\Case05_12\Program.cs
?????文件???????1374??2008-06-11?21:14??C#連接局域網sql數據庫\Backup\Case05_12\Properties\AssemblyInfo.cs
?????文件???????2868??2008-06-11?21:14??C#連接局域網sql數據庫\Backup\Case05_12\Properties\Resources.Designer.cs
?????文件???????5612??2008-06-11?21:14??C#連接局域網sql數據庫\Backup\Case05_12\Properties\Resources.resx
?????文件???????1094??2008-06-11?21:14??C#連接局域網sql數據庫\Backup\Case05_12\Properties\Settings.Designer.cs
?????文件????????249??2008-06-11?21:14??C#連接局域網sql數據庫\Backup\Case05_12\Properties\Settings.settings
?????文件????????917??2008-06-11?21:14??C#連接局域網sql數據庫\Backup\Case05_12.sln
????..A..H.?????16384??2013-07-09?11:37??C#連接局域網sql數據庫\Backup\Case05_12.suo
?????文件???????9728??2013-07-09?15:14??C#連接局域網sql數據庫\Case05_12\bin\Debug\Case05_12.exe
?????文件??????24064??2013-07-09?15:14??C#連接局域網sql數據庫\Case05_12\bin\Debug\Case05_12.pdb
?????文件??????11608??2013-07-09?15:14??C#連接局域網sql數據庫\Case05_12\bin\Debug\Case05_12.vshost.exe
?????文件????????490??2010-03-17?22:39??C#連接局域網sql數據庫\Case05_12\bin\Debug\Case05_12.vshost.exe.manifest
?????文件???????4083??2013-07-09?11:43??C#連接局域網sql數據庫\Case05_12\Case05_12.csproj
?????文件???????1610??2013-07-09?15:13??C#連接局域網sql數據庫\Case05_12\Form1.cs
?????文件???????5004??2008-06-11?21:27??C#連接局域網sql數據庫\Case05_12\Form1.Designer.cs
?????文件???????5814??2008-06-11?21:27??C#連接局域網sql數據庫\Case05_12\Form1.resx
?????文件????????609??2013-07-09?15:14??C#連接局域網sql數據庫\Case05_12\obj\Debug\Case05_12.csproj.FileListAbsolute.txt
?????文件???????9728??2013-07-09?15:14??C#連接局域網sql數據庫\Case05_12\obj\Debug\Case05_12.exe
?????文件????????180??2013-07-09?15:14??C#連接局域網sql數據庫\Case05_12\obj\Debug\Case05_12.Form1.resources
?????文件??????24064??2013-07-09?15:14??C#連接局域網sql數據庫\Case05_12\obj\Debug\Case05_12.pdb
?????文件????????180??2013-07-09?15:14??C#連接局域網sql數據庫\Case05_12\obj\Debug\Case05_12.Properties.Resources.resources
?????文件???????6121??2013-07-09?15:14??C#連接局域網sql數據庫\Case05_12\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件???????4608??2013-07-09?11:43??C#連接局域網sql數據庫\Case05_12\obj\Debug\TempPE\Properties.Resources.Designer.cs.dll
?????文件????????527??2011-01-02?19:42??C#連接局域網sql數據庫\Case05_12\Program.cs
?????文件???????1374??2008-06-11?21:14??C#連接局域網sql數據庫\Case05_12\Properties\AssemblyInfo.cs
?????文件???????2856??2013-07-09?11:43??C#連接局域網sql數據庫\Case05_12\Properties\Resources.Designer.cs
............此處省略28個文件信息
評論
共有 條評論