asp.net杂文

来源：互联网发布：sql语句聚合函数编辑：程序博客网时间：2024/06/05 05:03

金额不可为负数
文件上传
迁移
dropdownlist

编程方式添加一列DataColumn
DataReader

" ValidationExpression="(/d+)(((/.)(/d)+))?">

    /// <summary>
    ///
    /// </summary>
    private string UploadFile()
    {
        if (TaskFileAttach.HasFile)
        {
            string fileType = TaskFileAttach.PostedFile.ContentType;
            if (MimeType.Instance().FileTypeIsValid(fileType))
            {
                string filePath = TaskFileAttach.PostedFile.FileName;   //客户端文件路径

FileInfo file = new FileInfo(filePath);
string fileName = DateTime.Now.ToString("yyyyMMddhhmmss") ;//+ usr.Usr_Name;

                int iLocal = file.Name.IndexOf(".");
                int iLen = file.Name.Length;
                string fileExt = file.Name.Substring(iLocal, iLen - iLocal);
                fileName += fileExt;

                string webPath = Server.MapPath("Files/" + fileName);
                if (!File.Exists(webPath))
                {
                    TaskFileAttach.SaveAs(webPath);
                    return fileName;
                }
                else
                {
                    throw new Exception("提示：文件已经存在，请重命名后上传!");
                }

            }
            else
            {
                Exception exp1 = new Exception("不支持该类型的文件！");
                throw exp1;
            }
        }
        return string.Empty;
    }

Response.Redirect("ProjectAndAction.aspx");

编程方式改变的选项
dstState.SelectedValue = ppr.Pac_state.ToString().Trim();

            DataSet ds = DBConnection.GetDataset(sql);
           DataColumn dc1 = new DataColumn();
         dc1.DataType = System.Type.GetType("System.String");
            dc1.Caption = "pac_AttacthFileSrc";
            dc1.ColumnName = "pac_AttacthFileSrc";

            ds.Tables[0].Columns.Add(dc1);
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                ds.Tables[0].Rows[i]["pac_AttacthFileSrc"] = "Files/" + ds.Tables[0].Rows[i]                  ["pac_AttacthFile"].ToString();
            }

return ds;

IDataReader dr = dbo.ExeSqlReader(sql);
if (dr.Read())
{ paai.Pac_prjId = int.Parse(dr["pac_prjId"].ToString());