Help! VS SQL Server database connection problem

dscy8899

I only have vs on this computer, and SQL Server is on another host on the local LAN. I want to connect VS to SQL Server on the host. How do I write the connection string?
PS: I checked. Many people use driver online, but it does n’t support

dscy8899

public partial class kaipiaoziliao_loginpage: System.Web.UI.Page
{
    protected void Page_Load (object sender, EventArgs e)
    {

    }
    protected void Button1_Click (object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection ();
        con.ConnectionString = "Server = i-server; database = fapiao; integrated security = SSPI;";
        
        SqlCommand objcmd = new SqlCommand ();
        objcmd.Connection = con;
        objcmd.CommandText = "select shuihao from cheeck where shuihao = '" + Convert.ToInt32 (TextBox1.Text.Trim ()) + "'";
        con.Open ();
        SqlDataReader dr = objcmd.ExecuteReader ();
        if (dr.Read ())
        {
            Session ["shuihao"] = TextBox1.Text.Trim ();
            Response.Redirect ("cheeck.aspx");
        }
        else
        {Response.Write ("<script language = 'javascript'> window.alert ('Your input is incorrect, please re-enter!'); </ Script>");}
    }
 
}
The above is my program segment, but SqlDataReader dr = objcmd.ExecuteReader () appears at runtime; is this line of error, is it because the database is not connected?

dydcool

SqlConnection conn = new SqlConnection ("Data Source = .\\SQLEXPRESS; database = DB2015; Integrated Security = True");
            string sql = "";
            SqlDataAdapter da = new SqlDataAdapter (sql, conn);
            DataTable dt = new DataTable ();
            da.Fill (dt);

shenmue024

If you ca n’t connect

con.Open (); This should be an error,

It should be a problem with sql, check it out.

dscy8899

Is the data source followed by the IP of the host? Is it necessary to add the port number? How to see the port number?

bobcao

Connection string problem
private string connectionstring = "server=ZHANGYAHUI\\SQLEXPRESS;uid=sa;pwd=sa;database=Student";

dscy8899

I changed the connection string to con.ConnectionString = "data source=192.168.0.1;database=fapiao;integrated security=SSPI";
192.168.0.1 is the IP of the local host, but it still does not work, or it still prompts "SqlDataReader dr = objcmd.ExecuteReader();" This error, what to do???

hy1000

Drag a SqlConnection to use the IDE's connection wizard to generate one!