Hello everybody I'm creating a Windows Desktop App using vb.net, I'm not very knowledgeble and I can say that I'm still a beginner. So I have this project where I'm trying to create a report form using ReportViewer where as after putting the ReportViewer control to my form and select the rdlc file and datasource this error suddenly pops up: *"Could not load file or assembly 'MySql.Data, Version=8.0.17.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)"* This only shows whenever I try to add a reportviewer …

Member Avatar
+0 forum 0

Hello i am new with this programming vb.net. i have simple problem loading the data. i have 1 datagridview and contains also a comboboxcolumn in that datagridview my problem is how do i populate the data in my first table and the second table would be populate in my combobox inside the datagridview

Member Avatar
+0 forum 0

Help i need to have 3 login attempts then the program will lock down but the message box shows up 3 times consecutively, it will close then pops out it will do this for 3 times then it closes ... help pleassseee :( Private Sub btnLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogin.Click Dim un, pw As String Dim counter As Integer = 0 un = txtUsername.Text pw = txtPassword.Text Do If un = "student" And pw = "21217" Then Me.Hide() CourseStudy.Show() Else counter = counter + 1 MsgBox("Try again", MsgBoxStyle.Critical, "Acess Denied") txtPassword.Text = "" txtUsername.Text = …

Member Avatar
+0 forum 0

I have 2 form there are form 1 and form 2 my program current situation is when user click delete it will pop up a login form. When user click cancel button from login form the data on the database will be delete ![login_form.PNG](/attachments/large/4/44621e202c33a0c03d1931bb384694fa.PNG) when user click cancel it will restart program and delete my data the program i would like to write on cancel button is when user click the cancel, form 2 will refresh and the data on the database will not be delete this is the my program running current situation ![A.PNG](/attachments/large/4/a86e1db60cebb2450ef5c573ef63e1db.PNG) ![InkedB_LI.jpg](/attachments/large/4/c5fa7a80e2be0600dfbd31349a6b18df.jpg) ![C.PNG](/attachments/large/4/c34e142048b1cb6a507db992fd043875.PNG) i am using …

Member Avatar
+0 forum 0

I need to put conditional formatting into an Excel sheet. When one cell has data entered, the entire row must have the font color changed. Any suggestions?

Member Avatar
Member Avatar
+0 forum 7

Help me , Search data with dataGuidViewer and print that searching result (vb.Net). I am try verious Code thous are found youtube, but it not work...... Please Help me VB.Net (2010, 2012,2013,)

Member Avatar
Member Avatar
+0 forum 2

![net.jpg](/attachments/large/4/7ba3189ab11bd153b391c468177113e9.jpg) Please help how to code this on vb.net with SQL server database

Member Avatar
Member Avatar
+0 forum 1

Hello. At work, I have to count about 5k in a day for products. When someone takes out or puts in products for example 450 I have to recount again. So I want to create a system that when someone puts some kind of product on the shelf they would enter the quantity they are putting on the stock. For example, TOM puts 150 pcs of -product1- in stock. Then Bill will take 50 pcs of the same product1. So the system would do the calculation: 150-50 = 100 pcs left in stock. When TOM will put again 110 pcs …

Member Avatar
Member Avatar
+0 forum 2

this is may code on adding or saving image in to mysql DB Private Sub SAVECATEGORY_Click(sender As Object, e As EventArgs) Handles SAVECATEGORY.Click If PictureBox1.Image Is Nothing Then MessageBox.Show("Please Insert image ") addcategoryclear() 'you call ddcategoryclear() to clear textbox and picturebox ElseIf TextBox1.Text = "" Then MessageBox.Show("Please Insert Image Name") addcategoryclear() 'you call ddcategoryclear() to clear textbox and picturebox Else Dim ms As New MemoryStream '...........need to Imports System.IO from general PictureBox1.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Png) ' ........save IMAGE cn.Open() Dim command As New MySqlCommand("INSERT INTO `category`( `IMG`, `NAME`) VALUES (@IMG,@NAME)", cn) With command.Parameters .Add("@IMG", MySqlDbType.Blob).Value = ms.ToArray() .AddWithValue("NAME", TextBox1.Text) End With If …

Member Avatar
Member Avatar
+0 forum 9

Hello Everyone, I'm trying to create / edit a binary value within the windows registry so far I have this: Dim data As Byte() = New Byte() {&H48, 96} Microsoft.Win32.Registry.SetValue("hkey_local_machine\hardware\description\system\bios", "SystemProductName2", data, Microsoft.Win32.RegistryValueKind.Binary) However, I want to set a product name say "Acer Stuff" to the registry and what is happening it will not print the characters. I'm getting numbers. Any suggestions? I've searched for a few hours to get this done and I'm having a difficult time. Any help would be greatly appreciated. Thanks.

Member Avatar
Member Avatar
+0 forum 1

![help1.png](/attachments/large/4/f82a18611583d3d8a689ee71b5a6bc3b.png) it hard for me to explain what the problem, but the thing that i need your help is , how to retrieve the ID to listview, im trying to create a POS project like on restaurant or fastfood store, in the listview it will retrieve image ang name, but if listview is click the image will copy to picturebox, the name will copy to textbox1 and the ID will copy to textbox , use the ID the name and picture can be change to update, please help me how to get the ID

Member Avatar
Member Avatar
+0 forum 8

Hello guys , can you help me how to get the ID from mysql DB , if the listview is click the name and the ID well retrieve to textbox1 and textbox2, i dont know how to get the ID?, on the listview the ID wasnt retieve , can you help me how to retrieve the ID from db

Member Avatar
Member Avatar
+0 forum 3

Hello, help me When you apply the save, an error occurs Dim c As Integer Dim val As String If cmbfeuille.Text = "" Then Exit Sub xlApp.ScreenUpdating = False xlApp.DisplayAlerts = False xlWorkBook = xlApp.Workbooks.Open(chemin) xlWorkSheet = CType(xlWorkBook.Worksheets(cmbfeuille.Text), Excel.Worksheet) For l As Integer = 1 To DataGridView1.RowCount - 1 For c = 0 To DataGridView1.ColumnCount - 1 val = CStr(DataGridView1.Rows.Item(l).Cells(c).Value) xlWorkSheet.Cells(l + 2, c + 1) = val Next c Next l xlApp.ScreenUpdating = True xlApp.DisplayAlerts = True xlWorkBook.Close() xlApp.Quit() modif = False

Member Avatar
Member Avatar
+0 forum 2

i have a database at *mysql * and i already save image and use search button to retrieve image from mysql database to picture box, *vb.net *, i dont have a code how listview retrieve all image from mysql but the code is different funtion but the concet is the same.

Member Avatar
Member Avatar
+0 forum 5

hello, im going to create POS project, can you help me how to retrieve all image from mysql db to listview, so that i can view all image that i save to my db, i already save image and use sreach button on retrieve image from db to picturebox. thank you guys . the code below is not retrieving image from db to listview, but if you click listview it will retrieve image from db to picturebox Dim constr As String = "Data Source = localhost; User ID = root; Database = chamchamber" Dim cn As MySqlConnection Dim cmd As …

Member Avatar
Member Avatar
+0 forum 8

i use vb.net 2017 the problem is that in project => application => Enable Application Framework is greyed out. How can i fix this ![Enable_Application_Framework.PNG](/attachments/large/4/68d6df59e58c439a2f19c6f17d4178c7.PNG)

Member Avatar
Member Avatar
+0 forum 1

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 38

Hi, I hv vb.net applivcation. I have following CODE1 to save data & to prevent duplicate data entry into table. The following code I put in button save event. However I want to put this CODE2 in perticluar textbox e.g. here SpecimenNoTextBox. so that when the user enter duplicate SpecimenNo.it says "Specimen No. already exist". How can i do this? **CODE1** If SpecimenNoTextBox.Text = "" Then MsgBox("Enter") Else Dim cmd As New OleDbCommand Dim con As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\data\Histopathology New.accdb") con.Open() Dim cmdlogin As New OleDbCommand(("SELECT SpecimenNo FROM HPReport"), con) Dim dalogin As New OleDbDataAdapter Dim dslogin As New DataSet …

Member Avatar
Member Avatar
+0 forum 11

Public Class Form1 Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click 'TextBox1.Text = Token() If Button1.Enabled = True Then Label1.Text = Label1.Text + " A1 " If Button1.BackColor = Color.Yellow Then Button1.BackColor = Color.Red Else Button1.BackColor = Color.Yellow End If Else Label2.Text = "" Label2.Text = True End If Button1.BackColor = Color.Yellow End Sub Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click If Button2.Enabled = True Then Label1.Text = Label1.Text + " b1 " If Button1.BackColor = Color.Yellow Then Button1.BackColor = Color.Red Else Button1.BackColor = Color.Yellow End If Else Label2.Text = "" Label2.Text = True End …

Member Avatar
Member Avatar
+0 forum 3

hello how can i insert multiple selected data from datagridview into database using checkbox..please help

Member Avatar
Member Avatar
+0 forum 1

Hello. I'm currently preparing a seating system in VB. May i know how can I change the booked seats into available by clicking "Reset" button? My database consists of "Booking" table that comprises the booking details and "Seating" table that comprises details including "Availability" whereby once the seats are booked, it will change the seats from available to booked under "Availability" column. As per my understanding, when i click the "Reset" button, it will delete the records in "Booking" table and update "Seating" table from booked to Available under "Availability" column. This action would lead my booked seats turn to …

Member Avatar
Member Avatar
+0 forum 8
Reusable Code Snippet Make a given number odd or even

There are times when you need to make sure your counter starts at an odd or even number. Even is pretty simple - `counter = counter + modulus(counter)`. If counter is even it stays, if it's odd it gets incremented by 1. Odd is a bit more complicated - `counter = counter + modulus(counter + 1)`, If counter is odd it stays, if it's even it gets incremented by 1. if you're in danger of counter being the max value you can always subtract instead. These basic algorithms should work for any language that has a modulus operator/function. I've included …

Member Avatar
Member Avatar
+2 forum 4

How to put a price on the items in the combobox? Please help . really needed it .. Thank you

Member Avatar
Member Avatar
+0 forum 1

how to select an item in the combobox and then put item quantity in the textbox. and how to price the combobox items. Really need help .. Next week is my system defense.. Thank you

Member Avatar
Member Avatar
+0 forum 1

need help for factorila within range if you entered 3 in textbox, This will appeared in Listbox 1! = 1 2! = 2 3! = 6

Member Avatar
Member Avatar
+0 forum 1

hi everyone can someone help me on vb.net code on how to load selected row from datagridview and transfer in to combobox or radio button.. i will appreciate your help so much

Member Avatar
+0 forum 0

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

The End.