欧美bbbwbbbw肥妇,免费乱码人妻系列日韩,一级黄片

C#實現(xiàn)學員信息管理系統(tǒng)

 更新時間：2019年06月12日 08:34:02   作者：zxh...  
這篇文章主要為大家詳細介紹了C#實現(xiàn)學員信息管理系統(tǒng)，具有一定的參考價值，感興趣的小伙伴們可以參考一下

新手寫一段學員信息管理系統(tǒng)，有代碼冗余的情況請諒解，代碼如下，請大神指點

//登陸入口頁面
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace 學員管理系統(tǒng)
{
 public partial class Lo : Form
 {
 public Lo()
 {
  InitializeComponent();
 }
  string sql= "Data Source=LAPTOP-PCMBBB0N;Initial Catalog=DB_Student;Trusted_Connection=true;";
  private void Log_Load(object sender, EventArgs e)
 {
  this.FormBorderStyle = FormBorderStyle.FixedToolWindow;
  this.Location = new Point(Screen.PrimaryScreen.Bounds.Width / 2 - this.Width / 2, Screen.PrimaryScreen.Bounds.Height / 2 - this.Height / 2);
 }
 Main main;
  private void button1_Click(object sender, EventArgs e)
 {
  try
  {
  string pwd =txtpwd.Text;
  if (pwd.ToString() == "")
  {
   label2.Visible = true;
   label2.Text = "密碼不能為空！";
  }
  else
  {
   if (pwd.Equals((table.Rows[0]["Pwd"]).ToString()))
   {
   label2.Visible = false;
   main = new Main();
   main.Show();
   this.Visible = false;
   }
   else
   {
   label2.Text = "密碼不正確！";
   label2.Visible = true;
   }
  }
  }
  catch (Exception)
  {
  throw;
  }
 }
 DataTable table = new DataTable();
 private void txtid_Leave(object sender, EventArgs e)
 {
  try
  {
  int id = int.Parse(txtid.Text);
   //1.鏈接數(shù)據(jù)庫對象
   SqlConnection sqlcon = new SqlConnection(sql);
  //3.創(chuàng)建數(shù)據(jù)庫命令對象
  SqlCommand cmd = new SqlCommand();
  cmd.Connection = sqlcon;
   cmd.CommandText = "SELECT * FROM Student WHERE ID=" + id;
   //5.數(shù)據(jù)適配器對象
  SqlDataAdapter sda = new SqlDataAdapter();
  sda.SelectCommand = cmd;
  //6.這個table可以用來接受適配的最終結果
  sda.Fill(table);
   if (table.Rows.Count > 0)
  {
   label1.Visible = false;
  }
  else
  {
   label1.Visible = true;
   label1.Text = "輸入ID不存在！";
  }
  }
  catch (Exception)
  {
  
  label1.Visible = true;
  label1.Text = "請輸入純數(shù)字ID！";
  txtid.Focus();
  txtid.Text = "";
  }
 }
 private void button2_Click_1(object sender, EventArgs e)
 {
  Register register = new Register();
  register.ShowDialog();
  this.Visible = true;
  label1.Visible = false;
 }
 }
}


