C#windows窗体应用程序连接数据库SQL2005不成功

[hongtiancai]

private void Form1_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection( "user id=hxh;password=20080712;initial catalog=hxh;Server=XINAN0107\SQLEXPRESS");
conn.Open();
DataTable dt = new DataTable();
da.Fill(dt);

this.textBox1.Text = dt.Rows[0]["math"].ToString();
this.textBox2.Text = dt.Rows[0]["age"].ToString();
this.textBox3.Text = dt.Rows[0]["course"].ToString();
conn.Close();
}
远程连接已打开，Server填IP也不行，能不能给个代码，大谢！

[cftea]

Server 换成 Data Source 试试。

[tianhuo_soft]

SqlDataAdapter da = new SqlDataAdapter("select语句", conn);//加上
da.Fill(dt); 

[qqhmitzk]

同上

[hongtiancai]

private void Form1_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection( "user id=hxh;password=20080712;initial catalog=hxh;Server=XINAN0107\SQLEXPRESS");
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM Student";
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
this.textBox1.Text = dt.Rows[0]["math"].ToString();
this.textBox2.Text = dt.Rows[0]["age"].ToString();
this.textBox3.Text = dt.Rows[0]["course"].ToString();
conn.Close();


}
还是连不上,换Data Source也不行

[qqhmitzk]

private void Form1_Load(object sender, EventArgs e) 
        { 
          SqlConnection conn = new SqlConnection( "user id=hxh;password=20080712;initial catalog=hxh;Server=XINAN0107\SQLEXPRESS"); 
          conn.Open(); 
    
            string strsql = "SELECT * FROM Student"; 
          SqlDataAdapter da = new SqlDataAdapter(strsql,conn); 
            DataTable dt = new DataTable("Student");// 
            //  DataSet dt=new DataSet()//可用这句
            da.Fill(dt);                  
              this.textBox1.Text = dt.Rows[0]["math"].ToString(); 
            this.textBox2.Text = dt.Rows[0]["age"].ToString(); 
              this.textBox3.Text = dt.Rows[0]["course"].ToString(); 
              conn.Close();        


        }