DataTable dt = new DataTable(); using (SqlConnection con = new SqlConnection("server=2.2.255.255;user id=aa;pwd=123;database=dbname")) { con.Open(); SqlCommand cmd = new SqlCommand("select * from table23", con); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); } 然后对获得的dt进行进一步的使用和处理如绑定到aspx页面的一个GridView控件中GridView1.DataSource = dt; GridView1.DataBind();
DataTable dt = new DataTable();
using (SqlConnection con = new SqlConnection("server=2.2.255.255;user id=aa;pwd=123;database=dbname"))
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from table23", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
}
然后对获得的dt进行进一步的使用和处理如绑定到aspx页面的一个GridView控件中GridView1.DataSource = dt;
GridView1.DataBind();
要是是这个了server=2.2.255.255;user id=aa;pwd=123;database=dbname
其他的看你是对什么控件操作了
/// <summary>
/// 创建一个数据库连接,返回数据库连接对象
/// </summary>
/// <returns></returns>
public static SqlConnection CreateConnection()
{ string Constring = "server=2.2.255.255;userid=aa;pwd=123;database=dbname";
SqlConnection con = new SqlConnection(Constring);
return con;
} /// <summary>
/// 从table23表中,获取数据,返回Datatable数据。
/// </summary>
/// <returns></returns>
public static DataTable GetData()
{ SqlConnection con = CreateConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "select * from table23 ";
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
try
{
sda.Fill(dt); }
finally
{
con.Close();
cmd.Dispose(); }
return dt;
}
//之后在前台用datagridView.DataSource() = (类名.)GetData();读出。
<connectionStrings>
<add name="ConnectionString" connectionString="主机地址; uid=用户; pwd=密码;database=数据库 "/>
</connectionStrings>
就行啦!