用ado.net对word,excel进行存取

用ado.net对word,excel进行存取(1)

blob表

3 id int 4 0
0 name char 50 1
0 blob image 16 1
0 type char 60 1

saveFile.ASPx.CS

  private void Button1_Click(object sender, System.EventArgs e)
  {
   Stream imgdatastream = File1.PostedFile.InputStream;
   int imgdatalen = File1.PostedFile.ContentLength;
   string imgtype = File1.PostedFile.ContentType;
   string name = this.getFileNameByURL(this.File1.PostedFile.FileName);
   byte[] imgdata = new byte[imgdatalen];
   int n = imgdatastream.Read(imgdata,0,imgdatalen);
   string connstr =  "workstation id=OVERMIND;packet size=4096;user id=sa;passWord=sa;data source=OVERMIND;persist security info=False;initial catalog=wztj";
   SqlConnection connection = new SqlConnection(connstr);
   SqlCommand command = new SqlCommand("INSERT INTO blob(name,type,blob)  VALUES ( @imgtitle, @type,@blob )", connection );
   SqlParameter paramTitle = new SqlParameter("@imgtitle", SqlDbType.VarChar,50 );
   paramTitle.Value = name;
   command.Parameters.Add(paramTitle);
   SqlParameter paramData = new SqlParameter( "@blob", SqlDbType.Image );
   paramData.Value = imgdata;
   command.Parameters.Add( paramData );
   SqlParameter paramType = new SqlParameter( "@type", SqlDbType.VarChar,50 );
   paramType.Value = imgtype;
   command.Parameters.Add( paramType );
   wztj.debug.TestSQL.TraceErrorSql("INSERT INTO blob(name,type,blob)  VALUES ( @imgtitle, @type,@blob )",command.Parameters);
   connection.Open();