C#怎么把存如到SQL中的视频二进制流取出来并显示出来？高手进~~~~~[痴迷.NET]~~~~~~

[suihuan111]

问题如题：
C#怎么把存如到SQL中的视频二进制流取出来并显示出来？
把视频存入SQL代码：
openFileDialog1.Filter = "AVI文件(*.avi)|*.AVI";
if(openFileDialog1 .ShowDialog ()==DialogResult .OK )
try
{

string str = openFileDialog1.FileName;
FileStream fs = new FileStream(str, FileMode.Open);
byte[] avbytes = new byte[fs.Length];
BinaryReader br = new BinaryReader(fs);
avbytes = br.ReadBytes(Convert.ToInt32(fs.Length));

SqlConnection con = new SqlConnection("server=(local);User ID=sa;password=sa;database=AVI");
con.Open();
SqlCommand com = new SqlCommand("insert into 视频 values(@avList)", con);
com.Parameters.Add("avList", SqlDbType.VarBinary );
com.Parameters["avList"].Value = avbytes;
com.ExecuteNonQuery();
con.Close();
MessageBox.Show("添加视频成功！", "操作提示");

}
catch (ApplicationException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;

}
从SQL中将视频二进制流取出代码：
。。。。。。。。。。
。。。。。。
。。。。。。
等待您接力

[A海阔天空]

没做过视频，做过图片

 string strImageID = Request.QueryString["id"];
        SqlConnection myConnection = new SqlConnection(this.objUserInfo.ConnectionStringGirls);
        SqlCommand myCommand = new SqlCommand("Select ImageName, Image from ad Where Id = '" + strImageID + "'", myConnection);

        try
        {
            myConnection.Open();
            SqlDataReader myDataReader;
            myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
            if (myDataReader.Read())
            {
                Response.Clear();

                Response.ContentType = myDataReader["ImageName"].ToString().Substring(myDataReader["ImageName"].ToString().LastIndexOf(".") + 1, myDataReader["ImageName"].ToString().Length - myDataReader["ImageName"].ToString().LastIndexOf(".") - 1);
                Response.BinaryWrite((byte[])myDataReader["Image"]);
            }
            myConnection.Close();
        }
        catch (SqlException SQLexc)
        {
            Response.Write("<script>alert(" + SQLexc.ToString() + ");</script>");
        }
        Response.End();

但是你这个把视频存在数据库中也太大了

[zgke]

SqlConnection con = new SqlConnection("server=(local);User ID=sa;password=sa;database=AVI");

SqlDataAdapter _DataAdapter = new SqlDataAdapter("Select avList from 视频");


DataTable _Table =new DataTable();
_DataAdapter.Fill(_Table);

byte[] _AviBytes =(byte[])_Table.Rows[0]["avList"];


//保存到文件
System.IO.FileStream _AviFileStrem = new System.IO.FileStream(@"C:\" + Guid.NewGuid().ToString() + ".avi", System.IO.FileMode.Create, System.IO.FileAccess.Write);
_AviFileStrem.Write(_AviBytes,0,_AviBytes.Length);
_AviFileStream.Close();

[suihuan111]

顶起

问题已解决

谢谢zgke