老师的小作业,一个登入和主界面

最新推荐文章于 2025-04-17 11:36:50 发布

SammyOnce

最新推荐文章于 2025-04-17 11:36:50 发布

阅读量1k

点赞数

CC 4.0 BY-SA版权

文章标签：作业 dataset datagrid null textbox imagelist

本文链接：https://blog.youkuaiyun.com/xzhai2007/article/details/1636988

本文介绍了一个使用C#编写的简单登录窗体的设计与实现过程。登录窗体包括用户名和密码输入框、两个按钮及相应的标签。文章还涉及了基本的数据库连接操作和简单的验证逻辑。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

LoginForm.cs

using System;

using System.Drawing;

using System.Collections;

using System.ComponentModel;

using System.Windows.Forms;

using System.Data;

using System.Data .SqlClient ;

namespace WindowsApplication2

{

/// <summary>

/// Form1 的摘要说明。

/// </summary>

public class Form1 : System.Windows.Forms.Form

{

private System.Windows.Forms.Button button1;

private System.Windows.Forms.Button button2;

private System.Windows.Forms.TextBox textBox1;

private System.Windows.Forms.TextBox textBox2;

private System.Windows.Forms.Label label1;

private System.Windows.Forms.Label label2;

private System.Data.SqlClient.SqlConnection sqlConnection1;

private System.Data.SqlClient.SqlCommand sqlCommand1;

/// <summary>

/// 必需的设计器变量。

/// </summary>

private System.ComponentModel.Container components = null;

public Form1()

{

// Windows 窗体设计器支持所必需的

InitializeComponent();

// TODO: 在 InitializeComponent 调用后添加任何构造函数代码

}

/// <summary>

/// 清理所有正在使用的资源。

/// </summary>

static void Main()

{

Form1 f=new Form1();

f.ShowDialog();

if(Form1.ShowForm==true)

{

Application.Run(new MainForm());

}

protected override void Dispose( bool disposing )

{

if( disposing )

{

if (components != null)

{

components.Dispose();

}

base.Dispose( disposing );

}

Windows 窗体设计器生成的代码#region Windows 窗体设计器生成的代码

/// <summary>

/// 设计器支持所需的方法 - 不要使用代码编辑器修改

/// 此方法的内容。

/// </summary>

private void InitializeComponent()

{

System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(Form1));

this.button1 = new System.Windows.Forms.Button();

this.button2 = new System.Windows.Forms.Button();

this.textBox1 = new System.Windows.Forms.TextBox();

this.textBox2 = new System.Windows.Forms.TextBox();

this.label1 = new System.Windows.Forms.Label();

this.label2 = new System.Windows.Forms.Label();

this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();

this.sqlCommand1 = new System.Data.SqlClient.SqlCommand();

this.SuspendLayout();

// button1

this.button1.Location = new System.Drawing.Point(32, 176);

this.button1.Name = "button1";

this.button1.TabIndex = 0;

this.button1.Text = "登入";

this.button1.Click += new System.EventHandler(this.button1_Click);

// button2

this.button2.Location = new System.Drawing.Point(128, 176);

this.button2.Name = "button2";

this.button2.TabIndex = 1;

this.button2.Text = "取消";

// textBox1

this.textBox1.Location = new System.Drawing.Point(104, 56);

this.textBox1.Name = "textBox1";

this.textBox1.TabIndex = 2;

this.textBox1.Text = "";

// textBox2

this.textBox2.Location = new System.Drawing.Point(104, 120);

this.textBox2.Name = "textBox2";

this.textBox2.PasswordChar = '*';

this.textBox2.TabIndex = 3;

this.textBox2.Text = "";

// label1

this.label1.Location = new System.Drawing.Point(16, 56);

this.label1.Name = "label1";

this.label1.Size = new System.Drawing.Size(56, 23);

this.label1.TabIndex = 4;

this.label1.Text = "用户名：";

// label2

this.label2.Location = new System.Drawing.Point(16, 120);

this.label2.Name = "label2";

this.label2.Size = new System.Drawing.Size(64, 16);

this.label2.TabIndex = 5;

this.label2.Text = "密码：";

// sqlConnection1

this.sqlConnection1.ConnectionString = "workstation id="W3-34";packet size=4096;user id=sa;data source="(local)";persist " +

"security info=False;initial catalog=DB";

// Form1

this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);

this.ClientSize = new System.Drawing.Size(240, 229);

this.Controls.Add(this.label2);

this.Controls.Add(this.label1);

this.Controls.Add(this.textBox2);

this.Controls.Add(this.textBox1);

this.Controls.Add(this.button2);

this.Controls.Add(this.button1);

this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));

this.Name = "Form1";

this.Text = "LoginForm";

this.Load += new System.EventHandler(this.Form1_Load);

this.ResumeLayout(false);

}

