We are filling a combobox with customer names from a table. select ID, name from tbl_customers order by name The names we are filling with CMB_custom.Items.Add(RSselct("name").Value) Is there a possibillity to put the ID into the combobox? If we select a name from the combo we can get also the ID.
View 4 RepliesBasically I have a VB.net word processor application, With a;
Rich Text Box
Header Label(as system.windows.forms.label)
Footer Label(as system.windows.forms.label)
The printing is no problem, but the problem I am having is saving the header and footer label's text into the RTF file and also loading these into the header and footer labels.
I need to populate some information into several ComboBoxes. The infromation should be read from the table in my database. Is it possible to read the information and populate it onto a combobox without using data binding?
I tried to populate several ComboBoxes, but if I use databinding, the ComboBoxes all show the same value.Also, if I select a certain value, it also selects that row in the table, which I do not wish to do..
I need to use an array at any part of the project. It has been suggested to me to build an array and show its result in a combobox. Instead of having an input textbox, i will have a combobox which will display 10 common names which are kept in the array.
'Defines the array Names
Dim names(9) As String
'Defines the array's fields[code]......
I have a problem getting the right information to a ComboBox.I have a table in SQL Server that contains a list of names.I want to get those names to appear in my ComboBoxes shown in the picture. (DONE)I also want the list of names to decrease by the names already used in other ComboBoxes in that Form...
EXAMPLE:So, lets say I have a list:
Name_1
Name_2
Name_3
[code]....
In the Form, there are 10 ComboBoxes.I choose the Name_1 for ComboBox1, Name_2 for ComboBox2 and Name_3 for ComboBox3.The options available for all other ComboBoxes should be Name_4 ... Name_6.If all of the 6 names are filled, the rest of the ComboBoxes should have no option to insert into them...
I went ahead and created a combobox which has an employee's first and lastname on the drop down. I used this code to achieve this:
Private Sub ViewEmployee_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim conn As New SqlConnection("Data Source=.SQLEXPRESS;
[Code].....
I am not sure what I am doing with this and need some direction. I have attempted to create a stored procedure in SQL Server 2005 called proc_GetPrefixes with the following content
USE [CRM]
GO
ALTER PROCEDURE [dbo].[proc_GetPrefixes]
[Code].....
The stored procedure is supposed to get all the records and what I want to do with the result set is to add all the items to a combobox. I have started off with the following and not sure where to go with this:
[Code]....
I have a program that needs to display a playlist of songs, for a band performing someplace, from a .txt file. The songs in the file are listed as follows:
All You Need is Love-Beatles
Rock
4.25
[code]....
The first line is the song's title and group name. The second is the songs genre. The third line is the songs length, 4.25 is 4 minutes and 25 seconds.upon clicking a button, I need to display a playlist from this .txt file based on the number of minutes the band has to play, minutes entered into a TextBox, and the songs genre, selected from a ComboBox. The songs cannot repeat and must be random.I have already coded the program to read the .txt file but have not clue where to start with the rest.
The program is currently trying to pull information from three different database tables and compiling the information onto one screen, to do this i am using three different connections and a function to handle the data at each stage. The issue is as my code hits PageLoadStage of "2" and runs the QueryDatabase() Function i am encountering an error of: "OleDB exception unhandled: No value given for one or more of the required parameters." This occurs on line 15 of the first code snippet. Can anyone explain this and/or identify any code issues if that is the cause.
[Code]...
I was looking for some stuff online, and i was looking through my reference sheets for vb.net, but it seems in the code i have found, there is declare in methods. Below is an example i am talking about. The thing is, that i dont recognize it and believe that it is an earlier version of Visual Basic ( 6 or earlier) which used it. Should i just keep looking for different code?
Public Declare Function RegOpenKey Lib "advapi32.dll" Alias "RegOpenKeyA" (ByVal hKey As Long, ByVal _
lpSubKey As String, phkResult As Long) As Long
Goal: Find information on how to implement a method which will check if a certain DSN exists, and then if it does, extract the information and use the information for connection purposes.
I have a text box where i am entering numbers of double datatype andon the Keytdown event of the textbox some checks take pace and in certain circumstances I want to be able to stop the user from entering other information until they enter the right information in the textbox (where it says right here) . now when I say exit sub the textbox somehow loses focus . but this is not how I want it to be I want the textbox to remain with the focus so the user can change the information . How can i go about this. And the other thing is why is my txtDestPayRate1.Focus() just befor the exit sub not working?
Private Sub txtDestPayRate1_KeyDown1(sender As Object, e As System.Windows.Forms.KeyEventArgs) Handles txtDestPayRate1.KeyDown
If e.KeyCode = Keys.Enter Then
[CODE]...
I am designing a backup/restore utility for work.atm i have been able to populate field for PC name, IP address, MAC address, number of printers installed on the PC but i am wondering is it possble to get all the printer information 'with the click of a button' to print all information like the prnmngr.vbs script down.I am able to run a batch file but i wanna get it to go from that app or even embed to batch file to the app and run it form there .
View 4 RepliesWhy does the code below result in 3 rows in my datagrid when there is only 2 rows in my CSV file? I end up with 2 populated rows and one empty row. The CSV file only contains 2 lines. I suspect the logic of the code below.
Do While Read()
row = New DataGridViewRow()
For Index = 0 To FieldCount - 1
[Code].....
I have a VB 2008 program over the Northwind DB customer table.It uses LINQ to add, delete and edit records.
So I load everything into a datatable/dataset first.The Add and Delete occurs when the buttons are clicked on a binding navigator. The edit occurs when a cell is changed, and that row is clicked off. I've set the Customer ID field as the primary key in the DT. I then bind everything together with a binding mavigator.
So far so good, Adding & Editing works nicely the DGV & customer table . [code]...
I have a datagridview that is being loaded from a dataset. This dataset is the result of a SQL Statement (which could be my problem). The MS Access Client table is the main table and contains 2 records, however, after loading the dataset, the row count is 3.
Below is the procedure where I load the dataset and then the DGV.
Public Function LoadClientDataSet()
Try
strSQL = "SELECT A.clientID, A.name, B.phone, B.zipCode, B.stateCD " & _
[Code]....
I have an application that is sending data to another system. every thing is ok, but after my 1st varible I get extra characters in the buffer. my code is something like
Private Sub Reg_ClientInfo()
With My_Reg
.ID = 710
.AppName = "DS;"
[code]....
[Code]....
So func is a function that accepts a string and return a string. In practice, internally, func also utilizez text1, text2. In fact, func can even be a member function with access the object that owns it (something like me or this operator).
And all that can be accomplished without changing the signature of func? How do the compiler do this?
I got a predefined code where extra methods should need to be written for, but I don't know how to do this exactly.
My predefined code is(and may not be changed):
[Code].....
Code: Private Sub PrintDetails(ByVal Sender As Object, ByVal e As System.Drawing.Printing.PrintPageEventArgs) e.Graphics.DrawString("sample", New Font("TimesNewRoman", 10, FontStyle.Bold, GraphicsUnit.Inch), Brushes.Black, New Point(10, 10)) end sub
when i use a print preview dialog to watch this printing is shows onlys and a i know that when i change the graphics unit to points i get it rightbut i don't want to reduce the size of the text i want that much bigger but i want it in 2nd, 3rd pages ?
Is there anyway to add stuff to a program, without having to download the whole program again?
View 3 RepliesDear Sir/Madam: I use VB 2008, where to find an extra Icon? I would like to change the icon on my windows form. Do I need to download, because I already used and registered Visual Studio 2008 Professional. [URL]
View 7 RepliesI have an .net application with 2 processes, communicating using a network stream.The protocol consists of a set of commands, some with parameters, which are sent through the stream to the server. The server processes the command, and sends a response.
The protocol for one of the commands looks like this:
[code]...
Usually, this works fine. Very rarely (probably once every few millions of calls), The reading side gets the wrong values. I added code to trace the values sent and received. This shows that occasionally, the reading side gets two extra bytes, with the value 0, which was not sent by the writing side. These extra bytes appear in different places, e.g. in one case they were between i1 and i2; in another they were between the first and second byte of s2. Does anyone have any idea where these 2 bytes could come from? I checked my code, and every place that writes to the stream is traced, so it doesn't look like they are actually written to the stream. It might be worth noting that s1 is always 0, in the current implementation.
Public Sub WriteTextFile(ByVal SourceToWrite As String, ByVal LocationToWrite As String)
Dim file As System.IO.StreamWriter
IO.File.Delete(LocationToWrite)
[Code].....
This is a module I made to write to a .txt file. Every time it adds a new line with null value. wouldn't really bother me but it adds but then something that only suppose to have like 3 lines in it ends up with 5000 over time, anyone know how to not add that extra line while writing file?
Suppose that I want to implement another method for a class namely hasFiles for System.IO.Directory , How can I do that?
for example if I add <Extension()> _ tag before each function or Sub I can add a new function or method for each Control.
I'm wanting to add two forms to my project that will allow me 1) Pull all the current MS Updates installed and list them in a nice looking grid, 2) Pull a list of all the available updates for the machine. I would love for this to work on XP/Vista/7.
View 5 RepliesIn the top right corner of a SharePoint site the user can select "My Settings" to update their details etc.
I am currently writing an automated app that will update user profiles from an Export we are getting on a nightly basis.
My question is...can i add extra fields to the information that is stored and editable against each user?
For example if I might want to add an "Office Location" field?
I am using WSS 3.0.
VS2010 (SP1) / .NET4 on Windows XP Pro Im having a slight issue with my password hashing function. The following function hashes the supplied password using SHA512 and returns a Base64 string.
[Code]....
I am exporting a sql data table to excel using VB 2008. The export works fine but when I open the excel spreadsheet and click on individual cells, I see an apostrophe at the beginning of the string. Is there a way to keep this from happening in the export?
Here is my code:
Dim strfileall = "C: estdata.xls"
Dim SQL1
As String =
[code]....
I'm getting a late binding error message on this specific section of code: objsys.Sessions(shrd.ocSess) Any suggestions as to why I'm getting this late binding error and how to fix it? [Code]
View 2 RepliesAssuming that I am going to add new record. I use this function to generate the ID for the new record.
Public Function GetMax(ByVal strTable As String, ByVal strField As String) As Integer
Dim cmd1 As New SqlCommand
Dim conn As New SqlConnection(gStrConnection)
Dim no As Integer
Dim str1 As String
[Code] .....
It returns 1. How can I modify this to make it 20120001 wherein the first 4 number (2012) will depends on the year today.