[quote=引用 8 楼 wind_cloud2011 的回复:]
string strCon = "Data Source=你数据库IP;Initial Catalog=db_17;User ID=sa;password=sa;Integrated Security=False";
string strSql = "select ID as 员工编号,Name as 员工姓名,Sex as 性别,Age as 年龄,Tel as 联系电话,Address as 家庭地址,QQ as QQ号码,Email as Email地址 from dbo.Info";
SqlConnection sqlcon = new SqlConnection(strCon);
SqlDataAdapter sqlda = new SqlDataAdapter(strSql, sqlcon);
DataSet myds = new DataSet();
sqlda.Fill(myds);
dgvInfo.DataSource = myds.Tables[0];[/quo谢谢大哥!
服务器名称,如果是远程服务器填写远程服务器的IP地址,本地.
不建议这么使用数据库,还是安装客户端使用比较方便[/quote]
大哥,其实我也想过这样,但是也有问题:
string strCon = "server=.;database = db_17;Trusted_Connection=true";//Data Source =WRET-MOSY688YVW\\MRGLL;Database=db_17;(//之后的是书上的例子)
string strSql = "select ID as 员工编号,Name as 员工姓名,Sex as 性别,Age as 年龄,Tel as 联系电话,Address as 家庭地址,QQ as QQ号码,Email as Email地址 from dbo.Info";
sqlcon = new SqlConnection(strCon);
sqlda = new SqlDataAdapter(strsql,sqlcon);
myds = new DataSet();
sqlda.Fill(myds);
dgvInfo.DataSource = myds.Tables[0];
运行之后,总说
[/quote]
这里不认识“.”这个东西。你原本不是问的vs数据库连接窗口的问题么?如果有新问题,重新开一个帖子吧。
string strCon = "Data Source=你数据库IP;Initial Catalog=db_17;User ID=sa;password=sa;Integrated Security=False";
string strSql = "select ID as 员工编号,Name as 员工姓名,Sex as 性别,Age as 年龄,Tel as 联系电话,Address as 家庭地址,QQ as QQ号码,Email as Email地址 from dbo.Info";
SqlConnection sqlcon = new SqlConnection(strCon);
SqlDataAdapter sqlda = new SqlDataAdapter(strSql, sqlcon);
DataSet myds = new DataSet();
sqlda.Fill(myds);
dgvInfo.DataSource = myds.Tables[0];
服务器名称,如果是远程服务器填写远程服务器的IP地址,本地.
不建议这么使用数据库,还是安装客户端使用比较方便[/quote]
大哥,其实我也想过这样,但是也有问题:
string strCon = "server=.;database = db_17;Trusted_Connection=true";//Data Source =WRET-MOSY688YVW\\MRGLL;Database=db_17;(//之后的是书上的例子)
string strSql = "select ID as 员工编号,Name as 员工姓名,Sex as 性别,Age as 年龄,Tel as 联系电话,Address as 家庭地址,QQ as QQ号码,Email as Email地址 from dbo.Info";
sqlcon = new SqlConnection(strCon);
sqlda = new SqlDataAdapter(strsql,sqlcon);
myds = new DataSet();
sqlda.Fill(myds);
dgvInfo.DataSource = myds.Tables[0];