I am currently creating a product lookup system for a project of mine, however from reading around it has come to my attention that an OLEDB connection will not handle the SQL query below as it will not handle more than a simple "SELECT, FROM". Table: tbl_ProductInformation Field: Product_Name CurrentEntry = Variable storing the users entry [CODE] "SELECT Product_Name FROM tbl_ProductInformation WHERE Product_Name LIKE '*" & CurrentEntry & "*'" [/CODE] The outcome of this query is then put into a listbox. Is there anyway to make the OLEDB SQL query work so that the returned entries will correctly narrow down …

Member Avatar
Member Avatar
+0 forum 16

Anybody who knows how to change word or character in kanji to katakana or vice-versa. I'm using 2 textbox to do this, the first textbox is for katakana and the second textbox is for kanji. What i wanted to do is, whatever i typed in the kanji textbox it will be converted to its corresponding katakana value in the first textbox or vice-versa. Is this possible in vb.net or do i need to use third party software / dll / activeX to be able to do this, anyone please give me a good idea how to deal with this problem. …

Member Avatar
Member Avatar
+0 forum 14

Hey everyone. I received this sql server error and I can't figure out where the trouble is: Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: 'Incorrect syntax near '​'.' Source Error: Line: 46 Error Line: cmdsql.ExecuteNonQuery() Dim connexcel As OleDbConnection Dim daexcel As OleDbDataAdapter Dim dsexcel As DataSet Dim cmdexcel As OleDbCommand Dim drexcel As OleDbDataReader Dim connsql As SqlConnection Dim dasql As SqlDataAdapter Dim dssql As DataSet Dim cmdsql As SqlCommand Dim drsql …

Member Avatar
Member Avatar
+0 forum 3

I have a problem. I want to show two different value in same button. Here is the image of the report---- https://ibb.co/wrrDSDX Try If Not String.IsNullOrEmpty(ComboBox1.Text + TextBox1.Text) Then Dim keyword As String = Me.ComboBox1.Text + TextBox1.Text.Trim() Me.LeaveInfoBindingSource.Filter = "(LeaveCategory LIKE '%" & keyword & "%')" & "OR Convert(PersonalNo,'System.String') LIKE '%" & keyword & "%'" Me.ReportViewer1.RefreshReport() Else Me.LeaveInfoBindingSource.RemoveFilter() formLeaveInfoReport_Load(sender, e) End If

Member Avatar
Member Avatar
+0 forum 2

This application was sending out orders without errors when smtp wasn't secured. Now the clients webmail server was changed to ssl. After making the changes the server times out. I did some research and found this .ConnectType = SmtpConnectType.ConnectSSLAuto I'm anable to assign the SmtpServer.ConnectType = SmtpConnectType.ConnectSSLAuto. This is my code. Dim SmtpServer As New SmtpClient() Dim mail As New MailMessage() SmtpServer.UseDefaultCredentials = False SmtpServer.Credentials = New Net.NetworkCredential(jonDoe@Domain.com, srvPass) SmtpServer.Port = 465 SmtpServer.Host = mail.Domain.com SmtpServer.EnableSsl = true mail = New MailMessage With {.From = New MailAddress(frome) } mail.To.Add(Too) mail.Subject = Subject mail.Body = InputBox("Enter the body here", "Body") For …

Member Avatar
Member Avatar
+1 forum 2

Hello to all. I am developing software in vb.net for sales invoices. Where i need to import invoice data from excel file to vb.net Grid Data View and then save into access db. I will use db data in future for creating customer invoices. I have code that import excel data into GDV successfully, but i d'nt know how to save data in access db. Access db Name "MyInvoice" and table Name is 'InvoiceData'. Please help me to write correct code. Thank You. Imports System.Data.OleDb Imports System.Data.SqlClient Public Class MainForm Private Sub BtnImpExcelFile_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) …

Member Avatar
Member Avatar
+0 forum 1

Hi all, I have a new project with vb.net. I need to always connect with older program that run in foxpro, i need to get dbf table and convert it to mysql table. Can anyone help me ?

Member Avatar
Member Avatar
+0 forum 2

Please i have a textbox, a button and a listview. The listview contains a list of items let's say 20 items. When i enter 3 in the textbox and click on the button, the first three items should be removed likewise if i enter 10, then the first 10 items should be removed. If i enter anything more than 20, the 20 items should be removed. Please help me out. Thanks in advance.

Member Avatar
Member Avatar
+0 forum 1

alright here is my issue i dont know how to even start this problem iam still new to vb so i need lil guidance and help in the right direction. here is the problem : Use a one-dimensional array to solve the following problem: Read in 20 numbers, each of which is between 10 and 100, inclusive. As Each number is read, print it only if it is not a duplicate of a number already read. provide the "worst case" (in which all 20 numbers are different). use the smallest possible array to solve this problem so any ideas to …

Member Avatar
Member Avatar
+0 forum 6

