Program To Show Time Tables?

Jan 3, 2010

I'm currently trying to create a program that includes a text box (to input a number into), a button and a list box that will display the times tables for the number that is entered into the text box.

The idea of the program is so that a user can enter a number into the text box, for example, the number 5 and all the times tables (up to 12) will be displayed[code]...

View 1 Replies


ADVERTISEMENT

Fill Combobox Using SQL Show Tables - Datagridview Does Show Table Names In Db Using The SHOW TABLES Sql Statment

Jun 6, 2011

SQL statements:

SQL = "SHOW TABLES;"
Try

conn.Open()

The remarked area works fine when I'm accessing a specific table. I've successfully inserted the products_model field into the combobox too. The datagridview does show the table names in the db using the SHOW TABLES sql statment, but I'm not understanding how to get this info into the combobox instead.

View 1 Replies

Join Two Tables In Dataset And Show In Gridview Using Program 2008?

Jan 27, 2010

How to join two tables in dataset and show in gridview using vb.net 2008?

View 1 Replies

To Add More Tables - Access All My Tables Togather At A Time

Mar 25, 2009

I have a 5 tables in my database and i want to access all my tables togather at a time.e.g.I have a code for one table i.e. rs.Open "select * from Group_info", con, adOpenDynamic, adLockBatchOptimistic. instead of Group_info table i want to access 5 tables also as Login_table,User_info table,group_name table etc. How i do that

View 11 Replies

List To Update Every Time And Show The Values Each Time To Which The Previous Value Is Added To The New Calculation?

Jun 22, 2010

The idea with this form is to add the futures which is calculated when the button is pushed but I need the list to update every time and show the values each time to which the previous value is added to the new calculation, e.g. of what it should look like in listbox:

Year 1: $1,290.93
Year 2: $2,724.32
Year 3: $4,350.76
etc....

I have been working on this a while and I am at a standstill, I was given a function to clear the form everytime it calculates but I don't know how to implement it, I am new to VB. Here is what I have so far:

Public Class frmFutureValue
Private Sub btnCalculate_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles btnCalculate.Click

[code]....

View 7 Replies

Show Messagebox/play Sound When System Time = Time Displayed In Listview?

Nov 13, 2010

Basically i'm trying making a task manager program for myself. I want to know how I can display a message box and or play a sound when system time = time displayed in listview. I have used a dropdown box for the user to select which option they would like to select - sound or message box to popup. The data for the task will be stored in a listview box. I want it so that when the date and the time is = to the date and time set for the reminder the action will follow.Here is my code so far:

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim notext As String = ""
If TextBox1.Text = notext Then[code]....

View 12 Replies

Show Records From Other Tables?

Mar 15, 2012

i want to show records from other tables but this error occurs

Sub fillorderdetail()
conn.Open()
Dim adpt As New SqlDataAdapter("select * from orderdetail", conn)

[Code].....

View 1 Replies

Cant Get The SQL Statement To Show All The Tables Within The Database

Jun 21, 2010

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].....

View 3 Replies

Show All Tables Combined Inside One Table?

Oct 26, 2011

I've got a database like this (Below)

What kind of SQL Query do I need to show all those tables combined inside one table?

View 5 Replies

Show Data From Two Related Tables In A Datagridview?

Dec 21, 2010

I am trying to produce a form in VB2008 which shows data from two related database tables, and then allows the data in one of the tables to be updated. I would like to do this using a DataGridView, but I have no idea how I would go about this.

View 4 Replies

Create Tables At Run-time?

Jun 5, 2011

Possible to create new tables in my database at runtime. What components will I have to use?

View 2 Replies

Saving In Two Tables At The Same Time?

Aug 31, 2009

i have two tables.. mainTable and tempTable..

in click event i save records to this table.. this table are identical in its structure. on my code i used 2 insert statement to store records to the two tables..

is there an other approach and a more easy way to do this? i mean without using two insert statement?

View 4 Replies

Compare 2 Sql Tables And Show Data That Are In Table 1 But Not In Table2?

Oct 29, 2009

how to compare 2 sql tables and show data that are in table 1 but not in table2?

Dim strSQLL As String = "Select t1.run from ML533 t1 left join portal t2 on t1.[run] = t2.[runNo] where t1.[run] <> t2.[runNo]"
Dim comm As New System.Data.SqlClient.SqlCommand(strSQLL, conn)
Dim ds1 As DataSet = New DataSet()

[code]....

i have tried google and other sites.. but still cannot find solution. maybe i post the wrong question. but i manage to do this code. but its only shows only 1 record missing, but its supposed to show 5 records that r missing.

View 3 Replies

Inserting Data Into The DataGridView. How To Show Columns From Different Tables

Jan 26, 2011

I need to get a table on my Form that has different columns from differen tables.As I call many tables by their Identity ID, I also need a way to show the information from that table.I created a query in my TableAdapter which selects information from 2 different tables. Tested it in the query builder and all was OK.I tried to put an empty DataGridView onto my Form and inserted the correct BindingSource for my Data Source.I then added a query and selected the query I created in my TableAdapter.

View 4 Replies

IDE :: Can't Save Data In Two Tables At The Same Time?

Feb 24, 2009

I have two tables < student > and <class> . In vb2008 i make the connection to the database, display the data in both tables, edit existing data. The problem is that when i try to insert new rows to both tables there is a problem when i try to save both tables at the same time. The save button is in the studentBindingNavigator. I connect to the db through the Add New Data Source. The message i get is Can not insert or change a record beause it requires a relevant record in table student. Does anyone know anything about it?The two tables are related to each other.

