DAN疼之后上些基础知识（二）

gridview 分页：

protected void gvupphoto_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        this.gvupphoto.PageIndex = e.NewPageIndex;
        this.gvupphoto.DataBind();
    }
    protected void gvupphoto_PageIndexChanged(object sender, EventArgs e)
    {
        db.databindgv(gvupphoto, "select * from tb_userupphoto ");
    }

提示并转到指定的页面

Response.Write("<script language=javascript>alert('只有会员才能上传图片!!!');location='Default.aspx';</script>");

asp.net中插入flash 在html 中添加

在gridview 中用 ....代替超长字符

SqlConnection con = new SqlConnection("Data Source=(local);database=database;uid=sa;pwd=");
        SqlDataAdapter da = new SqlDataAdapter("select * from tb_bigtitle", con);
        DataSet ds = new DataSet();
        da.Fill(ds, "table");
        GridView1.DataSource = ds;
        GridView1.DataKeyNames = new string[] { "b_id" };
        GridView1.DataBind();
        for (int i = 0; i < GridView1.Rows.Count; i++)
        {
            string str ;
            DataRowView drv;
            if (GridView1.PageIndex == 0)
            {
                drv = ds.Tables["table"].DefaultView[i];
                str = Convert.ToString(drv["b_content"]);
                GridView1.Rows[i].Cells[3].Text = substring(str, 5);//调用下边的方法

            }
            else
            {
                drv = ds.Tables["table"].DefaultView[5 * (GridView1.PageIndex)];
                str = Convert.ToString(drv["b_content"]);
                GridView1.Rows[i].Cells[3].Text = substring(str, 5);

            }
public string substring(string str,int n)
    {
        if (str.Length < n)
        {
            return str;
        }
        else
        {
            string newstr = str.Substring(0, n);
            newstr = newstr + "...";
            return newstr;
        }
    }

滚动字幕

     <marquee direction="up" scrollAmount="2" scorollDelay="7" onmouseout="this.start()" onmouseover="this.stop()" >
            <span style ="font-size :14px">
            技术工艺，以上乘的质量、上佳的服务、公期，以及优越
            </span>
          </marquee>

内嵌框架

框架（注意转换不到视图模式）

启动本机发送邮件

<a href ="mailto: chenhongjun125@163.com">chenhongjun125@163.com</a>

局部刷新技术

存储过程查数据

SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["connectionstring"]);
        con.Open();
        SqlDataAdapter da = new SqlDataAdapter("text", con);
        da.SelectCommand.CommandType = CommandType.StoredProcedure;
        DataSet ds = new DataSet();
        da.Fill(ds);
        gvtext.DataSource = ds;
        gvtext.DataKeyNames = new string[] { "id" };
        gvtext.DataBind();

用存储过程存数据

SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["connectionstring"]);
        con.Open();
        try
        {
            SqlCommand com = new SqlCommand("addtext", con);
            com.CommandType = CommandType.StoredProcedure;
            SqlParameter[] prams ={
            new SqlParameter ("title",SqlDbType .VarChar ,50),
            new SqlParameter ("content",SqlDbType .VarChar ,50),
        };
            prams[0].Value = tbtitle.Text;
            prams[1].Value = tbcontent.Text;
            foreach (SqlParameter parameter in prams)
            {
                com.Parameters.Add(parameter);
            }
            com.ExecuteNonQuery();
            con.Close();
        }
        finally
        {

        }