怎么在本机连接虚拟机里的数据库

发布网友

我来回答

共1个回答

热心网友

虚拟机和物理机网卡桥接,能ping通就可以访问，你可以从你虚拟机网卡设置里看看是不是桥接Bridge。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using System.Windows.Forms;

namespace DataInput
{
public class DataInputClass
{
private string instrName="";
private string ConStr = "server=.;database=SerialData;uid=sa;pwd=880906";
//数据库对象
SqlConnection conn = null;
SqlCommand cmd = new SqlCommand();

char separator = '^';
string[] myResult = new string[10];

public DataInputClass(string myInstrName)
{
instrName = myInstrName;
}
public string InstrName
{
get
{
return instrName;
}
}

public string myDataInput(string myInstrCode)
{

//打开数据库
try
{
conn = new SqlConnection(ConStr);
conn.Open();

if (!(conn.State == ConnectionState.Open))
{
MessageBox.Show("数据库打开失败!");
}
}
catch(Exception e)
{
MessageBox.Show("数据库打开异常!"+ e.Message);
return "";
}
//数据入库
try
{
myResult = myInstrCode.Split(separator);
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "insert into SerialResult values(" + "\'" + myResult[0] + "\',\'" + myResult[1] + "\',\'" + myResult[2] + "\')";
cmd.ExecuteNonQuery();
cmd.Dispose();
return "";
}
catch(Exception e)
{
MessageBox.Show("数据插入失败异常!" + cmd.CommandText+"|"+e.Message);
return "";
}

}

}
}