C# web开发个人小结（待续）

Gridview 控制列宽

<asp:BoundField HeaderText="专业" DataField="yuanxiao" ItemStyle-Width="250px" />

ItemStyle-Width控制列宽

数据库连接

1、在App_Code下写连接类

public static SqlConnection createcon()
    {
        return new SqlConnection("server=10.10.1.1;uid=sa;pwd=123456;database=dataname;Max Pool Size = 1024");
    }
//在XX.aspx引用
 SqlConnection con = DB.createcon();

2、在配置文件Web.config里面写连接语句

<appSettings>
    <add key="ConnectionString" value="Data Source=(local);Initial Catalog=dataname;User ID=sa;Password=123456;"/>
</appSettings>
//在XX.aspx中引用
string connectionString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
SqlConnection sqlConn = new SqlConnection(connectionString);
 

//或者
<connectionStrings>    
<add name="ConnectionString" connectionString="server=服务器地址; user=用户名;pwd=密码;database=数据库名称"/>
</connectionStrings>
//在XX.aspx中引用，引用命名空间：using System.Configuration;
public string connectionstring = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
SqlConnection sqlConn = new SqlConnection(connectionstring); 

3、用Javascript来判断FileUpload上传文件的类型

 var fileName = document.getElementById("FileUpload1").value;
            var exName = fileName.substr(fileName.lastIndexOf(".") + 1).toUpperCase();
            if (exName != "JPG" && exName != "BMP" && exName != "GIF") {
                alert("上传相片的格式不正确，格式只能为jpg,gif,bmp！");
                return false;
            }

4、用JavaScript去年左右的空格

        //去左空格; 
        function ltrim(s) {
            return s.replace(/^\s*/, "");
        }
        //去右空格; 
        function rtrim(s) {
            return s.replace(/\s*$/, "");
        }
        //去左右空格; 
        function trim(s) {
            if (rtrim(ltrim(s)) == "") {
                return true;
            }
        }

        function checkNull() {
            if (document.getElementById('TextBox1').value == "" || trim(document.getElementById('TextBox1').value)) {
                alert("不能为空！");
                return false;
            }
        }