本文介绍了部署asp 4.0 Web应用程序时出现问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在一个类中创建了连接字符串,但是我无法使用数据库.
i created connection string in a class but i am not able to use database.
public class DataContext { SqlConnection con = new SqlConnection(); SqlCommand cmd = new SqlCommand(); SqlDataAdapter da = new SqlDataAdapter(); //SqlDataReader dr = new SqlDataReader(); public void Openconnection() { if (con.State == ConnectionState.Closed) { try { string constring = "data source = myserveraddress;Initial Catalog=mywebsite;Persist Security Info=True;User ID=myid;Password=mypassword"; con.ConnectionString = constring; con.Open(); cmd.Connection = con; } catch (Exception ex) { ex.Message.ToString(); } } } public void CloseConnection() { if (con.State == ConnectionState.Open) { con.Close(); } } public DataTable getDataTable(string Query) { DataTable dt = new DataTable(); Openconnection(); cmd.CommandType = CommandType.Text; cmd.CommandText = Query; da.SelectCommand = cmd; da.Fill(dt); CloseConnection(); return dt; } public int executeNonquery(string Query) { Openconnection(); cmd.CommandType = CommandType.Text; cmd.CommandText = Query; int i = cmd.ExecuteNonQuery(); CloseConnection(); return i; }我正在使用这样的连接线来部署我的网站...
i am deploying my website by using connction strin like this...
推荐答案尝试添加"".供将来使用: www.connectionstrings/sql-server-2005 [ ^ ]
更多推荐
部署asp.net 4.0 Web应用程序时出现问题
发布评论