-
大小: 397KB文件類(lèi)型: .rar金幣: 2下載: 0 次發(fā)布日期: 2021-05-29
- 語(yǔ)言: C#
- 標(biāo)簽: c#??用戶(hù)登錄??數(shù)據(jù)庫(kù)??
資源簡(jiǎn)介
當(dāng)時(shí)隨手做的一個(gè)小程序 ,C#連接sql 2000數(shù)據(jù)庫(kù)的用戶(hù)登錄。

代碼片段和文件信息
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?登錄測(cè)試
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1()
????????{
????????????InitializeComponent();
???????????
????????}
????????private?void?button2_Click(object?sender?EventArgs?e)
????????{
?????????????this.Close();
????????}
????????private?void?button1_Click(object?sender?EventArgs?e)
????????{
????????????//int?k;
????????????string?CString?=?“?Data?Source=PC-346121294017\\SQL;Initial?Catalog=53;Integrated?Security=True;“;
????????????string?sql?=?“select?top?1?*?from?用戶(hù)登錄?where?用戶(hù)名=‘“+comboBox1.Text?.Trim?()+“‘a(chǎn)nd?密碼=‘“+textBox1?.Text?.Trim?()+“‘“;
????????????SqlConnection?Mycon?=?new?SqlConnection(CString);
????????????Mycon.Open();
????????????SqlCommand?Mycom?=?new?SqlCommand(sql?Mycon);
????????????//Mycom.Connection?=?Mycon;
????????????//Mycom.CommandType?=?CommandType.Text;
????????????//Mycom.CommandText?=?sql;
???????????//?k?=?Mycom.ExecuteNonQuery();
????????????SqlDataReader?dr?=?Mycom?.ExecuteReader?();
????????????
????????????if?(dr.Read())
????????????{?
????????????????button2.Enabled?=?true;?
????????????}
????????????else
????????????{
????????????????MessageBox.Show(“密碼錯(cuò)誤“?“提示“);?
????????????}
????????????Mycon.Close();
???????????
????????????
????????????
????????}
????????private?void?comboBox1_SelectedIndexChanged(object?sender?EventArgs?e)
????????{
????????????
????????}
????????private?void?Form1_Load(object?sender?EventArgs?e)
????????{
????????????button2.Enabled?=?false;
????????????int?k;
????????????string?CString?=?“?Data?Source=PC-346121294017\\SQL;Initial?Catalog=53;Integrated?Security=True;“;
????????????string?SQLStr?=?“select?用戶(hù)名?from?用戶(hù)登錄“;
????????????SqlConnection?Mycon?=?new?SqlConnection(CString);
????????????Mycon.Open();
????????????SqlCommand?Mycom?=?new?SqlCommand();
????????????Mycom.Connection?=?Mycon;
????????????Mycom.CommandType?=?CommandType.Text;
????????????Mycom.CommandText?=?SQLStr;
????????????k?=?Mycom.ExecuteNonQuery();
????????????SqlDataAdapter?adp?=?new?SqlDataAdapter(SQLStr?Mycon);
????????????DataSet?ds?=?new?DataSet();
????????????adp.Fill(ds);
????????????comboBox1.DataSource?=?ds.Tables[0].DefaultView;
????????????comboBox1.DisplayMember?=?“用戶(hù)名“;
????????????comboBox1.ValueMember?=?“用戶(hù)名“;
????????????comboBox2.DataSource?=?ds.Tables[0].DefaultView;
????????????comboBox2.DisplayMember?=?“用戶(hù)名“;
????????????comboBox2.ValueMember?=?“用戶(hù)名“;
????????????Mycon.Close();
????????????
????????}
????????private?void?button3_Click(object?sender?EventArgs?e)
????????{
????????????int?k1;
????????????string?CString?=?“?Data?Source=PC-346121294017\\SQL;Initial?Catalog=53;Integrated?Security=True;“;
????????????string?sqlstr?=?“insert?into?用戶(hù)登錄(用戶(hù)名密碼)?val
?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----
?????文件???????1504??2012-12-17?09:57??登錄測(cè)試\登錄測(cè)試\bin\Debug\登錄測(cè)試.application
?????文件??????28672??2012-12-17?09:57??登錄測(cè)試\登錄測(cè)試\bin\Debug\登錄測(cè)試.exe
?????文件???????2150??2012-12-17?09:57??登錄測(cè)試\登錄測(cè)試\bin\Debug\登錄測(cè)試.exe.manifest
?????文件??????34304??2012-12-17?09:57??登錄測(cè)試\登錄測(cè)試\bin\Debug\登錄測(cè)試.pdb
?????文件?????423936??2012-12-13?11:08??登錄測(cè)試\登錄測(cè)試\bin\Debug\登錄測(cè)試.publish\setup.exe
?????文件???????5305??2012-12-13?11:08??登錄測(cè)試\登錄測(cè)試\bin\Debug\登錄測(cè)試.publish\登錄測(cè)試.application
?????文件??????24576??2012-12-13?11:08??登錄測(cè)試\登錄測(cè)試\bin\Debug\登錄測(cè)試.publish\登錄測(cè)試_1_0_0_0\登錄測(cè)試.exe.deploy
?????文件???????5894??2012-12-13?11:08??登錄測(cè)試\登錄測(cè)試\bin\Debug\登錄測(cè)試.publish\登錄測(cè)試_1_0_0_0\登錄測(cè)試.exe.manifest
?????文件???????1504??2012-12-17?09:57??登錄測(cè)試\登錄測(cè)試\bin\Debug\登錄測(cè)試.vshost.application
?????文件???????5632??2005-12-08?14:51??登錄測(cè)試\登錄測(cè)試\bin\Debug\登錄測(cè)試.vshost.exe
?????文件???????2150??2012-12-17?09:57??登錄測(cè)試\登錄測(cè)試\bin\Debug\登錄測(cè)試.vshost.exe.manifest
?????文件???????7329??2012-12-17?09:57??登錄測(cè)試\登錄測(cè)試\Form1.cs
?????文件??????19240??2012-12-17?09:51??登錄測(cè)試\登錄測(cè)試\Form1.Designer.cs
?????文件???????5814??2012-12-17?09:51??登錄測(cè)試\登錄測(cè)試\Form1.resx
?????文件???????1504??2012-12-17?09:57??登錄測(cè)試\登錄測(cè)試\obj\Debug\登錄測(cè)試.application
?????文件????????842??2012-12-17?09:51??登錄測(cè)試\登錄測(cè)試\obj\Debug\登錄測(cè)試.csproj.GenerateResource.Cache
?????文件??????28672??2012-12-17?09:57??登錄測(cè)試\登錄測(cè)試\obj\Debug\登錄測(cè)試.exe
?????文件???????2150??2012-12-17?09:57??登錄測(cè)試\登錄測(cè)試\obj\Debug\登錄測(cè)試.exe.manifest
?????文件????????180??2012-12-17?09:51??登錄測(cè)試\登錄測(cè)試\obj\Debug\登錄測(cè)試.Form1.resources
?????文件??????34304??2012-12-17?09:57??登錄測(cè)試\登錄測(cè)試\obj\Debug\登錄測(cè)試.pdb
?????文件????????180??2012-12-11?15:49??登錄測(cè)試\登錄測(cè)試\obj\Debug\登錄測(cè)試.Properties.Resources.resources
?????文件????????449??2013-02-26?11:33??登錄測(cè)試\登錄測(cè)試\obj\登錄測(cè)試.csproj.FileList.txt
?????文件????????471??2012-12-11?15:46??登錄測(cè)試\登錄測(cè)試\Program.cs
?????文件???????1224??2012-12-11?15:46??登錄測(cè)試\登錄測(cè)試\Properties\AssemblyInfo.cs
?????文件???????2878??2012-12-11?15:46??登錄測(cè)試\登錄測(cè)試\Properties\Resources.Designer.cs
?????文件???????5612??2012-12-11?15:46??登錄測(cè)試\登錄測(cè)試\Properties\Resources.resx
?????文件???????1095??2012-12-11?15:46??登錄測(cè)試\登錄測(cè)試\Properties\Settings.Designer.cs
?????文件????????249??2012-12-11?15:46??登錄測(cè)試\登錄測(cè)試\Properties\Settings.settings
?????文件?????423936??2012-12-13?11:08??登錄測(cè)試\登錄測(cè)試\publish\setup.exe
?????文件???????5305??2012-12-13?11:08??登錄測(cè)試\登錄測(cè)試\publish\登錄測(cè)試.application
............此處省略23個(gè)文件信息
評(píng)論
共有 條評(píng)論