91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 69KB
    文件類型: .rar
    金幣: 2
    下載: 0 次
    發布日期: 2021-05-19
  • 語言: C#
  • 標簽: c#??sql??winform??

資源簡介

基于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個文件信息

評論

共有 條評論