raymyster

You can do it using ODBC as following: [CODE]Imports System.Data.Odbc Public Class frmMain Dim MyConString = "Driver={SQL Server Native Client 10.0};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;" Dim Con As New OdbcConnection With {.ConnectionString = MyConString} Dim ds As New DataSet Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Con.Open() Dim cmd …

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 special character. try this following code : [CODE] Private Sub textDate_KeyPress(ByVal sender As Object, ByVal …

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. [CODE]Dim dr As OleDbDataReader If dr.HasRows Then 'Do actions here! Else MessageBox.Show("No records forund", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error) END IF[/CODE] Regards.

[CODE=vb.net]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) osht= owb.Worksheets(1) ocell = osht.Range("A1")[/CODE]

prove the formula: (111*)* = (11 + 111)* thank you for helping

hello, Dijkstra's algorithm is it more like greedy search or more like A* or none. Thanks

very interesting!

Hello Community, I have the following query: [CODE]SELECT Inventory.Inventory_Id, Inventory.Inventory_description, Inventory.Inventory_stock_count, nz((SELECT Sum(Order.item_qty) AS SumOfitem_qty FROM [Order] WHERE Order.From_date<=Date() AND (Order.To_date)>=Date() AND Order.Item_ID="I" & Inventory.Inventory_Id),0) AS CurrentlyOut, [Inventory_stock_count]-Nz((SELECT Sum(Order.item_qty) AS SumOfitem_qty FROM [Order] WHERE Order.From_date<=Date() AND (Order.To_date)>=Date() AND Order.Item_ID="I" & Inventory.Inventory_Id),0) AS NetHere FROM Inventory;[/CODE] This query runs perfectly under …

[LIST=1] [*] 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 c) scroll down to system.management d) press OK [*]Add a label …

why not use ado.net instead? use commandtext its easier!

In the Combobox keyPress event add this: [CODE] e.KeyChar = ChrW(0)[/CODE] [CODE]Private Sub ComboBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles ComboBox4.KeyPress e.KeyChar = ChrW(0) End Sub[/CODE] Regards.

Use the stack class in a program that reads a String, one character at a time, and determine whether the String contains balanced parentheses, that is , for each left parenthesis ( if there any ) there is exactly one matching right parenthesis later in the String . so the …

i need to make a program that will identify the values of ABCDE that will result to EDCBA if you will multiply it with 4. looks like this: ABCDE x 4 = EDCBA i already have the values, it's 21978 x 4 = 87912 but i dont know how to …