我的第二个C#代码
我写的第二个C#
protected void Page_Load(object sender, EventArgs e)
{
{
string strConnection = System.Configuration.ConfigurationManager.AppSettings["connString"];
// string strConnection = System.Configuration.ConfigurationSettings.AppSettings["connString"];
//DataSet
SqlConnection Conn;
SqlDataAdapter Adqt;
DataSet Ds;
string strSql="select * from table_1";
Conn = new SqlConnection(strConnection);
Conn.Open();
Ds = new DataSet();
Adqt = new SqlDataAdapter(strSql, Conn);
Adqt.Fill(Ds, "table_1");
GridView1.DataSource = Ds.Tables["table_1"].DefaultView;
GridView1.DataBind();
Ds.Clear();
Conn.Close();
//DataReader
SqlCommand Cmd;
SqlDataReader Rd;
Conn = new SqlConnection(strConnection);
Conn.Open();
Cmd = new SqlCommand(strSql, Conn);
Rd = Cmd.ExecuteReader();
int i=0;
while (Rd.Read())
{
i++;
//i = i + 1
Response.Write(i);
Response.Write( " " + Rd["aaa"].ToString);
//为什么不能这样 Response.Write( i.ToString + Rd["aaa"].ToString);
}
Rd.Close();
Conn.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
{
string strConnection = System.Configuration.ConfigurationManager.AppSettings["connString"];
// string strConnection = System.Configuration.ConfigurationSettings.AppSettings["connString"];
//DataSet
SqlConnection Conn;
SqlDataAdapter Adqt;
DataSet Ds;
string strSql="select * from table_1";
Conn = new SqlConnection(strConnection);
Conn.Open();
Ds = new DataSet();
Adqt = new SqlDataAdapter(strSql, Conn);
Adqt.Fill(Ds, "table_1");
GridView1.DataSource = Ds.Tables["table_1"].DefaultView;
GridView1.DataBind();
Ds.Clear();
Conn.Close();
//DataReader
SqlCommand Cmd;
SqlDataReader Rd;
Conn = new SqlConnection(strConnection);
Conn.Open();
Cmd = new SqlCommand(strSql, Conn);
Rd = Cmd.ExecuteReader();
int i=0;
while (Rd.Read())
{
i++;
//i = i + 1
Response.Write(i);
Response.Write( " " + Rd["aaa"].ToString);
//为什么不能这样 Response.Write( i.ToString + Rd["aaa"].ToString);
}
Rd.Close();
Conn.Close();
}
}
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步