Hi there, To use a dropdownlist control when the datagrid is set in edit mode, you simply use a template column and specify a dropdownlist control in the EditItemTemplate element. To bind data to the dropdownlist, you either specify the DataSource property at design time: asp:TemplateColumn ... <EditItemTemplate> <asp:DropDownList Runat="server" ID="DropDownList1" DataSource="<%# DDLDataSource() %>"> </asp:DropDownList> </EditItemTemplate> </asp:TemplateColumn> //The sample code in code-behind public string[] DDLDataSource() { string[] source = new string[3]{"Manager", "Superuser", "User"}; return source; } or do that in code at runtime, the sample code looks like this: private void DataGrid1_EditCommand(object source, DataGridCommandEventArgs e) { DataGrid1.EditItemIndex = e.Item.ItemIndex; //You code here to rebind the DataGrid. ... //I assume you want to use a dropdownlist for the first column DataGridItem item = DataGrid1.Items\[e.Item.ItemIndex\]; DropDownList ddl = (DropDownList)item.Cells\[1\].FindControl("DropDownList1"); ddl.DataSource = DDLDataSource(); ddl.DataBind(); }

Here's the code for finding the controls on the page: For Each ctrl As WebControl In Page.Controls If TypeOf ctrl Is TextBox Then Dim txtBox As TextBox = DirectCast(ctrl, GetType(TextBox)) txtBox.Enabled = True End If Next If you have any questions, let me know. ~Javier Lozano (blog)

You can do it by using the opener property of the window object from the popup window. 1) In parent window use window.open(...) to open the window. 2) On the click event of the list of hyperlink, use the window.opener property (the parent window) to access the textbox. (window.opener.document.txtLinkValue.value = 'some text') Hope this helps! ~Javier Lozano (blog)

Go to your DataGrid columns, select the Edit column and change the property "Causes Validation" to false. A nice feature of .Net 2.0 is the use of validation groups. So you can have multiple validators on a page, but they are grouped so some will fire based on one event and others will fire for another. Jeff Martin My Blog

I don't think it is possible with the current datagrid control. It requires a roundtrip (when updating) to set the ItemIndex property to a row and render itself. The only way I see this working is to create a html table with javascript and stuff. But it will not be an easy way. I may be wrong ;P sebastien.lachance.blogspot.com

gamerPotatoe wrote: System.Data.OleDb.OleDbException: Operation must use an updateable query Try to check the information from here.[^] A thousand mile of journey, begin with the first step. APO-CEDC Save Children Norway-Cambodia Office

You probably didn't add the new Line control to the Controls collection of the object onto which your drawing. For instance, if your drawing on the surface of a Form (not a picture box!), you would have to add the control to the Controls collection of the Form: Dim WithEvents myLine As Line Set myLine = Form1.Controls.Add("VB.Line", "myLineControl") myLine.Visible = True The VB.Line might be a bit different. Check in the Object Browser (F2) to see what the exact name of the control is if not VB.Line. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

The Picture component loads a picture file into its image. So to load a picture you usually specify the file name of the picture to be loaded...a file name is a string. So you need to GET the file name as string Public Property Get Picture () As String

gamerPotatoe wrote: I would like to know on how to start and where to begin. Start by designing your object model. You don't need VB to do that. You need to design an Interface for your objects that will allow you to walk your object tree. It will also need to support your design for your network simulation. You probably be make strong use of the factory design pattern. to create your objects as you need them. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

This is quite complex, but I'm gonna give it a try :) You can probably do this in two ways (without using a temporary table, that is). 1. If you're fine with the result being shown vertically: SELECT CLASS, DATENAME([month], RSRVDATE) AS Month, COUNT(*) AS Total FROM RESERVED_LEGS INNER JOIN Tickets_Purchased ON RESERVED_LEGS.PNR = Tickets_Purchased.TKTNO GROUP BY CLASS, MONTH(RSRVDATE) ORDER BY CLASS, MONTH(RSRVDATE) This should return something like: CLASS Month Total First January 100 First February 150 ... 2. If you want the result to be shown horizontally (this is more difficult): SELECT CLASS, (SELECT COUNT(*) FROM RESERVED_LEGS INNER JOIN Tickets_Purchased AS TP ON RESERVED_LEGS.PNR = TP.TKTNO WHERE MONTH(RSRVDATE) = 1) AND TP.CLASS = TicketsPurchased.CLASS) AS Jan, (SELECT COUNT(*) FROM RESERVED_LEGS INNER JOIN Tickets_Purchased AS TP ON RESERVED_LEGS.PNR = TP.TKTNO WHERE MONTH(RSRVDATE) = 2) AND TP.CLASS = TicketsPurchased.CLASS) AS Feb, (SELECT COUNT(*) FROM RESERVED_LEGS INNER JOIN Tickets_Purchased AS TP ON RESERVED_LEGS.PNR = TP.TKTNO WHERE MONTH(RSRVDATE) = 3) AND TP.CLASS = TicketsPurchased.CLASS) AS Mar, ... ... ... FROM Tickets_Purchased GROUP BY CLASS ORDER BY CLASS You can always use the query from #1 and format it to present it the way you want it to be, as I think it will be the most efficient query from both. I hope it helps ;) PS: You might want to tweak the SQL queries a bit to make it work :) PPS: Maybe there is a more efficient way to do #2. Anyone? Edbert P. Sydney, Australia.

Add a GROUP BY clause at the the end with the name of proper column and you will see that it will works. Look into GROUP BY in SQLServer Books Online for how to use it. Mazy You're face to face, With the man who sold the world - David Bowie

note it is for vb6.0 dim chkbox as checkbox set chkbox=controls.add("vb.checkbox","checkbox1") chkbox.visible=true chkbox.left=50 chkbox.height=50 chkbox.enabled=true u can also change name (the second parameter in controls.add method) by concating string