//注冊頁面
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace 學員管理系統(tǒng)
{
 public partial class Register : Form
 {
 public Register()
 {
  InitializeComponent();
 }
 string sql = "Data Source=LAPTOP-PCMBBB0N;Initial Catalog=DB_Student;Trusted_Connection=true;";
  private void button1_Click(object sender, EventArgs e)
 {
  try
  {
  SqlConnection sqlCon = new SqlConnection(sql);
  string sqltxt = string.Format("INSERT INTO Student VALUES('{0}','{1}','{2}','{3}','{4}')", textBox2.Text, textBox1.Text, textBox3.Text, textBox4.Text, textBox5.Text);
  SqlCommand cmd = new SqlCommand(sqltxt, sqlCon);
  sqlCon.Open();
  int res = cmd.ExecuteNonQuery();
  if (res > 0)
  {
   MessageBox.Show("注冊成功");
   textBox1.Text = "";
   textBox2.Text = "";
   textBox3.Text = "";
   textBox4.Text = "";
   textBox5.Text = "";
   textBox1.Focus();
  }
  }
  catch (Exception)
  {
  throw;
  }
 }

     

//信息頁面（可以進行數(shù)據(jù)庫信息更改，刪除，查看 以及翻頁操作）
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace 學員管理系統(tǒng)
{
 public partial class Main : Form
 {
 public Main()
 {
  InitializeComponent();
 } 
  string strcon = "Data Source=LAPTOP-PCMBBB0N;Initial Catalog=DB_Student;Trusted_Connection=true;";
 int countPage;
 int nowPage = 1;
 SqlConnection sqlCon;
  private void Main_Load(object sender, EventArgs e)
 {
  sqlCon = new SqlConnection(strcon);
  //綁定頁碼信息
  try
  {
  string sql = "SELECT COUNT(*) FROM Student";
  SqlCommand cmdl = new SqlCommand(sql, sqlCon);
  sqlCon.Open();
  object res = cmdl.ExecuteScalar();
  if (res != null)
  {
   if ((int)res % 6 > 0)
   {
   countPage = ((int)res / 6) + 1;
   }
   else
   {
   countPage = (int)res / 6;
   }
  }
  }
  catch (Exception)
  {
  throw;
  }
  finally
  {
  sqlCon.Close();
  }
  //初始信息綁定
  try
  {
  SetPage(sqlCon);
  dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
  dataGridView1.RowHeadersVisible = false;
  foreach (DataGridViewColumn dc in dataGridView1.Columns)
  {
   dc.SortMode = DataGridViewColumnSortMode.Programmatic;
  }
  dataGridView1.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
  dataGridView1.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
  dataGridView1.ScrollBars = ScrollBars.None;
  dataGridView1.MultiSelect = false;
  dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
  dataGridView1.AllowUserToResizeRows = false;
  dataGridView1.AllowUserToResizeColumns = false;   
  dataGridView1.ScrollBars = ScrollBars.None;
  dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
  dataGridView1.AllowUserToAddRows = false;
  dataGridView1.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
  dataGridView1.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
  foreach (DataGridViewColumn item in dataGridView1.Columns)
  {
   item.SortMode = DataGridViewColumnSortMode.NotSortable;
  }
  dataGridView1.ReadOnly = true;
  dataGridView1.CellMouseDown += DataGridView1_CellMouseDown;
  }
  catch (Exception ex)
  {
  throw;
  }
  finally
  {
  sqlCon.Close();
  }
 }
 private void SetPage(SqlConnection sqlCon)
 {
  string sql = string.Format("SELECT ID AS '賬號',NAME AS '姓名',Sex AS '性別',Age AS '年齡',Zhanli AS '電話' FROM Student WHERE ID IN(SELECT TOP(6) ID FROM Student WHERE ID NOT IN (SELECT TOP({0}) ID FROM Student ORDER BY ID)ORDER BY ID ) ORDER BY ID", (nowPage - 1) * 6);
  SqlCommand cmd = new SqlCommand(sql, sqlCon);
  SqlDataAdapter sda = new SqlDataAdapter(cmd);
  DataSet ds = new DataSet();
  sda.Fill(ds);
  dataGridView1.DataSource = ds.Tables[0];
  label1.Text = nowPage.ToString();
  label3.Text = countPage.ToString();
 }
  private void DataGridView1_CellMouseDown(object sender, DataGridViewCellMouseEventArgs e)
 {
  if (e.Button == MouseButtons.Right && dataGridView1.SelectedRows.Count > 0)
  {
  dataGridView1.ClearSelection();
  dataGridView1.Rows[e.RowIndex].Selected = true;
  ID.Idd = (int)dataGridView1.SelectedCells[0].Value;
  contextMenuStrip1.Show();
  }
 }
 private void 刪除ToolStripMenuItem1_Click(object sender, EventArgs e)
 {
  try
  {
  SqlConnection sqlCon = new SqlConnection(strcon);
  string sqltxt = "DELETE FROM Student WHERE ID=" + ID.Idd;
  SqlCommand cmd = new SqlCommand(sqltxt, sqlCon);
  sqlCon.Open();
  int res = cmd.ExecuteNonQuery();
  if (res > 0)
  {
   MessageBox.Show("刪除成功！");
   Main ma = new 學員管理系統(tǒng).Main();
   ma.Show();
   this.Visible = false;
  }
  }
  catch (Exception)
  {
  throw;
  }
 }
 private void 修改密碼ToolStripMenuItem_Click(object sender, EventArgs e)
 {
  xiugai xiu = new xiugai();
  xiu.ShowDialog();
  this.Visible = false;
 }
 private void 查看詳細信息ToolStripMenuItem_Click(object sender, EventArgs e)
 {
  chakan cha = new chakan();
  cha.ShowDialog();
  this.Visible = false;
 }
 private void 下一頁ToolStripMenuItem_Click(object sender, EventArgs e)
 {
  
  if (nowPage >= countPage)
  {
  return;
  }
  else
  {
  nowPage++;
  SetPage(sqlCon);
  }
 }
  private void 上一頁ToolStripMenuItem_Click(object sender, EventArgs e)
 {
  if (nowPage <= 1)
  {
  return;
  }
  else
  {
  nowPage--;
  SetPage(sqlCon);
  }
 }
 }
}

/查看詳細信息
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace 學員管理系統(tǒng)
{
 public partial class chakan : Form
 {
 public chakan()
 {
  InitializeComponent();
 }
  private void button1_Click(object sender, EventArgs e)
 {
  Main ma = new 學員管理系統(tǒng).Main();
  ma.Show();
  this.Visible = false; 
 }
 string sql = "Data Source=LAPTOP-PCMBBB0N;Initial Catalog=DB_Student;Trusted_Connection=true;";
 private void chakan_Load(object sender, EventArgs e)
 {
  try
  {
  SqlConnection sqlcon = new SqlConnection(sql);
  string sqltxt = "SELECT * FROM Student WHERE ID="+ID.Idd; 
  SqlCommand cmd = new SqlCommand(sqltxt, sqlcon);
  sqlcon.Open();
  SqlDataAdapter sda = new SqlDataAdapter(cmd);
  DataTable table = new DataTable();
  sda.Fill(table);
  Name1.Text = (table.Rows[0]["NAME"]).ToString();
  ID1.Text = (table.Rows[0]["ID"]).ToString();
  Pwd.Text = (table.Rows[0]["Pwd"]).ToString();
  Sex.Text = (table.Rows[0]["Sex"]).ToString();
  Age.Text = (table.Rows[0]["Age"]).ToString();
  Zhanli.Text = (table.Rows[0]["Zhanli"]).ToString();
  }
  catch (Exception)
  {
  throw;
  }
 }
 }
}

//創(chuàng)建一個類用來存儲用戶賬號
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace 學員管理系統(tǒng)
{
 public class ID
 {
 public static int idd;
 public static int Idd
 {
  get
  {
  return idd;
  }
  set
  {
  idd = value;
  }
 }
 }
}
//修改密碼
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace 學員管理系統(tǒng)
{
 public partial class xiugai : Form
 {
 public xiugai()
 {
  InitializeComponent();
 }
 string sql = "Data Source=LAPTOP-PCMBBB0N;Initial Catalog=DB_Student;Trusted_Connection=true;";
 private void button1_Click(object sender, EventArgs e)
 {
  string yuan = textBox1.Text;
  string New = textBox2.Text;
  string New2 = textBox3.Text;
  if (yuan=="")
  {
  label4.Visible = true;
  textBox1.Focus();
  }
  else
  {
  if (New=="")
  {
   label5.Visible = true;
   textBox2.Focus();
  }
  else
  {
   if (New2==""||New2!=New)
   {
   label6.Visible = true;
   textBox3.Focus();
   }
   else
   {
   try
   {
    int num = int.Parse(yuan);
    SqlConnection sqlcon = new SqlConnection(sql);
    string sqltext = "UPDATE Student SET Pwd=" + New2 + "WHERE ID="+ID.Idd;
    //string sqltext = "UPDATE StudentInfor SET Pwd=" + New2 + "WHERE ID="+ID.Idd;
    SqlCommand cmd = new SqlCommand(sqltext,sqlcon);
    sqlcon.Open();
    int res = cmd.ExecuteNonQuery();
    if (res>0)
    {
    MessageBox.Show("修改成功");
    }
   }
   catch (Exception)
   {
    throw;
   }
   }
  }
  }
 }
 }
}

以上就是本文的全部內容，希望對大家的學習有所幫助，也希望大家多多支持腳本之家。

相關文章

  • C#仿Windows XP自帶的掃雷游戲

    C#仿Windows XP自帶的掃雷游戲

    這篇文章主要為大家詳細介紹了C#仿Windows XP自帶的掃雷游戲，文中示例代碼介紹的非常詳細，具有一定的參考價值，感興趣的小伙伴們可以參考一下
    2021-04-04
  • C#詞法分析器之轉換DFA詳解

    C#詞法分析器之轉換DFA詳解

    本篇文章介紹了，C#詞法分析器之轉換DFA詳解。需要的朋友參考下
    2013-05-05
  • Unity3D開發(fā)實戰(zhàn)之五子棋游戲

    Unity3D開發(fā)實戰(zhàn)之五子棋游戲

    這篇文章主要為大家詳細介紹了Unity3D開發(fā)實戰(zhàn)之五子棋游戲，文中示例代碼介紹的非常詳細，具有一定的參考價值，感興趣的小伙伴們可以參考一下
    2019-09-09
  • C# 提取PDF中的表格詳情

    C# 提取PDF中的表格詳情

    這篇文章主要給大家介紹C# 提取PDF中的表格，本文介紹在C#程序中（附VB.NET代碼）提取PDF中的表格的方法，調用Spire.PDF for .NET提供的提取表格的 類 以及 方法 等來獲取表格單元格中的文本內容,需要的朋友可以參考一下
    2021-10-10
  • c#高效的線程安全隊列ConcurrentQueue<T>的實現(xiàn)

    c#高效的線程安全隊列ConcurrentQueue<T>的實現(xiàn)

    這篇文章主要介紹了c#高效的線程安全隊列ConcurrentQueue<T>的實現(xiàn)，文中通過示例代碼介紹的非常詳細，對大家的學習或者工作具有一定的參考學習價值，需要的朋友們下面隨著小編來一起學習學習吧
    2020-11-11
  • Visual Studio 2019 清理空行問題（非正則表達式）

    Visual Studio 2019 清理空行問題（非正則表達式）

    這篇文章主要介紹了Visual Studio 2019 清理空行問題（非正則表達式）,本文通過實例截圖給大家介紹的非常詳細，對大家的學習或工作具有一定的參考借鑒價值，需要的朋友可以參考下
    2020-04-04
  • C#使用Monitor類實現(xiàn)線程同步

    C#使用Monitor類實現(xiàn)線程同步

    這篇文章介紹了C#使用Monitor類實現(xiàn)線程同步的方法，文中通過示例代碼介紹的非常詳細。對大家的學習或工作具有一定的參考借鑒價值，需要的朋友可以參考下
    2022-04-04
  • C# winfrom實現(xiàn)讀取修改xml

    C# winfrom實現(xiàn)讀取修改xml

    這篇文章主要為大家詳細介紹了C# winfrom實現(xiàn)讀取修改xml的相關資料，具有一定的參考價值，感興趣的小伙伴們可以參考一下
    2016-05-05
  • C#實現(xiàn)簡單的3DES加密解密功能示例

    C#實現(xiàn)簡單的3DES加密解密功能示例

    這篇文章主要介紹了C#實現(xiàn)簡單的3DES加密解密功能,結合實例形式分析了C#實現(xiàn)3DES加密解密的定義、使用等具體步驟與相關操作技巧,需要的朋友可以參考下
    2017-08-08
  • 解決C# 截取當前程序窗口指定位置截圖的實現(xiàn)方法

    解決C# 截取當前程序窗口指定位置截圖的實現(xiàn)方法

    本篇文章是對C#中截取當前程序窗口指定位置截圖的實現(xiàn)方法進行了詳細的分析介紹，需要的朋友參考下
    2013-05-05

最新評論