Questions I am Having Trouble With 
Author Message
 Questions I am Having Trouble With

Hi I have been studying VB.NET, ADO.NET and SQL for about 3 months. I have
been building a test app for just to see if I could do it. A friend of a
business owner showed it to them and it turned out that they liked what I
did so far and asked me to do it for real.
Here are some questions....if possible please provide code samples and
explanations. I am having trouble finding good understandable tutorials on
the net on these.

1. DataGrid - How do I make it only load say 20 records at a time and then
tell buttons to go forward 20 or back 20 etc.
2. How do I allow users to print their current datagrid view?(I have
checkboxes that allow users to select the fields they wish to see at any one
time.)
3. How do I copy the SQL database through a command button to an excel
spreadsheet format to be located on the users machine?(locally).
4. I am building a form that has a textbox(TextBox1) to type text in to
search, a combo box(comboBox2) that allows the user to select the field they
wish to search in, and a datagrid(DataGrid1) to display the results. For the
life of me I cannot get the results to display in the datagrid.
ANyone that can help with these I will be so greatful



Tue, 15 Feb 2005 23:11:13 GMT  
 Questions I am Having Trouble With

1) Open the property builder on the datagrid.  There is a Paging tab that
allows you to set everything you need to do this.
2) If you are using webforms, they should be able to print from IE.  You
just need to show the correct info on the page.
3) I'm not positive, but I think you need to create a sqp stored proc to do
this, them you can add a sqlcommand to your project to execute this.
4) If you are filling the dataset correctly, check to see if you are calling
databind(either for the whole page or your control) after you have the data
in your dataset.

Hope this answers your questions.
-Ed Smith
Visual Basic Test Team

--
This posting is provided "AS IS" with no warranties, and confers no rights.


Quote:
> Hi I have been studying VB.NET, ADO.NET and SQL for about 3 months. I have
> been building a test app for just to see if I could do it. A friend of a
> business owner showed it to them and it turned out that they liked what I
> did so far and asked me to do it for real.
> Here are some questions....if possible please provide code samples and
> explanations. I am having trouble finding good understandable tutorials on
> the net on these.

> 1. DataGrid - How do I make it only load say 20 records at a time and then
> tell buttons to go forward 20 or back 20 etc.
> 2. How do I allow users to print their current datagrid view?(I have
> checkboxes that allow users to select the fields they wish to see at any
one
> time.)
> 3. How do I copy the SQL database through a command button to an excel
> spreadsheet format to be located on the users machine?(locally).
> 4. I am building a form that has a textbox(TextBox1) to type text in to
> search, a combo box(comboBox2) that allows the user to select the field
they
> wish to search in, and a datagrid(DataGrid1) to display the results. For
the
> life of me I cannot get the results to display in the datagrid.
> ANyone that can help with these I will be so greatful



Wed, 16 Feb 2005 04:29:27 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. I am having trouble with bitblt

2. Help: I am having trouble with sendkeys

3. I am having trouble

4. Hi, I am having trouble with bar code font not working

5. VB4 Question: Having trouble changing .ScrollBars property

6. I am using the Compare MS Project COM Program and having issues

7. I am having problems with addnew

8. Help!!I am having VB homework problem...

9. vb5 i am having problems with lost variables

10. I am having probles with this code

11. Regular expression - It should be easy, but I am having a bad time

12. I am having an Identity Crisis

 

 
Powered by phpBB® Forum Software