View 1 Replies

Navigating Multiple Tables At A Time?

Jun 9, 2011

Is it possible to navigate multiple tables at a time.... The two tables are joined with primary and foreign key relationship...

some site to which i can refer or some sample code for all first,next,previous,last

I can do it when its single table....

Private Sub btnFirst_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnFirst.Click
' con.Open()

[Code]......

View 4 Replies

Save Data To Both Tables At The Same Time?

Apr 29, 2010

I dragged 2 tables onto a form, the nav bar at the top showed up, but it only saves data for one table for some reason - how can I make it save data to both tables at the same time? I looked up the properties, but I can only select one dataadapter

View 4 Replies

Asp.net IE6 And Firefox For HTML Tables - Show The Whole Thing In A Small Panel At The Top Of The Page?

Mar 17, 2010

I'm doing the first bit of web-page development I've done in years, in VS2008, using VB.net. I have a fairly simple layout, which is using several nested tables. IE6 displays the layout just fine, but Firefox for some reason shows the whole thing in a small panel at the top of the page, with a scrollbar.

View 1 Replies

Time Formating And Calculation - Time Value In My Program ?

Feb 23, 2010

With a Time value in my program. Basically, I am importing a travel Time from a database e.g. 3:45 so it takes 3 hrs and 45 minutes to get from a to b. I then want to double this - 3:45 * 2 = 7:30, and then want to multiply it by a cost e.g. travel is charged at 25 per hour. so it would be total travel time = 7:30. Travel cost = 25. Total Travel Cost = 7:30 * 25. In the access db, it is stored as a text field, and then imported in vb as a string.

View 1 Replies

Add Tables To RichTextBoxes In Program?

Feb 29, 2012

How do I add tables to a RichTextBox in VB.NET 2010?

I've tried adding the tables by using RTF codes, but I can't get that to work. And there is nothing like richTextBox1.AddTable() which would make things very simple. At least, if there is, I haven't found it.

View 1 Replies

Insert Into Two Tables From Program?

Mar 18, 2011

I want to insert two values into two tables of a sql database which i had created. In my vb.net code my problem is if i insert it get insterted but only in one table else sometimes it's not getting inside.[code]...

View 2 Replies

.net - VB - Show Msgbox Once A Time(r)?

Jun 2, 2012

I have the following code Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick Dim mesaj As New Integer

[Code]...

The timer interval is set to 5000(5 seconds), but every time when the timer is ticking the msgbox appears on screen but the in the file msg.txt is writting once. So, The timer check if that unic is different from unic1, and if is different shows up a msg box, and it's writting the new line in msg.txt, but on next timer tick, even if the unic and unic1 are equals the msgbox shows up anyway, but it's more interesting because it doesn't write again in file, only shows up the msgbox. I don't understand this.

View 1 Replies

Show Many Messagebox In Same Time?

Sep 7, 2011

how i can do this to show many message box without click OK to see the another like in this video [URL]

View 1 Replies

Rename Tables In SQL Databases With Program?

Oct 26, 2011

I am looking for the proper code format to rename a table of an SQL file within VB.net.[code]...

View 7 Replies

When Program Executes Must Show An Notification That Program Is Running

May 1, 2009

I want to create a program that will run every start of computer and will check if it is 9:00 AM and can only be seen at the bottom right cornner besides the clock. When the program executes must show an notification that the program is running.

View 4 Replies

Asp.net - Change This Code In .net To Show Just The Time?

Dec 10, 2010

how to convert this code in vb.net to show only time instead of date and time in vb.net

Dim UTCTime As Date = Date.UtcNow
Dim IndianTime As DateTime = UTCTime.AddHours(5.5)
TextBox1.Text = IndianTime

View 5 Replies

Msgbox To Show Me Both Values At The Same Time?

Jun 10, 2009

Let's say I have the this statment If textbox1.text <> textbox2.text Then

Now I want the msgbox to show me both values at the same time. I know if I want it to show me the value of one of the textbox i just have to use & val(textbox1 or 2.text) &. How do I make it show me both of them at the same time.

View 1 Replies

Show Time(HH:MM:SS) From Excel To Textbox?

May 31, 2010

I have a problem about read in excel to textbox in VB,I want show time (format hh:mm:ss) of "A1"(is 16:50:20) in excel to textbox in VB but I get "10.720 " in text box

View 9 Replies

Why Control Needs So Many Time To Show Transparent

Mar 24, 2012

i know that VB.net and above don't use true transparency(and maybe true opacy) except forms, but even them have 1 visual bug. because if the we put the backcolor igual to transparent key, the picturebox is transparent... but give us a form hole.i found several codes that do transparency, but i see 1 problem on them, because the control needs time to be transparent.[code]some codes(that i founded on internet) are diferent but give us the same result.can anyone explain to me why the control needs so many time to show transparent?(i have tested using the keyboard to move the control, and i see the control is like visible and then hide and then visible. and if i continue click on key, the control isn't showed until i release the key)

View 7 Replies

Query Multiple Tables In A VB2008 Program Using SQL?

Dec 13, 2009

I have a 4 table database and need to query at least 2 tables (the single table query works fine). The output goes in textboxes / labels on an existing form.

I'm trying something like this:

Private
Sub AddCustomer_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

[Code].....

View 12 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved