
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