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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Copy or print result set

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :


I want to know if there is anyway we can copy or print columns in result set of a query with the column headers.



View Complete Post

More Related Resource Links

How to copy column headers along with the query result in SS00

HiIs it possible to copy the column headers along with the query result from SQL Server 2000 Query Analyser.Thanks in advance.fjz

Using Copy.copyIntoItems() to upload a document to SharePoint, result indicates "Success" but docume

I'm encountering a problem uploading a modified document back into SharePoint 2007 (Trial).  SharePoint is not showing the update.  I'm using Axis2 1.5 and Java.

1) I've successfully checked out the Word doc using the Lists webservice, which marks the doc in SharePoint as checked out by me.
2) I've successfully retrieved the actual document using the Copy webservice.
3) After making changes locally, I'm attempting to upload the document back into SharePoint using the copyIntoItems method in the Copy webservice.

        CopyStub stub = new CopyStub();

        Options options = stub._getServiceClient().getOptions();
        options.setProperty(HTTPConstants.AUTHENTICATE, getAuthenticator());
        // If this next statement is uncommented, the call throws an exception with HTTP/1.1 415 Unsupperted Media Type.
        //options.setProperty(Constants.Configuration.ENABLE_MTOM, Constants.VALUE_TRUE);

        CopyStub.CopyIntoItems copyIntoItemsRequest = (CopyStub.CopyIntoItems) getTestObject(CopyStub.CopyIntoItems.class);

        DestinationUrlCollection destUrlCollection = new DestinationUrlCollection();
        // 11/5/2009 The following needs to be a relative URI.  Don't include http://<domain>. 
        // This will eliminate the error:

Copy Result query to anothe query


i have  tow query in one stored procedure

first query and the second one  every of them return only value

i want to copy the result of tow values in a new row in new table

as i want to check on this tow values in ado.net

i want to get only this tow values as a row not first and secon query

only a row has result of first and second query results

thanks so much

ALTER PROCEDURE dbo.Sp_Integration_Check_Item
	@ItemCode varchar(100),
	@Customer_Code varchar(100)
select ItemCode from Items where ItemCode=@ItemCode
select Survey.ID AS SID from Survey 
	join Customers on Survey.Customer_ID=Customers.ID
	WHERE Customers.Customer_Code=@Customer_Code

Control to Protect content, Restrict Copy & Print



We are developing a web application, where in, it will have a provision for the user to upload his copyrighted content. It should be viewable to the end-users but, it should not allow the user to copy or print the content. First we preferred PDF, but it is having the provision of saving the file to the local disk of the viewer. The save and print functionality shall not be allowed for the users. We cannot have any control onthe user if he uses print-screen button.

Any suggestions on any tools to achieve our gols are welcome.

Thanks in advance.

PrintPocketCE Print Pocket Excel, Pocket Word and email files

Version 3.560 (May 15, 2009):

Important bug fix: a slight difference in how some devices create fonts was causing a few devices to have significantly longer print times for large print jobs.

Adjusted PocketJet printer paper feed commands

Other minor fixes and enhancements.

Version 3.559 (Mar 5, 2009):

Added support for Martel MCP78xx printers

Version 3.558 (Aug 20, 2008):

Added support for Martel MCP78xx printers

Version 3.557 (June 27, 2008):

Fixed error in Canon printer support

Fixed COM0 port selection

Version 3.556 (June 15, 2008):

Added support for Brother MW-260

Added support for Sato MB400

Version 3.555 (Aug 8, 2007):

Added support for Pentax RuggedJet 3 and RuggedJet 4 printers

Changed Epson TM-P60 support to maximum page width of 1200 dots

Version 3.551 (Aug 1, 2006):

Added Peripheral Nomad printer support

Version 3.550 (Mar 23, 2006):

Added Panasonic JT-H200PR printer support

Added Pocket Spectrum printer support

Fixed problem with WM5.0 "inverted image" problem

bluetooth print via serial port PDA

Print via BlueTooth using PDA

how to take print out in asp.net


 i want to take print out of asp.net page..

Firstly i want to transfer this content in MsWord file in same format that is on browser screen

then i want to take automatic print out....

how can i do this

Please reply


Print command



Is there a way of setting up a print area for a part of my webpage, I only want to print a certain part of the page, when I select print at the moment it will print the whole page and the layout is rubbish!!

Visual Web Developer 2010 Express "Copy Web Site" using different login


I created a site and am trying to grant another pesron access to upload changes to it without giving them my super-user login.

I made a login for her but I can't test whether it works or not because no matter how much I "disconnect" in the Copy Web Site page of VWD 2010, reconnecting to the same site always logs in as my superuser account without prompting me for a login again.

How do I test is the account it set up correctly before having her try to upload to it?    I want to force the login to remote site dialog to pop up again to test her account.

Any ideas?

Print row count on Label



I have an SP that simply performs a COUNT(*) from a table. I'm am trying to print that number in an ASP Label. It works in Query analyzer but I cant wrap my head around how to display it in a label. Any guidance much appreciated. 

Thank you. 

Bulk Copy From Datatable To SQL Server Table


 I have read the data of a excle file and captured the data into the dataset to a datatable, now that data is to be inserted into a SQL Server table using bulk copy option. I am using -

 public bool BulkEnterData(DataTable dt, string tblName)
        SqlBulkCopy bulk = new SqlBulkCopy(con);
        bulk.DestinationTableName = tblName;

        return true;

ERROR Getting-
A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.) 

How to resolve the above problem or any other solution is available.


Active Directory and .NET: paging the search result

Hi everybody!

I have a question about Active Directory in .NET
For my project I need to fetch results from Active Directory search page by page, because later I would need to bind it to the pageable DataGrid.

I tried to use .NET library DirectoryServices for that, but paging provided by this library is transparent to the user and is used only to increase the efficiency of searching, when results are too big. I.e. I cannot tell the DirectorySearcher to give me first page, then the next or previous page, it returns me all resulting pages in one bundle.

However, what I need is to explicitely get page after page directly from the AD searcher and to be able to go at least one page forward or backward.

The solution with copying all results to the DataBase and then do the paging is not accepeted by the clent, since it is too inefficient. And since it's a Web app, I cannot keep results in memory either.

I found some hints about COM Interface, but I could not find good and detailed examples or explanations. I aslo found this line of code: DirectoryServices.Interop.IDirectorySearch.ExecuteSearch(), but I don't know which libraries should i add to be able to compile this code.

If somebody could help me out with that problem, any suggestion is welcome, 'cause this issue is eating me alive :)

Thank you!

Upload a Print Screen?


Is it possible to Print Screen and then immediately Paste into a .NET app and upload to a server?  I'd like to skip the step of the user having to first paste the screen into an image program and save as a jpg, gif, etc.  Thanks!

Reporting services in 2008 r2 how to get a report in a print button click event in my c#.net page


how to  get a report in my c#.net page button lick event also steps to call a report from asp.net to reporting services


Thanks in advance

print of crystal report


hi all

my crystal report works well but when  i want press button print instead of print ,export it to a file

what should i do for paper print?

thanks in advance  

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