Database

Jerry Hammond wrote:

Is this a better method than detach and attach?

Aaron VanWieren wrote:

The whole point of detach and reattach is to provide a means to share databases

Aaron VanWieren wrote:

it is allot simpler than backing up and restore method

Pete O`Hanlon wrote:

When you post a question like this, you need to provide more information than this.

Colin Angus Mackay wrote:

Looks like he didn't want to provide more information.

public void Load(object dbField)
{
     Clear();
     if (dbField != DBNull.Value)
     {
          byte[] buf = (byte[])dbField;
          _ms = new MemoryStream(buf);
          _bm = (Bitmap) Image.FromStream(_ms);
     }
}

public object Save()
{
     if (_bm == null)
     {
          return DBNull.Value;
     }
     else
     {
          MemoryStream ms = new MemoryStream();
          _bm.Save(ms,_bm.RawFormat);
          byte[] buf = ms.GetBuffer();
          ms.Close();
          return buf;
     }
}

kayos592 wrote:

When executing the above code, you will enter the first @Err condition but not the second.

kayos592 wrote:

Both errors produce the same Severity level so I'm not sure why it resumes on one but not the other.

<br />
CREATE TABLE TestTable<br />
	(Field1 INT)<br />
GO<br />
<br />
DECLARE @Err INT<br />
<br />
SELECT * FROM TestTable WHERE field1 = 'ABC'<br />
SELECT @Err = @@Error<br />
	IF @Err <> 0<br />
	BEGIN<br />
		PRINT 'Im In Error Handling number 2'<br />
	END<br />