怎么连接用Microsoft Visual Studio 2010连接数据库!但是SQL2008不打开数据!这样可以连接吗?
这样可以吗???? 需要时语句???
2013-05-19 11:14
2013-05-19 20:48
2013-05-19 23:11
2013-05-20 09:47

2013-05-20 09:49
程序代码:
<connectionStrings>
<add name="SQLConnString" connectionString="data source=.;database=数据库名字;user id=;pwd=" providerName="System.Data.SqlClient"/>
</connectionStrings>
public static readonly string SQLConnString = ConfigurationManager.ConnectionStrings["SQLConnString"].ConnectionString;
2013-05-20 13:55
<connectionStrings>
<add name="TeleSales" connectionString="server=localhost;database=Telesales;uid=***;password=***"/>
</connectionStrings>
2013-05-20 14:39
using System.Data.SqlClient;
程序代码:
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["TeleSales"].ConnectionString);
string query = ""//sql语句
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read()) {
//读取行数据,要怎么操作放在这里
//可以这样读取dr["fieldName"]或者dr[0],fieldName为字段名
//在这个循环中,每次读取为数据库数据的一行,知道所有的行都读取过就退出循环了
}int count= cmd.ExecuteNoneQuery();
2013-05-20 14:53
2013-05-20 15:09
2013-05-20 16:08