#endregion

public static bool ShowForm=false;

/// <summary>

/// 应用程序的主入口点。

/// </summary>

[STAThread]

private void button1_Click(object sender, System.EventArgs e)

{

if (this.textBox1 .Text.ToString () =="" |this.textBox2 .Text.ToString () =="")

{

MessageBox.Show ("请把您的帐号和密码输入完整！");

}

else

{

try

{

sqlCommand1=new SqlCommand ();

sqlCommand1.Connection =sqlConnection1;

this.sqlCommand1.CommandText="SELECT PWD FROM usertable WHERE userid='"+this.textBox1 .Text .ToString ().Trim ()+"'";

this.sqlConnection1 .Open ();

SqlDataReader

reader= sqlCommand1.ExecuteReader ();

reader.Read ();

string textpwd=reader.GetString (0);

if (this.textBox2 .Text .ToString ().Trim ()==textpwd.Trim ())

{

ShowForm=true;

this.Close ();

}

else

{

MessageBox.Show ("密码输入错误！");

ShowForm=false;

}

catch(System.Exception)

{

MessageBox.Show ("没有该用户", "错误",MessageBoxButtons.OK ,MessageBoxIcon.Error );

}

this.sqlConnection1 .Close ();

}

private void Form1_Load(object sender, System.EventArgs e)

{

}

Mainform .cs

using System;

using System.Drawing;

using System.Collections;

using System.ComponentModel;

using System.Windows.Forms;

using System.Data;

namespace 图书管理

{

/// <summary>

/// Form1 的摘要说明。

/// </summary>

public class Form1 : System.Windows.Forms.Form

{

private System.ComponentModel.IContainer components;

private System.Windows.Forms.ToolBar toolBar1;

private System.Windows.Forms.ToolBarButton tBtnFirst;

private System.Windows.Forms.ToolBarButton tBtnPre;

private System.Windows.Forms.ToolBarButton tBtnNext;

private System.Windows.Forms.ToolBarButton tBtnLast;

private System.Windows.Forms.ToolBarButton tBtnNew;

private System.Windows.Forms.ToolBarButton tBtnEdit;

private System.Windows.Forms.ToolBarButton tBtnDelete;

private System.Windows.Forms.ToolBarButton tBtnSubmit;

private System.Windows.Forms.ToolBarButton tBtnCancel;

private System.Windows.Forms.ToolBarButton tBtnQuit;

private System.Windows.Forms.Button btnSearch;

private System.Windows.Forms.TextBox txt1;

private System.Windows.Forms.Label label2;

private System.Windows.Forms.DataGrid dataGrid1;

private System.Windows.Forms.Label label1;

private System.Windows.Forms.Label label3;

private System.Windows.Forms.Label label4;

private System.Windows.Forms.Label label5;

private System.Windows.Forms.TextBox txt2;

private System.Windows.Forms.TextBox txt3;

private System.Windows.Forms.TextBox txt4;

private System.Windows.Forms.TextBox txt5;

private System.Windows.Forms.GroupBox groupBox3;

private System.Windows.Forms.CheckBox checkBox1;

private System.Windows.Forms.CheckBox checkBox2;

private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;

private System.Data.SqlClient.SqlConnection sqlConnection1;

private System.Data.SqlClient.SqlCommand sqlSelectCommand1;

private System.Data.SqlClient.SqlCommand sqlInsertCommand1;

private System.Data.SqlClient.SqlCommand sqlUpdateCommand1;

private System.Data.SqlClient.SqlCommand sqlDeleteCommand1;

private 图书管理.DataSet1 dataSet11;

private System.Windows.Forms.ImageList imageList1;

private CurrencyManager cmOrders;//数据导航

public string EditOrAdd="";

public Form1()

{

// Windows 窗体设计器支持所必需的

InitializeComponent();

// TODO: 在 InitializeComponent 调用后添加任何构造函数代码

}

/// <summary>

/// 清理所有正在使用的资源。

/// </summary>

protected override void Dispose( bool disposing )

{

if( disposing )

{

if (components != null)

{

components.Dispose();

}

base.Dispose( disposing );

}

Windows 窗体设计器生成的代码

/// <summary>

/// 应用程序的主入口点。

/// </summary>

[STAThread]

static void Main()

{

Application.Run(new Form1());

}

//--------------创建窗体时读入全部数据--------------

private void Form1_Load(object sender, System.EventArgs e)

{

this.sqlDataAdapter1.SelectCommand.Parameters[0].Value="%%";

this.sqlConnection1.Open();

this.sqlDataAdapter1.Fill(dataSet11);

this.sqlConnection1.Close();

//为数据集添加数据项浏览控制

cmOrders=(CurrencyManager) BindingContext[dataSet11,"读者类型"];

}

private void toolBar1_ButtonClick(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e)

{

if (e.Button.ToolTipText == "首记录")

{

this.dataGrid1.UnSelect(cmOrders.Position); //取消原选中的行

cmOrders.Position = 0;

this.dataGrid1.Select(cmOrders.Position); //选中当前行

this.dataGrid1.CurrentRowIndex = cmOrders.Position; //移动表头指示图标

return;

}

if (e.Button.ToolTipText == "上一记录")

{

if (cmOrders.Position >= 0)

{

this.dataGrid1.UnSelect(cmOrders.Position);

cmOrders.Position--;

this.dataGrid1.Select(cmOrders.Position);

this.dataGrid1.CurrentRowIndex = cmOrders.Position;

}

return;

}

if (e.Button.ToolTipText == "下一记录")

{

if (cmOrders.Position <= cmOrders.Count-1)

{

this.dataGrid1.UnSelect(cmOrders.Position);

cmOrders.Position++;

this.dataGrid1.Select(cmOrders.Position);

this.dataGrid1.CurrentRowIndex = cmOrders.Position;

}

return;

}

if (e.Button.ToolTipText == "尾记录")

{

this.dataGrid1.UnSelect(cmOrders.Position);

cmOrders.Position = cmOrders.Count-1;

this.dataGrid1.Select(cmOrders.Position);

this.dataGrid1.CurrentRowIndex = cmOrders.Position;

return;

}

if(e.Button.ToolTipText=="新增")

{

EditOrAdd="add";

SetModifyMode(true);

//设置默认值

txt3.Text="1";

txt4.Text="1";

txt5.Text="1";

}

if(e.Button.ToolTipText=="修改")

{

EditOrAdd="edit";

this.txt2.Text=this.dataSet11.Tables[0].Rows[this.dataGrid1.CurrentRowIndex][0].ToString().Trim();

this.txt3.Text=this.dataSet11.Tables[0].Rows[this.dataGrid1.CurrentRowIndex][1].ToString().Trim();

this.txt4.Text=this.dataSet11.Tables[0].Rows[this.dataGrid1.CurrentRowIndex][2].ToString().Trim();

this.txt5.Text=this.dataSet11.Tables[0].Rows[this.dataGrid1.CurrentRowIndex][3].ToString().Trim();

if(this.dataSet11.Tables[0].Rows[this.dataGrid1.CurrentRowIndex][4].ToString().Trim()=="True")

{

this.checkBox1.Checked=true;

}

if(this.dataSet11.Tables[0].Rows[this.dataGrid1.CurrentRowIndex][5].ToString().Trim()=="True")

{

this.checkBox2.Checked=true;

}

SetModifyMode(true);

}

if(e.Button.ToolTipText=="删除")

{

DialogResult result=MessageBox.Show("确认删除？","删除数据",MessageBoxButtons.OKCancel);

if(result==DialogResult.OK)

if(cmOrders.Count>0)//立即从数据集中删除

{

cmOrders.RemoveAt(cmOrders.Position);

this.sqlDataAdapter1.Update(dataSet11);

}

else

MessageBox.Show("表中为空，已无可删除数据","提示",MessageBoxButtons.OK,MessageBoxIcon.Error);

// if(MessageBox.Show("删除的行不可恢复，你确定要删除吗？","警告",MessageBoxButtons.YesNo,MessageBoxIcon.Warning)==DialogResult.Yes)

// {

// int ReCount=this.dataSet11.Tables["读者类型"].Rows.Count;

// for(int i=0;i<ReCount;i++)

// {

// if(this.dataGrid1.IsSelected(i))

// {

// this.dataSet11.Tables["读者类型"].Rows[i]["类型"]="*";

// }

// DataRow[] findRows=this.dataSet11.Tables["读者类型"].Select("类型='*'");

// for(int i=0;i<findRows.Length;i++)

// {

// findRows[i].Delete();

// this.sqlDataAdapter1.Update(this.dataSet11,"读者类型");

// }

// this.dataSet11.Tables["读者类型"].AcceptChanges();

// }

}

if(e.Button.ToolTipText=="提交")

{

if(EditOrAdd=="add")

{

if(txt2.Text.Trim()=="")//检查非空字段

{

MessageBox.Show("类型名称不能为空","提示",MessageBoxButtons.OK,MessageBoxIcon.Error);

return;

}

DataRow newRow=this.dataSet11.Tables[0].NewRow();

newRow[0]=this.txt2.Text.ToString().Trim();

newRow[1]=this.txt3.Text.ToString().Trim();

newRow[2]=this.txt4.Text.ToString().Trim();

newRow[3]=this.txt5.Text.ToString().Trim();

if(this.checkBox1.Checked)

{

newRow[4]=1;

}

if(this.checkBox2.Checked)

{

newRow[5]=1;

}

this.dataSet11.Tables[0].Rows.Add(newRow);

//MessageBox.Show(this.dataSet11.Tables[0].Rows.Count.ToString());

if(dataSet11.GetChanges()!=null)

{

try

{

this.sqlDataAdapter1.Update(dataSet11);

SetModifyMode(false);

}

catch(Exception express)

{

MessageBox.Show(express.ToString(),"提示",MessageBoxButtons.OK,MessageBoxIcon.Error);

dataSet11.RejectChanges();

}

else if(EditOrAdd=="edit")

{

}

EditOrAdd="";

return;

}

if (e.Button.ToolTipText == "取消")

{

try

{

cmOrders.CancelCurrentEdit(); //取消编辑

SetModifyMode(false);

}

catch(Exception express)

{

MessageBox.Show(express.ToString(),"提示",MessageBoxButtons.OK,MessageBoxIcon.Error);

}

return;

}

if(e.Button.ToolTipText=="退出")

{

this.Close();

}

private void btnSearch_Click(object sender, System.EventArgs e)

{

this.sqlDataAdapter1.SelectCommand.Parameters[0].Value="%%";

if(txt1.Text.Trim()!="")

{

this.sqlDataAdapter1.SelectCommand.Parameters[0].Value="%"+txt1.Text.Trim()+"%";

}

//清空数据表，并根据新设置的查询参数重新填充

dataSet11.读者类型.Clear();

this.sqlDataAdapter1.Fill(dataSet11);

}

private void SetModifyMode(bool blnEdit)

{

//设置文本框和下拉列表框属性

txt1.ReadOnly=!blnEdit;

txt2.ReadOnly=!blnEdit;

txt3.ReadOnly=!blnEdit;

txt4.ReadOnly=!blnEdit;

txt5.ReadOnly=!blnEdit;

//设置搜索按钮属性

btnSearch.Enabled=!blnEdit;

}

private void dataGrid1_Navigate(object sender, System.Windows.Forms.NavigateEventArgs ne)

{

}