I am using the following code in my program's save method:
aGuestsTableAdapter.Update(guestsDataSet)
This appears to update the .mdf file in the inDebug folder but the update does not make it all the way through to my original data source .mdf file in my Solution Explorer.
I have Visual Studios 2008 and a VB windows application.I just started to get the error "Source code is different from original version" Searches show this means that I may have made changes while in debug. I hope this is not serious cause I made quite a few.Is there any way to fix this? To make the current code "valid" so I can debug again?
View 2 RepliesI recently acquired a job as IT Support/Developer for a small company. I inherited responsibility for their customer relationship managing system("CRM"). I did not build the web application, but I was expected to remove small bugs and input improvements. The version of the application was it was running on the live server was obviously in its release build, with all code-behind files compiled and hidden away.I was able to find the original application project folder with the aspx and vb source files contained within. I installed Visual Studio 2008 with SP1 onto my work machine, and opened the application as a website. Initially the problem I had was the breakpoints weren't working because the correct symbols weren't being loaded. After a large headache I was able to track down/ generate the correct pdb files, and it stopped complaining about that.As it stands, I can build the website and run it in the debugger. In its completely unmodified state any breakpoints inserted work perfectly fine, however, as soon as I add or modify any new code, the breakpoints cease to work; "Breakpoint will not currently be hit. Source code is different from the original version." As far as I can tell it does not matter which code-behind file I edit the code within, as soon as I make any changes, the breakpoints stop working.Things I have attempted to solve the problem:
-Save and rebuild the website after each change I make.
-Restart Visual Studio.
-Restart my computer.
-Ensured the debugger is set to "Debug" and not release, verified this within the web.config file with "Debug=True".
-Uninstalled all versions and reinstalled the .NET Framework versions 2.0 and 3.5 with the belief that the references assemblies may be incorrect or out of date.
-Tried disabling/enabling/re-enabling various options in the debugger section of the options including "Enable just my code", "Require Source code to exactly match". The latter seemed to make the breakpoints work, but they would appear to randomly jump, obviously pointing to the wrong place.
-Examined the list of modules/output displayed during runtime to ensure the correct assemblies were being loaded, as far as I can tell, they are correct.
-Tried converting the website into a web application project, in order to gain access to the "Clean Solution" option, to no effect (indeed, converting to an application seems to generate even more errors, I'm assuming because the syntax enforcement is much stricter in a project rather than a website).
-Tried deleting the temporary asp.net files for the application.
-Tried redirecting the version of the .NETFramework stated in the IDE to an earlier version. I did this because I noticed the temporary asp.net files created on runtime come under the 2.0.50727 directory yet in the IDE it states it's directed toward version
3.5, however redirecting to version 2.0 not only didn't fix the breakpoints, but created additional errors.
-Contemplated deleting the bin and obj directories, however after attempting to delete the bin directory a large number of errors were thrown, thus I assume the dlls contained within are required to even run, and are not constructed on runtime.
I have a couple of suspicions of what could be wrong:
-The version of Visual Studio used to originally create the application is different from what I'm using now, could this affect the code?
-I need to get it working as an application, not a website. I suspect it was originally created as a web application because the original directory contains a "My Project" folder.
-The symbols/pdb files, while the IDE shows them as being loaded, are still out of sync. If this is the problem then I believe it probably does not lie with the pre-built Microsoft dlls, but rather those created independently as part of the application.
I suppose ultimately I don't understand why rebuilding, website or not, doesn't synchronize the source code with the changes I make. I have been agonizing over this for days now and I truly at my wits end. There's probably some very simple option or configuration.
I have several combo boxes which are mapped to the same datasource (an array), when user selects one combo box, all other boxes are get updated to the same selection too. what is the problem?
View 10 RepliesHow Do I update a data source link of an excel File from VB.net?I need to update data source links when saving an excel file. All of this through vb.net app
View 1 RepliesHow to update DataGird View created in Data Source were I have use manual connection in editing , updating ,saving the database? I want when I create new account, it will update the current drag an drop datagrid view.
View 1 RepliesI have the code
[Code]....
Then while the box pop up I click No button, the program should exit sub but actually it is not. The code looks stick somewhere else. hat I found is that PHP
[Code]....
I'm using a MS Access 2007 database. I modified the field definition of one of the fields in a table, it a text field and I change the maximum length from 40 to 150. I have a data source in my app that contains this table and many others. I refreshed the data source but the change didn't take affect. I went through configure option but the change still didn't take affect. It gives me this error,
The value violates the MaxLength limit of this column.
If I add/delete a database field the data source is updated when I go through the configure process. I finally just deleted the table from my data source and then added it back.
I've made a dataset using the dataset designer, and I'm trying to add a column to reflect changes made to the database (added a column, nothing fancy). Is there a way to 'refresh' the dataset schema from the datasource without deleting my adapter (and all the methods and queries I've created)?
View 2 RepliesI refreshed my data sources to include additional items from the SQL Server databases and it appears that my entire data source from my VB.NET project disappeared.I am using Entity Framework. I may have clicked on something wrong, not quite sure. Unfortunately I can't recreate the Data Source without creating a new Entity and Data Model.I can delete the entry in the App.Config file and recreated it, however things aren't quite right.Is there a way that I can recreate my Data Source from the entry that is in my App.Config file...since that appears to have remained intact.BTW, I can go to my Data Model and successfully refresh from there, however my project isn't connecting to the database so I have quite a number of errors until I can get reconnected.
View 4 RepliesI am updating a data table (dt_report_crypt) from an encrypted csv file in the code below:I decrypt the colums and update the same dreport_crypt, such that it will contain de-crypted data.This part is working wellI however need to use this de-crypted datatable as a data source to update a second table(dt_report), using the sql SELECT command to filter relevant data,
Dim dt_report As DataTable
Dim dt_report_crypt As DataTable
Using cn As
[code].....
I have an Access database and I want to view on a datagridview specific rows. For that I used the following :
CasesBindingSource.Filter =
"OfferDate Between #1/1/1997# And #12/31/1997#"
Cases is the table, OfferDate a field of the table wich is DateTime type.
When I use Between operator I get the following error :The expression contains unsupported operator 'Between'.
I have a .csv file with data as below
[Code]...
I want to be able to click on the save icon and have the data on the form save to the original database. Right now I seem to have a disconnected dataset I have tried to change everything from read only to a false statement but it just will not work. It saves to the form fine just not the orignial data base.
View 3 RepliesMy application uses several checkedlistbox controls, datagridviews, and textboxes.I'm using the checked list box to provide a more intuitive interface for the users -- they know what they selected by the check mark.I have a binding source for all the individual textboxes (they are in one table) and a binding source for the datagridviews.I use the insertonsubmit and deleteonsubmit for changes made in the listboxes.I can then use the getchangeset to determine if any changes were made to the record.My problem is that sometimes a user only wants to "test" inputs to a record but may not want to have those changes actually made to the database -- or an error was made and they want to "undo" the inputs.How do I remove the unwanted changes and allow the user to continue working with the original data?
View 7 RepliesI can't get my binding source to update from a DataGridView
This is how I'm loading the dataset into the dgv:
vb.net Dim sFileName = filelocation & "Checks.xls"
Dim connectionStringTemplate As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 12.0;HDR=Yes;IMEX=1"""
Dim connectionString As String = String.Format(connectionStringTemplate, sFileName)
Dim sqlSelect As String = "SELECT * FROM [Sheet1$];"
Dim workbook As DataSet = New DataSet()
[Code]...
My issue is as follows.I have 3 Textboxes bound to 3 fields in a Dataset. TextBox_Rate , TextBox_Hours , TextBox_Salary .What i needed was for TextBox_Rate + TextBox_Hours to be = TextBox_Salary . found out that this can be achieved by use of a Multibinding and a Converter .The Multibinding looks as follows:
<TextBox FontSize="14.667" HorizontalAlignment="Right" HorizontalContentAlignment="Right" Style="{StaticResource TextBoxStyle}">
<TextBox.Text>
[code].....
I am developing a VB.Net windows application to replace a legacy Access database. I started with the legacy database (.mdb) and made changed to tables (like deleting unused columns) and changing anniversaries from 3 columns (day, month, and year) to DataTime etc recognized the need to import data from the legacy system at the time when the new one goes live and wrote an import dialog to do this. And this is where my problem is. The importer correctly imports the data and writes new tables, but each time I restart the application I have the old data back.
This is the approach I took:
In the load event I fill each tableadapter in the new (target) dataset as follows:
Me.ClientInfoTableAdapter1.Fill(Me.DataSet1.ClientInfo)
[code].....
I was wondering if it was possible to make a program edit itself and save kind of like memory however unlike memory it can add content as well as save it.
I know it seems crazy but, i was wondering
I have an existing project written in VB.NET using Visual Studio 2005 communicating to a SQL Server 2005 database. The database was migrated to a sql server 2008 r2 on a different physical server so the dataset's server name needs to be updated. I do not have access to the database anymore. is there a way to just update the server name without invoking the dataset wizard and requiring a connection to the database?
UPDATE: I tried to created a new project with just a button with the command calling the following subroutine to test the connection from a windows app to the sql server database. here is the sub:
Public Conn as New ADODB.Connection
Public Sub PubSubConnectToDB()
Conn.Open("Server=w2k54
[Code]....
I am able to created a system dsn on the same server with the same credentials and test the connection successfully.
I have a textbox with its Text property bound to a datasource. How do I update the datasource in code?
View 3 Repliescontinuing on from my original post about datagridview.... [URL]
is there any working examples of implementing add/update/delete using the binding source?
i have a datagridview that has a bindingsource as its datasource and i am wanting to provide Add/Update/Delete functionality on the grid itself. Each record has a delete button which when clicked will remove the row and then add/edit is performed in the grid itself
the user then clicks a save/commit button that will then perform the nessecary updates on all rows
my initial plan was to have a copy of the data (iList) and then compare this to the contents of the binding source data to confirm whether to add/update or delete the record
also upon clicking the delete button i cant get it to remove the row from the datagridview. it thought i could do something like this...
Private Sub dgvDocumentTemplates_CellContentClick(ByVal sender As Object, ByVal e As DataGridViewCellEventArgs)
If (e.ColumnIndex = 6) And (e.RowIndex <> dgvDocumentTemplates.Rows.Count - 1) Then
[Code].....
I have a 'SrcDirectoryTextBox' which stores a folder nameThis folder name is read in from the .ini file I have created and works okI also have a srclistbox which is filtered by a *.fil (filetype)I can read in the ini file and display it, but how do I make the srclistbox trigger after the ini file has been read, so that it displays the filenames.
View 2 RepliesModifying data with the ListView's EditItemTemplate by programmatically settings its DataSource property and calling its DataBind method. I don't have option to use data source control for ListView. All ListViews are bound with data from code-behind. So, I have to handle the Edit/Update mode of ListView manually. [Code]
View 2 RepliesI'm trying to connect a VB application (2010) to an MS Access DB by adding a data source from the data menu but I receive this error message "The connection you selected uses a local data file that is not in the current project.Would you like to copy the file to your project and modify the connection ?
If you copy the data file to your project, it will be copied to the project's output directory each time you run the application" and the options are (yes , No , Help)
If I choose Yes I will not be able to make the application 'device independent ' since it will not be copied under the bin , and if I choose No , changes won't be applied to the DB
how to use the VS 2010 IDE tools in a way the Microsofties didn't specifically intend. But since this is something I immediately tried without success.
I have defined a .NET 4.0 WPF Application project with a simple class that looks like this:
Public Class Class1
Public Property One As String = "OneString"
Public Property Two As String = "TwoString"
[Code]....
The expected result was that "OneString" would appear next to "One" and "TwoString" next to "Two" in the running window.
The question is: Why didn't this work? What will work instead? If I put bindings in a DataTemplate, it works. Blend, with its sample data stuff, implied that this should work, but it doesn't.
I have 5 combo boxes that need to show the same list of items that come from a single dataset table. I have managed to bind the datatable to the combo boxes no problem at all.. but when I run the application and select an item from one of the combo boxes all the others change to the item I selected. After some research I believe that this problem is something to do with using the one datasource so I have tried assigning the dataset datatable to 2 different variables and used them as datasources for 2 of the comboboxes but the same still happens.
A work around to this I can see is to call the same methods and SQL select statements 5 times over to get individual datasources for each combo box but this doing that sounds crazy to me. how I can get around this easily? Code snippet below shows 2 combox boxes and their datasources. I'm using VS2005, .Net 2
ComboBox1.DropDownStyle = ComboBoxStyle.DropDownList
ComboBox1.DataSource = AllergyListDataSet.Tables("ListOfAllergies")
ComboBox1.DisplayMember = "Condition"
[Code]....
can data reader be used as a data source for a grid control?
View 5 RepliesI have a combo box with a data source. This box shows one column of a table and allows me to select one item.Next, I have an ordinary text LABEL that I need to put text from another column of the item selected above.I tried to set the data binding field of the label, but this grabs only the first row or data and shows the selected column. That is nice, but I can not figure out how to update the selected selected ROW when the combo box item is changed.In this case the combo box lists a bunch of inventory parts. When I select a specific part, I need the change the text in a label to show the manufacturer. (like a sub-form). This same behavior will be used in several other places, but the relationships can cascade.
View 4 Repliesi'm got this sql query code in dataset designer
SELECT pkt.fldPackageID, pkt.fldPSID, pkt.fldQuantity, pkt.fldQuantityUsed, pkt.fldRetail, pkt.fldPK, ps.fldName
FROM tblPaketRow AS pkt INNER JOIN
tblProdukDanService AS ps ON ps.fldID = pkt.fldPSID
WHERE (pkt.fldPSID = @param)
I'm trying to display the results in datagridview,i drag from the data source in vs 2008..I can't figure out to do that.I use this code to set the @param on form_load event.
Me.TblPaketRowTableAdapter.JoinTable(SalonDataSet.tblPaketRow, modCommon.s)