connectfirst.cs

软件工程的课程作业

using System;
using System.Drawing;
using System.Windows.Forms;

namespace PSMS
{
	/// <summary>
	/// Summary description for connectFirst.
	/// </summary>
	public class connectFirst
	{
		public connectFirst()
		{
			//
			// TODO: Add constructor logic here
			//
		}

		public bool setconnect( System.Data.OleDb.OleDbConnection psmsconn)
		{
			connectForm cfo = new connectForm ();
			cfo.ShowDialog();
			if(cfo.sumbit.BackColor == Color.GreenYellow)
			{
				string str=@"User ID="+cfo.textBox2.Text+";";
				if(cfo.textBox3.Text != "")	str += "Password="+cfo.textBox3.Text+";";
				str +=	"Data Source="+cfo.textBox1.Text+";"+
						"Tag with column collation when possible=False;"+
						"Initial Catalog="+cfo.textBox4.Text+";"+
						"Use Procedure for Prepare=1;Auto Translate=True;Persist Security Info=False;"+
						@"Provider=""SQLOLEDB.1"";Workstation ID=RIKEN;Use Encryption for Data=False;Packet Size=4096";
				psmsconn.ConnectionString = str;
				try
				{
					psmsconn.Open();
				}
				catch(System.Exception)
				{
					MessageBox.Show("连接失败");
					return false;
				}
				MessageBox.Show("连接成功","恭喜");
				return true;
			}
			return false;
		}
	}
}