实验室目前一个项目是用C#写的界面,读取inSQL、SQLserver数据库中的数据转存到MySQL。正在一步一步看代码。
前言:简单测试连接sqlserver请见上一篇:小白记录,以便回忆:C#测试连接Sqlserver 2014数据库
小白记录,以便回忆:C#测试连接Sqlserver 2014数据库
一、控件布局:
新建Windows窗体应用程序。添加标签、按钮、文本框,布局如下:
其中TextBox依次命名为textBox1-----textBox3,按钮为button1。
二、项目新添加一个类
右键点击项目名称——>添加——>新建项——>类,类名为:SqlServer_connect.cs
三 、SqlServer_connect类中代码
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;//注意着三个引用!!
using System.Data.SqlClient;
using System.Windows.Forms;
namespace _1008sqlserverconnect
{
class SqlServer_connect
{
private ConnectionState SQLServerConnect_State;
public ConnectionState SQLServerConnect_State1
{
get{return SQLServerConnect_State;}
set{SQLServerConnect_State = value;}
}
public void SQLServer_Connect(string Server_SQLServer, string UserId_SQLServer, string Password_SQLServer)
{
try
{
string conSQLServer = "server=" + Server_SQLServer + ";MultipleActiveResultSets=true;integrated security=FALSE;uid=" + UserId_SQLServer + ";pwd=" + Password_SQLServer + ";";
SqlConnection connSql = new SqlConnection(conSQLServer);
connSql.Open();
SQLServerConnect_State = connSql.State;
MessageBox.Show("连接成功");
}
catch (Exception e)
{
MessageBox.Show("SQLServer连接失败");
}
}
}
}
四、form中代码
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;
namespace _1008sqlserverconnect
{
public partial class Form1 : Form
{
public Form1()
{
SqlServer_connect sqlserverconnect = new SqlServer_connect ();
SqlServerConnect_Form_Event += sqlserverconnect.SQLServer_Connect;
InitializeComponent();
}
public delegate void SqlServerConnect_FormEventHander(string Ip, string UserName, string Password);
public event SqlServerConnect_FormEventHander SqlServerConnect_Form_Event;
private void button1_Click(object sender, EventArgs e)
{
SqlServerConnect_Form_Event(textBox1.Text, textBox2.Text, textBox3.Text);
this.Close();
}
private void Form1_Load(object sender, EventArgs e)
{
textBox1.Text = "127.0.0.1";
textBox2.Text = "sa";
textBox3.Text = "root";
}
}
}
五、测试结果:
关于事件那一块请多指教,一直感觉事件订阅这一块代码不知道放哪里。。。。。。