ADO.NET朝花夕拾(二)
protected void Page_Load(object sender, EventArgs e)
{
ShowDate();
}
void ShowDate()
{
using (SqlConnection con = new SqlConnection("server=.;database=huifeng;integrated security=true;"))
{
using (SqlCommand cmd = new SqlCommand("select * from orderr Where id>@id1 And id<@id2", con))
{
con.Open();
DataSet ds = new DataSet();
SqlParameter[] ps = {
new SqlParameter("@id1",4),
new SqlParameter("@id2",11)
};
cmd.Parameters.AddRange(ps);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(ds,"table1");
for (int i = 0; i <ds.Tables["table1"].Rows.Count ; i++)
{
Response.Write(ds.Tables["table1"].Rows[i][0].ToString()+"<br>");
}
}
}
}
{
ShowDate();
}
void ShowDate()
{
using (SqlConnection con = new SqlConnection("server=.;database=huifeng;integrated security=true;"))
{
using (SqlCommand cmd = new SqlCommand("select * from orderr Where id>@id1 And id<@id2", con))
{
con.Open();
DataSet ds = new DataSet();
SqlParameter[] ps = {
new SqlParameter("@id1",4),
new SqlParameter("@id2",11)
};
cmd.Parameters.AddRange(ps);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(ds,"table1");
for (int i = 0; i <ds.Tables["table1"].Rows.Count ; i++)
{
Response.Write(ds.Tables["table1"].Rows[i][0].ToString()+"<br>");
}
}
}
}
作者:Cat Qi
出处:http://qixuejia.cnblogs.com/
本文版权归作者和博客园共有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。
出处:http://qixuejia.cnblogs.com/
本文版权归作者和博客园共有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。