Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public int Insert(byte[] Byte,string Name,int userid)
- {
- try
- {
- SqlCommand storedProcCommand = new SqlCommand("Insert", con);
- storedProcCommand.CommandType = CommandType.StoredProcedure;
- storedProcCommand.Parameters.AddWithValue("@Bytes", banner2Byte);
- storedProcCommand.Parameters.AddWithValue("@name", bannerName);
- storedProcCommand.Parameters.AddWithValue("@userid", userid);
- con.Open();
- storedProcCommand.ExecuteNonQuery();
- con.Close();
- }
- catch (Exception ex)
- {
- }
- }
- public int Retrieve(int id)
- {
- try
- {
- SqlCommand storedProcCommand = new SqlCommand("Retrieve", con);
- storedProcCommand.CommandType = CommandType.StoredProcedure;
- storedProcCommand.Parameters.AddWithValue("@id", id);
- con.Open();
- SqlDataReader reader = storedProcCommand.ExecuteReader();
- reader.Read();
- byte[] arrays= reader.getBytes();
- reader.Close();
- con.Close();
- }
- catch (Exception ex)
- {
- }
- }
- public Image bytearr2image(byte[] byteArrayIn)
- {
- MemoryStream ms = new MemoryStream(byteArrayIn);
- return Image.FromStream(ms);
- }
Add Comment
Please, Sign In to add comment