For this particular sub I type the customer id in a text box and then click the button, then I'm trying to get the relative information pertaining to that id. Not sure what I am doing wrong. Comes back with an error message of system.data.sqlclient.sqlexception Recursive common table expression '[customers]' does not contain a top-level UNION ALL operator. Private Sub FillByCustomerIDToolStripButton_Click(ByVal sender As Object, ByVal e As EventArgs) Handles FillByCustomerIDToolStripButton.Click Try Dim customerID As Integer = CInt(CustomerIDToolStripTxtBox.Text) ' LOAD THE CUSTOMERS TABLE WITH THE SELECTED CUSTOMER. Dim id = Me.CustomersTableAdapter.FillByCustomerID(Me.DatabaseDataSet.customers, customerID) If Me.DatabaseDataSet.customers.Count > 0 Then For Each row As …

Member Avatar
Member Avatar
+0 forum 2

So, I created a program in VB.Net with Windows Form and I want the user to be able to create a new user, limited to 5 user accounts only. I also want to know if it's possible to change password and delete user accounts. Can I make it so that each User has their own MS Access database? For example, User 1 can only access Database1 but not Database2. And User 2 can only access Database2 but not Database1. Here is the log-in form that I created that can only have one user account: Public Class Form3 Private Sub Register_Click(sender …

Member Avatar
Member Avatar
+0 forum 1

Hi, I'm creating a project using VB.Net Windows Form and I want to create a Log-In form that can **Add New User (Limited to 5 User Accounts), Delete User Account, and Change Password**. I want to use Microsoft Access with it. What are the codes I should use to create it? I also want each User to have their own database. For example, User 1 can only access Database1 but not Database2. And User 2 can only access Database2 but not Database1. I am a beginner and I only see MySQL tutorials on YouTube but I don't have MySQL. On …

Member Avatar
Member Avatar
+0 forum 2

Hi! We are a 4 member group for our thesis and we already have submitted 5 topic proposals yet nothing was accepted...and here are the topics: enrollment system, gadgets on track, employment resource system, subdivision technical entry pass Now, I need a help for new ideas that can be developed through visual studio and it can be a web-based or window-based projects. Hope you can help me Thanks in advance!

Member Avatar
Member Avatar
+0 forum 37

