I am trying to create a drop down box to have it display the following information 90, 89 and 70, with this code:
Private Sub AsuComboBox_Change()
End Sub
I am trying to create a form to filter information from 3 different tables with 3 drop down lists.
Is there anyway i can select the information from 2 lists and ignore the 3rd?
FilterExpression="First_Name like '{0}%' and Award_Title like '{2}%' and CONVERT(Year, 'System.String') like '{1}'">
But I can only filter with the First name and Year - it seems to ignore the Award.
Background - I'm trying to populate a drop down list with state information from a database. I'd like the full state name to be the option and the state abbreviation to be the value. Example:
<option value="AL">ALABAMA</option>
Current Progress - The full state names and abbreviations already exist in the DB. I've successfully populated the DDL with full state names from the DB. Here's the code I've used to do this (minus stuff I've deemed irrelevant).Model Context (generated from template):
Partial Public Class BrokerCRMEntities
Public Property States() As DbSet(Of State)
End Class
State Model (generated from template):
Partial Public Class State
[Code]...
Question - In addition to populating full state names like I've done above, I'd also like to populate the value of the select options in the same DDL with the state abbreviations in my DB/model. How is this done?
I Want to develop a software like Yed.i just don know where to start.how we can create a workspace where i can drag and drop icons and create connection etc etc.
View 6 RepliesI have used VB (versions 2 - 6) through many years; however, I am crash-course training myself into the VB2008 / VB2010 world kicking a screaming. I would like suggestions as to what SQL database access method should I focus more on in my learning process without making me feel that I'm a million years behind. I know I have WinForms where I can create a datasourse and drag / drop fields or tables on a form to create a grid (not really what I'm looking for).
My trouble isn't so much designing the form but in how I access the database. Theres XML, LINQ to SQL, ADO.NET, and many other methods. Not only do I need to grasp these methods quickly but I also need to know what type of projects I should create. What I mean is...I was thinking that I would design a WinForm app; however, I see that there are WPF apps and others to chose from. This is getting deep. I know it depends on the project that I'm working on. My plans are to write an app based off of either an SQL Express 2008 or SQL Server 2008 database. This first app will be standalone for now but may later become multi-user. I know I'm far behind on my learning curve coming from VB6. I have read a bit on VB2005 / 2008 / 2010. I own
both VB2008 and VB2010. I use VB2008 at work. I know ADO.NET is still alive but by what I read online, it's a dying method and is only kept for backward compatibility. XML and LINQ to SQL and other methods are all pretty new to me.
I have a dataset with a members table that has a first name column and last name column. How do I get the full name to display in the drop down list?
View 2 Repliesi know how to display an image in a picturebox by drag drop. but cant find anything on the net about dropping an image to a textbox then having the textbox display its location
reolved if any one else searches for it.
Dim Files() As String = CType(e.Data.GetData(DataFormats.FileDrop), String())
Dim fileDetail As New System.IO.FileInfo(Files(0))
txtFilePath.Text = fileDetail.FullName
I am having trouble organizing the needed registers on page Document Print If anyone has any such Content or to have a better control of Info. How to display the image information according to the percentage of Code 33 is wrong because it exceeds 100%.I have to change my logic as pre set four record each item.[code]
View 8 RepliesLet me see if I can explain it.... Am basically doing a program that records project time for each worker and how much items(by type) they collect in total (No individual total)[code]...
View 1 RepliesI am trying to display the data I've retrieved from a text file on the datagridview. But I can only display the first set of information on the datagridview. There are 2 set of information.
Private Sub DoDetection()
ListStatus.Rows.Clear()
'listHistory.Rows.Clear()
[Code]......
[Code]...
my design is attach! Attached image(s)
[code]... How can i use a datagrid to display this information? I get it to display in a list box but cant figure out how to use a datagrid
View 1 RepliesI have a question which is related to use module to display data from original forms to different forms. Let's assume I have 4 forms: frmCustomerName, frmCustomerAddress, frmPhoneNumber, and frmSummary.
Module modInformation
Public Sub DisplayInformation()
Dim sCustomerName As String
[Code]....
Is it possible to create a button with a drop down, or a combobox that has the dropdown arrow along the bottom as opposed to the right hand side? I am trying to emulate the "Paste" button in the Word 2010 ribbon.
View 2 RepliesI needed to create in-cell dropdownlist in excel using VB.NET[code]...
View 1 RepliesIm a Noob at this this is my first creation, i want a step by step guide like if anyone can manage that i want to create drop down menus where the url goes like IE8 , also wanna create Tabs For Web Browser. I want To Also Make Favorites and history and thats it for now like IE8 Please Can Someone Help Me ill paste my code below
[Code]...
I have 3 databases: Subject, Class, and Students. In the Subject database, I have SubjectID and SubjectName and the PK is SubjectID. I have the releationship bound to the Students table where I only have the SubjectID in there. Next in the Class database I have ClassID and ClassName. ClassID is the PK and it's relationship is bound to the Students database where I only have the ClassID in there. Here is what I am having troubles with.I have comboboxes set up on a form to where the user can select which class and which subject the student is good at. What I want to do is to be able to insert those values into the Students table so that the values will make the correct Subject and Class name appear on the students record. I also want to be able to modify said Subject and Class ID, which when you click on the button, brings up another form to edit Student info, such as name, address, phone number, etc.
I am not sure what I am doing wrong. I take the comboboxes and display them on the form. For the datasource I use the Class for one and Subject for the other. The display member is Subject name or Class name and the value member is either class ID or Subject ID. When I run the project though, the class name and subject stay the same for all the students. I have sample data in my tables that is different for each student, but it does not work.
My button won't display the information my arrays are holding. why it won't show the information that is stored in the arrays... It shows only 'blanks' I don't understand!!!
Public Class frmMain
Dim intCount As Integer
Dim nmlStudents(49) As Namelist
[Code].....
I've currently got a service that produces xml files every 10 seconds containing server information. I'm looking for a way to display this on a web page. I have been looking on the web for the best way to do this and it seems that using AJAX would be good as it allows the loading of dynamic content to be done in the background. However how can I use AJAX? Should I add a ASP.NET website to my visual studio project? OR should I look to use javascript & AJAX in something like dreamweaver? I'm very new to programming so i only really have a bit of experience in vb.net.
View 2 RepliesI currently have an old database that has tables for requests and customers. This information is currently displayed in ASP.NET
What I was required to do, was to connect a new database for users into this system, while keeping the tables for the requests in the old database. Thus it is using 2 databases. I have set it up so, when a user creates a new request, in the request tables it saves it with his userID from the new database, but when the table is being displayed, it uses this new userID to find the user information from the old customers table. Thus I ended up with this:
Sub BindDataGrid()
cmdoledb = New SqlCommand("SELECT r.customerid, r.RequestID, R.RequestDate, R.RequestDescription, a.AssignedTo, r.Urgency, r.ExCompletionDate from tbl_requests r, tbl_assignedto a where r.statusid = 1 and r.assignedtoid=
[Code]....
Currently it displays nothing, and gives out an error for myItem.Value = rdr.GetInt32(0) being a Null. I went through it step by step and it loads customerids normaly into the myItem.Value, but when they run out, it is supposed to exit, but keeps going, thus giving an error.
I have one navigational toolbar that will allow me to click from one record to another. I am supposed to also have a navigation menu that does the same thing. I have found no information in my book that works on this. Is there a better place to find this type of information?
View 1 Repliesis it possible to create our own toolbox by which we drag and drop the tools?
View 2 RepliesI am currently working on a school database that I am having troubles with. I have the Table Adapters, Binding Source, and DataGridView all working, along with the Insert, Update and Delete Commands. I have the user open up the SubjectForm. On this form the user is looking at a DataGridView of the subjects table and everything that is in it. When the user clicks add new on the right side, it opens up a new form called AddNewSubject. When the user gets done adding the new subject in, a dialog box appears and says that the subject was added successfully. After the user clicks exit, it takes them right back to the SubjectForm where the DataGridView is. My question is, how do I update the data in that grid so that after the user clicks exit on the AddSubject Form, the new data will appear in the grid? I have tried a combination of things and they haven't worked. I will add my code at the bottom.[code]....
View 10 RepliesHow do I code different buttons to display different information on the same panel removing the previous information before displaying the new information?
View 4 Repliesi'm using a label to display information like song title, album, etc... in my visual basic program, some of those includes the & symbol & such, labels seem to dis-regard this character, is there any way to make label show this character or a similar thing that's meant for un-editable text?I don't want to use textbox/richeditbox just to make & symbol to appear, unless is there is a way to make it so you can't edit them & so they don't even look like they were ever editable, meaning get rid of the box around text & background, or something..that is only way i'd like using those controls
View 2 RepliesIf you can take a look at the received tab [url] It is meant to display the hosted images full properties. It doesnt at the moment because it completly fills the tab with ugly information.Can any of you think of a better way to display the newly hosted images information.?Im thinking of just killing off the tab. But thats not very professioanl in case the user wants the full picture information?
View 1 RepliesI have a form in VB.NET and I would like the user to be able to click a button which will display another form (with the original form still visible).
View 1 RepliesI have made an information display that is split in two parts. The right part shows a jpg converted document with picturebox and VB.Net. The picture changes if there is more documents to show. The left part is a webpage that is opened from the VB.Net program. It contains two xml newstickers in flash from [URL]. Both parts are feeded from a sql database. Everything works but I have a little problem with the newstickers. Everytime the right part with jpg converted document change document the newsticker scroll is jumping. Is there somebody who know a way to decrease the impact on the scrolls then I change document in the picturebox? Can I run the webpage in a other process or something? Or must I find another newsticker ?
View 2 RepliesOnce I click a link, I want to popup a dialog/window to display all the information of products. The parent page should be disable while the popup is opened. then, I would like to be able to pass information from the popup to the parent page..
View 2 RepliesJust like an array in a group box or a frame as i used in vb6.
If there are 5 customers details then when i load the form it will add (PictureBox, Label and a listbox) for each customer dynamically and display them with their information. Moreover, if i add 6th Customer information in the database then next time i load the form it should display his/her information as well. I did this in VB6 sometimes back but need a start to do in .net
Private Sub LoadCustomerInformation()
Dim Qry As String
Dim RS As New Recordset
[Code].....