Populating A Dropdownlistbox In .net 2010 Winforms?
Jan 20, 2011I am trying to populate a dropdownlistbox with data returned from the database. I have a ClaimID & ClaimType. I can't seem to get the syntax correct.
View 2 RepliesI am trying to populate a dropdownlistbox with data returned from the database. I have a ClaimID & ClaimType. I can't seem to get the syntax correct.
View 2 RepliesI am new to winforms and I am trying to populate a dropdownlistbox with data returned from the database. I have a ClaimID & ClaimType
View 7 RepliesI am trying to load CustomerName and PrintStreamACNO from tblCustomers to my dropdownlist. I am not getting the correct syntax on the binding and displaying.
Imports System
Imports System.IO
Imports System.Reflection
Imports PSXSTL.Data
Imports PSXSTL.Data.DataAccess
[Code]...
I would like to enquire how I would go about population a chart (bar graph) in VB 2010 Professional?
I am pulling the information from a MS SQL Database.
it doesnt like my code:
Dim n As Integer
Dim flag As Boolean
Dim i
[code].....
I'm having this
vb.net
Dim strQuery As String = "SELECT * FROM tblHistory" ' ORDER BY moniDate DESC"
Try
'~~~ Create the connection
[code]....
This is in the Form_Load to populate a ListView control. But I'm getting the following error:
InvalidArgument=Value of '1' is not valid for 'index'.
Parameter name: index
Where am I doing it wrong?
I want to poplate a checked list box based on a column from a datasource or standard listbox based on a selection from a combobox adding each item as I select it in the combo box.
Obviously populating direct from the data source would be best
Is there a way to populate the value in a dropdown? I am using the following command:
ComboBox1.Items.Add(DropDownData)
I googled, searched and tried houres but I can not find a simple code/class that does the following: I have a SQL database and I want to show some colums of a table in a listview... Not so difficult I thought, in VB6 it was fixed in 2 minutes but now I'm struggeling for houres... I found Imports System.Data.SqlClient but further then this, I fail...
View 3 RepliesI have a tab control in my form and inside it I put a listview. What I wanted to do is populate the listview everytime I clicked on each tab. But I don't know how to do it.
Here is the bit of my code
Public Class Form2
Private Sub PopulateRecords()
Dim TSR As New ADODB.Recordset
Dim STRSQL As String = ""
[code]....
I'm doing an MP3 playlist project for uni and I'm struggling with populating the List View with the XML received from a web service.
[Code]...
What I want to do is gather the data that displays in my listview (called 'lstData') when selected and populate my textfields with it's information.[code]
View 2 RepliesI'm working on a new version of something I had created years ago in VB6. What I was doing then is populating a combobox with lines from a sequential file ("title","URL") like this:
Open "data.dat" For Input As #1
Do While Not (EOF(1))
Input #1, NameInput, URLInput
cmbEntry.AddItem NameInput
Loop
And then checking against it on a button click to load the URL associated with the selected name:
Open "data.dat" For Input As #2
Do While (cmbEntry.Text <> NameInput) And (Not (EOF(2)))
Input #2, NameInput, URLInput
Loop
[Code] .....
What I'm trying to do in Visual Basic 2010 is the same process, though I'll be including a third field ("category","title","URL") to determine which one of four different comboboxes I add the entry to. I know I need to use streamreader, but I'm not finding much in the way of documentation or examples on how to do what I'm trying to do, which is:
- Populate one of four comboboxes with the second value in each line of an external text file, based on the first value in that line
- Set a string to the third value in a line of an external text file, based on the second value of that line
How to read these values from the file.
I am trying to create a basic quoting tool but got stuck on how to clear and change the item collection from within a combobox for a datagrid.What we have is a list of 4 columns like a. Device b.TypeofService c.State d.Price Inside a sql database. Data is also structure like above as well.
I have a datagridview where the user will populate a,b,c and the price will be display and a total at the end. However a,b, and c aren't related in my current application. The combobox will show all possible dinstinct values for each column.
This works fine but I want to refine the application to only show the values of b. which are in the database after the user select the value for a. I have tried searching on how to do this as I assume to the Contry/State/City situation but could not find anything for a datagridview control in VB.NET.
Can anyone point me in the right direction? If I cannot do this dynamically from within a datagridview I was thinking of maybe creating three combo box outside and having it populating the datagridview afterwards but it wouldn't be as nice.
I'm working in this application in Visual Basic Studio 2010 I have a combobox where user select phone model and textbox where a text file is loaded when user select model, I added text files to the project resource because I don't want to put them in files in the root directory of my application
[IMG][/IMG]
what I need is a code to make text box load the text file wich have the same name of selected in combobox for example when user selct : CT-810 in combobox the text file with name: CT-810 must be loaded in the text box and so on for other combobox records
I want to create a .DLL (my library file) so that it can be used as data source for reports (to use with .RDLC files).Can I use same .DLL in my ASP.Net application for reports as data source (here also .RDLC files).It will save my time and maintain report integrity between WinForms application and ASP.Net application.
View 2 Repliesim trying to play a flv file in project.1.The problem im having is when i add the Macromedia flash factory object i get the error "Failed to import the active X control-ensure it properly registered" which i have registered it to many time and still get the error.
View 2 RepliesI have WinForms application with SQLServer 2008 Express. I want to move my data from it to SQL Azure. The architect of application as Client-Server Type (using stored procedures).
I want to know that if there is any performance issue when I am using broadband internet (with speed 2Mbps download and 512kbps upload)?
I was wondering if it is possible to use the WPF Ribbon in windows forms(they added it in .net 4). I know about the ElementHost Control which works fine for created controls, but it doesn't seem to be able to host default controls, I could create a wpf control and put the ribbon in, but that seems like a terrible hack.(And lots of work since there are lots of controls related to the ribbon)
View 4 Repliesthis is my absolute first attempt at the mschart control in a winform, so any help would be appreciated - i have sales reps that issue quotes to customers and would like to plot number of quotes by month using the mschart control.I have a dataset populated with a single table with 2 columns in it - sales_rep and quote_issued_date (there's more, but i'd like to only focus on those two because they contain all the info i need)i have a windows form with an MSChart control dropped on to it. I'm trying to get this to work on a 'column' chart type.i'd like to count the number of records in the dataset per sales rep per monthi'd like to get the x axis to be months in the year (fixed, not drawn from the data) - jan thru dec.
i'd like to get the Y axis to reflect the highest count of rows per rep per month + say....10% (so the graph doesn't peak out at the top every time, it would be more for aethestics)i'd like to get the columns displayed in the graph to be each rep, each month (ie for january john has 10 quotes issued, bill has 5, tom has 31 - for feb john has 3, bill has 10, tom has 19 - etc etc etc) - because the form is just a quick visual, i'm dumping any code in the form load event and calling it good.
I have a desktop WinForms app that I would like to be able to connect to my Sql Server database that I have through my GoDaddy webhost. Problem is not all ISP's forward the 1433 port (like mine) so I can't connect directly to the DB from any of my home computers without buying the expensive dedicated IP address package, which has me thinking since my website can connect directly to the DB I was wondering if it might be possible for me to make a dll that would have all of the database interaction through subs and functions and all my WinForms app would have to do is connect to that dll through http or something, anyone know if I could do something along those lines?
[Code]...
I'm writing a desktop application that uses the main access database that will be hosted on a central server, but there will be a laptop with the app on that has an offline mode so records can be created offsite. When the laptop returns I want it needs to be synced back to the main database.
Has anybody got any pointers on a way to do this, I've briefly read about JRO but is there an alternative / better method?
Originally, I was just going to write some custom code to do this, but thought I'd check to make sure there wasn't something already out there.
I am deploying a VB.net 2010 winforms application, and when I install it on the client's machine, the install process also installs an instance of SQL Server 2005 Express. The application connects to a central SQL database on the server. To install, I am using the "Publish" option in VS 2010. Why does it do that? There should be no need for a local instance of SQL Express. Is there a way to avoid installing SQL 2005 Express (I know it is free, but I would rather not have it installed if possible).
View 1 RepliesIs there a shortcut to get to the designview form in a winforms project in visual studio 2010.F7 will take you to code behind class form and shift + F7 will take you to design mode. Is there a shortcut to filename.designer.cs formWhere you have the control definitions, delegates (for click event etc). defined. I go to the form often if I change the name of click event etc.I have to go through solution explorer and click on the file. Is there a shortcut like F7 that opens the designer.cs file?
View 1 RepliesI have to run a thread create in the code.In the form1 i have a button that run the new separate thread for elaborate some data, so i need it for not freeze the form.I have inizialized thread:
dim th as thread = new thread (addressof elaborate)
And at the button.click event:
th.isbackground= true
th.start()
Now, at the form load i have iconized my program, but when i start new thread the tray icon is duplicated from it. I want to resolve that when start new thread it's not show new notifyicon.
(i don't have found anything online, only Multiple notification icons appear when using multithreading)
I have a list of .txt, .doc, .pdf on my listview. How do i code this problem;
1. When i double-click the item (sample.txt) on my listview it will open in a notepad.
2. When i double click the item (sample.docx or sample.doc) it will open the MS word and shows me the things written on the particular item.
I'm using the following
[code]...
But the result is always the same
I've decided to learn Visual Basic .Net as this is what some of my colleagues work with, and this will allow me to work with them on projects.I have purchased Microsoft Visual Basic 2010 Step by Step and downloaded the sample files. When I am trying to debug the first sample application (a Windows form), it is telling me that it can't load System.Drawing V4.0.0.0. However, if I create a new Windows Form application (C# or VB.Net) this works fine.
I had a look at the References tab in the project settings and System.Windows.Forms is referenced, but the version referenced is 2.0.0.0. I have removed and re-added this reference and it stays at 2.0.0.0 and I still get the error.Does anybody have any ideas as to what may be going on?
Is it possible to set a project default for VB.NET winforms projects so that the default Modifier for controls added to winforms is Private (not Friend)?I know there's a "modifiers" property in the properties window so I can set it for each individual control however I would like to change the project so from now on myself and other developers have to specifically decide to change from friend to private. (Which I would strongly discourage them from doing).I believe there is no way of doing this, but on another forum a while ago someone mentioned it would be possible with an add-in (but didn't name the add-in or where to get it).
View 1 RepliesI hope I got all that in this question title. Let me explain. We are starting on small desktop app that will snowball into a big app with many forms. The database is SQL Server. It will have classic stored procs/functions performing classic CRUD functions. Given a table or stored proc in SQL Server what is the quickest way to create a form with all the hooks to maintain a table.
For e.g. lets assume I have table like this (most code below is pseudo code)
Table Employee
{
Name varchar(30)
DOB Datetime
Address varchar(100)
}
From this as source I want to create my Target which is form with 3 labels and 3 textboxes with add delete modify buttons (or OK button to add if not exists or modify if exists)
[Code]..
The code generation tool or technique that will be used should generate the correct db hooks (create SQL parameters, SqlCommand, execute sql.. basic try catch etc. Is there any open source tool to do this ? Some trick or templated approach via VS 2010 ? Worst case any third party tool ?