MySQL数据库和sqlserver压力监测程序实操-sqlserver连接mysql数据库

你是否对获压力监测程序MySQL数据库和sqlserver的实际操作感到很是头疼？别急，以下的文章将会给你相应的解决方案，以下的文章主要是介绍获得压力监测程序 MySQL数据库和sqlserver的方案，以下就是其具体内容描述。

using System.Data;  
using System.Data.SqlClient;  
using System.Configuration;  
using System.Web;  
using System.Web.Security;  
using System.Web.UI;  
using System.Web.UI.WebControls;  
using System.Web.UI.WebControls.WebParts;  
using System.Web.UI.HtmlControls;  
using MySQL(和PHP搭配之***组合)DriverCS;  
/// <summary>

db 的摘要说明

/// </summary> 
public class db  
{  
public db()  
{  
//  
// TODO: 在此处添加构造函数逻辑  
//  
}  
/* public static SqlConnection createCon()  
{  
return new SqlConnection("server=.;database=ylcg;uid=sa;pwd=123456;");  
}*/  
public static MySQL(和PHP搭配之***组合)Connection createCon()  
{  
return new MySQL(和PHP搭配之***组合)Connection(new MySQL(和PHP搭配之***组合)ConnectionString("localhost","ylcg","root","123456").AsString);  
}  
/* public static DataTable ylTable()  
{  
SqlConnection con = db.createCon();  
SqlDataAdapter sda = new SqlDataAdapter();  
sda.SelectCommand = new SqlCommand("select * from yl", con);  
DataSet myds = new DataSet();  
sda.Fill(myds, "yl");  
sda.Dispose();  
con.Close();  
return myds.Tables["yl"];   
}*/  
public static DataTable ylTable()  
{  
MySQL(和PHP搭配之***组合)Connection con = db.createCon();  
MySQL(和PHP搭配之***组合)DataAdapter sda = new MySQL(和PHP搭配之***组合)DataAdapter();  
sda.SelectCommand = new MySQL(和PHP搭配之***组合)Command("select * from yl",con);  
DataSet myds = new DataSet();  
sda.Fill(myds, "yl");  
sda.Dispose();  
con.Close();  
return myds.Tables["yl"];   
}  
/* public static void insertNew(int num)  
{  
SqlConnection con = db.createCon();  
SqlCommand cmd = new SqlCommand();  
try  
{  
for (int i = 0; i < 100; i++)  
{  
string[] times ={"00:10","00:20","00:30","00:40","00:50",  
"01:10","01:20","01:30","01:40","01:50",  
"02:10","02:20","02:30","02:40","02:50",  
"03:10","03:20","03:30","03:40","03:50",  
"04:10","04:20","04:30","04:40","04:50",  
"05:10","05:20","05:30","05:40","05:50",  
"06:10","06:20","06:30","06:40","06:50",  
"07:10","07:20","07:30","07:40","07:50",  
"08:10","08:20","08:30","08:40","09:50",  
"10:10","10:20","10:30","10:40","10:50",  
"11:10","11:20","11:30","11:40","11:50",  
"12:10","12:20","12:30","12:40","12:50",  
"13:10","13:20","13:30","13:40","13:50",  
"14:10","14:20","14:30","14:40","14:50",  
"15:10","15:20","15:30","15:40","15:50",  
"16:10","16:20","16:30","16:40","16:50",  
"17:10","17:20","17:30","17:40","17:50",  
"18:10","18:20","18:30","18:40","18:50",  
"19:10","19:20","19:30","19:40","19:50"};  
System.Random r = new Random();  
int myyl = r.Next(1120, 1890);  
string sql = "insert into yl values('" + times[i].ToString() + "'," + myyl + ",11)";  
// System.Web.HttpContext.Current.Response.Write(sql);  
con.Open();  
cmd.Connection = con;  
cmd.CommandType = CommandType.Text;  
cmd.CommandText = sql;  
cmd.ExecuteNonQuery();  
cmd.Dispose();  
con.Close();  
}  
}  
catch  
{  
System.Web.HttpContext.Current.Response.Write("dd");  
}   
 
}*/  
public static void insertNew(int num)  
{  
MySQL(和PHP搭配之***组合)Connection con = db.createCon();  
MySQL(和PHP搭配之***组合)Command cmd = new MySQL(和PHP搭配之***组合)Command();  
try  
{  
for (int i = 0; i < 100; i++)  
{  
string[] times ={"00:10","00:20","00:30","00:40","00:50",  
"01:10","01:20","01:30","01:40","01:50",  
"02:10","02:20","02:30","02:40","02:50",  
"03:10","03:20","03:30","03:40","03:50",  
"04:10","04:20","04:30","04:40","04:50",  
"05:10","05:20","05:30","05:40","05:50",  
"06:10","06:20","06:30","06:40","06:50",  
"07:10","07:20","07:30","07:40","07:50",  
"08:10","08:20","08:30","08:40","09:50",  
"10:10","10:20","10:30","10:40","10:50",  
"11:10","11:20","11:30","11:40","11:50",  
"12:10","12:20","12:30","12:40","12:50",  
"13:10","13:20","13:30","13:40","13:50",  
"14:10","14:20","14:30","14:40","14:50",  
"15:10","15:20","15:30","15:40","15:50",  
"16:10","16:20","16:30","16:40","16:50",  
"17:10","17:20","17:30","17:40","17:50",  
"18:10","18:20","18:30","18:40","18:50",  
"19:10","19:20","19:30","19:40","19:50"};  
System.Random r = new Random();  
int myyl = r.Next(1120, 1890);  
string sql = "insert into yl(sendtime,sendvalue,cgID) values('" + times[i].ToString() + "'," + myyl + ",11)";  
// System.Web.HttpContext.Current.Response.Write(sql);  
con.Open();  
cmd.Connection = con;  
cmd.CommandType = CommandType.Text;  
cmd.CommandText = sql;  
cmd.ExecuteNonQuery();  
cmd.Dispose();  
con.Close();  
}  
}  
catch  
{  
System.Web.HttpContext.Current.Response.Write("dd");  
}  
}   
}  
MySQL(和PHP搭配之***组合)> create table yl( ylID int(10) unsigned NOT NULL AUTO_INCREMENT Prima(最完善的虚拟主机管理系统)ry ke  
y, sendtime varchar(20), sendvalue int(10), cgID int(10) not null) ENGINE=MyISAM 
AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

以上的相关内容就是对压力监测程序sqlserver和MySQL数据库的介绍，望你能有所收获。

【编辑推荐】