I'm writing a flash cards program to help myself and others study. When the user presses the "New Card" button, I've been able to make it create the new card and jump to edit it, but the dataset/binding source/table adapter is not switching with it, so when you deselect the text box, it switches back to whatever was selected before the new card was made.[code]
View 1 RepliesWhat is the best way to easily switch from a test database to a production database in vb.net and MySql, when all MySql connection strings are currently hard coded?
View 3 RepliesMost of my project started out using Access databases, but now I want to swap them out for the SQL versions. One example would be this:
DEMOGRAPHICSTableAdapter.FillByCount(EyeBaseDataSet.DEMOGRAPHICS)
SPat = EyeBaseDataSetSQL.DEMOGRAPHICS.Patient_NumberColumn.Ordinal
'TODO: This line of code loads data into the 'EyeBaseDataSet.History' table. You can move,
[code]....
I have a connectionstring in MySettings which all my datasets use. The project has three copies of the same database: LIVE, WHATIF and TEST. I need to have a dialog in my startup that asks the user which db they want to use and then I thought I could amend MySettings.Connection string dynamically. Hey-ho it's read-only! Is there any other approach I can use where I change a connection string once and all my datasets will then point to the selected db?
View 3 RepliesI have created an access database which i want to search with vb.net, I tried a few thing but it didnt work as desired.
Firstly the program is suppose to display items in the database base on the criteria selected by the user. what i've succefssfully done so far is I've added a datagrid 2 combobox, 1 (searchcbo) with the columns in the database and the other (searchcbo1) will autoload the items under the column selected in and a button (searchbtn) but i have no clue of the code to put in the button. i also tried the fill method but that didnt work as i wanted to. ultimately i want a combobox with the list of columns and a textbox to enter criteria and of course a search button.
The searchbtn should act as the "WHERE" sql command, e.g. SELECT EmployeeNumber, Firstname, LastName, Phone, Location....etc FROM CallLog WHERE searchcbo.text = searchcbo1.text And display the results in the datagrid.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'CallLogDataSet.CallLog' table. You can move, or remove it, as needed.
Me.CallLogTableAdapter.Fill(Me.CallLogDataSet.CallLog)
[CODE]....................
Attached image(s)
I came across this Switching from VB.NET to C#?I would be moving from C# to VB.Net. To be more precise, I would be moving from C# 3.0 to VB 10.0 (.Net 3.5 to .Net 4.0). I am initially planning to use a C# to VB converter to cope up with the syntax.
View 6 RepliesI have the following code, which works fine most of the time:
Private Function NormalizeTexture(ByVal Texture As Bitmap) As Bitmap
Dim Out As New Bitmap(2048, 2048, PixelFormat.Format32bppArgb)
Dim Gra As Graphics = Graphics.FromImage(Out)
[Code].....
I have some forms in my application and need to switch between them. I dont want to open another form over other form, in short I want the user to get a feel that he is working on one form only. Right now I am doing something like this but this is not what I want
[Code]....
In my project, I want the abiliity to switch between forms without closing them. What is the best way to do this? I have a "Login Splash Form" that you sign into, and then a Main Menu Form opens in Full Screen. I want this form always to stay open with the ability to open up other forms from this main menu screen as needed.
View 3 RepliesI have 2 listbox's, same locations/sizes (one behind the other). I have 2 buttons, and they just switch the views between the listbox's by changing their visibility propertyThe problem is listbox1, which gets populated first, displays just fine. No code in the program touches listbox2, except for 1 button that adds items. When switching to listbox2 to see the added items, the items are there (verified by debugging and hovering over the added variable), but the text that is displayed won't update. The text that is displayed is the text from listbox1.
View 14 RepliesI am currently working on transferring data between minitab and excel and have everything working out fairly well. I am having trouble getting back to minitab (I can get the initial program to run with the shell commmand). I have tried appactivate, and windows commands but I am not having any luck.
View 1 RepliesHaving had to replace my old computer, one can virtually only get 64 bit Win7 in UK.All my old Visual Studio 2008 + other components installed OK but when I tried to build and run a prgramme that still runs happily on the old machine, I get the following error message
System.TypeInitializationException was unhandled
Message=The type initializer for 'mydata.Colin' threw an exception.
Source=mydata
TypeName=mydata.Colin
StackTrace:
[Code]...
The programme is called mydata and Colin is my User name. Anybody got any idea what is wrong and how to correct it. I have tried to run it in Visual Basic 2010 Express and get the same error.
Hopefully VB2012 will have Gigs of error messages that mere mortals can understand!
I have an application I wrote that is in VB.NET 2.0. Works great, but I'd like to switch this application to Linq. I use ADO.NET to load XML into a datatable. The XML file has about 90,000 records in it. I then use the Datatable.Select to perform searches against that Datatable. The search control is a free form textbox. So if the user types in terms it searches instantly. Any further terms that are typed in continue to restrict the results. So you can type in Bob, or type in Bob Barker. Or type in Bob Barker Price is Right. The more criteria typed in the more narrowed your result. I bind the results to a gridview.
1) Go to Project Properties --> Advanced Compiler Settings and change the Target framework to 3.5 from 2.0.
2) Add the reference to System.XML.Linq, Add the Imports statement to the classes.
So I'm not sure what the best approach is going forward after that. I assume I use XDocument.Load, then my search subroutine runs against the XDocument. Do I just do the standard Linq query for this sort of repeated search? Like so:
Dim people =
from phonebook in doc.Root.Elements("phonebook")
where phonebook.Element("userid") = "whatever"
select phonebook
I have a dropdown list that will add new titles to my database, however I would like to add a textbox that will allow the user to type in a new title if there is nothing in the dropdown that makes any sense for what they are trying to add.
I have the dropdown dynamically getting titles from the database. Unfortunately, this means that the first value in the dropdown list is not a default that says "Select an option." I don't know how to get the dropdown to have the first option listed as "Select" when the values are being pulled from the database. I can't add Select an option to the database so how would this even work?
What can I add to my codebehind that will allow the textbox to insert into the database if the dropdown list is not inserting anything? Right now I don't have any codebehind for the textbox but I do have the dropdown list inserting the correct information.
<li class="alternatingItem">
<asp:LinkButton ID="DescButton" runat="server">Description</asp:LinkButton>
<asp:Panel ID="DescPanel" runat="server" CssClass="modalPopup" Style="display:none">
<div class="PopupHeader">Add a Description</div>
[code]....
I am using a DateTimePicker to allow the user to select dates between which, info from a database is selected and displayed in a DataGridView.This works fine exept that the dates selected by the DateTimePicker seem to bring back results in US date format!
If I do a debug.print (DateTime1.text), the date is in UK format i.e 11/05/2009 but when these variables are used in a Select statement, the dates returned seem to be in US format e.g. selecting dates between 01/04/2009 and 7/05/2009 selects dates between 04/01/2009 and 05/07/2009 when the results are displayed in the DataGridView!
[Code]...
get selected value from database and input this value to combobox. [code] when I run this program . in combobox 1 just have 1 value.in database I have some value.
View 1 RepliesI am trying to add selected items from a dgv (data gride view) where if i click on the cell it get transfered to a listbox. this is the code I have tried to use
Private Sub dgv_CellClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles dgv.CellClick
frmBorrowed.lbBorrowed.Items.Add(dgv.SelectedCells)
End Sub
and this is what shows in the listbox (Collection) but what I want is the listbox to show me the text that was in the clicked cell. this is sorta like a checkout list. This list will then be saved, probably to txt file or another database. not sure yet.
trying to get my first windows form running with controls. I havent been able to figure anything out. . . and then i realized duh, it's all in VB. How do I switch the generated files to C#? Am I confused? This is what I'm getting when I try to add my first control for Button_Start:
[Code]...
I'm starting to play around some with VB2008.
In VB6, I would write something like this:
rs.open("SELECT * FROM Contacts", cn1)
strFirstName = rs!FirstName
In VB2008, line 2 does not work. How do get to the fields in the recordset?
I am currently writing a program and I have all the windows in three languages. Is there any way of quickly changing through the languages? I mean, I can do it manually but the list has like 500+ languages and I was wondering if there was any keyboard shortcut to switch between the used languages, or any way to put a buttom on the toolbar.
View 4 RepliesTher time necessary to programmatically switching the cam on for the first time is very long while the next calls are normally much faster.Is there a way to speed up the switching on of the web cam the first time?
View 2 RepliesI have written a VB 2008 Standard Edition program using a SQL 2008 Epress database in my development environment. When I point my program to the production SQL 2000 database it blows up. With the following error:
---------------------------
Microsoft Visual Studio
---------------------------
GentranDataSet.Document_tb.Fill,GetData () could not be previewed.
The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
---------------------------
OK Help
---------------------------
The tables are "exactly" the same in the two databases... I think.
I have done some reading and wonder if this could be a unicode and non-unicode issue. Is 2000 non-unicode and 2008 unicode?
Can I "refresh" my data enviroment without having to re-create all my data objects in my VB code?
I am switching from listviews to datagrids and one of my listviews uses a sort in it. How can I sort in code using a datagrid?
View 2 RepliesI set up studio 2010 to work with c and now want to change it back to VB.net but can't remember how I did that. It seems like it was through the tools menu but seem to have forgotten how.
View 3 RepliesI am building a webbrowser using VB.Net 2010, and I am having trouble updating the url when I switch between open tabs using tabcontrol. I am also using a textbox for the address bar.
View 15 RepliesI know this is a very basic question but it has been awhile since I created a project with a database( been using a lot of XML). I created a database then selected it as a data source added some controls to some forms. Then I realized I needed to adjust some tables and I needed to add a whole new table. I deleted the controls and updated the tables that needed some adjustment. Now I would like another table. Can I disassociate the data source and do my adjustment to the database?
Have I created a problem with the binding object since I just deleted the controls on the form. I have written classes and some logic or else I might just start over. I guess I could copy those files but I am wondering if there is an easy way to fix what I have started. I realize that there are alot of questions here so any resource on how to modify a database that is attached to a VB.Net project.
I try to do a very simple job which is: Delete a row in dgv AND database! But now after three days I'm running out of steam
The problem is: I select on or more rows in dgv and push the del button. The sub zDelete starts working and at the end the selected row is gone and the row after my selection is gone too!?!? The deletion of the selected row was well done in dgv and database. But why is the next row in dgv only also disappeared??? After a restart of the form the missing row is back up again. And when I try to delete the last row it trows an exception error: System.IndexOutOfRangeException was unhandled
The code fragment is this:
'Delete all selected rows in dgv AND database!
Private Sub zDelete()
If MessageBox.Show("Do you really want to delete the selected rows?", "Delete", MessageBoxButtons.YesNo) = DialogResult.Yes Then
[Code].....
I am using Visual Basic 2008.I Have a lilstview with items from an MS Access database loading in to it. I can update, insert and delete all from the database and the listview is updated accordingly. However, I cannnot for the life of me get it to remove a row from the database based on the selected index of the listview!!!I suppose I could use a DataGridView but then I would need to add a datasource wouldn't I?
View 4 RepliesI am trying to get a value for a textbox from a database according to the selected item in combobox. but i had this ex.message " there is no row at position (0) "i have filled the combobox droplist from the same database table as below!
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim connstrg As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:Documents and SettingshedrisMy DocumentsREGISTER.mdb;"
Dim conn As New OleDbConnection(connstrg)
[code]....
I have a datagridview with a column checkbox, now my problem is how can i insert those checked checkbox into my table in sql database???
and one more thing,how can i remove the addnew thing at the last row of my datagridview? because it represents null..