[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 541
  • 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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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