站内搜索：

ASP.NET健康饮食管理系统(7)

来源：xiaoniu168.com 作者：本站原创添加时间：2011-12-23 点击数：21839

以下是引用片段：

if (myPhoto.ContentLength <= 0)
            {
                //修改指定的健康网信息没图片
                DataControl.ExecSql("update HBXX set Xxbt='" + this.TextBox1.Text.Trim() + "',XXnr='" + this.Textbox3.Text.Trim() + "',XXlb='" + this.DropDownList1.SelectedItem.Text + "',fbsj='" + this.TextBox4.Text.Trim() + "' where Xxid=" + Session["ID"].ToString());
            }
            else
            {
                //修改处理图片数据到二进制数组然后存储在数据库中
                string[] temp = myPhoto.FileName.Split('.');
                string strHzm = "." + temp[temp.Length - 1];
                string Sql;
                Sql = "update HBXX set xxbt='" + this.TextBox1.Text.Trim() + "', Xxtp=@myPhotoArray, XXnr='" + this.Textbox3.Text.Trim() + "',XXlb='" + this.DropDownList1.SelectedItem.Text + "',fbsj='" + this.TextBox4.Text.Trim() + "' where Xxid=" + Session["ID"].ToString();
                SqlConnection tmpCnn = new SqlConnection();
                tmpCnn = DataControl.CrConn();
                if (tmpCnn.State != 0)
                {
                    tmpCnn.Close();
                }
                tmpCnn.Open();
                SqlCommand cmd = new SqlCommand(Sql, tmpCnn);
                cmd.Parameters.Add("@myPhotoArray", myPhotoArray);
                cmd.ExecuteNonQuery();
            }