Hello Community,
I have the following query:

SELECT Inventory.Inventory_Id, Inventory.Inventory_description, Inventory.Inventory_stock_count, nz((SELECT Sum(Order.item_qty) AS SumOfitem_qty
FROM...

very interesting!

Dim oxcel As Excel.Application
Dim owb As Excel.Workbook
Dim osht As Excel.Worksheet
Dim ocell As Excel.Range

oxcel= New Excel.Application
oxcel.Visible = True
owb= oxcel.Workbooks.Open(Path)...

why not use ado.net instead?

use commandtext its easier!

Thanks for using my code :)

you should put a timer & put the code block in a function make that timer call the function every one second & your values will get refreshed every 1 second.

yes you...

you just to handle keychar, but you must know the ascii of letters. this following code will not allowed you to input other character except letters or strings. so u cannot input number or other...

hello,
you didn't provide accurate information in order for me to reply you but i will try to give you some idea, now this is with a data reader.

Dim dr As OleDbDataReader
If dr.HasRows Then
...

You can do it using ODBC as following:

Imports System.Data.Odbc

Public Class frmMain
Dim MyConString = "Driver={SQL Server Native Client...

In the Combobox keyPress event add this:

e.KeyChar = ChrW(0)


Private Sub ComboBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles...

Make a new form
Add reference to the system.management that is:
a) right click on your project solution file
b) go to add reference, you will be taken to a window where first tab is com component...