I am using this code to bring data in combobox but u_id is the premiry key n not full name then on selection how can i bring the perfect result?[code]...
View 3 Replies
What wrong with my databinding? How to correct the perfect binding with combobox and texbox.. When I select Projectname the other are changing except the email... Why the email is not changing?
Code:
commemails = New OleDbCommand
daemails = New OleDbDataAdapter
dsemails = New DataSet
dtemails = New DataTable
myconn = New OleDbConnection(("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=") + My.Application.Info.DirectoryPath & "SMRPsource.mdb")
[Code] .....
I am currently having a headache on how to solve this problem that i am facing. here is the situation: I have a combobox and a list box on the main form. The combobox will get the data from the ms access database. In the database, i have the details of a person's IC, Name and DOB say for eg on one entry I have D215311523C,SHAWN,13/04/1987 So now, my combobox on form load will show the list of dates in the database to allow the user to search base on the date itself by clicking on the selected date. So when the user clicks on the particular date say 13/04/1987, people in the database whose birthday is 13/04/1987 will be shown on the listbox.Meaning to say if i have 3 entries whose dates are the same 13/04/1987, 3 entries will appear. If there is only two entry, then two results will be shown. But now, when i do a single click on the date, one result will be shown. That is correct. But the problem is when i click on the same date again, three of the same results will be shown on the list box. that is it will display : 13/04/1987 13/04/1987 13/04/1987 which is not the case. Then it will show more duplicates of the same results if i click more times on the same date which should not be the case.
Dim n As Integer
Dim numbers() As Integer
Dim StartFrom As Integer
Dim EndAt As Integer
[code].....
windows VB 2005 datagridview I have a datagridview created dynamically, added to the form using controls.add()when I press enter key in a cell a list appears also generated dynamically and added to the form using controls.add().Ok. when it works fine. But the list view appears behind the grid - I want to appear the list view infront of the gridview
View 7 RepliesHave a good day lets assume that i have 2 tables First one is customer table and has primery key called cusid ( auto increment)second one is order table and has foregion key custid how i can connect them , what i mean exactly when insert the record in the customer table i need the foregion key get the same value as primery key in customer table
Note : I'm using sql server 2008 and vb.net 2008
Is there an easy way to bring an item to front, instead of having to click on "bring back" the items not wanted?Clickcing on it in the property window should show it, now nothing happens
View 10 RepliesTopic moved to http://social.msdn.microsoft.com/Forums/en-US/vblanguage/thread/1b9cf70d-5b91-42f1-b89c-b04deb2b89e1
View 10 RepliesI have completed this code, but I cant seem to get the answer into the combobox?
Dim mydatabase As String = DatabaseNameComboBox.Text
Dim TableNaming As String = TableNameComboBox.Text
Dim DatabaseConn As New OleDbConnection
Dim DatabaseConnString As New OleDbConnectionStringBuilder
Dim strSQL As String = "Select * from " & TableNaming & ""
[Code] .....
This last line, just adds the select * from statement, but I want the column names?
I'm trying to fill combobox with my SQL query result.[code]...
View 2 RepliesI am trying to fill a combobox using the results form a query to combine two fields (first and Last name). I cannot seam to get to the query through the table adapter. I can set the binding source and select one of the fields to fill the control but I cannot get to the query's.
View 2 RepliesI have added a query to my form using the sqlDataAdapter object and the wizard.Now I want to show the result of the query in a combox on my form.The combobox is not binded to a data source, but is going to be used for searching a record (but this is for later)
View 10 RepliesI am new in vb.net 2008.I want to populate items of a combobox with a result of a query that may include join or not.
View 3 Repliesi have a form in design view. with faremaskedtextbox and a extra_farecombobox,could anyoneplease tell me the vb code to addfaremaskedtextbox +extra_farecombobox together anddisplay result in another total_faremaskedtextbox.so basically i wanttotal_faremaskedtextbox to add the two numbers that are put into each faremaskedtextbox and extra_farecombobox. and show the result in total_faremaskedtextbox.
View 5 RepliesI have 2 tables: locations and depot:[code]I have 2 forms, frm1 and frm2. Frm1 has a combobox, cboLocations which pulls from the Locations table. Frm2 has textboxes which populate based upon the location selected from cboLocations on frm1. Frm2 also has a combobox, cboDepot, which pulls from the Depot table.So far, I've been able to get cboDepot to populate with the first depot_refnbr. This is not the corresponding depot_refnbr that matches with the selected Location; it is just the first depot_refnbr in the Depot table.I need to populate cboDepot's text property with the depot_name, and not the depot_refnbr that corresponds with the Location selected on frm1 from cboLocations.Frm1 has a button, and I'm not sure if I'd have to code this in the button click event, the cboLocation_Selected IndexChanged event, or in frm2's load event.
View 11 RepliesI have a small section of a windows form that allows users to select when a customer should be called (i.e. day of the week, time and inbound or outbound)When the form is loaded I will extract the information using a dataset and bind to form controls. I want to use a combo box for call stautus - inbound or outbound - however wish to give the user the choice at runtime.My thoughts are I would need to set a static list (so the user could choose) and set the default or displayed value to the info the dataset has extracted.This code to select the index doesnt work when I am comparing the dataset result to the "Outbound" string even though I am using the ToString method.
Private Sub TestTelesalesForm_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Me.Telesales_DEV004016TableAdapter1.Fill(TelesalesDataset1.Telesales_DEV004016)
Me.comboCallStatus.Items.Add("Outbound")
[code]....
following issue I'm having:
I have 2 tables: locations and depot:
Locations:
site_refnbr (primary key)
site_name
depot_refnbr(foreign key)
[Code]...
I need to populate cboDepot's text property with the depot_name, and not the depot_refnbr that corresponds with the Location selected on frm1 from cboLocations.Frm1 has a button, and I'm not sure if I'd have to code this in the button click event, the cboLocation_Selected IndexChanged event, or in frm2's load event.
i am using one combobox and displaying all the emp name available in my database.i have one text box and one button .if i press on button one emp record will be deletes from mytable.then if i click on dropdownlist of combobox i want to display updated result how?
View 2 RepliesDrawing a 3-D border should be easy enough, right? Nope. Does anyone know how to draw a border that looks exactly like TextBox's? Right now, I'm just drawing black lines at the top + left and white at the bottom + right but the bevel isn't nice and when the background color is white, the bottom + right don't show up.
View 8 RepliesSo I am trying to solve this program using the algorithm given, and I get no error messages but everytime I execute the program it just crashes. Any idea what I am doing wrong?\The user wants a program that will return a set of perfect numbers based on the value that is given. If the user types in 3, the program will return 3 perfect numbers
So this is the code I have so far...
dim perfectnumber as integer = 2
dim divisorRunningSum As Integer = 2
[code].....
I need a vb.net console program to check whether a number is perfect or not.
View 2 RepliesI am trying to convert Bob Jenkins perfect hash function from C# to VB.Net and I am stuck at following.
a += (UInt32)(url[k + 0] + (url[k + 1] << 8) + (url[k + 2] << 16) + (url[k + 3] << 24))
How can I write above statement in VB.Net?
a is UInt32
url is String
k is Integer
I tried the following but it doesn't work.
a += url(k + 0) + (url(k + 1) << 8) + (url(k + 2) << 16) + (url(k + 3) << 24)
To avoid manually doing type casting, I am using "Option Strict Off"
In my form, I have textbox + combobox to enter datas which are saved to ms access. I have search option too. Also i have DataGrid to show the result of the search. What I want now is, 1. To show the search result in the textbox/combox as well (I already am able to make the result show on datagrid)2. When there are multiple result showing on DataGrid, if i click on a particular result on DataGrid, let the textbox/combobox automatically loads the details of the one i clicked.
View 6 RepliesAlmost 2 months i try to find perfect solution for my project. I making one multi-user chat application with SERVER and CLIENT application. I read a lot of material about socket communication and try a million of examples all around, some in C# some in VB.net, but I can't find solution.Problem that every example and my try have is when 10-20 user chatting really fast, server reacting slow or whatever is, but final product is that two or many message show in one LINE. For example if i send string "test1" and an my friend, let's call him FRIEND1, send "test2" almost in same time, server sending it to all connected clients like this:stefanACM:test1FRIEND1:test2.I try to implement in my application "Asynchronous TcpListener & TcpClient" from jmcilhinney, but have same problem...
So, can anybody help me with this.I just need one server application that will recive connection, save IP and nick of connected user, and send every message that client sent to all connected users (of course without problem that I mention on beginning of post). On end, that when client disconnect just to close connection.From Client side I need just connect part, send and receive messages.
So in one line, I think I need BASIC EXAMPLE OF PERFECT MULTI USER CHAT CLIENT AND SERVER, without any hiden bug.If someone decide to help me with code,
Includes alpha blending, pathfinding, grid rendering, and lots of other algorithms that make basic game programing in VB 2010 a lot simpler. Copy the code in the attached text document into a blank class. Then add it to your project. Initialize as you would any other class...
"Dim aGameGridOrWhatever as New DynamicBitmap"Let me know if anyone finds any bugs in the PathFinding algorithm. I finished it tonight. I'll post some examples of how to do stuff to this thread soon.
Private Sub AddIngoing_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]...
I am using a datagrid in my where i am having four columns. In first column the parameter values are entered and in the second column measured value is entered and in third column the nominal value is entered.Inthe fourth column the result is displayed by subtracting the measured value and nominal values. I am doing this calculation in Datagrid cell validated event. What i want is,there will be many rows in the grid,when typing the value in the third column the corresponding result will be displayedin the rowof theresult column,save button will be displayed while the form loads,when the calculate part is completed that is there should not any cell of the resut column empty then i should enable the save butto.
View 2 RepliesI am encountering the following issue So i have a device that sends stuff at the serial port, i then parse it and put it into an array of bytes like that:
Dim HCI_Command_Rcvd_Byte() As Byte All good till here What i wanna do is make an array and put this result every time the serial port gives me a new result, for example:
[Code]...
Basically what i wanna do is let the port parse the messages, fill in the array with the result at an empty spot in this array and then i will have a separate thread that will look in into this array in each non empty space and after it looks into the non empty space it will use or discard the info and also mark this space as empty (after it checked)
I have this code in vb6 the result of this query is bond in flexgrid how can i do this in vb .net using data grid.
Dim SQL As String
Dim rs As ADODB.Recordset
'SQL = "SELECT PO_Header.OrderID, PO_Header.RefNo AS [PO Num], PO_Header.OrderDate AS [Order Date],Category.Description + ' ' + SubCategory.Description as Department, " & _
[CODE]...
I want to execute an SQL statement and put the result in to a data table.
Sub getvehicletypes()
Dim dt As New DataTable
Dim intLine As Integer = 0
[Code].....
Once Ive got it in a dataset I need to work out how to search the dataset for a code and return the corresponding description and vice versa
i have bounded my listbox to a dataset the result is system.data.dataview not name of all my students. below is my code.
con = New OleDbConnection("PROVIDER=microsoft.jet.oledb.4.0;data source=d:
redata.mdb")
con.Open()
[code].....
