Changing field sizes in database tables
I do it like this:
'First creating a temp table, temptabell, and copying data to it from table tabell
Dim strSql2 As String = "SELECT * INTO [" & temptabell & "] FROM [" & tabell & "]"
Dim dbCommand2 As New OleDbCommand(strSql2, cn)
[Code]....
This is working, this is how I did it in VB6, but I wonder, is there an easier way?
Would it be possible to change field sizes more directly?
Using a Windows Form with a Menu bar and a Gridview control, I have bound data to the GridView from an MS Access 2000 database query using Dataset. The contents of this table displays just fine. But I want to be able for the user to select a different query from the menu bar and display it in the same GridView control. How can I change the query bound to the control (in VB)?
Public Class Actinide Private Sub Minerals_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Me.Actinide_Series__Radioactive_TableAdapter.Fill(Me.Minerals2000DataSet._Actinide_Series__Radioactive_) End Sub Private Sub LanthanideToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LanthanideToolStri
[code]....
The error message that it is giving me is:
"Value of type 'Mineralogy.Minerals2000DataSet.Yttrium_MineralsDa ta Table cannot be converted to
'Mineralogy.Minerals2000DataSet._Actinide_Series__ Radioactive_Data Table'.
The query is getting information from two seperate tables,so I can't just bind a table to the control and then filter what is displayed using SQL.
I have a question about For function. I have in form 2 pictureboxes and i want that one which size is 300x300 will be resized to 100x100 and second which is 100x100 will be resized to 300x300 So im using this code for that:[code]But why sizes changing instantly after ~1.5 seconds? For function doesn't shows all action.
View 11 RepliesI am in the process of testing my application on different language versions of XP and Vista.I notice that some containers size differently in the chinese version of the OS. This is particularly noticeable with panels which always appear to be about 10% smaller in height. The width is ok, its just the height that is changing. I can overcome the problem by making sure that all controls within the container are placed towards the top but it then doesn't make the UI look as good when running under English versions of the OS.
View 4 RepliesI'm looking for a way to combine a field from multiple tables into a single field in a new table. Because the data populating the tables is coming from an outside source, I would prefer not to change the data in the original files. I have a separate table for each year because this is the way the data is provided. The field layout is not consistent from year to year, but each year there is a field that we'll call "score." I'd like to pull the field "score" from each year's table and have it populate a "score" column in a new table along with the year of the data so that all the years' scores are in the same place. Is there a way to do this using Visual Basic + Access?
View 3 RepliesI would like to have an application setting wherein the user could set the font size of the controls at run-time.
View 10 RepliesI am using ASP.NET with SQL Server 2005.
My date get saved in the database with data type = "smalldatetime".
I am displaying the date value into a text box called txtDate with a Reader......
Dim conn As Data.SqlClient.SqlConnection
Dim Comm As Data.SqlClient.SqlCommand
Dim reader As Data.SqlClient.SqlDataReader
[Code]....
But currently my date get displayed as "2008/06/30 12:00:00 AM" and i want to display it as "30 June 2008".
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:.....................
here what i try to get:
Table A:
Field: Name A
Field: Id_A
[Code]....
In fact i want to list in grid the table A with a column which contains a checkbox and is checked if the item is include in table B (field TableA_Id_A).
This is the code I'm using:
Dim conn As MySqlConnection
conn = New MySQLConnection()
conn.ConnectionString = "server=domain.com; user id=user; password=password; database=dbname"
[Code].....
So how can I create the tables for the username and password field?
I want to multiply textbox value with ms access tables field value and insert the output in field two .i get error : table is not declared.
Private Sub TextBox1_Change()
If IsNumeric(TextBox1.text) Then
table("table1").field2("record1").text = TextBox1.Text *
[Code].....
There are lots of questions about this but I've not been able to solve my problem using the answers to any of them (after many, many attempts..)
I'm working in vb.net creating an asp.net web application. I have an SqlDataSource and a GridView on my page.
I want to change the DoNotMail boolean value represented by a Gridview checkbox and automatically update in the database if the checkbox is checked from 0 (False, Will Mail) to 1 (True, Won't Mail) here is the code I used. [code]...
is it possible to do a two way sync on the entire gridview when the user hits a button so you don't have to do an update every time a row is changed? because the user might check the box and then check another box then uncheck a box and it would be a lot of updates...
I created a local Database in VB2008 with 4 tables, the problem is that I have a textbox in one table and a combobox in other table and I want that the information that I put in textbox appear after in combobox from the other table... that's possible?
Table: Filmes ... Field: NomeTextBox
Table: Tempo de Aluguer ... Field: Nome_FilmeComboBox
I'm Using vb.net 2008 i want display 2 different field in crystal report...here the code in form at vb.net 2008
If Not IO.File.Exists(path) Then
Throw (New Exception("Unable to locate report file:" & _
vbCrLf & path))
End If
[code]....
what i want is when i choose "TBL1" then at crystal report that only show the field from table one... = T1_CD then if i choose "TBL2" then at crystal report only show field and the data from table two... = T2_CD when i make file.rpt in crystal report i just can only drag field from table one.. how i can combine another field from table two?is neccesary that i must passing parameter from form at vb.net to crystal report?
If a field in a datarepeater is empty i would like to change the backcolor of that field to red. If there is data in the field the backcolor must be normal (white) I have been trying this for the last several days without any success.
View 1 RepliesDim query as String = "Select * from openquery (devbook, 'SELECT wb.arrival_time FROM web_bookings wb ')"All I need is to convert my arrival_time into a datetime field in the query
View 1 RepliesI am creating a database in VB.NET for a movie rental place. I currently have three forms;
Member Information
DVD Information
Borrow DVDs
What I would like to do is when I am viewing a member's details, if I click a button 'Borrow DVD for Member', the member's ID number transfers over to the Borrow DVDs table in the Member ID which also would hold some information from the DVD Information table, but I'm sure if i can figure out how to do this firstly, I will be able to apply the same rule and work it out myself.I have been trying to use a query statement like;
INSERT INTO [Borrow DVDs].[Member ID] [IN goodstuffvideos.mdb]
SELECT [Member Information].[Member ID]
FROM [Member Information]
but that has been coming up with error codes and completely not working.
Borrow DVDs table fields are: Borrow ID, Member ID, DVD ID Number, Hiring Fee, Borrowing Limit?
DVD Information table fields are: DVD ID Number, Title, Rating, Hiring Fee, Borrowing Limit Member?
Information table fields are: Member ID, Family Name, Given Name, Address, Town/Suburb, Postcode?
The error coming up is; Error in INSERT statement. Unable to parse query text.And under that it says The query cannot be represented graphically in the Diagram and Criteria Pane.
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 RepliesUpon changing the field size a game should restart. Upon trying to do so I see the previous grid (e.g. 10x10) displayed on top of the new one (e.g. 4x4). How would I prevent this and indeed start the game fresh?
View 10 RepliesI had a dataSet which link to a database. I need to add one field inside the database, After adding the field, how can I update and link it to the dataSet?
View 4 Replieshow 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] .....