.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Reading binary Data from Sql Server.

Posted By:      Posted Date: September 22, 2010    Points: 0   Category :Sql Server
 
 am trying to read data from a sql 2000 database.

one of the fields is defined as datatype:image, Length:16.

when I am in SQL management studio  and do a select for this one column

0x10285C0900000000000000007A44010000000100000002000000626E224931889FCA16AC80E78B8048B88095CB807EA08049B580E2B2804CC180FBC180FCB38048B7807CB6801EC8802FB68061C080AEBC803DBF807BB9807CB28046D1809BB98095B780E2B880C8BC80C6C98081BD8062B480E2B48061C38073BB80FBBF8094C080C9B68040C7802FB78095BC8061BF80C7C080E8BA802FB480E1C4338045C28096B380AEBE338084B480FBC180E2B68060CE80E2B680F3B48047C580C9B680ADC780E6B68094BD8014C48094C1802BB580C8B880F9CB80AEBA80E1C2801AAF8014BD80ADC6807BB980AFC78062B68048B98094C280EABE8014BD8094BF8061C1802FB380D8C580E2B98060CD80C8B98055A6802DC58095B880F9CB800ABA80E3AE8046C90080CAAB802FB080E0CA80FBBC8092D08007B28013C78011DD80018080B48980D2E880A7FE8096B280B1A18000B38094C180ACCC807DAB80D8C5802FB88095B78060C98031B48093C78049B38093C88047C08048A880FAC780AFB48014C4800EC28014BF8062BB80E1BE9A802FB78093C880C8B58047C68000B380AFB18046CE8062B680A9C88016AC8048BF80C7C08061BD80DAC98016B580AEBB8062B7801EC880E2B6807BBE80FAC38031B4807AC6802FB4807AC3807AC18046B580E1C280E2B48047C680BDB88060C78095B680C8BD8030C18030AF8093CC8015B780AEC18035BC80C8B8802EC18062B680D1C68015B580E1C18062B580B7CA807AC48063AC8013C780FBB7804ABD8014C1807CB580FBBE80B4C280FBC080FCB3802DCB80B5B58062BB807AC680B0B0807AC3


View Complete Post


More Related Resource Links

Reading and checking .CSV File and Inserting Data to SQL server

  

Hi,

I have got a page in which there is a file upload option where I have to upload/import the csv file. What I want to do is to check if the correct format of file is uploaded for instance if any other than csv file is uploaded, the system should give an error message. Also what I need to do is to check certain fields of the csv file for instance there are some mandatory fields in the csv file which should be there like name , postcode, How can I check that these fields are not empty . After performing these task, the system should automatically upload the csv file onto the sql sever 2008. Any ideas  or tutorial ... will be highly appreciated. 


Sending Binary Data from Server to Client

  

HI ALL,

I want to send a file by converting it into binary file to the client end and then it should be read by javascript which again I am passing to the OCX method.(like my OCX method accept only the binary data so i have to transmit binary data from server side to client).

Kindly provide me some solution.


MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

Accessing SharePoint 2010 Data with Server-Side APIs

  
Accessing SharePoint data in server-side solutions is one of the most common tasks that you will perform as a SharePoint developer. SharePoint 2010 provides powerful server-side APIs that enable you to retrieve, add, edit, and delete SharePoint data programmatically. SharePoint 2010 also includes the new LINQ to SharePoint technology that enables you to work with SharePoint data efficiently and easily.

Sorting Data in a GridView Web Server Control

  
The GridView control provides built-in sorting functionality without requiring any coding. You can further customize the sort functionality of the GridView control by using custom SortExpression property values for columns as well as by using the Sorting and Sorted events

Frequently Asked Questions - SQL Server Data Types

  
This is good and precise introduction and Frequently Asked Questions - SQL Server Data Types

server side does not save data when using POST data to another URL using WebRequest

  

Hi,
 I am using a IIS 7.5 on Windows 7. I have a simple application that uses System.Net.WebRequest to POST data to another URL (in fact, the server side URL is on my local computer and it is hosted in IIS 7.5).

  1.  The problem is the server does not save data from client although on the client side codes when I debug and I see the OK message return from the code line

   response.StatusDescription; // this has value of "OK"
 
 
2. How can I debug the server code side where to receive the request from client side who posts the data ?
 


The following is the codes for client who posts data using System.Net.WebRequest, and codes for server side who received posted data to save to database.


Client side codes: // also run on my local computer

public string PostIntegrationXml(XmlDocument xmlSubmitDoc)

        {

           

    &nbs

Reading data from .doc or .docx and inserting into db

  

Hello,

A vendor is providing content which needs to be inserted into the db. The content is basically questions with options and explanations. An example is below.

=========================================

OData and AtomPub: Building an AtomPub Server Using WCF Data Services

  

Learn how to use the AtomPub protocol to pump up your blogs. Chris Sells includes a practical demonstration of mapping so you can expose a standard AtomPub service from a Web site and use Windows Live Writer to provide a rich editing experience against the service.

Chris Sells

MSDN Magazine August 2010


Under The Table: Spatial Data Support In SQL Server 2008

  

New spatial data support in SQL Server 2008 opens the door to mapping and querying geometric and geographic data, allowing you to build exciting new applications.

Bob Beauchemin

MSDN Magazine February 2009


Hierarchy ID: Model Your Data Hierarchies With SQL Server 2008

  

Here we explain how the new hierarchyID data type in SQL Server 2008 helps solve some of the problems in modeling and querying hierarchical information.

Kent Tegels

MSDN Magazine September 2008


Data Services: Develop Robust and Scalable Apps with SQL Server Data Services

  

Here the author introduces SQL Server Data Services, which exposes its functionality over standard Web service interfaces.

David Robinson

MSDN Magazine July 2008


SQL Server: Uncover Hidden Data to Optimize Application Performance

  

SQL Server 2005 gathers a lot of useful data that you can use to identify areas where database performance can be improved. Here's what you need to improve performance.

Ian Stirk

MSDN Magazine January 2008


Data Points: SQL Server Management Objects

  

SQL Server Management Objects offer developers a robust toolset for backing up and restoring databases, and issuing DDL commands, as John Papa explains.

John Papa

MSDN Magazine June 2007


SQL Server 2005: Regular Expressions Make Pattern Matching And Data Extraction Easier

  

Now you can perform efficient, sophisticated text analysis using regular expressions in SQL Server 2005.

David Banister

MSDN Magazine February 2007


SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services

  

Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006


Data Points: Report Controls in SQL Server 2005 Reporting Services

  

Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.

John Papa

MSDN Magazine July 2006


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend