OK so I did a noob screw up, I was cleaning my application and delting unused data sources and unused data bindings. Now my form is blank! All code shows up for the form and all items still show in the mainFrm.Designer.VB
View 4 RepliesI'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 am running into some difficulty with the .NET garbage collector. i have a custom control that i need to dispose and reallocate depending on user interactions. calling ctrl.dispose() and then instantiating a new control accomplishes what i want, with the nasty exception that the garbage collector (at least, i am presuming this is the GC, since this exception will happen on it's own after the application has been idle in the background for several minutes) will then periodically throw an exception: "cannot access disposed object
View 4 Repliesbasically i had this problem before which i fixed with this code!
'REMOVE TIME
If ListBox1.SelectedIndex <> -1 Then
Dim Box As MsgBoxResult = MsgBox("Are you sure you want to remove this time?", MsgBoxStyle.YesNo)
[Code]....
It worked perfectly, all ive done to my code since is change the way the listboc is loaded / saved, it now comes from a .txt in My Documents rather than the C drive.
It now only deleted the top value of the group selected int he listbox and not all of them as it did before.
i have a query as i am using a data griid view which has 7 colums one off these colums is a combobox"item"
for the list of items in this combobox i want to pick from a database table
Dim Conx As String
Dim DBx As String
Conx = "Provider=Microsoft.ACE.OLEDB.12.0; "
[Code]....
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.
how can I remove a source file from a Visual Basic 2008 express project withtout deleting it??
I tried Build Action None and I get plenty of errors concerning .Dessigner file.
Most of the VB.net windows application I have created so far have been working off a local server. To add a data source I click Add New Data Source and then database and then connect to the database by linking through an ODBC driver. This works neatly and places data sets that I can then pull onto forms in various formats, DGV's textbox, Combobox etc.
The application I am trying to build now links to a hosted server on the internet. For security reasons I cannot create an ODBC that connects to the database. I can use a ADO connection string and this is fine for various tasks and I know I can populate a DGV using this connection. However, it is much quicker once I have dataset that I can repeatley call on.
I am wondering if anyone else has experienced any issues with adding a data source to a VB.NET 2010 solution using the 'Add New Data Source' wizard. I am getting a very odd behavior when i add the data source, I see a .xsd file is added in my solution explorer but I do not get a data source listed in the data source view. In short, it will add a dataset to the project but will not add an entry in the project data sources. I realize I can code to get the same results but purely out of convenience I would much prefer to just use the wizard and the corresponding table adapters it generates as I always did.
By the way, a google search shows that many people had similar issues in the 2005 version but their issues involved trying to use special characters in the project path (i.e. 'C:My ProjectsR & DMy Tool. I do not use any special characters in my project paths and yet am still experiencing this issue.
I have created a form with three comboboxes. means
FirstNameComboBox
MiddleNameComboBox
LastNameComboBox
All fields are select ( name ) from a "CustomerName" table. "CustomerName" table is have more than ten thousand records. I am use three binding sources its worked great but it is very slow bcz three comboboxes are filled data on form loading time. I am using visual studio 2010 (visual basic).
im trying to add a new data source to my visual studio 2010 project. As it stands my project consists of a few windows forms. I plan on making it access a database (made in access, unless this is a problem), and be able to perform pre-set queries, search/sort, and basic delete,add,edit functions. I will hopefully be later adding the function to print reports according to the database entries.However, the problem i am having is that when i go on to data sources, and click add new source, the following happens:3, it asks me which connection i will be using, i click new connection, then in the new connection dialog i choose the following : Microsoft Access Database File (OLE DB), then i browse for the database i made in the 'database file name' box, Then i delete the default username in the log in to database bit, as my database has no protection.
View 3 RepliesI need to connect to an MySQL database in my VB.NET application (VB 2010 Express). When I attempt to use the Data Sources wizard to establish the connection, it does not provide an ODBC data source. I'm using Add New Data Source/Database/DataSet/New Connection which shows the Add Connection dialog. The only options it gives me for data sources are Access & SQL Server and the OLEDB data provider. It does not appear to give me the option of adding a new data source provider. Attached is an image of my current Change Data Source dialog. Where do I get the ODBC data source provider and how do I install it into Visual Studio?
View 3 Repliesno beating around the bush, here's the code.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim myXMLFile As String = Application.StartupPath & "creditors.xml"
[code].....
I 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 have a database(acces) with tabel questions and answers.
-->
tblquestions
questionId -> -> primary key
question -> string
[code]...
There's a combobox with questions and a listbox with questions of the chosen answer(s).I have already to add and show the questions, answers.Now I wan't to delete the answer(s) (in the listbox) of the chosen questions I have this already
con = New OleDbConnection(providerStr & dbLoc)
con.Open()
Dim command As New OleDb.OleDbCommand("DELETE FROM Answers WHERE questionId= " & 0 & " AND answer='" & lstAnswers.SelectedIndex.ToString & "')", con)
[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.
My program takes a checkboxed item and depending on the serial number that is present on the item on the invoice, subtracts one from the amount list I have the following in a listview on a details page which I added with the following code:
Item - Low Socks(pink)
Serial # - 34-75-860
Price - 5.89
Amount - 12
[Code]...
Right now it doesn't look like it does anything. I have tried changing my index's on my subitems to 1 and 3 instead of 0 and 2 but i figured because they are subitems that they need to be subitem index 0 and subitem index 2 since there is one item and three subitems to that one item.
I'm trying to delete an item from a listbox so that it wouldn't appear when i run the program again. Is there anyway you could do this.
View 14 RepliesHow do i call ODBC Data Source Administrator form of Control Panel and get the selected DSN and its contents
View 3 RepliesI 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 an invoice that lists several items that one person has ordered. I want to take this invoice and every time I check the item it removes one of those from another list i created called item details. I added items to this list using the item collection in the listbox.. I have invoice one that has a pink sock ordered. when i clicked this box next to it I want my total pink socks of 12 to move down to 11... the detail page and the invoice are two separate pages.
View 1 RepliesI have a project where I added visually and successfully a datasource of MySql. I binded a datagridview with a table.
But, how do I change programatically the password, ip or user to connect with the MySql server? Because it can change at any time, so I can let the user change these values.
What I'm trying to accomplish is first of all, adding items in a list box, but while doing so, store data into that item so when the user clicks on it, the data will be brought up into the correct text boxes.
My idea on how this will all work out has to do with array lists. I'm thinking each time an item is added to the list box, an array list is generated containing all the data from the text boxes. The array list would be named as the text of the list box item.
So then when the user clicks on one of the items, it can find that array list easily because of the selected index, and then update the text boxes with the data.
Is the way I'm thinking of possible? If not, or if there is an easier what, what would that be?
i know how to add items to a list box box if all controls are on one form but for space reasons i'm adding items/urls into a text box on form2 then when i click OK the items are supposed to be saved/stored in the checked list box on my main form.
View 5 RepliesIn my application, I have a data bound form using a binding control (built by the wizard). The application has one primary data screen plus a few more on tabcontrol subscreens.Picture for example that the tabcontrol has two tabs, tab1 and tab2.When the form is displayed, tab1 is visible.Now picture the form or window split in half the top part of the form has a few textbox controls bound to the data and there are a few textbox controls in the lower half of the screen on tab1 of tabcontrol1.There are a few textbox controls on tab2 as well.When the form displays, I can access any of the .text properties of any of the textbox's that I can see on the form and in tab1 of the tabcontrol.BEFORE tab2 is chosen or even, I need to get some of the data from the .text property on a textbox control that is on tab2.I have tried to get the data but as far as VB is concerned, it does not appear to be there UNTIL tab2 is displayed.
To prove this, I put a command button on the form and it simply does this: MSGBOX (mytext box33. text)mytextbox33 is a databound control on tab2 of the tabcontrol1.tab2 is not in focus and apparently, neither is the data.how can I read the .text property of a textbox that is on a form but the form (or tab) is not in focus?
I am using Parallel.ForEach to do some time consuming operation. Coming to the question ,
For example,
I am enumerating a collection called 'TestCollection' which has 3 items.
Parallel.ForEach(TestCollection, po, AddressOf DoSomeThing) So 3 tasks will be running in paralell at a time Now I want to add another 2 items to TestCollection, while the task is running.
How to enque the additional 2 items to the 'TestCollection' so that additional two tasks will also run in paralell. Finally 5 tasks should run in paralell without stopping the running task. If a post answers your question,
Okay I have this two Forms.. one for the parent and one for the mdichild. I have a toolstrip menu in the parent with a button(with a pic) named close document.
View 2 RepliesI need to delete some rows from csv file based on a column value. Here is my sample.csv file [code]In my vb.net winforom application, I have to read this file and need to delete the rows related to 06/06/10 date column values then write the remaining rows into new.csv file. So far my program works on reading whole data present in the file.[code]
View 2 RepliesI deleted a textbox on my login form and when I debug the startup (login) form still has the textbox that was deleted. I tried deleting the form and its components but still this form appears on start up Is. there any way that I can fix this?
View 3 Replies