DB/Reporting :: Database Controls Basics?
Jan 4, 2009
I am trying to do a very simple demo - load data from an access database and let the user manipulate it with a DataGridView. Here's what I understand so far:1) Create an OleDbDataAdapter by passing it a query and a connection.2) Create a DataSet by calling .Fill() on the DataAdapter with a DataSet object and a name for the retrieved data.3) Attach the DataGridView to the DataSet using the .DataSource property of the DataGridView and the .Tables property of the DataSet.However, I was told there is a much easier way to do it now in vb2008 using TableAdapters.1) Create a DataTableAdapter ( I can't actually find this object -what is it called?)2) Use the Fill method on the DataTableAdapter to connect it to a DataSet3) Now anything the user does in the DataGridView can be saved simply by using TableAdapter.Update.
View 2 Replies
ADVERTISEMENT
Jan 5, 2009
I'm working on a emulator program where I load all controls from a database. My database looks something like this :
Code:
IDPageTypeControl_Indexnr Property Data
1131Label 1 Text Lbl1
1161Label 2 Text Lbl2
[code]......
View 11 Replies
Feb 22, 2012
how to create a comparison statement for a record that I have placed in a column of a SQL Database. In other words, I have a 2- forms, the first form is where the enduser places a few record requirements along with 4-digit number followed by the submission of a registration. After the registraions is submited, I have it coded to where the registration gets saved along with the 4-digit number into the database followed by a second form appearing. Ok, here comes the problem: When the user exits the applaication and then restarts the application again, the first form apears although it is not necessary since the enduser had already registered.
So, how do I or what kind of comparison statement can I create that will let visual basics or the first form know that the registration was completed and force the second form to appear instead or first?I would liked to makes some type of comparison with the 4-digit number thats in located in the SQL database.
View 8 Replies
Oct 21, 2010
I've been using DevExpress and CrystalReports for previous .NET versions. I'm wondering if there are any native reporting controls for .NET 4.0, so I could do away with the 3rd party ones.
View 1 Replies
Mar 19, 2012
How would I go about adding items into my gridivew without having controls that are binded. I know you can hide the controls but thats not the right way to do things i wouldnt think.
View 3 Replies
Sep 1, 2008
i have a form with 6 tabs on 3 of which have controls, spent a lot of time putting it all together, set it up to link to a SQL DB, all working fine,Until....at the bottom of the form (in design mode) you have the icons that say BindingSource1 and CustomerDataSet1 etc.Well i accidently deleted some, now when i run the form i got an error saying that it couldnt load, i see the code is there but the form is just the blank form you get when you start(the form is still the same name and if i click view code all the code is there, but on the form are no controls, no tabs ... its all gone....(i only deleted a binding source ) i dont understand where its all gone.
when you click on the undo it didnt put the deleted items back (and i am not sure which one there were) now that the form has gone back to normal there are no Binding sources at the bottom I opened the designer code, i see the names of all the missing items, e.g. CustomersDataSet1 and TblCustomers1BindingSource1 e.t.c do i just re add those back to the bottom of the form and then the main controls will re appear?
I have looked through the code and re added the binding sources and adapters that are referenced in the code along with the Binding navigator, if i run it the form is still blank.I have tried to add the controls back and when i do it adds it as e.gTblCustomers1BindingSource2 if i try to rename them to the name they should be ie. TblCustomers1BindingSource1 it says it already existsI am using VB 2008 Pro?
View 2 Replies
Apr 21, 2008
I am working on a Data Survey Project and first I have a few questions about the different types of databases, and second, I need help querying my tables that have relationships.
1. I need a database that is stand alone. It is just the back end for the program. Simply to hold all the data an employee gets while out on a job. So would I be better using access, or SQL Express? I have played with both, but I do not want a large redistribution to my user machines. When I compile and produce this app does the SQL Database still work without installing any SQL Technology? Or do they have to go in after they install my app, and install Express?
2.Overview: I suppose depending on the first question regarding the database, it might change this question a bit, but none the less...I have 4 tables( using Access at the moment) I will be generating Reports based on data in the database. I haven't gotten that far yet. *Project* is the table that holds all the details that pertain to the job and client. It has a "one-to-many" relationship to *Survey*. So for one customer there are going to be many Survey Records. *Project Type* also has a 1-to-many back to *Projects*. Parts is kind of an orphan, but is linked to the *Survey* table with a one to many. So there can be many parts for one survey. I wanted this table for a drop down box, so the user could just simply select what hardware he was using instead of typing all the names and parts.
So in VS 2008 using the Designers and related Query tools, how do I constrain the Survey Data to one Customer? I have one form that opens from a button that is "New Project" and then there are all the *project* fields listed, so the user fills out the info and hits accept and that opens a new form called "frmSurvey" I need to add some code to the accept button to check what type of project is selected from the frmNewProject and then run a select query based on that. How do I write query statements in the code section of the form, without using the Visual Database tools?
Ill stop here, and get these questions out of the way first. If I could just get a handle on how to use the data properly with different forms and different controls with my queries, that would be great.
DATABASE
CODE:
View 4 Replies
Apr 21, 2008
I want to move my programs and the database to another computer and hard-disks. It looks to me as though I nearly have to re-create the controls and rewrite some of the code to make it so the programs still work after the move. At least with ODBC all I would change was the DSN definitions external to the programs. Is there an easy way to move or rename a database without loads of work?
View 3 Replies
Mar 30, 2008
I am trying to copy a table from a network database to a local database. I used DAO and could check if the network table existed using a function that tried to assign a TableDef object to the table in question. If there was no error then I assumed that the table existed and the function returned true...Or it would error out and return false.I could then proceed with the copy or not as the case may be.I am converting the code to ADO.net and need to know how to check for a table. [code]
View 1 Replies
Sep 20, 2011
Recently working in vb 2010 express. I'm using service-based database which is based on SQL Server. This database will be deployed at the server. Is it possible that multiple vb.net programs, which are installed in remote computers or client computers in the same network, connect to this database simultaneously? Does the service-based database support multiple connections?
View 1 Replies
Nov 8, 2010
I am looking into WCF specifically in relation to Silverlight. if I am correct in thinking that I can create a WCF Service, and expose a TCP endpoint using a Windows Service that my Silverlight app can use? I have managed to expose this using IIS but it would be good if we could bypass using IIS as some of our customers don't like it.
[Code]...
View 3 Replies
Jun 17, 2010
I'm looping through a zip file trying to add the file name of each file within.Is this the correct method?
Dim ZipNameArray(?)
Using zip As ZipFile = ZipFile.Read(ZipToUnpack)
For Each file In zip
[code].....
View 4 Replies
Sep 10, 2009
I'm trying to create a simple example of an editable gridview, and for some reason can't seem to get the basics working. Why is this example not displaying the label Bar and a textbox when I click on "edit"?
aspx: <%@ Page Language="vb" AutoEventWireup="false" CodeBehind="gv.aspx.vb" Inherits="WebRoot.gv" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-
[CODE]...
code behind:
Public Class MyFoo
Public ReadOnly Property FooVal() As String
Get
Return _val
[CODE]...
View 1 Replies
May 2, 2011
I'm trying to make to do a widening conversion from a byte to an integer. form has a text box for both Input, and Output, plus a conversion button. [Code] I'm trying to use a catch block, but I'm not certain how it works exactly, and also tried to use an If statement to avert the issue, but that didn't work either. When ever user inputs a number greater than what can be held within the Byte data type the program crashes from the run time error. [Code] and an error message pops up in the compiler saying overflow exception was unhandled.
View 19 Replies
Jan 25, 2012
How add excel plugin in visual basics project? i created a form application and need to add excel plugin in visual basics project...
View 1 Replies
Jan 9, 2011
I am new to vb.net, from VB6. Trying to understand drawing a simple line graph into a picturebox, which was so simple in VB6 ! From code snippets, I can see the basic idea using an bitimage to draw the lines and then showing it in a picturebox. I don't understand how to (simulate) scaling of the bitmap's x/y scales like you could do with VB6's .Scale.
View 1 Replies
Nov 13, 2011
Assume a grocery store approached you to write a simple program that calculates total sales of purchases. The program should accept item costs as input, calculate the tax on each item (8%), then display the item cost, total cost, and total after taxes. Item costs will be added to a listbox while the total without the taxes will be displayed in a label, the tax amount in another label, and finally, the total cost (items cost + tax) in a third label. this is the problem I have to program for,
View 3 Replies
Jun 29, 2010
I WANT TO impliment security on visual basics 2005 HOW DO I GO ABOUT DOING THAT
View 4 Replies
Jul 20, 2010
I want to make a program that will sync two folders together with the command in cmd called xcopy, so when i click on a sync logo the folders sync. But i want the user to be able to browse for the locations then set the locations as they sync folders. I already have linked two FolderBrowserDialogs to two textboxes so when i select a folder in the browser the directory shows in the text box. But then how do i put the two directories into the xcopy command? This is what i have done so far...
[Code]....
View 5 Replies
Mar 1, 2009
How do I upload what I made form Visual Basics onto my website??!
View 4 Replies
Sep 8, 2009
What are the basics to creating a tcpclient / server?
View 3 Replies
Jan 30, 2009
I spent some time with data modems till I realized it's a voice modem that I'm going to need in my application. I see that there are some other commands for a voice modem, although nothing very elaborate. I would imagine you make the call as you would in a data modem ATDT etc and it looks like there is really just one command to send audio...
AT+VTX
AT#VTX
Not sure what this is all about except maybe just different standards? Still not sure about how to detect when the call is answered though. I won't be talking to another modem. Maybe the serial port itself has a pin change or something? You would think there would be a bit "somewhere" that the modem would generate when it quits ringing. I may have build my own outboard box to do this. (easy enough -- probably more reliable too -- modems sure need rebooting a lot it seems).
Here is the goal though --Voice modem calls out, call is answered, and I inject my audio from the PC sound card for a minute or so and then tell the modem to hangup.
View 5 Replies
Jul 22, 2009
I need to programmatically add a row to a MS Database.How is this done?
View 2 Replies
Feb 25, 2011
I don't actually know if I can use any XML file as a database that I can edit and make some changes to it using vb.net 2008 and save them. Because I'm working aboard a war ship and we have a central automatic system to control all the internal communication using standard telephones. to reprogram the extinctions we used to have a MS DOS program and it's so old and now it's totally lost and not found and after a long searching I have found a file that could maintain the extensions and reprogram the system but it's an XML file.
[Code]...
View 1 Replies
Jul 10, 2008
I'm using Visual Basic 2008 Express Edition. What I have is an Access database that will have several tables. What I want to do is connect to the database, enter the name of a table in a text box and query that table. The code that I have now is: [Code] I'm not sure how to modify this code so that tablename = whatever I type in the text box.
View 5 Replies
May 26, 2008
I am using SQL server managment express. I have 4 databases in it and got a bug on my computer which I could not get rid of. I saved these to disk and reinstalled windows, I reinstalled SQL server and I am now trying to add my 4 databases. Can any one help me with this, I can add a new database but not an existing.
View 2 Replies
Nov 16, 2009
I have working on a project to add details to a database. I'm having trouble with the connection string, the code is as follows:
Code:
Public Function AddContactToDatabase(ByVal sFirstName As String, ByVal sLastName As String, ByVal sAddress1 As String, ByVal sAddress2 As String, ByVal sAddress3 As String, ByVal sAddress4 As String, ByVal dDOB As Date, ByVal sPhone As String)
[Code]......
View 2 Replies
Jan 24, 2010
[Code]....
Thought I should probably say im using Windows 7 and the 2010 beta Visual studio
View 1 Replies
Feb 4, 2009
Using VB 2008 Express /Using SQL Server Express/Database name is "StopData"/Computer name is "LAPTOP"?Here's what I have.
Code:
Imports System.Data.SqlClient
Public Class frmMain
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code].....
View 1 Replies
Jan 15, 2012
I have a database app that I wrote in VB6 a while back that uses Access as the backend. I have installed the app on Windows 7 pc's and all works fine....most of the time.On some pc's I see an issue where if I replace, rename, or even remove the DB, my app (b/c of something to do with Windows 7) still sees and reads the information from the old DB. It seems no matter what I do, I cannot "remove" the .mdb file from the system. As one can imagine, this is making it very hard to replace the outdated db with an updated version. I never experienced anything like this running the app in the XP environment.
View 3 Replies