20,285 Topics
 | |
| | Hi! I have added a contextmenustrip on my form and in the contextmenustrip I have added two items. when I click on the 1st contextmenustrip item it works but when I click on the 2nd contextmenustrip item it does not work only the 1st contextmenustrip item works. and when I …  |
| | I just use this code to input data to oracle database from vb.net. Try Dim mstream As New System.IO.MemoryStream() PictureBox1.Image.Save(mstream, System.Drawing.Imaging.ImageFormat.Jpeg) Dim arrImage() As Byte = mstream.GetBuffer() mstream.Close() query = "INSERT INTO ds.students (ID,NAME,PIC)" & _ "VALUES (@ID,@NAME,@PIC);" Dim cmd As OracleCommand = New OracleCommand(query, con) cmd.Parameters.Add("@ID", Convert.ToInt32(TextBox1.Text)) cmd.Parameters.Add("@NAME", Convert.ToString(TextBox2.Text)) …  |
| | Previously I used vb.net with mysql database and successfully added data from insert query. In that senario my sql code is like this : INSERT INTO ds.students (id, name,pic)" & _ "VALUES (@id,@name,@pic) Now I used oracle database with vb.net. When I run program it shows: "ORA-00936 - Missing Expression" … |
| | I was very tired of searching, but I did not find anything i have a from and its minted textbox and CheckedListBox the CheckedListBox have five choices and i want to insert the Items(more than 1) Checked from the CheckedListBox and the textbox into a table in the database like …  |
| | this is the code of the from which i trying to open form the login form it is say invalid attempt to call read when reader is closed Imports System.Data.SqlClient Public Class Form40 Private Sub Form40_Load(sender As Object, e As EventArgs) Handles MyBase.Load Label1.Text = users Dim user_Name As String … |
| | I have a question is there a way t write the following in a shorter way because i have to write this all about another 25 times. there is always one difference with one of all the textboxes. ' zonder roepnaam en zonder tussenvoegsel, wel vader maar vader geen tussenvoegsel, …  |
| | heY guys, I just step to oracle database system. so I'm new to this. I'm trying to make connection oracle db with vb.net. I saw below connection string on web. But I dont know it's keywords. So please teach me. SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID))); uid=myUsername;pwd=myPassword; |
| | Hi, I am trying to get the the number of rows that are populated in a SQL Server table. I am using the code below but it only counts one row everytime when I know in fact that there are 47 row in a particular table. Could someone please point … |
| | Hello everyone has been a while since i made a question here i have a real problem with a web app that i been doing recently the problem is related with the datetime format when i make transfer data from the webapp to a database in access, the field in … |
| | Hi Dw. I am developing a client server multi-thread application. This application uses signals(certain messages as signals), in order to perform a task for a client. For instance if a client wants to login, the client send a message as: `Login:<username>:<password>` and on a server I first check if the … |
| | Hi Dw. I have a timer that in every 600 interval access the database and the database I'm using is MS Access database. The problem I have is that with this being said, the MS Access database has a limitation of 64 connections on each thread so this 600 interval … |
| | Hi all, 1. My **DataGridview** is populated and displays the data correctly. No Problem here. 2. I use the **Up/Down Key** to navigate in the *DataGridview* and the rows get highlighted when I pass over them. No problem here. ***This is what I would like to code if posible:*** 3. … |
| | hello every one this my code to fill my combobox with the name of clients and i but the connection string in a module to let my prog workimg in any pc in the group But the problem here in the combobox says can not make the connection, I know …  |
 | hi to all, i have an menustrip in the form MAIN i want to load menustripitems as per the user permission given in the tbluser database table which load during form load event in datagridview DataAdapter1 = New SqlDataAdapter("Select * From tbluser WHERE userID = '" & txtuserid.Text & "' … |
 | Group, I can't seem to append multiple files into one text file. Unfortunately it's creating the first file but is not creating or appending the additional files into the first file. My code looks like this: getRestranName = System.IO.Directory.GetFiles(folderName) Dim counter As Integer = My.Computer.FileSystem.GetFiles(folderName).Count fileCount = Convert.ToInt32(counter) fileCount = … |
| | hello every one i made a Simple sales program by vb with tables sql I have worked and use the following to connect with data con.ConnectionString = "Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename= C:\Users\hany_\Documents\Visual Studio 2015\Projects\hanysql\hanysql\Database5.mdf;Integrated Security=True" Now, after the completion of the program I want to know what is the way to run … |
| | As I dig deeper into the capabilities of Visual Studio, I have seen that you can have multiple projects in a single solution. I must be missing something because I can't come up with a reason to ever do this? My guess is that I don't understand the benefit. So, … |
| | cmd = New SqlCommand("INSERT INTO temp_balance ( debit, credit, accname ) SELECT Sum(temp_sheet.debit) AS debit, Sum(temp_sheet.credit) AS credit, IIf (debit < credit ,'loss','profit') AS expr1 FROM temp_sheet group by temp_sheet.debit,temp_sheet.credit ;", con) there an error i dont know the error incorrect syntax near ' ) |
| | I have a problem that I am really having a hard time with. I have a textbox in my form that I am trying to add into autocomplete so when I get back into that form I can just type the first letter and have it populate. I have a … |
 | I want to insert a table cell into a table from another table by select method and after, to display an error in text prompted from the user was not found. Can someone tell what's the problem with my codes? My codes are as follows: Dim Item As String = … |
| | Hey guys, does anyone know how to do this? Here is my current code that will not work. I have tried everything that I know how to make this work to no avail. This is under form1_load. Any help would be awesome. Thanks in advance. |
| | Hi everyone! Long story short; I got a Secugen Hamster IV finger print device. I want to use it in my hospital application to be used in identification of patients at the hosptl. However, I do not find this device to be useful in that they they dont' have current … |
| | bonjour tous les monds, how can i Refresh ComboBox After Adding New Values via a Seperate Form in vbnet any ideas mercie en avance ; |
| | Hi, Having a real trouble getting a form to launch, which has previously worked. I have a series of buttons set up on a menu screen, each button launches a different form in the same project. For each 'click' event there are two lines of code: a DIM statement to …  |
| | I have been searching all over for a way to open a text file that was created using vb.net on one form and open that same text file and place the contents into a list view. The text file will have a description, a part number, and a quantity, this … |
| | Hi Dw. I have a MS Access database that has 9 columns what I want to do is to retrieve all data from a database only on 5 columns. I think I have to use the `select * from data` but I don't know how to select the columns I … |
| | Can you guys help me how to make this happen? I want to have a row validation for adding of items. I have a datagridview named **datagridview1** with columns **dgvTxtItemCode, dgvTxtItemDesc** and so on. I want to add a validation wherein whenever inputted the same itemcode or item desc a … |
| | Hello. I wanted to remove a key in registry using only VB.NET code and i do not know how. Can you please help me ? |
| | Hey I need help from danniweb . I try some codes according to my knowledge to make this code. I load some valuse to data grid view from mysql table. Think there are 10 records loaded to data grid view. Then just I want to make 10 records to generate …  |
| | Hello everyone, I've looked in several forums but can't find an answer. In excel I want to place a picture in a cell, that's no problem. Then, I want to display that picture in the header with VBA code. I know vba can link to a directory to display a … |
The End.