TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
evan liewer
NA
25
35.8k
Filter Null Columns
Sep 10 2012 6:07 PM
I have a database table that records medical tests. Each patient only takes certain tests, so out of the 10 columns, they will only have data in 4 or 5 of them.
I want to fill a dataGridView on a new form with 2 columns, one with the Column Name, and the second where a doctor can record the lab result.
Picture of the SQL database
Patient Num WBC Cholesterol Pregnant Herpes
Jon Doe "" "" NULL NULL
Desire for WinForm
DataGrid View
WBC ______
Cholesterol _______
Once the doc enters the values I will update the database.
I thought of doing this at first with XML, and I was able to write XML to the database with blank attributes, but had a hard time updating attributes and thoguht creating this new table would be better.
Reply
Answers (
5
)
Create SSIS package for backup database and restore in sql server 2008 R2?
How to interchange column name and values in a table