小格杂记

自定义类取session的值

HttpContext.Current.Session["a"]="hello";

.CS 文件里改变文字颜色

"<font Color='red'>(" + GetNameById(sql) + ")</font>"

asp.net 弹出对话框

this.Page.ClientScript.RegisterStartupScript(this.GetType(), "str", "<script>alert(\"添加成功！\");window.location.href='EnvironmentMng.aspx'</script>");

asp.net后台获取html控件值

Label1.Text = Request.Form["yBirthDay"].ToString();

sql2000 ：

sql2005 sqlexpress：
<add name="hospitalConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=hospital;Trusted_Connection=yes" providerName="System.Data.SqlClient"/>

asp.net include 页面：

<%--#include virtual = "/bin/comm_site/inc_page_end.aspx" --%>

asp.net datagrid 行变色

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{

        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.Attributes.Add("onmouseover", "this.style.cursor='hand';c=this.style.backgroundColor;this.style.backgroundColor='#E7EFFC'");
            e.Row.Attributes.Add("onmouseout", "this.style.cursor='';this.style.backgroundColor=c");
        }
    }

asp.net动态创建table column

public void SearchReportByVid()
    {
        DataTable dt = manager.SearchReportByVid(vid+flag).Tables[0];
        DataTable dtt = new DataTable("dttt");
        DataRow newRow = null;

        if (dt.Rows.Count != 0)
        {
            DataColumn dc = new DataColumn();
            dc = dtt.Columns.Add("item_name", Type.GetType("System.String"));
            for (int i =0; i < dt.Rows.Count; i++)
            {
                if (i < dt.Rows.Count - 1)
                {
                    if (dt.Rows[i]["item_name"].ToString().Trim() != dt.Rows[i + 1]["item_name"].ToString().Trim())
                    {
                        newRow = dtt.NewRow();
                        newRow["item_name"] = dt.Rows[i]["item_name"].ToString();
                        dtt.Rows.Add(newRow);
                    }
                }
                else {
                    newRow = dtt.NewRow();
                    newRow["item_name"] = dt.Rows[i]["item_name"].ToString();
                    dtt.Rows.Add(newRow);
                }
            }
        }

}

绑定下拉列表

public void InitDataAll()
    {
        this.yPlace.Items.Clear();
        DataSet ds = manager.GetCheckHelthPlaceAll();
        this.yPlace.DataSource = ds.Tables[0];
        this.yPlace.DataTextField = "dtext";
        this.yPlace.DataValueField = "arid";
        this.yPlace.DataBind();
    }

asp.net 上传图片

if (file.HasFile)
            {
                string fileContentType = file.PostedFile.ContentType;
                if (fileContentType == "image/gif" || fileContentType == "image/pjpeg")
                {
                    Random number = new Random();
                    string filename = DateTime.Now.ToString("yyyyMmddhhmmssfff") + "_" + number.Next(10000, 99999).ToString() + "_" + file.PostedFile.ContentLength + System.IO.Path.GetExtension(file.PostedFile.FileName);
                    string filenameGUID = Guid.NewGuid().ToString() + System.IO.Path.GetExtension(file.FileName);
                    file.SaveAs(Server.MapPath("~/pic/") + filenameGUID);
                    pic.Text = "pic/" + filenameGUID;
                    img.Visible = true;
                    img.ImageUrl = "pic/" + filenameGUID;

                    //下面不是自动命名上传图片，直接上传原文件的名字图片
                    //string strDir = file.FileName;
                    //string strPath = Server.MapPath("~/pic/") + strDir;
                    //file.SaveAs(strPath);
                    //pic.Text = "pic/" + strDir;
                    //img.Visible = true;
                    //img.ImageUrl = "pic/" + strDir;
                }
                else
                {
                    infro.Visible = true;
                    infro.Text = "提示：文件类型不符,只能上传JPG,GIF图片！";
                }
            }

查询分析器修改SQL登录密码：

EXEC sp_password NULL, '你的新密码', 'sa'

asp.net 日期格式绑定

Text='<%# DataBinder.Eval(Container, "DataItem.yyrq2","{0:yyyy-MM-dd}").ToString() %>'
<asp:TemplateField HeaderText="发布日期">
                        <ItemTemplate>
                            <%# Eval("dt","{0:d}")%>
                        </ItemTemplate>
</asp:TemplateField>

div+css 以IE7浏览器来渲染，兼容IE8

div+css 以IE5浏览器来渲染，兼容IE5及以浏览器下版本