I'm creating a table with the CREATE statement and it is working fine, but I have to lopp thru one of the columns. I have a value on variable and I will have to create the column depending on the variable value. Here is my code. I need to loop thru the Rnd column renaming it like this
[code]....
now i am doing final year project in vb.net and ms.access.but how i will connect vb.net with ms.acess data base table.
View 5 RepliesI am an old VB2 programmer and in the process of moving up. In VB2 I could obtain a data row via and index on an access table. I can not find an example on how to do this. I can retrieve a single row using a query, but an index would be faster. I know in Oracle use can use a hirt to direct the query to use the index.Here is what I was during in VB2 (Sample) with no hint.
Set Stock_Tbl = "DataBaseName".openTable(Stock_Tbl_Name)
Stock_Tbl.Index="Symbol_Idx"
Stock.Tbl.Seek="MSFT"
[code]....
I am a beginner programer. I am working on a windows form in vb.net Visual Studio 2010I have several text boxes, dropdowns, radio buttons and check boxes in my windows forma.
View 1 RepliesI have a IF statement which is checking each row in the data table (for a match) and ELSE statement with commands which are executed if the If statement is not satisfied. Now I would like to write like so that it goes to the Else part BUT ONLY for values which are not satisfied in the IF statement. If I am more specific; I would like to calculate values if a match is found and just print them if it is not fond (usually there are both cases). Now the problem is the bold text; if there is a match found I don't want it processed BUT if the match is found I do. How can I write that?
currencyPosition = 0
Dim d As Integer = w + 100
For Each currency In Ary
[CODE]..........................
We are creating a VB program for school to collect data on student attendance and populate it to a table. I have all of the 'GET' statements but am having trouble creating the 'Insert' procedure. This is what I have so far. The form being used to fill the table has 4 items being recorded. 'Present' radio button marked as present, tardy or absent; StudentId, PeriodId and date. Not sure if we are on the right track. The target table is tmAttendance. There are approximately 25 rows of data on the input form.
View 3 RepliesModule Module1
Dim Bf, Bt, Lgt, Total, Pwr, Valu, Val2 As Integer
Dim InNum, Temp, OutNum As String
[code]....
I, will just explain a few areas of this to ease the process of understanding it:
1-The conversion Subs are to be used for values such as A7 in Hexadecimal
2-The Err Boolean will hopefully be used to link back to the top in the event of an error
3-Apollogies for the abreviated variable names, it simplifies things in my mind but winds my fellow students and teacher up no end.
This code is not fully functional yet, however I believe it should give an answer for my test value of 800 Base 10 to Base 8 (1440), however when the program runs in debug mode I can enter the three inputs but then it leaves two lines and gives an unresponsive flashing cursor.
I'm working on a simple base form in which all the other forms in the project will inherit.This base form only adds 5 properties (at the moment) dealing with painting a gradient background. The problem I'm facing right now is when I change a property on Form1 (the test form) and click run it doesn't show that change. I also checked the .designer.vb file and when I make a change it's not added to the code behind file, I'm at a loss right now to why
View 5 RepliesIn our application, we have a number of Windows Services (more than 30) that must run behind the scenes to process data at given times throughout the day. I was attempting to create a BaseService class that I could inherit from that would log to our database when the service started or stopped as well as some other common functionality. However, I ran into a show stopper in trying to create BaseService as MustInherit as we have a number of MustOverride properties. The issue lies in:
<MTAThread()> Shared Sub Main()
Our code is all in VB (as you can probably tell). Given that it is a Shared method, I cannot have it be overriden (i.e. make it MustOverride). Without this method, the code will not compile, however it will not really work in the base class. The code in this method is:
Dim ServicesToRun() As System.ServiceProcess.ServiceBase
ServicesToRun = New System.ServiceProcess.ServiceBase() {New BaseService}
System.ServiceProcess.ServiceBase.Run(ServicesToRun)
The BaseService (the name of my base class) cannot be created because it is specified as MustInherit. And therein lies my problem. I cannot create this in the Base Class and cannot override it in the inheriting classes.
I have a class structure and am attempting to create an array of object instances from the class some instances are parents and some are children Code snippets,
Parent Class object
Option Strict On
Option Explicit On
Public Class cTransportItem
[code]....
I am writing a game editor, and have a lot of different "tool" objects. They all inherit from BTool and have the same constructor. I would like to dynamically populate a toolbox at runtime with buttons that correspond to these tools, and when clicked have them create an instance of that tool and set it as the current tool. Is this possible, and if so will it be better/easier than creating those buttons by hand?
View 3 RepliesI am building a data based application using VB 2008 an SQL Express. I need to create textboxes on my form using code, (With & End With) method. I need a simple code string that will allow the app to check if the field to wich the textbox wil be databound is Nul, If so the textbox will not be created.
View 8 RepliesI am using VB 2008 with Oracle8i Database
Dim rsResult as new ADODB.Recordset
Do While Not rsResult.EOF
...........FILLING mshflexgrid.
[code]....
During MoveNext, i am getting this error, -21474667259 Insufficient base table information for updating or refreshing There is a problem in formating, but it showing error on recordset....why..?
how can i insert data from data base with selected Datagridview columns i have insert combobox to Datagridview and it can load data from DB now i need insert data to another columns in Datagridview when i change combobox items?
View 7 RepliesI am trying to read and save data into a access Database but using the rows and colunms valeu can
View 1 RepliesHow would you add data source to your combobox from a combobox that is connected to the access atabase?they are both ın the same form of course and the software language ıs Visual Basic. I ve got two comboboxes that I need to connect with eachother combobox1 is showing the "itemsonsell" from the "table_items" table from my access database, the second one should show the "prices" value from "table_items" depending on which "itemsonsell" item is chosen on combobox1,I ve done the solution below,but it didnt seem to be working,it is showing all the "prices" that are under the "table_items" table's "prices" class.
[Code]....
i just want to know how to get a template and store it in a data base without using data set
View 1 RepliesI am getting following error when I am trying to use Convert.FromBase64String "The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or a non-white space character among the padding characters."
Dim payloadBytes = Convert.FromBase64String(payloadBase64)
Basically when my facebook registration form [URL]mphone field has a dash in it and encoded string is posted to other page and I am trying to decode it there which creates this error. Basically I am trying to extract data from Facebook Signed Request.
I am using following code before calling my mainform. This code is used to have a Login window before the main application starts.[code]....
View 1 RepliesI have properly configure the database connection. I wanted to get data from the database to 2 text boxes.
[code]...
l cant get add data to my data base or delete any.l am using mysqlworkbench 5.3 CE , this is what l have done in vb.net. [code]
View 6 RepliesI have changed my Data Base location to external now I am getting an error. I know way, I need to fix it but do not know where
View 4 RepliesI would like to ask how to do a GUI base data binding? without righting any lines of code in terms of adding,editing, deleting or searching records from the database to your application.
View 9 RepliesCode for saving javascripts info in data base whats the procedure. Sql server 2005 databasevb.net
View 1 Replieshow to my record connect with data base
View 3 Replieshow to store pdf file in data base using visual basic?
View 2 RepliesIs anyone any good with Databases & VB if so could you give me your opinion on the diagram i have drew and my application.ive never used a database before but would like to encorprate one into my app - i have done a diagram - i would like to know if it is possible to do and what type of data base would be esiest to do it with.
View 9 RepliesI am trying to familiarise my self with connecting to SQL and manipulating data and I seem to have fallen at the first hurdle I am trying to programmtically connect to a database and fill a data grid with a dataset.
The problem seems to be with the data provider my code is:
Dim strConnection As String = "Data Source=GARY-LAPTOPSQLEXPRESS;Initial Catalog=OriginalFileLocations;Integrated Security=True;Provider=SQLOLEDB"
Dim cnnOriginalFileLo As OleDbConnection = New OleDbConnection
[Code]....
I used to be able to program in VB6 and am now trying to learn .netI am trying to familiarise my self with connecting to SQL and manipulating data and I seem to have fallen at the first hurdleI am trying to programmtically connect to a database and fill a data grid with a dataset.
View 9 Replieswell my project is to do a BD with search and a popup or text box as remember cause i have "date" as field ... well i have done with success the DB and the search field but i dont know how to do th "remember + popup/textbox"
View 9 Replies