J
jason
I'll try to explain in detail what it is I'm struggling
with. I created a SQL database with one table called
CallSheet which contains the following columns:
Caller ID: <--Primary Key, auto indexed by my SQL server
From:
Company:
Status:
Date:
Phone Primary:
Phone Secondary:
Completed: <--boolean
here is the Select statement being used my my
sqldataadapter:
Select *
from CallSheet
Where completed = false
I used the where clause to try to keep from pulling down
the entire database everytime it loaded the dataset. So
at this point, I have a dataset loaded using the fill
method that displays all columns. And that's not too
bad, but there are few things that are bugging me that I
can't seem to figure out how to fix(listed by priority):
1) When the application runs, people don't need to see
the Caller ID or Completed columns. How can I filter
which columns are displayed in the dataset during runtime?
2) How can I set the column width for each of the columns
in the dataset? I realize that during runtime I can
modify them via dragging, but I would like to be able to
save people from having to do that. Anybody got any
ideas?
3) Ok, one other thing..how can I print the actual
dataset? Not the windows form, I need to output the
dataset for printing somehow, lots of documentation talks
about printing text files and such..but no one talks
about printing from datasets.
Any ideas would be appreciated, this is my first
application with Visual Basic .net, just trying to get my
feet wet.
Thanks a ton
Jason
with. I created a SQL database with one table called
CallSheet which contains the following columns:
Caller ID: <--Primary Key, auto indexed by my SQL server
From:
Company:
Status:
Date:
Phone Primary:
Phone Secondary:
Completed: <--boolean
here is the Select statement being used my my
sqldataadapter:
Select *
from CallSheet
Where completed = false
I used the where clause to try to keep from pulling down
the entire database everytime it loaded the dataset. So
at this point, I have a dataset loaded using the fill
method that displays all columns. And that's not too
bad, but there are few things that are bugging me that I
can't seem to figure out how to fix(listed by priority):
1) When the application runs, people don't need to see
the Caller ID or Completed columns. How can I filter
which columns are displayed in the dataset during runtime?
2) How can I set the column width for each of the columns
in the dataset? I realize that during runtime I can
modify them via dragging, but I would like to be able to
save people from having to do that. Anybody got any
ideas?
3) Ok, one other thing..how can I print the actual
dataset? Not the windows form, I need to output the
dataset for printing somehow, lots of documentation talks
about printing text files and such..but no one talks
about printing from datasets.
Any ideas would be appreciated, this is my first
application with Visual Basic .net, just trying to get my
feet wet.
Thanks a ton
Jason