Solved

Populate data from SQL Server into excel

Posted on 2011-03-10
1
526 Views
Last Modified: 2012-06-27
Hi,

I need to populate datafrom SQL server to excel in some specific cell.

I have done that using  ADO.NET.

But I am stuck in populating data into check box.
The criteria is :

There is a status flag in a table. The value of that be 0 or 1.
That field value will be populated into a check box field in excel. The tick mark will be put in the excel check box if the field value of the database table is 1.


Please help  me.
Regards,
0
Comment
Question by:sam000
1 Comment
 
LVL 30

Accepted Solution

by:
SiddharthRout earned 500 total points
ID: 35104980
See this link

http://support.microsoft.com/kb/306125

And when you have the relevant data then simply incorporate this code.

Checkbox1.Value = Field1

Sid
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question