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

資源簡(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)論

相關(guān)資源