dynamically creating a web page 1

[andyd273]

I have a web part that pulls information from a database, puts it into a table and displays in on the web page.
My boss wants me to take the table with the information in it and put it into another web page.

I'm using vb.net 2003 to do the writing, and I'm fairly new to this side of things, and so I dont know how to make this work.

two ways I can see it working (though I dont know how to accomplish either, yet) is to either compile all of the html for the table, and then somehow magically create a new blank browser window and put the table html in as the body.
Or have a second webpage/webpart that has the functions it needs to compile the table, and somehow pass the needed information to look up the correct record from the database.

My problem is that I dont yet know enough to make either of these work, and am having trouble finding this stuff anywhere online or in books. if anyknow knows how to do either of these or knows of something that will work better and can give me a hint as to where to look for a solution, I will be very grateful.

 

[jbenson001]

Why not just put the same web part on another page?

 

[andyd273]

Its the passing of information between webparts, especially webparts on seperate pages, that I dont know how to do.

He basically wants the list of customers on the main page, and the fact sheet to show up on a second page.
What is a good resource to looking up how to do this?

 

[jbenson001]

So basically you want a master/detail type page setup? the first page has the master, then you choose one, and the second page has the detail?

 

[andyd273]

Yeah, that describes it good.

 

[jbenson001]

How are you displaying the Master data? Is it just in a table? How are you going to allow the user to select a row?
Or are you using a datagrid or gridview?

 

[andyd273]

Datagrid
the first section of the table:

/code

dgCustomer = New DataGrid
Dim newColumn As BoundColumn
Dim btnColumnSelect As ButtonColumn

dgCustomer.AllowPaging = False
dgCustomer.HeaderStyle.Font.Bold = False
dgCustomer.HeaderStyle.BackColor = Drawing.Color.DarkBlue
dgCustomer.HeaderStyle.ForeColor = Drawing.Color.White
dgCustomer.HeaderStyle.Wrap = False
dgCustomer.GridLines = GridLines.Both
dgCustomer.SelectedItemStyle.BackColor = Drawing.Color.AliceBlue
AddHandler dgCustomer.SelectedIndexChanged, AddressOf myGrid_IndexChanged
dgCustomer.AutoGenerateColumns = False

btnColumnSelect = New ButtonColumn
btnColumnSelect.ButtonType = ButtonColumnType.LinkButton
btnColumnSelect.CommandName = "Select"
btnColumnSelect.Text = "Select"
btnColumnSelect.Visible = True
dgCustomer.Columns.Add(btnColumnSelect)

/end code

the rest of that function sets the rest of the cells, and then else where I read the data in from the database and fill in the lines.
The customer is selected by clicking on a button, which pulls in more data, and that generates a html table with all of the stuff filled in.

 

[jbenson001]

When the user clicks on the select button, grab the key value for that row, then pass that to your details page, and query the database again to get the detials and display them.

 

[andyd273]

That sounds like a good idea, but for some odd reason I'm having trouble finding anywhere that tells how to do that.

Also, does it make a difference on how you do it if its part of a sharepoint portal page?

 

[jbenson001]

something like:

Private Sub dg1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles dg1.SelectedIndexChanged
   dim key as integer
   key = dg1.DataKeys(e.Item.ItemIndex)
   Response.Redirect("YourDetailsPage.aspx?ID=" + key.ToString)
End Sub

Your Details Page

'In the form_load evetn
dim Id as integer = Request.QueryString("ID")
''Use ID for your queery

you can also use a session variable if you like

Jim

 

[andyd273]

Thanks for the tip.

I'll give that a try (possibly next week, as its just about time to go home for the day)

Much thanks

 

[jbenson001]

alright.. good luck