与数据库连接的方法

方法一：在配置中配置环境
<connectionStrings>
  <add connectionString="server=192.168.24.252;uid=sa;pwd=jh0101;database=C6V3ZP" name="SqlConn"/>
</connectionStrings>

string conn = System.Configuration.ConfigurationManager.ConnectionStrings["SqlConn"].ConnectionString;

方法二：直接连接数据库
SqlConnection conn = new SqlConnection("server=192.168.24.252;uid=sa;pwd=jh0101;database=C6V3ZP");

try{
 SqlCommand cmd = new SqlCommand("select * from HR_DictItem where PNo='"+DictNo+"'", conn);

 conn.Open();

 SqlDataAdapter da = new SqlDataAdapter(cmd);

 DataTable dtSource = new DataTable();

 da.Fill(dtSource);
}
catch (Exception ex){
        Response.Write(ex.Message);
}
finally{
        conn.Close();
}