minhpc_bk, I just wanted to thank you for sharing your knowledge in this particular issue. Your insights made a big difference in working out a viable solution and ultimately prevented a full conversion to the Visual Studio-based model, which has its benefits, but it may have not been well justified for adoption in this particular case. Thanx again and have a happy and prosperous 2006. angelo

I'm back w/ questions. I tried to compile an assembly that would contain the namespaces needed, just as you suggested. Since I'm working outside of Visual Studio and w/out a project, I tried doing it manually, but I got errors. The Utilities.vb file imports the following: Imports ADODB Imports System Imports System.Text Imports System.Collections.Specialized Imports System.Security.Cryptography Imports System.Web.Mail Imports System.Runtime.InteropServices Imports System.ComponentModel Imports Microsoft.VisualBasic and my batch file contains: cls C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\vbc /out:bin\Utilities.dll /t:library /r:System.Data.dll /r:ADODB.dll /r:System.Text.dll /r:System.Collections.Specialized.dll /r:System.Security.Cryptography.dll /r:System.Web.Mail.dll /r:System.Runtime.InteropServices.dll /r:System.ComponentModel.dll /r:Microsoft.VisualBasic.dll Utilities.vb pause When I try running it the server returns: vbc: Command Line error BC2017 : could not find library 'ADODB.dll' vbc: Fatal error BC2000 : compiler initialization failed unexpectedly: The system cannot find the file specified. I'm new at this and it's possible I'm screwing it up. In general though, if I comment out the ADODB, the next one: System.Text appears not to be in the library, and if I comment out this one, the next one is not in the library, and so on. My guess is I'm missing something important here, any guesses?? btw, I appreciate you help.

minhpc_bk: I've been trying to make your suggestions work for me, but... Indistinctly of the way I call the methods in the Utilities.vb code ('script' or 'Assembly') I keep getting the same response from the server: 'Namespace or type 'ADODB' for the Imports 'ADODB' cannot be found.' with a reference to the source error: Line 1: Imports ADODB Line 2: Imports System Line 3: Imports System.Text I'm lost here. Do I need to compile the utilities.vb into a .dll ?? Angelo D.

Hi minhpc_bk, Thank you for your response. In fact, I had a feeling that non-precompiled ASP.NET cannot take advantage of supporting classes. That I need to compile at least those support/utility classes into an assembly that is accessible by the pages, and you just confirmed it for me. Yes, this pages was coded in VB.NET. I appreciate your time and care in explaining the issue in elegant text.

I have a Utilities.vb page that contains a number of classes (not compiled) being referenced by a number of (in-line coded) aspx pages. Since I'm not too familiar with either ASP or ASP.NET, I was wondering if the statement used extensively in ASP classic: would still apply in .NET in this context. This application was not created using a Visual Studio Project, and the above referenced Include statement doesn't work as the server keeps returning: Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. BC30002: Type 'Utilities.DPAPI' is not defined. etc. etc.........

I've got your suggestion working fine. Thank you. The code behind now is the tricky part. I need to read into the radio button pair either a YES or a NO depending on the current value in the dataset, because at the moment none of the radio buttons are selected.

How could I add a pair of radio buttons (w/ values YES and NO) in an edit (and add new) column of a data grid? I've seen samples that have one radio button per column to select it or de-select it (used a lot in surveys) but I haven't found yet an example where the user gets a pair in one column cell.

I need to open a page in a new window when a hyperlink is clicked in a data grid? Here's my code as of now:

The form uses data from an existing record and allows to create a new one with some of the existing data. Obviously, no two records can be identical, so there's a constraint on the table that spans three columns (Logical_Name, Physical_Name, and Table_ID) preventing identical values in those three columns to be used on a new record. This works just fine SQL-wise at a prompt, because I can do inserts directly on the DB server but the aspx page appears not to be reading the modified values in the text boxes, and instead keeps sending the original values, effectively throwing a constraint violation error every time. This is the first time I'm doing this type of form in ASP.NET, so here's the code for the insert Sub: Sub subBtnClick( s As Object, e As EventArgs ) Dim strInsert, radReq As String Dim cmdInsert As SqlCommand If radYes.checked radReq = "Yes" Else radReq = "No" End If conMeta = New SqlConnection( "Server='DOHSDBS96';trusted_connection=true;Database='METADATAv2'" ) strInsert = "INSERT INTO A_T_Field (Logical_Name,Physical_Name,[Description],Edit_Mask,atfSize,atfDecimal," & _ "atfDomain,Business_Rule,Required,Default_Value,Table_ID,Data_Type_ID,Quality_ID,Status_ID)" & _ "VALUES (@lName,@pName,@desc,@eMask,@size,@dcml,@domn,@bRule,@req,@dValue,@tblID,@dtID,@qualID,@statID)" 'cmdInsert = New SqlCommand( "sTblAddNew", conMeta ) 'cmdInsert.CommandType = CommandType.StoredProcedure cmdInsert = New SqlCommand( strInsert, conMeta ) cmdInsert.Parameters.Add( "@lName", txtLogiName.Text ) cmdInsert.Parameters.Add( "@pName", txtPhysName.Text ) cmdInsert.Parameters.Add( "@desc", txtDesc.Text ) cmdInsert.Parameters.Add( "@eMask", txtEditMask.Text ) cmdInsert.Parameters.Add( "@size", txtSize.Text ) cmdInsert.Parameters.Add( "@dcml", txtDecimal.Text ) cmdInsert.Parameters.Add( "@domn", txtDomain.Text ) cmdInsert.Parameters.Add( "@bRule", txtBusRule.Text ) cmdInsert.Parameters.Add( "@req", radReq ) cmdInsert.Parameters.Add( "@dValue", txtDefValue.Text ) cmdInsert.Parameters.Add( "@tblID", txtTblID.Text ) cmdInsert.Parameters.Add( "@dtID", ddlDataType.SelectedItem.Value ) cmdInsert.Parameters.Add( "@qualID", ddlQualities.SelectedItem.Value ) cmdInsert.Parameters.Add( "@statID", ddlStatus.SelectedItem.Value ) Try c

Jon G. Thanks for the tip. It was so simple that I'm almost embarrased! I was taking the long road in thinking it through when it was simpler to turn off causesValidation on the navigation buttons and voilá! Regards to you, b-d

I have an insert row in the footer of a DataGrid. I need to validate user data on each textbox but only when the "Add Button" is clicked, otherwise empty textboxes will flag a warning preventing the user from even moving between pages. I thought of using a custom validator and checking that the add button was clicked to submit the form, but I'm not sure as to the syntax to follow. Has anyone done any of this before?? b-d:|

I have a datagrid that needs to display records given by a Select statement with a WHERE clause that is passed in a given value by variable 'appID'. For some reason I've been unable to make it work any which way I tried. As I'm not totally sure how to effectively pass a value in the context of a SQL Adapter to the DB, The last thing I tried was passing it to a variable and then to the SQL string. The compiler screams with the error: " BC30311: Value of type 'String' cannot be converted to 'System.Data.SqlClient.SqlCommand'. " Has anyone ever tried this?? I've looked around and most data bound to datagrids are usually simple queries, i.e., "Select * From Clients" with no filtering whatsoever. Here's some code: Sub BindGrid() Dim dsAppl As DataSet Dim conMeta As SqlConnection Dim dadAppl As SqlDataAdapter Dim whereClause As String = "WHERE Application_ID = '"&session("appID")&"' " dsAppl = New DataSet() conMeta = New SqlConnection( "Server='DOHSDBS96';trusted_connection=true;Database='METADATAv2'" ) dadAppl = New SqlDataAdapter( "SELECT *, Q.Type AS QType, S.Type AS SType FROM A_Table A_T INNER JOIN Quality Q ON Q.Quality_ID=A_T.Quality_ID INNER JOIN Status S ON S.Status_ID=A_T.Status_ID" & whereClause & "ORDER BY & viewstate("sortField").ToString() & " " & viewstate("sortDirection").ToString(), conMeta ) dadAppl.Fill( dsAppl,"A_Table" ) Try AppDataGrid.DataSource = dsAppl AppDataGrid.Databind() Catch exc As Exception Response.Write(exc) AppDataGrid.CurrentPageIndex = 0 End Try ShowStats End Sub :omg:

I need to assign a radio button list with a value passed through a variable from another page. This is the syntax I'm using: radOwner.Items(0).Selected = True radOwner.selectedItem.value = context.items("Owner") Something is obviously wrong because when I try to assign the "Owner" value to radOwner it doesn't work. Does anyone know how is this usually done.

HI Andy, Your suggestion is equally usable and it's actually less typing than the one I used, but in this case my problem was a typo: I had "Usage_start_Date" on my sending page and "Usage_Start_Date" on my receiving page, and since case sensitivity is crucial that small 's' in 'start' caused it not to assigned. Thanx for your input. b-d

I am unable to display a short-date value passed from a previous page. What's wrong with this syntax?? 'Sending page Context.Items.Add( "Usage_start_Date", lblStartDate.Text ) server.transfer( "appEdit.aspx", true ) 'Receiving page 'On page load I assign a date value to a text box: txtStartDate.text = Context.Items("Start_Date") 'html Thanx

Thanks for replying. The "Your value" is a string and what the SelectedValue attribute needs is an index (0,1,2,3) for the assignment to work, which I'm almost positive there's a way of getting without looping over a dataset and finding it that way. As of the past few days I've been reading about the FindByValue and IndexOf in uses such as: ddlDivName.Items.FindByValue (drDiv.getValue().ToString()).Selected = True but I'm not sure where to plug in the string value in my session variable. As it is the compiler returns: System.InvalidOperationException: Invalid attempt to read when no data is present. at System.Data.SqlClient.SqlDataReader.PrepareRecord(Int32 i) at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i) at ASP.appDetailEdit_aspx.Page_Load It shouldn't have to be so hard, right?

I need to display a value passed through a session variable to a DropDownList that is already bound to a DB table and do the same to a dependent child DDL. I hope I'm explaining this clearly. In essence I have two DDLs bound to two separate data tables. The value selected on the first DDL will 'filter' out and display only related values in the second DDL. This much is working fine. Now, what I need is to have the first DDL display a value passed through a session variable from a previous page on both DDLs so that the user begins an update session with valid current information. It shouldn't be so hard to accomplish but I haven't had much luck on this one, yet. I have read a few threads on this forum but it isn't clear to me how to apply the statement: .SelectedIndex = .Items.IndexOf(.Items.FindByValue(etc etc etc ) I'm not even working in a backcode environment as all my pages are inline coded. Any help on this subject would be deeply appreciated. a-c

I have a radio button list (or it could be a pair of individual radio buttons) that receive a value passed by a session variable from a previous page via the statement: radioButton.selectedItem.value = context.items("variable") Then, after user input, the radio button value is passed to an UPDATE statement with the @radButton variable: cmdUpdate.parameters.add( "@radButton", radioButton.selectedItem.text ) The HTML code is: When I make Selected="false" in the asp:ListItem Value="No" ... it throws the following error: Object reference not set to an instance of an object. Any ideas?

I have a page with labels, dropdown lists, and buttons, which needs to be always visible in the browser. When the user clicks a 'modify' button on this page, a web form with text boxes will open up in the form of a new popup window, so that changes can be made and submitted from this smaller popup window. Ideally, the main page should be re-loaded in the original browser window reflecting the latest udpates after the popup window is closed. I am passing variables to the popup and the code below doesn't quite behave as I wanted it to. As it is right now, I'm calling the appDetailEdit,aspx twice, but I don't know enough to write an inline javascript statement so that it opens up a popup window, passes the values I need to it, while keeping the main page in the original browser window, which will reload automatically when the form in the popup window is submitted. Thank you. :doh: CODE STARTS Sub bClick1( s As Object, e As EventArgs ) Context.Items.Add( "Application_ID", lblAppID.Text ) Context.Items.Add( "Name", lblName.Text ) Context.Items.Add( "Acronym", lblAcronym.Text ) Context.Items.Add( "Program_Area_Name", lblProgArea.Text ) Context.Items.Add( "Usage_start_Date", lblStartDate.Text ) Context.Items.Add( "Description", lblDesc.Text ) Context.Items.Add( "Field_Detail", lblFieldDet.Text ) Context.Items.Add( "DivisionName", lblDivisionID.Text ) Context.Items.Ad d( "BureauName", lblBureauID.Text ) Response.write("window.open('appDetailEdit.aspx','PopUp','location=no,toolbar=no,status=no,menubar=no,scrollbars=yes,resizable=yes')<" & "/script>") server.transfer( "appDetailEdit.aspx", true ) End Sub CODE ENDS </x-turndown>

Thank you killer, You made my day, man. thanx again. I knew there was a more efficient way of handling connectivity but I blanked out. I like your suggestion of using a single variable for a connection. Can you point me to a good example I could look at?? have a good weekend. b-d