Through Web Search I found [this link](https://www.daniweb.com/posts/jump/1740388) but I want to know is there a way to do it so the sub items in the dropdown would be colored?

Member Avatar
+0 forum 0

The panel has controls like labels, text boxes, list view and pictures boxes. which is probably more than four pages. I have tried all my best still i cant print all the pages. i surf online for help and found this code. the code works perfect by printing all the pages but leaves the list view and picture boxes. how do i fix this please

Member Avatar
+0 forum 0

Hi there I’m learning vb.net and my main outcome is to be able to find out how to create from scratch custom GUI controls like 7 Segment displays in vb.net mind you and once I have accomplished that to be able to connect the hardware to a serial port like db9 etc: to communicate with the software and control actual 7 segment led displays from software. Sorry for a mouth full So I hope anyone with this knowledge can show me or guide me in the right direction on these specifics design from scratch? I’m prepared to learn everything just …

Member Avatar
Member Avatar
+0 forum 1

I am trying to apply an automatic scrolling down and up in Datagridview Scrollbar. I've seen a related topic (using scrollbar panel) but I dont know how to convert for datagridview auto scrolling up and down. I'll be using Timer for autoscrolling. Here is the code from another topics forum. Please help. Private scrollUp As Boolean = False Private Sub Timer1_Tick(sender As Object, e As EventArgs) Handles Timer1.Tick If scrollUp Then Dim scrollY As Integer = -Panel1.AutoScrollPosition.Y - 1 If scrollY < 0 Then scrollUp = False Else Panel1.AutoScrollPosition = New Point(Panel1.AutoScrollPosition.X, scrollY) End If Else Dim scrollY As Integer …

Member Avatar
+0 forum 0

I have to Create an application that enables the user to create a file named grades.txt in which to store grades. The app should allow the user to write to grades.txt file: student number, student name, surname, subject, individual assignment grade, group assignment grade, test grade. When you click Create button grades.txt should be created in your app Debug folder. When you click display button the file contents should display on datagridview. Display at least 10 records. Use LINQ to read and display file contents to datagridview. I'm not sure where to start.

Member Avatar
+0 forum 0

##**What can you tell us about XSD file in C# ?? Explain in Details..**##

Member Avatar
Member Avatar
+0 forum 1

hi, I have a vb program that wants to retrieve data from MySQL dbase. this code is working fine : Dim vDATE As String vDATE = mDATE.ToString("yyyy/MM/dd", System.Globalization.CultureInfo.InvariantCulture) Dim connstring As String = "server=xxx.xxx.x.xx;database=dbname;uid=idko;Pwd=passko" Using con As New MySqlConnection(connstring) con.Open() Dim query As String = "SELECT issue_date, inc_date, exp_date, total FROM table_name WHERE ISSUE_DATE = @DATE " Dim MYSQLCMD As New MySqlCommand(query, con) MYSQLCMD.Parameters.AddWithValue("@DATE", vDATE) Dim reader As MySqlDataReader = MYSQLCMD.ExecuteReader While reader.Read MessageBox.Show(reader.GetString(0) & vbCr & reader.GetString(1) & vbCr & reader.GetString(2) & vbCr & reader.GetString(3)) End While End Using but the code below give me an error that says …

Member Avatar
Member Avatar
+0 forum 8

How can I get internal HDD_DETLAIS = SerialNumber, Model, Manufacturer,TotalHeads ...... etc. Please help me.. Now my problem is my code run ok, but when I insert external HDD or pen drive then showing the last counting device Details please help .... i want to show only internal HHD device means OS loaded disk "C" drive Thanks Dim HDD_DETLAIS As String Dim HDD As New ManagementObjectSearcher("select * from Win32_DiskDrive") For Each HDDDET In HDD.Get HDD_DETLAIS = HDDDET("SerialNumber") + " Model-" + HDDDET("Model") + " Manufacturer-- " + HDDDET("Manufacturer") ' + " TotalHeads - " + hd("TotalHeads") '+ " Signature - …

Member Avatar
Member Avatar
+0 forum 3

My program fail to generate the auto ID on my text can help me. Private Sub getNextNumber() If Not app.State = ConnectionState.Open Then 'open connection app.Open() End If Dim da As New OleDb.OleDbDataAdapter("select top 1 ID from ADMIN ORDER BY ID desc;", app) Dim dt As New DataTable 'fill data to datatable da.Fill(dt) app.Close() If dt.Rows.Count > 0 Then txtID.Text = (Val(dt.Rows(0)(0)) + 1).ToString.PadLeft(5, "A") Else txtID.Text = "1".PadLeft(5, "A") End If End Sub

Member Avatar
Member Avatar
+0 forum 1

Hello all, I've actually seen a few posts floating around the web (most of which are rather old and none of which were solved) about the same question that I'm having which is this: I have a combobox that is populated with movies with a number corresponding to where it is held in our archives ie. "451 How The Grinch Stole Christmas" What I would really like to do is have an autocomplete routine that would make it possible NOT to have autocomplete only work on the first character. As it stands, with Visual Studio's native autocomplete if my combobox …

Member Avatar
Member Avatar
+0 forum 2

Hello, I have a ComboBox in my WinForm which has data from SQL server (used LINQ to bring up the data). I'd like to have an option just like AutoComplete in VB.NET but not only by the first letter but for a search LIKE. For Example: My ComboBox has there texts: "nighty night" "hi and goodbye" "food is good" So what i'd like to do is when i start typing for example the word "good" a list of options will appear (just like AutoComplete with suggest) and i can choose from: "hi and goodbye" "food is good" Is this option …

Member Avatar
Member Avatar
+0 forum 5

I have looked on the web for a solution to print scrollable panel larger than can be fitted on the screen but couldn't find any solution and it looks like that many people has this problem! PrintForm (printform powerpack component) can not do this because it only capture that part of the panel that is fitted on the screen. And if you want to do this with the PrintDocument component and print all the visible parts of the form grids,tablelayoutpanels etc and to formate it correctly then you can become really frustrated! Here is my solution to print scrollable panels …

Member Avatar
Member Avatar
+0 forum 5

Hi guys, Am developing a clinical management system in VB.net and using Microsoft Access for the database. Everything else is working very well. But the login code is not working. It's throing an error message "Object reference not set to an instance of an object" on line 12. Below is the code for the log in button.

Member Avatar
Member Avatar
+0 forum 1

This was a query raised by one of a forum members at another site, where he had a worksheet filled with random numbers, and I have already answered that query [at my post here](https://vbacoder1962.wordpress.com/2019/07/15/extracting-cell-phone-numbers-from-random-strings-of-variable-length/). You may go through that post and read the logic behind the code. ![vbacoder_Code_20190715.jpg](/attachments/large/4/160efbe4e4d0a8400d04653a6e420c7b.jpg)

Member Avatar
+1 forum 0

i cant filter no transaction in 30 days for ex. select * from tblmasterlist where re_order_level = '-1', interval (30) " how?

Member Avatar
Member Avatar
+0 forum 1

Hey community, how can i show the connected USB-Device like keyboard, mouse, webcam and so on? Or how can i search in the connected USB-Devices, if I know the name or only a part of the name? I am looking for some examples since 2 days, but no one doesn´t work. So I hope you can help me with some code examples in vb.net. best regards joshi

Member Avatar
Member Avatar
+1 forum 22

Hello. So I had to make this program that: 1. User enters a value (say, ID number) in a textbox, presses search, then the program searches for that particular item on a table and then copies all the row data where that ID number is. 2. Then pastes those copied data on another table in Access, then displays it on a datagrid Thanks. Im new so I haven't made up code yet :(

Member Avatar
+0 forum 0

The End.