/// <summary> /// Return stream private extenstions, just for testing.. /// </summary> /// <param name="streamID"></param> /// <returns></returns> public static Hashtable GetStreamPrivateExtensions(int streamID) { String query = "select privextns from stream where stream_id=" + streamID; if (!DatabaseUtility.openAndExecute(query)) { return(null); } try { if (reader.Read()) { System.Data.SqlTypes.SqlBinary sb = reader.GetSqlBinary(0); byte[] ba = sb.Value; object o = Utility.ByteArrayToObject(ba); Hashtable h = (Hashtable)o; return(h); } } finally { DatabaseUtility.cleanUpConnection(); } return(null); }
/// 带参数的sql语句,单参数 /// <param name="sqltext">sql语句</param> /// <returns>返回大字段参数</returns> public static System.Data.SqlTypes.SqlBinary ExecuteBinarysqlToBinary(string sqltext, string connstr) { System.Data.SqlTypes.SqlBinary sb = new System.Data.SqlTypes.SqlBinary(); System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(connstr); try { System.Data.SqlClient.SqlCommand scomm = new SqlCommand(sqltext, conn); conn.Open(); System.Data.SqlClient.SqlDataReader sr = scomm.ExecuteReader(); if (sr != null && sr.HasRows) { sr.Read(); sb = sr.GetSqlBinary(0); } sr.Close(); } catch (System.Data.SqlClient.SqlException ex) { throw (ex); } finally { if (conn.State.ToString() != "Closed") { conn.Close(); } } return(sb); }
protected void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here Response.ContentType = "image/jpeg"; int width = 110; int height = 140; if (Request.QueryString.Count >= 3) { width = int.Parse(Request.QueryString["w"]); height = int.Parse(Request.QueryString["h"]); } string s = " SELECT * FROM dbo.tbl_Core_PeopleImages "; s += " WHERE (PersonId = '" + Request.QueryString["id"] + "' ) "; s += " ORDER BY ImageDate DESC"; Encode en = new Encode(); string db_connection = en.GetDbConnection(); using (SqlConnection cn = new SqlConnection(db_connection)) { cn.Open(); using (SqlCommand cm = new SqlCommand(s, cn)) { using (SqlDataReader dr = cm.ExecuteReader()) { if (dr.Read()) { System.Data.SqlTypes.SqlBinary b1 = new System.Data.SqlTypes.SqlBinary(); b1 = dr.GetSqlBinary(2); byte[] b3 = new byte[b1.Length]; b3 = (byte[])b1; MemoryStream ms1 = new MemoryStream(b3); Bitmap myImage = new Bitmap(ms1); myImage.Save(Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg); } else { Bitmap b = new System.Drawing.Bitmap(width, height); Graphics g = Graphics.FromImage(b); g.FillRectangle(new System.Drawing.SolidBrush(System.Drawing.Color.White), 0, 0, width, height); b.Save(Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg); } dr.Close(); } } } }
private void Insert() { using (SqlConnection Connection = new SqlConnection(Properties.Settings.Default.SkyDatabaseConnectionString)) { var binaryContent = new System.Data.SqlTypes.SqlBinary(Content); Connection.Open(); SqlCommand command = new SqlCommand() { Connection = Connection }; command.CommandText = "INSERT INTO [Message] VALUES(@user_id, @chat_id, @ContentType, @content, @date)"; command.Parameters.Add(new SqlParameter("@user_id", User_id)); command.Parameters.Add(new SqlParameter("@chat_id", Chat_id)); command.Parameters.Add(new SqlParameter("@ContentType", ContentType)); command.Parameters.Add(new SqlParameter("@content", binaryContent)); command.Parameters.Add(new SqlParameter("@date", Date)); command.ExecuteNonQuery(); } }