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 3 7868
Hi Jason,
Answer to the first question:
select from, company, status, ddate, phonep, phones from callsheet where
completed = false
Note that you don't have to have completed in the column list and can still
call it in the where clause. Also, the order of columns is completely up to
you.
2nd q - setting the column width suggests you are in a datagrid, right? I
use the component one grid so much that I don't remember how to set widths,
but look at the object model - it has to be simple to do.
3rd q - to print the dataset, use the crystal report viewer/designer (which
comes with vs .net).
HTH,
Bernie Yaeger
"jason" <Ja**********@praxis.com> wrote in message
news:04****************************@phx.gbl... 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 -----Original Message----- Hi Jason,
Answer to the first question:
select from, company, status, ddate, phonep, phones from
callsheet wherecompleted = false
Note that you don't have to have completed in the column
list and can stillcall it in the where clause. Also, the order of columns
is completely up toyou.
You are correct, but I need to be able to modify the
completed column. How can I modify it unless it's a part
of my dataset? I want it to be there, that way I can
continue to use a datarow variable to set it when users
use the application? Do you know a way that I can modify
that variable without having to have it in a dataset? 2nd q - setting the column width suggests you are in a
datagrid, right? Iuse the component one grid so much that I don't remember
how to set widths,but look at the object model - it has to be simple to do.
The component one grid? I don't suppose you have a link
for that somewhere, I'd love to find something other than
a dataset. (of course, if I wasn't so green, I might do a
little better at it)
3rd q - to print the dataset, use the crystal report
viewer/designer (whichcomes with vs .net).
Doesn't that mean I would have to put crystal reports on
every machine?? I thought crystal reports was more for
the developer, not the end users using the application.
Or is that wrong? HTH,
Bernie Yaeger
"jason" <Ja**********@praxis.com> wrote in message news:04****************************@phx.gbl... 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
.
Hi Jason,
In order to modify a column that is not in a datatable (which is the table
or tables inside a dataset), you would have to write a stored procedure
which refers to that column even though it isn't in the datatable that is
available to the end user. More simply, you could include the column but
hide it (by setting its visible property to false) inside the datagrid
wherein it is being displayed.
The MS datagrid is fine, to my recollection, but the Component One grid is
much more flexible and performs magnificently. You can learn more about it
at www.componentone.com. There are many, many other 3rd party .net grids,
and many of them look to be very useful as well, so you should look at
others as well. If you enter '.net datagrid' in google, you should be able
to begin reviewing several of these. They're all pretty expensive, but most
come with a suite of other useful controls - costs range from about $300 to
$800 or so (which includes all of the controls).
No, you would not have to deploy crystal on all of the pc's that use the
app. You would simply have to have a setup routine that installs the
necessary .dlls. Crystal has tutorials on how to do this - it's not
exceptionally difficult. You might begin by going to www.crystaldecisions.com for some guidance. But think about it, Jason.
You'll have to build more and more sophisticated reports as time goes by -
you're not going to get anywhere, practically speaking, without a useful
report writer. And of course the end user doesn't interact with CR - they
simply perform the appropriate button click and your code executes the
report.
HTH,
Bernie
"Jason" <ja**********@praxis.com> wrote in message
news:0d****************************@phx.gbl... -----Original Message----- Hi Jason,
Answer to the first question:
select from, company, status, ddate, phonep, phones from callsheet wherecompleted = false
Note that you don't have to have completed in the column list and can stillcall it in the where clause. Also, the order of columns is completely up toyou.
You are correct, but I need to be able to modify the completed column. How can I modify it unless it's a part of my dataset? I want it to be there, that way I can continue to use a datarow variable to set it when users use the application? Do you know a way that I can modify that variable without having to have it in a dataset?
2nd q - setting the column width suggests you are in a
datagrid, right? Iuse the component one grid so much that I don't remember how to set widths,but look at the object model - it has to be simple to do.
The component one grid? I don't suppose you have a link for that somewhere, I'd love to find something other than a dataset. (of course, if I wasn't so green, I might do a little better at it)
3rd q - to print the dataset, use the crystal report viewer/designer (whichcomes with vs .net).
Doesn't that mean I would have to put crystal reports on every machine?? I thought crystal reports was more for the developer, not the end users using the application. Or is that wrong? HTH,
Bernie Yaeger
"jason" <Ja**********@praxis.com> wrote in message news:04****************************@phx.gbl... 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
.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Richard |
last post by:
Hi,
I have a form based on a table. When I filter the form I want to run a
report based on the same table with the same filter as the form. No problem
until I want to filter a combo box where...
|
by: Hardy Wang |
last post by:
Hi all:
I have a DataSet populated with values. How can I return
ds.Tables.DefaultView's records from a starting number to a ending
number?
For example, I have 100 records in the DefaultView, but...
|
by: SPG |
last post by:
Hi,
I need to be able to filter the columns that are visible through a dataset.
That is, I can have all columns in a dataset, but only some of them are
visible when filtered.
I know you can...
|
by: Mark |
last post by:
Hi - when working with datasets, is it quicker to loop through the
dataset, comparing some column values with predetermined values, or
should I apply a filter on the dataset to retrieve the values...
|
by: andrew007 |
last post by:
I have a question about dataset rowfilter.
I have a list of event table in a database. each event has start-date and
end-date column. I grab these from db and save to dataset. And then I have
to...
|
by: HAN(removethis)twister |
last post by:
Is there a way to make a DataView Row Filter filter for more than one
column? Thanks!
|
by: Thomas A |
last post by:
Hi,
I fill a datgrid with data from a xml document, it works fine
But....
Now I will to filter the data to the grid so only the data shows from
the criteria that I set.
My code now is very...
|
by: Brian Henry |
last post by:
say i have a dataset called dv
and i have a boolean value i want to filter by "b_DoesWork"
while the column name in the data view that i want to filter on is called
"Works" how would i filter...
|
by: Uri Dimant |
last post by:
Hello
We use VS 2005.
I fill a data table with simple data from database (one table) which has one
column called 'flag' filtering by numbers as 1,2,3.
Now that I have all data in data table I'd...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |