資源簡介
基于vb進行數據庫的增刪改查操作
sql語句
c#

代碼片段和文件信息
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;
using?System.Data.SqlClient;
namespace?zz
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1()
????????{
????????????InitializeComponent();
????????}
????????private?void?button1_Click(object?sender?EventArgs?e)
????????{
????????????Form1_Load(sender?e);
????????}
????????private?void?Form1_Load(object?sender?EventArgs?e)
????????{
????????????try
????????????{
????????????????SqlConnection?conn?=?new?SqlConnection();
????????????????conn.ConnectionString?=?“server=.;database=student;uid=sa;pwd=qwe123!“;
????????????????conn.Open();
????????????????SqlCommand?cmd?=?new?SqlCommand();
????????????????cmd.CommandText?=?“select?*?from?基本信息表“;
????????????????cmd.Connection?=?conn;
????????????????SqlDataAdapter?sda?=?new?SqlDataAdapter(cmd);
????????????????DataSet?ds?=?new?DataSet();
????????????????sda.Fill(ds?“基本信息表“);
????????????????this.dataGridView1.DataSource?=?ds;
????????????????this.dataGridView1.DataMember?=?“基本信息表“;
????????????????this.dataGridView1.AutoGenerateColumns?=?true;
????????????????for?(int?i?=?1;?i?????????????????{
????????????????????this.dataGridView1.Columns[i].DefaultCellstyle.SelectionBackColor?=?Color.White;
????????????????????this.dataGridView1.Columns[i].DefaultCellstyle.SelectionBackColor?=?Color.Black;
????????????????????this.dataGridView1.Columns[i].ReadOnly?=?true;
????????????????}
????????????????conn.Close();
????????????}
????????????catch?(Exception?ee)
????????????{
????????????????MessageBox.Show(“錯誤:“?+?ee.Message?“錯誤“);
????????????}
????????}
????????private?void?button2_Click(object?sender?EventArgs?e)
????????{
????????????if?(this.dataGridView1.SelectedCells?==?null)
????????????{
????????????????MessageBox.Show(“請選擇要刪除的項!“?“錯誤“?MessageBoxButtons.OK?MessageBoxIcon.Error);
????????????}
????????????else
????????????{
????????????????if?(this.dataGridView1.CurrentCell.ColumnIndex?==?0)
????????????????{
????????????????????string?st?=?this.dataGridView1[1?this.dataGridView1.CurrentCell.RowIndex].Value.ToString();
????????????????????SqlConnection?conn?=?new?SqlConnection();
????????????????????conn.ConnectionString?=?“server=.;database=student;uid=sa;pwd=qwe123!“;
????????????????????conn.Open();
????????????????????SqlCommand?cmd?=?new?SqlCommand();
????????????????????cmd.CommandText?=?“delete?from?基本信息表?where?姓名=‘“?+?st?+?“‘“;
????????????????????cmd.Connection?=?conn;
????????????????????cmd.ExecuteNonQuery();
????????????????????conn.Close();
????????????????}
????????????}
????????}
????????private?void?dataGridView1_CellContentClick(object?sender?DataGridViewCellEventArgs?e)
????????{
????????}
????????private?void?button5_Click(object?sender?EventArgs
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件??????20480??2014-08-07?10:53??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\bin\Debug\zz.exe
?????文件??????42496??2014-08-07?10:53??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\bin\Debug\zz.pdb
?????文件??????11600??2014-08-07?10:53??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\bin\Debug\zz.vshost.exe
?????文件????????490??2012-06-06?02:06??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\bin\Debug\zz.vshost.exe.manifest
?????文件???????4521??2014-08-05?15:51??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\Form1.cs
?????文件???????6620??2014-08-01?16:09??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\Form1.Designer.cs
?????文件???????5817??2014-08-01?16:09??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\Form1.resx
?????文件???????4038??2014-08-04?14:21??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\Form2.cs
?????文件???????7816??2014-08-04?14:21??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\Form2.Designer.cs
?????文件???????5817??2014-08-04?14:21??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\Form2.resx
?????文件???????3676??2014-08-04?14:18??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\Form3.cs
?????文件???????7607??2014-08-04?14:18??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\Form3.Designer.cs
?????文件???????5817??2014-08-04?14:18??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\Form3.resx
?????文件???????5420??2014-07-30?13:57??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\obj\x86\Debug\DesignTimeResolveAssemblyReferences.cache
?????文件???????6281??2014-08-07?10:53??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件????????644??2014-08-07?10:53??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\obj\x86\Debug\zz.csproj.FileListAbsolute.txt
?????文件???????1091??2014-08-04?14:21??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\obj\x86\Debug\zz.csproj.GenerateResource.Cache
?????文件???????9214??2014-08-04?10:32??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\obj\x86\Debug\zz.csprojResolveAssemblyReference.cache
?????文件??????20480??2014-08-07?10:53??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\obj\x86\Debug\zz.exe
?????文件????????180??2014-08-04?11:41??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\obj\x86\Debug\zz.Form1.resources
?????文件????????180??2014-08-04?14:21??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\obj\x86\Debug\zz.Form2.resources
?????文件????????180??2014-08-04?14:18??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\obj\x86\Debug\zz.Form3.resources
?????文件??????42496??2014-08-07?10:53??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\obj\x86\Debug\zz.pdb
?????文件????????180??2014-08-04?11:41??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\obj\x86\Debug\zz.Properties.Resources.resources
?????文件????????483??2014-07-30?11:55??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\Program.cs
?????文件???????1336??2014-07-30?11:55??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\Properties\AssemblyInfo.cs
?????文件???????2856??2014-07-30?11:55??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\Properties\Resources.Designer.cs
?????文件???????5612??2014-07-30?11:55??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\Properties\Resources.resx
?????文件???????1089??2014-07-30?11:55??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\Properties\Settings.Designer.cs
?????文件????????249??2014-07-30?11:55??C#窗體程序對數據庫的增刪改查操作(三層架構)\zz\Properties\Settings.settings
............此處省略16個文件信息
- 上一篇:wpf 觸屏虛擬鍵盤支持中英文切換
- 下一篇:RosAPI C#
評論
共有 條評論