常用代码片段

web.config

---

<?xml version="1.0" encoding="utf-8" ?>
<configuration>

 <appSettings>
  <add key="sqlstr" value="server=XXXX;uid=sa;pwd=pass;database=XXXX;" />
 </appSettings>
.......

CONN

---

SqlConnection conn;
conn = new SqlConnection( ConfigurationSettings.AppSettings["connstr"]);
conn.Open();

DR(SqlDataReader)

---

SqlCommand cmd;
cmd = new SqlCommand("myQuestion @uid='" + myuserid + "'",conn);

SqlDataReader dr;
dr=cmd.ExecuteReader();

DG(DataGrid)

---

DataSet ds = new DataSet();
cmd.Fill(ds);
DG.DataSource=ds;
DG.DataBind();