Search results for query: *

Thanks for the assistance. Since I'm new to ASP.net I'm not exactly sure exactly how to use the Imports System.Data When I have [code] Dim strCity As String = CType(frmV.DataItem, System.Data.DataRowView)("contactcode") [\code] I get this error "Unable to cast object of type 'tblICompany'...

Good morning, I have 2 cascading dropdownlists and am attempting to bind the child dropdownlist to the parent one. I found the following code online that should rectify my issue, but need assistance utilizing it, as I am using Linq to SQL data source. Protected Sub...

Good morning, I've developed several combo boxes on my web pages that are not updating when I submit the page for updating. One such combo box possesses the following code. Company:           &nbsp...

That did it. Thanks!

Good morning, I am attempting to freeze a column is a form's subform. I have a button within the main form that allows the user to change the view of the subform from datasheet to single form view. I've added the code to freeze the subform's column to the change view button, but receive an...

Hi, Hope this is the right place to ask this, as the issue is exporting to Excel from a report. I have a report that contains a sum field that is within a group section (it is created within the report and not part of the underlying query) that I would like to export to Excel and have the...

Thanks for your help and patience. Sorry, but I'm missing something. I'm assuming this line of code is reading the field's data company ID from contact table) and not the data that belongs to the associated datasource that the dropdown control is using (which is the company ID and company...

That solved the DataRowView issue, but now I'm getting an error on the next line Dim id As String = row("Companycode").ToString() That states "System.NullReferenceException: Object reference not set to an instance of an object."

Sorry, I should have been more clear. The error is on the below line and states that "DataRowView is not a declared name". I had the same issue with rowtype and I changed it to DataControlRowType, but I can't find a corresponding one for DataRowView Dim row As DataRowView =...

Thanks for the conversion. That's a cool tool. I made some changes to the rowstate and datarowtype to better fit VB, but still can't find anything in VB that is associated with DataRowview. Thanks to your conversion I currently have the following, which is throwing an error on DataRowview...

I got through the datarowtype issue, but am now getting an error on the dataRowView row = e.Row.DataItem as datarowview line. It states that name datarowview is not declared. I can't find any associated name in VB. I currently have Protected Sub SetDropDownValues(ByVal sender As...

Jason, Thanks so much for your help. I've attempted to change your Behind code from C# to VB, but am getting an error saying that "Name 'DataRowType' is not declared." So far I have the following Protected Sub SetDropDownValues(ByVal sender As object, ByVal e As...

Hi, I am attempting to add a dropdown to a an edit template field in a gridview whose data source is table 1. The field is an integar field that is a foreign key to table 2's primary key. I'm binding the primary key and description field from table 2 as the data value and shown value in the...

Thanks again for your assistance. The error is happening in Access and the non-error server has 30 users on it. Even though the error is happening in Access, I'm thinking (I could very well be wrong) its SQL, as the same Access DB linked up to the other SQL Server (with the identical stored...

Thanks for the quick reply and your assistance. Checked both of your suggestions and that isn't it. I believe its the way each SQL Server DB is refreshing the data or possibly the locking and concurrency setting of each DB. I don't get the message with the DB when I move off of the record...

Hi, I apologize if this question should be asked within the Access forumn, but I believe the issue is with SQL. I have a back-end SQL DB connected to an Access front-end DB. When the user clicks a button the following stored procedure is run @RecordType as varchar(25), @PrimaryKey as...