20,278 Topics
| |
I have a graph in my excel file. There is two values that changes this graph appearance, so I want to change these cell values in a FOR loop, in order to make a "animation". Is it work? Every step of the loop will change the graph, but how can … | |
Hi Dw I'm creating a program which I want to check if the normal and also a hidden folders exist or not and if exist delete it. | |
| Private Sub txtPassword_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtPassword.KeyPress Dim NotAllowed As String = "~`@%^&+={[}]()!:,;'><?/|\-.#+()_$*" If e.KeyChar = ChrW(Keys.Enter) Then e.Handled = True End If If e.KeyChar <> ControlChars.Back = True Then If NotAllowed.IndexOf(e.KeyChar) = -1 = False Then e.Handled = True End If End If End … |
I have a radio button and a listbox. After clicking on the radiobutton, a collection of items will be added into the listbox. I'm trying to go back to the collection I've started working on to edit a System.Collections.Specialized.StringCollection, but after running the program, the list of items has not … | |
what i am trying to do is make a program to read an excel file that i already have , choose certin columns depending on its header title then paste these columns into sheet2 . the problem is when i check for the columns i want to extract it gives … | |
I am trying to bind data to my DataGridView. (However, this is the easy explanation.) Background on what I am trying to accomplish: I have a rather large program here. This part of the code uses a DataGridView to display the data I have read and parsed (from another program … | |
Hi , I want to make a program who read a word from a textfile . More accurate, In The text file I have the next text: Version="1.0" Adress="http://" StartFile="/" and my program I want to read what is From Version , to read 1.0 From Adress to read http:// … | |
![7d2f0b828b7075213b3cc4ce79ce21d1](/attachments/large/4/7d2f0b828b7075213b3cc4ce79ce21d1.png "7d2f0b828b7075213b3cc4ce79ce21d1") i have 2 database listview1(from tbl_storage) listview2(fromsales) so i want my listview items and subitems to be increment or be loop correct me if im wrong with that. sellingprice and Qty.(Quantity) ex. itemno | name | qty| price | total | 1 | a | 1 | 100 … | |
i now able to save the fingerprint directly to database using this code... Dim fingerprintData As MemoryStream = New MemoryStream Template.Serialize(fingerprintData) fingerprintData.Position = 0 Dim br As BinaryReader = New BinaryReader(fingerprintData) Dim bytes() As Byte = br.ReadBytes(CType(fingerprintData.Length, Int32)) Dim cn As SqlConnection = New SqlConnection("Data Source=.\SQLEXPRESS;Initial Catalog=dataBEST;Integrated Security=True;Pooling=False") Dim cmd … | |
Hi guys I'm having a problem in opening excel files using the workbook.open for me to save all the changes made by oledbcommands. Dim MyConnection As New OleDbConnection("provider=Microsoft.ACE.OLEDB.12.0; Data Source='" & path & "'; Extended Properties=Excel 12.0;") MyConnection.Open() Dim i = 0 Dim h = Label1.Text Do 'Dim q = … | |
I have a list box, with an item "Math". When I click on the Math item, I want a new collection of items to be added to the listbox after removing the current Math item, and make a back button to appear to return Math item back in case I … | |
I'm trying to select items from the listbox when pressing Enter on the selected item. Here is what I have tried so far: Private Sub ListBox1_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles ListBox1.KeyDown Select Case e.KeyCode Case Keys.Enter ListBox1.SelectedItem = ListBox1.PerformMouseClick() End Select End Sub | |
When creating a new project, I have a list of Frameworks to chose from. I need a Framework which will allow my program from Bin -> Debug -> Program.exe to work on various computers, such as Vista, Windows 7 & 8, and perhaps any others of the Windows family. I … | |
Hi I've run this code and i get no errors but my form data is not saved on the dataset or database. This is the click event code. [code] Dim conn As New SqlConnection("Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDictionary|\TMSDB.mdf;Integrated Security=True Instance=True") Dim ds As New DataSet conn.Open() Dim Adp As New SqlDataAdapter("select * … | |
Just got to playing around, and felt that the VB forum on here could use some posts. What I was playing around with forms in VB.NET and wanted to hard code centering a form. Here is what I found...and if anyone has an easier or slicker way...let me know. -in … | |
Greetings, Can someone please tell me on how to use this class? Public Function GetDataFromStoredProcedure(ByVal spName As String) As DataTable Dim ds As New SqlDataAdapter Dim dt As New DataTable Dim cmd As New SqlCommand Dim con As New SqlConnection(_connectionString) Try _success = True con.Open() cmd.CommandType = CommandType.StoredProcedure cmd.CommandText = … | |
i've upgraded my vb.net application from visual studio 2005 to 2013 and and when i click to show a form which its windowstate is set to maximize , the form shows in design size and i need to open another form and go back to it to get it in … | |
Hello, I'm new here so sorry if this question isn't worded how they usually are but I can't figure out how to get vb to only display the dates of working days (Monday - Friday). I have got it to calculate days between certain dates (I thought that might get … | |
Greetings, i just want to ask how to insert a data with fk. Like if i insert a data on tblPatient, the patientID will be displayed on the tblRecord. is it just a normal insert into tblpatient or is there another code for it? Thanks. | |
i did an Empty project(bored... only problems :( ). but can i add a manifest file to exe or the project? | |
I have 2 form called form1 and form2 why i cannot use this code form1.textbox.Text = "Hello" ???? | |
what's the problem with this ? any 1 can help me out..tnx in advance Dim filePath As String Try filePath = Application.StartupPath() & "\" & DBFile connection = New OleDb.OleDbConnection(ConnectionString & filePath) connection.Open() Dim command As OleDb.OleDbCommand = New OleDb.OleDbCommand command.Connection = connection '---set the user's particulars in the table--- … | |
Good day Can you please help me with my codes. My teacher tasked us to make a program that will accept a password from the input box then will show form1. Otherwise, it will repeat on asking for the correct password. the program will stop asking if you gave the … | |
Greetings, can someone please give me an idea on how to make a stored procedure with foreign key. Here's what i want to happen. 1) I have 1 button for Adding patient. 2) On the add patient button, i want to Add the patient information on the tblPatient and insert … | |
I have a listbox with items and a panel. What I want to do is when I click on an item, a label shows up in a panel, which was already there before the item was clicked. I've managed to show the label, but it didn't add to the panel, … | |
Get the image source of the below link which pass the condition **itemprop="image"** and **id="poster_image"** <img itemprop="image" id="poster_image" style="width: 300px; height: 442px; " alt="" title="" src="*This is the source.jpg*" /> | |
please anyone help, can anyone know how to search data in my form without any search button, i would like to search data once i automatically enter specific data in my form as a fast result, please? | |
Dim checks As Double Dim Fee As Double Dim Q As Double Dim Initial As Double Initial = 10 Dim number1 As Decimal = 0.1D Dim number2 As Decimal = 0.08D Dim number3 As Decimal = 0.06D Dim number4 As Decimal = 0.04D TextBox1.Text = checks If checks >= 1 … | |
This is the problem I am working on ( you have likely seen it before) A bank charges $10 per month, plus the following check fees for a commercial checking account: $0.10 each for less than 20 checks $0.08 each for 20 through 39 checks $0.06 each for 40 through … | |
how can i paste result from excel formula to value or even store the result into a string below codes does not seem to works... For x = 2 To rowcount worksheet2.Range("B" & x).Value = worksheet2.Range("D" & x).Text worksheet2.Range("C" & x).Value = worksheet2.Range("E" & x).Text Next worksheet2.Range("C" & x).Value = … |
The End.