📄 login.cs
字号:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using SetServer;
using System.IO;
using System.Data.SqlClient;
namespace xlsb
{
public partial class login : Form
{
public login()
{
InitializeComponent();
}
private void button5_Click(object sender, EventArgs e)
{
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
SetForm newsetform = new SetForm();
newsetform.Show();
}
private void login_Load(object sender, EventArgs e)
{
string strname="";
int Len_Num=0;
if (File.Exists("conn.ini"))
{
button1.Enabled = false;
button2.Enabled = true;
FileStream fs = new FileStream("conn.ini", FileMode.Open, FileAccess.Read);
StreamReader strmread = new StreamReader(fs);
while (strmread.Peek()!=-1)
{
strname = strmread.ReadLine();
Len_Num =strname.Length;
if (Len_Num >= 7)
{
if (strname.Substring(0, 7).ToString() == "server=")
main.servername = strname.Substring(7, (strname.Length-7)).ToString();
}
if (strname.Substring(0, 3).ToString() == "sa=")
main.saname = strname.Substring(3, (strname.Length-3)).ToString();
if (Len_Num >= 9)
{
if (strname.Substring(0, 9).ToString() == "paasword=")
main.pass = strname.Substring(9, (strname.Length-9)).ToString();
}
}
strmread.Close();
if (treeView1.Nodes.Count == 1)
{
treeView1.SelectedNode = treeView1.Nodes[0];
TreeNode tmp;
tmp = new TreeNode(main.servername);
//在TreeView组件中加入子节点
treeView1.SelectedNode.Nodes.Add(tmp);
treeView1.SelectedNode = tmp;
treeView1.ExpandAll();
}
SqlConnection myConnection = new SqlConnection("Data Source="+main.servername+";Initial Catalog=master;Persist Security Info=True;User ID="+main.saname+";Password="+main.pass);
myConnection.Open();
SqlDataAdapter da = new SqlDataAdapter("select medname,dbname from KINGSOFMED", myConnection);
DataSet ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0].DefaultView;
//dataGridView1.
}
else
{
button1.Enabled = true;
button2.Enabled = false;
}
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
main.dbname=dataGridView1.CurrentRow.Cells[1].Value.ToString();
pasform newpaform = new pasform();
newpaform.Show();
}
private void button4_Click(object sender, EventArgs e)
{
dataGridView1_CellClick(null,null);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -