我是建一个专门连接数据库和一些操作数据库的的类,不说话,直接上代码。
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace SMS.BaseClass
{
class DataCon
{
public SqlConnection getcon()
{
string sqlstr = "Data Source=10.16.100.98;Database=ynkc;uid = SA; pwd=990904";
//string sqlstr = "Data Source=ZSCHSERVER1-IBM\\SQLEXPRESS;Database=chgltest;uid = SA; pwd=990904";
//string sqlstr = "Data Source=10.16.100.98;Database=ynkc;uid = SA; pwd=990904";
SqlConnection Mycon = new SqlConnection(sqlstr);
//Mycon.Open();
return Mycon;
}
public void getcom(string comstr)
{