快速构建页面【组员参看】

第一遍，快速浏览粗体字及各级标题
第二遍~第X便，随意。
获取数据的代码：
1.最常规
                string gID = "";
                SqlConnection sqlconn = new SqlConnection(sqldata.ascon);
                SqlCommand sqlcomm = new SqlCommand();
                sqlcomm.CommandText = "SELECT * FROM [Lcts] WHERE [kcFengmianID]='" + Image3.ToolTip + "'";
                sqlconn.Open();
                sqlcomm.Connection = sqlconn;
                SqlDataReader sdr = sqlcomm.ExecuteReader();
                while (sdr.Read())
                {
                    gID = sdr["kechengID"].ToString();//读取kechengID
                }
                sqlcomm = null;
                sqlconn.Close();

                sqlconn = null;

    另一种方法是这样的

 
            SqlConnection con1 = new SqlConnection("server=.;database=Indivicute;uid=sa;pwd=123456;");
            con1.Open();
            SqlDataAdapter sdaa1 = new SqlDataAdapter("SELECT sum(studyDuration) as allLecTime FROM View_stu_learnLesRec where lecId='" + lecId + "'", con1);
            DataSet myds01 = new DataSet();
            sdaa1.Fill(myds01);

  if(myds01.Tables[0].Rows.Count!=0)
            {
           allLecLearnTime = myds0.Tables[0].Rows[0]["allLecTime"].ToString();//获取成功
            }           

datalist.datasouce=ss;

datealist.databind();

            con1.Close();

2.三层代码 （获得数据集，并用datalist等控件显示）
            helios.BLL.shujuku.Lcts bll = new helios.BLL.shujuku.Lcts();
            DataSet ds = new DataSet();
            StringBuilder strWhere = new StringBuilder();
            if (txtKeyword.Text.Trim() != "")
            {     
                #warning 代码生成警告：请修改 keywordField 为需要匹配查询的真实字段名称
                //strWhere.AppendFormat("keywordField like '%{0}%'", txtKeyword.Text.Trim());
            }           
            ds = bll.GetList(strWhere.ToString());           
            gridView.DataSource = ds;
            gridView.DataBind();

3.三层代码（读取单个东西）
            helios.BLL.shujuku.Lcts bll = new helios.BLL.shujuku.Lcts();
            helios.Model.shujuku.Lcts model = bll.GetModel(kechengID);
            //读取课程标题
            this.lblkcBiaoti.Text = model.kcBiaoti;
            //课程介绍
            this.lblkcJieshao.Text = model.kcJieshao;
4.（封装后）最傻瓜（读取某个东西）
            string gID="";
            string sqlSel = "Select shoucangID from kechengSUOSHUshoucangjia where kechengID=" + Request.Params["id"] + "and yonghuID=" + Session["yonghuID"].ToString();//如果用户没有关注该课程，该语句会提示错误，未获得balabala
            SqlDataReader sdr = operateData.getRow(sqlSel);
            while (sdr.Read())
                {
                    gID = sdr["kechengID"].ToString();//读取了kechengID给gID
                }
5.前台利用SqlDataSource,获取数据，并赋值给datalist等控件显示
    <asp:SqlDataSource ID="sqlShoucang" runat="server" ConnectionString="<%$ ConnectionStrings:isharingConnectionString %>"
        SelectCommand="SELECT * FROM [Collections] WHERE ([yonghuID] = @yonghuID)">
        <SelectParameters>
            <asp:SessionParameter Name="yonghuID" SessionField="yonghuID" Type="Int64" />
        </SelectParameters>
    </asp:SqlDataSource>
插入数据
1.最傻瓜
                string strid = Convert.ToString(e.CommandArgument);

                sqldata.exdata("INSERT INTO [LctsPost-gxUsers] ( [tieziID],[yonghuID]) VALUES('" + strid + "','" + Session["yonghuID"].ToString() + "')");

2.      string str3 = "server=.;database=Indivicute;uid=sa;pwd=123456;";
            SqlConnection conn3 = new SqlConnection(str3);
            conn3.Open();
            SqlCommand cmd = new SqlCommand("insert into 表 (列名,列名,列名) values('数据','数据','数据')", conn3);
            cmd.ExecuteNonQuery();
            conn3.Close(); 

更新数据
1.（利用分装函数）最傻瓜
                 string ganxieshu = pagesdata.recordc("[LctsPost-gxUsers] WHERE tieziID=" + strid + "");
                //更新感谢数
                sqldata.exdata("UPDATE LctsPost SET ganxieshu='" + ganxieshu + "'WHERE tieziID=" + strid);
2.最傻瓜二
                sqex = sqex + "UPDATE MiroLcts SET wkBiaoti='" + name + "',neirong='" + msh + "',yonghuID='" + yonghuID + "' WHERE weikeID='" + id + "';";
                }
                sqldata.exdata(sqex.ToString());
                string a = pagesdata.recordc("Lcts WHERE yonghuID=" + Session["yonghuID"].ToString() + ""); //输出共有多少条符合当前用户的课程记录条数

                sqldata.exdata("UPDATE Users SET kaike='" + a + "'WHERE yonghuID=" + Session["yonghuID"].ToString());

删除数据
1.最傻瓜
                string strid = Convert.ToString(e.CommandArgument);
                sqldata.exdata("DELETE [LctsPost-gxUsers] WHERE yonghuID='" + Session["yonghuID"].ToString() + "'AND tieziID='" + strid + "';UPDATE LctsPost set ganxieshu=(SELECT COUNT(*) FROM [LctsPost-gxUsers] WHERE tieziID='" + strid + "') WHERE tieziID='" + strid + "'");

插入与更新数据结合
1.最傻瓜                
                //插入感谢记录
                string strid = Convert.ToString(e.CommandArgument);
                sqldata.exdata("INSERT INTO [LctsPost-gxUsers] ( [tieziID],[yonghuID]) VALUES('" + strid + "','" + Session["yonghuID"].ToString() + "')");
                //输出共有多少条符合当前用户的感谢条数
                string ganxieshu = pagesdata.recordc("[LctsPost-gxUsers] WHERE tieziID=" + strid + "");
                //更新感谢数
                sqldata.exdata("UPDATE LctsPost SET ganxieshu='" + ganxieshu + "'WHERE tieziID=" + strid);
上述代码直接来源于正在做的isharing网站
阅读注意事项：
1.无需关注具体语义，如 INSERT INTO [LctsPost-gxUsers] ( [tieziID],[yonghuID]) VALUES('" + strid + "','" + Session["yonghuID"].ToString() + "')");这句话中的Session["yonghuID"].ToString() ，或[yonghuID]是什么意思，只需知道这句话是select语句即可。
2.不懂可以马上call我，不要浪费每个月免费的200分钟啊。
3.最好面谈，效率高。
4.这里的傻瓜意指最简单，竟然只用两句话就能插入或者更新数据，真是太变态了。
@赵暧 
@王一丹