Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 538
  • Last Modified:

Populate data from SQL Server into excel

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
sam000
Asked:
sam000
1 Solution
 
SiddharthRoutCommented:
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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now