display an image from db in asp.net

I have Image column(varbinary(max)) in that image stored as 0xFFD8FFE000104A46494600010100000100010000FFDB004300090607080706090807080A0A090B0D160F0D0C0C0D1B14151016201D2222201D1F1F2428342C242631271F1F2D3D2D3135373A3A3A232B3F443F384334393A37FFDB0043010A0A0A0D0C0D1A0F0F1A37251F253737373737373737373737373737373737373737373737373737373737373737373737373737373737373737373737373737FFC000110800B7011303012200021101031101FFC4001B00010100030101010000000000000000000001020405030607FFC400411000020103010309050505070500000000000102030411051221911431324151525371A10613223361237281B1C1424362B2D11516637392A2E12434E2F0F1FFC400190101010101010100000000000000000000000102030405FFC4002811010002020104010402030100000000000001020311120421314151132223321452426181A1FFDA000C03010002110311003F00908C7623F0AE65D45D98F757010E847C9191F5DF2D8ECC7BAB80D98F757032004D98F757026CC7BAB8190031D98F75702ECC7BAB814013663DD5C06CC7BAB814A063B11EEAE03663DD5C0C8018ECC7BAB80D98F757032004D98F75701B31EEAE052818ECC7BAB80D98F7570322144D98F75701B31EEAE05004D98F75701B31EEAE06400C7623DD5C06CC7BAB814A061B11EEAE03623DD5C0C8018EC47BAB813623DD5C0CC60830D98F75701B31EEAE067826009B31EEAE03663DD5C0A009B31EEAE03663DD5C0A00D6AB18EDBDC80ABD3608AD887423E48A630E847C919150000000A0000000281014010A0000000001400000000000000010000500000850062565041AB57E6305ABF31832AF587423E48A21D08F922E0D200A40000005200294800A0850000000000014A0428000002028020050880A02A029000000000835EAFCC6056F98C115ED0E847C91490E847C919151014010148001401014010140003000000014800A0800A08500002800000008000280000000835AAFCC6055F98C115ED0E847C91490E847C914A8A08632AB4E0D46752316F99369640CC10A00000500010A00000A04052010A0010A0000000000101480500000000042800001AF57E6304ABF31822BDA0BE08F9194709A6E2A4BB1F5921D08F919151ECAFF004CA5FF007DA6DCD38F8946BED2F55B8D852F64EFA94A9D5B8B95092C385551945F9FC38344D4AFA75B566DEC6C4BBD078FF8385B1DFF00C65D6B7AFB87521A7681426DDA6AF7B083FD870F7905FD17D1348F5AD67A4D58D376BED0D3A2D7CC556CE536FCB1258F53E6E7A657A7BE857525D92DCCF394EEA82FB7A2DA5FB4D657138CCE4A79DBB4463B3ECD56F67A954A9B75BDED294A588C6DEA663178C2CE5EF58E7EBCB253B5D1750928E9F7B5695479C42AC1FC58C6709E1EEDA5C4F8A55EDEBD3529296C4F7A9296D27C72B81DFB2D72953A90718420A314B108A5BFADE3C8CC5ED1DE25A9AD6675A746AE837915B541D2B88F6D39EFE0F073EB50AD6F2D9AF4AA537D938B5F99D0B4D72D21395492A949B79CC1BCBDDD8B277ED7DA0D3EE3628ABAA2D4F762BAC25FFB9351D4DA3F6827A6ACFEB2F8D07DF4F42D22FE0A508D18CDF5DBD4C2E1CDE872EEBD8F92CBB4BA4FB23563FAAFE876AF5149F3D9C2705E3C3E54A74AEB41D4EDB2E56D29C57ED52F8BD39FD0E6C938C9C649A92E74D61A3B45A27C4B94C4C79000540000000000004050040654E13AB2D9A7194DF64564CA74A7059AA9535FE2350FCC93311E562267C3CC1E73B9B5A7F32EE82FBB2DBFE5C9E33D4ECA3B94EAD47DB4E9EEFF00734FD0C4E5A47B6A31DE7D3681CF9EB1497CBB69BFACAA25E897EA69D7D6EEA2F14ADE9AEC718E71FEA787C0C4F538E1B8E9EF2EE17664D6545E3B70701EA1795377BF9C5BEA8251FE51C96EAE1A94E3524FB6A3FEA63F9333FAD5AFA1AFDA5DB5529B96CAAB49CBBAAA26F864CDA69E1AC33954F4993C7BC9C57D22B26F5BDB46824A33A8D76393C703AD2D927F6873BD691E258D5F98C16AFCC60DB0F787423E48A487423E48A690000005006B46C6D62A4A14210526E5250584DBE77B8D6ABA4C25BE954717D8D651D2062D8A96F30DC64B4789706AD95ED1E845CD76C5E7D39CF1F7D70B74961F63DCCFA430AB4A9D58ECD48292FA9C2DD37F59758CFF00DA1F3BCAAAC65B934FAB06D5BEBBA8DBEEA37B734D762A923DEE34CD9CCA86F5DDEB39D38ECBD99470FC8F2DE2F49D59E8ACD6D1B876E87B69AE515857D29AEC9C232FD0D897B75A8D6495DDB585C457555B7CFEA7CCB847AB718ECAEA9266794B5A7D4FF7B2C6A2FB7D02D1FF00955674FF002664BDA0D0A7D3D26E697F97779FE647C9BDDCE88F0CDC65BC7B6671D67D3EB3FB63D9C6FE28EAB0FC694BF445FED2F6767D1BBBF87DEB784BF291F9E6B756A5BAA2E124B6F6B9FE98FEA6869B73715F52B6A12A9F0D4A8A2F1D8758C993E5CE71D3E1FA9BBCD0DF36A174BCECFF00F334EE756D26DE50CDCDCCA12E792B6E8F9FC472EE34B9D393F755E5F76714D7E8CD79D0AAA389252EDC7309CB923DA463C73E9DC9EB3A5C17C30BCAAFEAA105F9C8F096BD463F2B4F6DFF008B70E4BFDB18FE6702A5BD454E51A2A54FB37657FC12C6D751B89AA508529D4CEE8E7129792EBF25BCC4E5C93EDB8C74F8769EBF71FBBB5B487D76252FE6933C65ACEA0DB71AEA1D5F674E31FC91E10D3B508E5D7B5A94DA78C4A9CA2FD51EB4F4CBA9F4A1187DE97F427E4B7CCAFE3ABCAB5E5DDC4766BDD57AB1EED4AB292E0D9E2A297523AB4F475CF52B7E118FEA6D53D3ADA1BDC1CBEB266A3A6C93E599CF48F0E0A59784B2CDDB7D2AF6BD19D7851D8A14FE656AB254E10F37268FADB0D0EB3A51AAA853A707D184DEC6D7D5E1671F9FD39CF4AFEC93D467096B5A856B8A74FA16D6F1F73461E51CB79FAE724B63AD7B6F6DD2D36EF3DA1F9BDDDED2A33946125554777BC4DA83F2CACFA1968D7DCA351A742AD1A5529D56D26A4F31DCDF6EF3F42B3B7D06C355969D42C6950BB85252CD4A7B5379EC93CB667AB69B67BEEDDAD1E510C6CD5504A4BAB9FF00118E626D1A8874CB14AD7BEF7F3DA3FF003E3FEB914E9429AC538463E4B064507D18ECF9680A00D6ADF31815BE630655ED0E847C91918C7A11F245348A5204050320000000000A785C5AD2B88E26B7F549739EE096AC5A352B13313B87CF5E59D5B6796B6A1DA8F9EA97F415492752394FB4FD0651528B8B49A7DA7E6D7DECDEA346BCE32545BCE5627CEB81E2C986293BF4F5E3CBCFB4F96EDBDED2937F6AB0976F31B91ACA51CA6A4BB7268E81615ACE55F94C545CB0961E7274A74219CC611CF6A47098875DBCE5EEE7CF059FE2594554E8A719469D38C973349651E75E94DD36A9B709769A329D7A724A504DBEBC606976EDAB9AEBF7B26BEAF2671BB9CB74A317E872237528E36A325EA7A46F69E712C0DC9A875D5C43656DC2482546A2DCD60E6C2B5293CA9B5F8E0CD624BE09E7F02F294E2FAED235FA96D693B3AF2752838B51DADF84FABC8E0D96ABAA69CA2AB5BD2BBA6B9E35E9ED3FF5477F1C9A49D58ADDBFC998D6D52368E2AB4DA72784B19375BE989A6DF6BA4FB55ECF5E629DF69F0B4A896F9B79A7C56F5F8AC1F594ADEC20E3568DAD1ED8CA293F2699F84DCDC5C6AD7939DA41C9421B0B7A5CFD6F27E81EC66BD5743D0E869B7968EB469CA6D4A3252C2949CB1F867B4B3333E248888F2FBBB9BDAD083951C4A4B7ECCB99FF00C9C3B8F68AAC73F66A0FB6304D1B16FED1E8B7938D393A942AC9E146517FFCF53CF54D269DDC2552CAAC2736B7C1B516F8EE39CC35B7CF5DEB72E52EE69D5A51AF871F79EEA0A5878CACE33D4B81CDB9D76FEAA7195CA945F538471F919EAB615ADE5B1714674E4DEEDA58CF9769A3676CDD74A357DDCB9E2D2355A4CCF64B5E35DD55D6A35BE554A8FEE2C7E47AAA3AA554B35670FACAA7F43A74DDC7EFEAC6A7F16C61FE3DA7A1EAAE0EDF74CBCF6CDFD621A96F42F218F7B76A4BAD6C67D79CDB00ED5AC56350E36B4DBCB5AB7CC60B5BE63007B417C11F245C087423E48A691014010170008500002140A0800A7235B8FDAD397F0E3D4EB64E7EB11CAA4FEAD7E471EA23F1CBAE19FBE1C849BDC65EEF0F7BFC0F58C52338A727D583E6BDFA6BCA9B5FBB93ECD9793C2784F0F77D24B077AC28665EF65CCBA3E66ED4A70A8B1521192FE2593D38F04DABBDBCF7CD15B6B4F9174E12E78A66B5C69B42BE36B6A2D7334CFADABA5DA54DFEEDC1F6C5E0D5ABA2EE7EE6BB5D8A4BFA09C19208CD497C94F4EA96A9D6A174E3EEFE2DFBB183A7A26B50BDBCB7B6BCB3A529D55855A09269A4DEFF00A6E153D9BD66E54A9D7BBB58D2936FE16DE3B376CACF13B9A7FB3FA769F5E1714694A55A0B0A739B78DD86D2E64CE98F1DF7DD9C9929AFF6F7A9A5DBCDE63B51F2669D7D136F9A509FDF89D9076B60C73E9C6335E3DBE75E95714FA30DDFC2454AEE97ECCD7E07D1839CF4D1EA5D3F913EE1F3FCA6AE315209F9A3DA8EA35697CBA9569FDC9BC70E63B58CF3984A8D29A6A54E0D7D6289F42DF27D6AFC35A1AFD79D2746EAA2AF49F3C6A417E86B46AD18D45521249A7B9499BFC92DBC0A7FE9460F4FB4CED7B8867B4461BC78D24E5ACF929DD539F5AF34F28D8EA52EA7CCFB4D7E416D9CFBAC3FA49AFD4F5A542149BD8DADFD4E4DA5C4EF5E7EDCA78FA660036CB5AAFCC6055F98C1956C43A11F245243A11F246469000000000000018050311832006269EAABFE9E32EECBF437B061529C2AC1C26B317D466F5E55986A96E36897CDFBD9A9F34767D4D8B283AF55538F9C9F623A33D2EDE5D1DB8F933DAD2D616B16A1BDB796D9E4AF4D3BFBBC3D36EA235DBCBDA31508A8C7725B91403DAF22820028214000020000A10A0080A0204280A80A4035EAFCC6055F98C1957B43A11F2464630E847C9191A400000000002800000000000001828026060A009821910080B8180202E08050400000050428000000001AD5BE6302B7CC60CA90BBA1B11FB4EA5D4CCB95D0F13D1804E52BA395D0F13D18E5743C4F4600E5271395D0F13D18E5543C4FF6B00729389CAE8789E8C72BA1E27A3007293472BA1E27A32F2BA1E27A3007293472BA1E27A31CAE8789E8C01CA4E272BA1E27A31CAE8789E8C01CA4E272BA1E27A31CAE8789E8C01CA4E272BA1E27A31CAE8789E8C01CA4E272BA1E27A31CAE8789E8C01CA4E272BA1E27A31CAE8789E8C01CA4E3072BA1E27A31CAE8789E8C01CA4E272BA1E27A3272AA1E27A3007293472BA1E27A31CAE8789E8C01CA4D1CAA8789E8C72BA1E27A3007293472BA1E27A31CAE8789E8C01CA4E272BA1E27A31CAE8789E8C01CA4D35EADD50F78FED3D18009CA578BFFD9

how to bind in gridview or repeater...

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

13y ago
You can convert the varbinary to Image then associate with grid controls.

using System.Data.Linq;

public static Image ConvertToImage(Binary iBinary)
{
var arrayBinary = iBinary.ToArray();
Image rImage = null;

using (MemoryStream ms = new MemoryStream(arrayBinary))
{
rImage = Image.FromStream(ms);
}
return rImage;
}

Hope this helps you.
0