Setting Up A Database Program?
Oct 8, 2009
I want to insert text into an empty database.I create a database using Access and now I want to insert text1) first I Added the data source2) I drag and drop the Fields into the dialog Form3) using dataview I inserted the database onto the dialog form4) added a little bit of code...5) Built the program and the database shows nothing...do I need to make a Query or something...bind the source
Private Sub btnExit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExit.Click
[Code]...
View 8 Replies
ADVERTISEMENT
Jun 18, 2012
I have a little problem with setting up a program in visual basic, could you help me out ? This is what i want to do.. I have no ideea on how to make the form in form thing..
View 2 Replies
Jun 14, 2011
I'm trying to select a TreeView node with my programhy does this not work?
Dim
MyNode As
New
[code]....
View 9 Replies
Jan 8, 2011
Is there a way to create a setting while program is running?For example, have a textbox in which the user will give the name of the setting
and a combobox with 3 items: String, integer, Boolean.But these settings have to stay until you open the program again.
View 4 Replies
Apr 10, 2012
I'm setting up a quote calculation program for my business.I'm just a beginner with Visual Basic (2010 Express) and am finding it very interesting.I already did some reading and followed the tutorials but I'm getting stuck with my program now.
[Code]...
Make it possible for users to enter necessary data in the "new quote" screen. The data needs to be written into the database table of "new quote"Make it possible for users to lookup previously made quotes in the "open quote" screen. I want them to be able to select a quote based on "quotenumber" or "customername".They then must be able to select a quote, which will open a new window with all quote information from the tables. This information needs to be editable and savable to the databaseGenerate a PDF of a "finished" quote and mail it as attachment to a customerthe "customer information" table contains information for the quote concering address and name of customer. I want this so that users can select a customer in the "quote screen" and all other data will be filled in automatically. I also want that users
can give in a new customer in the quote screen and that that customer will be saved in the "customer information" table.point 4 is also applicable for the "material information table".
View 1 Replies
Apr 3, 2009
I'm trying to make a quiz application with Visual Basic at the moment. I want to write a routine that asks five questions to which the answer must be either Yes or No. It must add up the number of Nos and if the number of Ns is less than two then print out �pessimist�, otherwise print out �optimist�.I'm only at the very beginning stage of the program, I've created the design of it but I'm not too sure whether the code concept for the radio buttons is right. How can I expand on this?
Public Class Form1
Inherits System.Windows.Forms.Form
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim numberOfNos As Integer = 0
[code]....
View 8 Replies
Mar 11, 2010
i'm trying to set a password in my database using vb.net.here's my codes..
Private Sub btn_ok_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_ok.Click
Dim chkpass As Integer
Dim strsql As String
[code]....
View 1 Replies
Aug 13, 2009
I want to set a password to my database..I used DAO to access a database..It is MS-Access 7.0 Database..I searched lot of forums, but i found only with ADO..I tried this concept with DAO.. But i couldn't get.
View 1 Replies
Mar 11, 2010
I have created a project with my forms & a little bit of validation logic, the basic skeleton of the project looks just fine.The data that I have for the project is currently in 2 Excel spreadsheets, so I have created a database within my project (I chose a SQL option, even though I have only ever used Access in the past) & I now have Database1.sdf & MyFinancesDB.xsd in my Solution Explorer.
I have created 2 Tables, the same as the Spreadsheets & have created Columns as necessary, and also set up Primary keys in both Tables and linked the Primary key of the Parent Table to a keyed column in the Child Table ... I *think* I have done what I need to do.Now, the big question (assuming I have set things up correctly !) is how do I import / load the data from the Excel spreadsheets into the SQL Tables?
View 1 Replies
Mar 5, 2012
I'm working on my own project management software and I'm having trouble linking the database with the interface and then coding it so that the components interact with the database. Can anyone refer me to a good tutorial. I tried the MSDN and found that to be a little too over my head.
View 2 Replies
Mar 27, 2011
Is it possible to set a form Topmost setting only for one commercial program?Say my program is A and commercial program is B... I want Topmost setting for program A will only work when I working on program B, and when I switch to other program than program B the Topmost setting for program A back to false.
View 2 Replies
Feb 9, 2010
I have a single form that I would like to move across the screen with my VB program. Of course it's simple to set the location X and Y property for compile time using the properties tab, but I want the form to move as the program runschanging the coordinates within a for-next loop.I can easily get the X and Y coordinates of the form within my program by using X = me.location where X has been dimmed as type point.console.writeline(X) will appear as {X=20, Y=40}. for example
View 2 Replies
Jun 11, 2010
i have so far set up a form to save data into a database and i am using:
[Code]....
View 4 Replies
Mar 11, 2010
i have so far set up a form to save data into a database and i am using:
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0.;" & _
"Data Source = F:Database1.mdb"
con.Open()
I tried saving the database as i did with images in the resource folder and used my.resources but this didnt work is there any way i can save the database into the project folder and link to it no matter whan machine i am on?
View 5 Replies
Nov 12, 2010
I tired the following Query to access my SQL Server database. It returns an error. SELECT Name, Address, PhoneNo FROM dbo.tblContacts where name=?
[Code]....
View 1 Replies
Apr 26, 2010
Does the database connection have to be set inside a TransactionScope?
Or can I set it in the ctor and then have instance methods create up a TransactionScope?
EDIT: e.g.
Public Sub New()
Dim conn = new SqlConnection(...connection string)
Public Sub SomeClassMethod()
[Code].....
the question is do you need to create the connection to the database after you've created a TransactionScope or can it be done before?
View 1 Replies
Jan 27, 2010
how to add the Uninstall option in the Start--> Programs, during setup and deployment of an application?
View 4 Replies
Jun 30, 2009
have a problem in setting hyperlink text property from database at runtime....Iam struggling to connect the database values to dynamic hyperlinks.
View 7 Replies
May 18, 2009
I have an application that's going to be portable so it's likely the path of the database itself (access mdb file) will change so hard wiring the path in the app.config isn't practical. I would like to create a 'Settings' form for the user to enter the path (browse for would be ideal but I can figure that out later) of the database file and save it for future use with the same app. I've found a few things out there talking about creating a new app.config file alongside the original with a 'key' defined but I'm not sure how that relates to the original app.config and how it would call the new variable to make the connection.
View 3 Replies
Oct 9, 2011
i have a program that connects to mysql database to check username/password.I have a line like this in the project:
conn = New MySqlConnection("server=myserver.info;Port=3306; user id=dbusername; password=dbpassword; database=dbname")Anyways, a user managed to get this info from the program
How can i make it so they can NOT grab this info from the program ?
View 12 Replies
Jan 20, 2011
I am trying to make a program that deletes all setting made by using the SaveSetting function. I don't use the MySettings class as it makes a setting for each user. This is basically what I need it to do:[code...]
View 9 Replies
Aug 13, 2011
I'm using .net 2008 Trying to create a small graphic component, I have a problem setting background both at design time and then runtime. I derived a panel like this
[code]...
But it isn't working! If I don't Overrides Property BackColor, this is working as expected but I really need to group in my custom tab.
View 6 Replies
Feb 28, 2010
I need a way to allow another form to load after my program display's an introduction cut-scene without loading the form in the middle of the cut-scene. Sort of like a delay.
View 2 Replies
Feb 24, 2009
I have a project that I used the 'Connect to Database' tool to set all the bindings and table adapters, etc. Currently the database is housed in the same directory as the exe. I was asked if I could have the database location be a dynamic value. My question is when you set up a project to work with a database using the 'Connect to Database' tool, how can you change its location?
I found this setting:
ASRDBConnectionString
But its read only.
Within that setting is text that says: DataDirectory
So thought that might be a variable to change somewhere....but can't find it.
View 5 Replies
Mar 29, 2012
Windows forms Application. VB .NET 4.0 In my application I have a global boolean variable that keeps track of when changes are made and when they are saved called changesSaved. On closing even it checks the value of this variable before closing the window.. I am using textchanged event to automatically change the value of changesSaved to FALSE when text is changed.. Problem: The group box items are being populated dynamically so the user can edit the values or simply just view them. This dynamic population is causing the textchanged event to fire because the program is changing the text value of the box to put the values in that are stored in the database. The textchanged event should not fire unless the user him or herself enters a value or values in the text boxes..
Is there a way to specify the source i guess you could say for the text changed event or another way so that it will only fire when the user inputs information.??? Functions are as follows: The first is called by the load event to place the values in the box... The next one is the one that is being called as a result of the first one and is also the one that is causing the problems.
[Code]...
View 3 Replies
Mar 28, 2012
Setting a textchanged event to only fire when text is actually entered by user not program
View 1 Replies
Jan 25, 2010
I am trying to create a setup file which would automatically install a link to the executable in the User's Desktop and Startup--> Program. However despite following all the steps in the right order I do not see any short cut in the desktop and Start -> Program.
View 4 Replies
Aug 5, 2011
Lets say we have an Access file in a well known path (i.e. "C:MyFolderMyFile.mdb"). That file does not have a primary key set on the table we are interested in . Is it possible to set one of the fields as a primary key (for example the "ID" field , which is also an AutoNumber data) ? And one more thing : I'd like to change the name of a field on that table . For example , lets say there is a field called "My Field 1" (note the space characters) and we want it to be renamed as "My_Field_1" . If it's possible , I'd like both these changes to be permanent in the data base file itself , not just in the imported DataSet ,
View 7 Replies
Aug 23, 2010
I need help and wondering if you can help me to get my first project...it's a hobby and wondering if you can get me code for this so i can see how it does it* Evaluate( ) Prints the evaluation of the hand to the evaluation Label.
o If IsFlush( ), prints "flush; "
o calls SetPipArray( )
o Uses a For Loop to go through pipArray. For each element, uses a Select Case statement to
[code]....
View 9 Replies
Feb 13, 2012
In our projects we use setting variables to store user setting for the applications. Moreover, with every latest version of the applications, we upgrade these variables to retain user settings.Normally, this works fine, but recently one of my end user reported an error i.e.Configuration System failed to initialize". The error is related to user.config file. Therefore we requested the user to send us his file.After received the folder, we noticed that it contains 3 files (3begfjb.newcfg,3begfjb.tmp and user. config). 3begfjb.tmp is an empty file, while 3begfjb.newcfg and user.config are identical files. We tried to open these files but the data in user.config isn't proper xml rather its unreadable formatted file.Do any you guys had experienced this sort of issue or any ideas how and what may have created these files and corrupted user.config file.
View 3 Replies