部署asp.net 4.0 Web应用程序时出现问题 [英] problem in deploying asp.net 4.0 web application

问题描述

我在一个类中创建了连接字符串，但是我无法使用数据库.

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...

推荐答案

尝试添加"".供将来使用: http://www.connectionstrings.com/sql-server-2005 [ ^ ]

这篇关于部署asp.net 4.0 Web应用程序时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！