I was just wondering if I can retrieve two tables from my database to one form? because i'm trying it but it doesn't seem to be working. just the first table i'm trying to retrieve is working.
View 7 RepliesThis is my coding in vb.net. I have used two database (1) party (2)partydup. Structure of the tables: party table: fields :code, name1,add1,add2 etc. partyduptable: fields: code, description
In both tables i have common field ("code"). I tried to retrieve the value of "description" field from partydup table when the "code" field in both the tables are same. I run the below coding but it is showing the error as "No data exists for the row/column". But i have a record which contains the code field value as 123 in both the tables. Still it is showing the error.
Imports System.IO
Imports System.Data.OleDb
Imports System.Data.OleDb.OleDbConnection
[Code].....
I still cant think a way to get my database from the datagrid in form2 and display it on form3..my little program is like a schedule that you'll edit your students class hour,subject and teacher.. then after that when you view your schedule.. you'll see only what subject you'll be at in that student data schedule...i've tried dbgrid.columns(n).text = label1.caption, but i found out that it'll copy the data but only those on the 1st row >.<. ill upload my program here for you guys to have a hint what program exactly im making on.
Here's the link :[URL]
For some unkown reason, my database tables will not drag and load onto a vb form, just get a circle with a slash in the middle. Trying to tanslate the table into textbox's.
View 4 RepliesI am new to the forum and I was wondering if anyone would know how to display data from the tables of a MS Access database on labels on a form. The code underneath is my code for saving inputted data from textboxes.
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
objDA = New OleDbDataAdapter("SELECT * FROM CDetails", "Provider=Microsoft.Jet.OLEDB.4.0;Password=;" & "User ID=Admin;Data Source =" & Application.StartupPath & "CustomerDetails.mdb")
objDS = New Data.DataSet()
objCB = New OleDbCommandBuilder(objDA)
[Code] .....
I would like to show these saved details onto another form. Is there a way to select rows and cells in the database and fetch the data in them to display them onto labels?
I dont know how to dynamically populate a dataset based off the tables in an existing database.Once I can get the dataset to populate, I can then move forward with the next step of the project.
View 1 Replies[img]C:\Users\Vikas\Pictures\database.jpg[/img]
C:\Users\Vikas\Pictures\untitled.jpg
[code].....
I am using VS2008 and SQLite. I have created a database and several tables and am attempting to populate the tables with data from arrays.
The following code (example) works fine but stops after it inserts 30 to 50 records. I am running the VB code in debug mode and when it stops, I press pause to see where it is. It stops on "SQLcommand.ExecuteNonQuery()" and when I press continue (F5) it will insert another 30 to 50 records.
I do not get an error message. Is this a timeout issue? How do I keep the loop running to the end of the array?
Following is example code.
Dim
SQLconnect As New SQLite.SQLiteConnection()
Dim SQLcommand As SQLiteCommand
CODE:.....................
I m trying to retrieve all tables with thr names to a listbox from my access DB.My DB in remotely located
Imports System.Data.OleDb
Public Class Form1
Dim objconn As OleDbConnection
Dim objcmd As OleDbCommand
[Code]....
I am making a survey-application in winforms that is connected to a MySQL database. Now I want to show the alternatives of a question, and how many answered each question. I have a table for alternatives called tblAlt and a table for answers from users called tblAnswers.
There are only 5 alternatives for each question. Is there a way to get each alternative, and how many answered each of them with one query?
This is what I made so far, but this is definitely wrong:
SELECT tblAlt.altText, Count(tblAnswers.answerID)
FROM tblAlt, tblAnswers
WHERE tblAlt.questionID = " & CInt(questionID) & "
[Code]....
I have a report made in Crystal Reports XI. The report is generated and exported to PDF in visual basic script using COM interface. Generally everything is running smoothly, but in one case generation breaks with error: Failed to retrieve data from the database. Details: [Database Vendor Code 9421]
Database used is MSSQL 2005 connected over ODBC to CR XI. When I am opening report with exactly the same parameters in Designer, everything works fine.It looks like it is data related, but it is hard to trace since the whole report is pretty sophisticated. Anyway I spent half a day on crawling over Dr. Google and it seems that he has no clue what might be an issue.
i need to make a database application that can write/retrieve cells/datasets from/to a database i buyed a book in there was an example of how to create a database application while debugging i had the "Object reference not set to an instance of an object." error and it highlighted this code
objDataRow = objDataSet.Tables("KlantenTable").NewRow
now the problem is here i declare something later in the code i write to it
objDataSet.Tables("KlantenDataTable").Rows.Add(objDataRow)
[Code]....
I am trying to make a database, fill it with tables and then fill the tables. I am having problems connecting to the server and am really not sure why. I have posted this thread in two areas of this site because I was not sure what was the best area to put it in. [code]
View 3 RepliesI had issues in refreshing a form that is bound to different tables in a database. Various forms allow the user to change and add and update information on the form via the database. I had created a public sub in that form that the other forms could call, after saving the data, that was supposed to refresh the data on the main form. This was not working so I researched the problem. I came across this page which pertains to Form.Activated: [url]
I placed all of the table adapter fills into this event, instead of in Form_Load, and it seems to work now, when the form first loads, and when other forms update data. My question is does anyone have experience using this and what are the consequences, if any, in using this to reload/refresh the data showing on the form?
I have to write an application that consists of mainly one main form, but several different things I wanna display. Pretty standard I guess. So there is a menu, some controls, and the main stuff below (ranging form graphs, tables, dropdown boxes, print preview, etc). I would like to use it like one would use frames in html, design an object that is limited to a box or panel that I define. The literature I have does not give me a clear idea of how to do this (yet). The most obvious seem to be the use of MDI, open a predefined form with no borders, maximize it before showing and remove all minimize/maximize options. But that does not work so well. The form inside the MDI parent does not fit the size that is given for it when it is loaded. e.g.
[CODE]:......................
So my main question is: Is MDI the way to go here at all or are there better/easyer ways to achieve this? If MDI is the way to go, how do I sucessfully restrict a child form inside another object, without giving the user any opportunity to resize (i noticed that I have minnimize/maximize/close buttons, even if I disable them on the child forms themselves)
how can I get all Tables from a Database, which I'm connected to. By the way, this is a MSDE Database.
View 3 RepliesI've got two different tables in my database. One is Class and other one is LAREACT and both of them have a key field of MAIN FACILITY USED. In the following part of my code a DataTable will be generated based on the sum of the records on both tables.Based on the bellow code ACTIVITYLOOKUP datatable is having "MAIN FACILITY USED","Description","TypeName","Type","Id" columns. The issue happens when there is a row with the same MAIN FACILITY USED entity. The datatable will not show it (filter it?). Do you know where the problem lies? and how it will be fixed without any modification in database?
[Code]...
How to bind a database having 2 or more tables in it using vb.net.
View 1 RepliesI have a form with 3 datagridview controls that are bound to tables in a sql database. When the form loads for the first time the data is displayed correctly. If I add data to the db on another form then show the first form again the data displayed does not include the new data. If I close the app and then open it again then the new data is displayed.I cannot figure out how to manually refresh the gridview. I have tried calling the fill method of the adapter, using the refresh method of the gridview and parent control and form with still no luck. I have a ASP.net project I'm working on also and it is so easy to refresh the sqldatacontrol and the gridview and I would have though a win form would have been just as easy if not easier.
View 2 RepliesI have a sql database and am using VB express 2008 in WPF and I want to know, how do I clear every record from a table in a dataset?
View 12 RepliesI have a database (acces) with 3 tables Table one has Id nr 1000 table 2 1000000 table 3 Id nr 1000000000 First table makes Id nr from 1001 to 1999. On Id nr 1001 i have multiple ID nr on the seccond table 10010000 to 10019999 and on the second table ID nr 10010001 i have multiple ID nr on the third table. This will last a while but the tables will fill up. Now i work with the Max value to find the highest ID number and add one to it.
[Code]...
how to create a local database, create some tables and set relations between those tables (just like in access) and I can show, add, edit and delete that data from a form.
but what I have yet to figure out is if I have 2 tables (i.e: tbleName, tblFood) and I want to have multiple tblFood items show for every 1 tblName item.
I've found that if I add a txtbox of the name table and a datagrid of the food table, the datagrid view shows all the food records, not just the ones for the name txtbox.
this is my code but is not correct
Public Sub ChangePosition()
If Me.BindingContext(DataSet1, "t_bul").Position = -1 Then
Label1.Text = "Record 0 from 0 "
[Code]....
My first method is trying to get all entries in one of the database tables. However when I try to build the solution this is the error I get:
<div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">Error
1 Value of type 'String' cannot be converted to '1-dimensional array of String'.[code]....
I am trying to connect to a SQL DB and loop through some tables. My tables are linked on the EMPLOYID field between UPR00100 and UPR00102. I want to write data as follows:
Level1, EMPLOYID, EmpName (from UPR00100) Level4, EMPLOYID, Address1, Address2,etc..
(from UPR00102)
Here is my data access code. I don't know how to code the loop. I know how to do it in SQL using a cursor but not VB 2005
Option Explicit On
Option Strict On
Imports System.Data
Imports system.Data.SqlClient
Module Module1
[Code] .....
I dont know how to link my table to the database yet i already finished connecting to the application itself. i have four fields on the form as well in the database table. that is
1.word
2.lug_trans
3.Eng_trans
4.meaning
the same fields appear in the database tables. i have to fill and hen after extract the data and display it on another form in four labels
hello everyone, i m using treeview control in vb .net . How do we usee a recursive function to add data at different levels from different tables in a database.
View 2 RepliesI was wondering if there is any way to bind TWO different database tables to ONE textbox in VB? I've spent the whole day going through tutorials and different webpages and I've found nothing at all on this...
Well let me try to explain what I want to do exactly: basically I have multiple buttons on 'Form 1' and a textbox on 'Form 2' asking the user to insert a value which will then go to an Access database. But here is where it gets tricky for me: IF the user presses Button 1, the Value inserted on Form 2 will go to a field in the database whereas if the user presses Button 2 to open Form 2, then the value will go to somewhere else and so on.
This would be easy to do if I was to create multiple forms or multiple textboxes, 1 for each button but what I really need is 1 form/1 textbox that would work for all of them... [URL]
The problem I'm having is that I cant get get the SQL statement to show all the tables within the database.
The code im using is as follows:
Imports System.Data.OleDb
Public Class frmtables
Dim objconnect As OleDbConnection
[Code].....
I am using visual studio 2010 with vb environment, I am connecting to a microsoft access database with 2 tables, one table per form, i can add a record and save it no problem, but when I update a existing record i receive the error, this happens on both tables, i am using the standard navigation buttons on the forms.
View 3 Replies