Dim oControl As New Forms.Control()
Using types As New DataSet
With oDal
.Parameters.Clear()
.Execute(sql, types)
[Code] .....
For some reason when you click the dropdown - "0" is displayed defaulted. It needs to be the first text/value pair from the table. The table is only returning one row at the moment, which is correct, but 0 still defaults.
I have dropdown list with name : list I want the first index to be the defualt value of dropdown list .
how could do I do this ?
In a combobox dropdown. What toolbox or properties do I use in VB Express 2010 to add a default to my drop down so the user will see the default when the panel is first shown?
View 3 RepliesWhat control should i use if i want a button with default text on it and when i press on it, it give a drop down menu that i can select different commands. I tried a combobox which seems to be very close to what i want. i set the dropdownstyle to dropdownlist so it looks like a button. but i cant seem to set a default text on the box and i dont want this text to be in the item list. also when i set the dropdownwidth to a value larger than the combobox width, it will align left.
View 4 RepliesI want to Update Column of a Table where ColumnName will be DropDown.SelectedValue.Example: A set of RECORDS will be displayed from a Customer Table where CUstNo ='1234' and City= 'Chicago' and Grade ='B' Once displayed I want to Update the grade to 'A' of all those customers from the above criteria. In My case I have like 100 Columns, so in where Clause Column Names will be selected from a DaropDown.In My Query, Update Customer SET ColumnName= 'some value' where ColumnName ='ActualValue'So how can I pass the ColumnName which is Dropdown Selected Value. I believe I can't give as Update Customer SET DropDown.SelectedValue = 'some value' where DropDown.SelectedValue ='ActualValue'
View 1 RepliesI have a question about the AddNewItem method. From what I understand, then this event occurs, the EndEdit() method is called and a new record is created IN MEMORY (or a buffer). The user fills in the form that is presented and when the Save button is pressed, the record in the buffer is actually added to the table.
In my application, a form is displayed and some of the forms databound text boxes have DEFAULT values (see the property for the textbox under the Data Bindings, Advanced and NULL VALUE). For example, I have a text box that holds a number and the NULL value is set to 0. When the form displays, the ZERO is in the text box. Assume the user NEVER enters the field or changes the ZERO to something else (which means the field is never validated).
Here is the problem. When the SAVE button is pressed, the ZERO that was the default value is NOT WRITTEN to the table. The field in the table is DBNULL. That is not the desired outcome. So - How can I check the fields in the BUFFER BEFORE they are written to the table?
I have a table that contains the matter field coefficient and I want to bring its value to 1 by default, but unfortunately I forget to do that when creating the table matter, and I try to change the table to the coefficient value in a default but it does not work
View 1 RepliesI have a list of servers in the first dropdown. I want to get list of all databases in the second dropdown depending on the server selected in the first dropdown.
For this I need to query each server while selecting the server.
I am trying to do an insert into a table called Policy. I keep getting an error that says parameter @Split has no default value. To try and resolve the problem, I set the default value of the split field (of type text) in the Policy table to "0" in Access 2007. I am passing in the value of a string "0" into the parameter before the insert statement executes.
Dim connection As OleDbConnection = PaulMeadeInsuranceDB.GetConnection
Dim insertcommand2 As New OleDbCommand(insertStatement2, connection)
connection.Open()
[Code].....
I need to print the contents of 3 textboxs to default printer. what examples I have found dont seem to work. I was trying the documentprint1 component as i thought it would be easy but cant figure out how to tell it what to print the second part is to print a variable (string) to the printer as well.no need for user to select just straight to default printer with its default settings
View 1 RepliesI have a combobox which contains a sample of names selected from a table.Currently the default name displayed in the box is the 1st name found in the table. What I would like to do is display the name of the person who is doing the selection as the default. The name is stored in a public variable 'PubName' and I do not want the user to be able to type into the combobox themselves.Is this possible?
View 2 RepliesI am creating my own browser. I want to make an option...to set as the browser to default.To do that I have to:Write a code which opens html(generally internet) file through my browser(form load event) DoneChange the "open with..." of the .html,.xml.... files Problem I want to change the open with event from my web browser. Actually i want an options form which will ask the user "Do you want to set /Browser name/ to be your default browser?" If yes then it will change the default options of the internet files.
View 5 RepliesIs 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 want to add a new table in my accdb and copy the content tfrom an existing table into the new one.
Is there an easy way to do this?
I have a data table whose one column is related to a column of another table. I have a listbox in a form which shows a column (which is sorted by another column value by ORDER clause) of the parent table and other columns are in textboxes. The child table is represented by a datagrid. When I add a new item in parent table and click save, the newly created item is listed at the bottom of the listbox violating my ORDER clause. When I wrote some codes to fill data again after updating, it shows an error message[code]...
View 3 RepliesHow do I copy a table to another table without overwriting the contents of the second table?
View 2 RepliesI am using VB 08 running an openfiledialogue wanting to get the result of the GDS file (*.gds) to be the default extension at the drop down menu instead of All file when the openfiledialogue box opens.
I coded it with:
OpenFileDialogue.Filter = "GDS File(*.gds)|*.gds|All files|*.*"
but the results i get in the open file dialogue box remains as all files being in the drop down menu as the default file extension. How to i set it to ".gds" format?
I want to fill a dropdown in the pageload by using a BLL and DAL class. This is the code
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
dropBrand.DataSource = BLLManufacturer.selectManufacturers()
[Code]....
The first dropdown fills up with brands as it is supposed to do, but the second does not. The second dropdown needs to show car models by the chosen brand in the first dropdown. However the dropBrand.SelectedValue always returns 0 whatever brand I select. Without the convert toint16 it doesnt work either nor with convert toint32 or toint64.
I am limited for space on my form. Is there a way that I can have a textbox act like a dropdown? So the form will show as one line. If the user starts typing multiple lines then it opens the drop down so they can see what they have typed. Will it have all of the same goods as a textbox, like copy and past? When they are not typing then it will be closed and only showing the first line.
View 3 RepliesI have been to internet hail and back trying to figure out what Im doing wrong with my combobox cells and columns.When I add items to the cell using .item.add("something"), othing shows in the cell. I can add 5 items and nothing shows up. No dropdown and nothing in the cell. In debug, I can stop and look at the cells value and see that n-items where indeed added but yet, they dont show up on the screen in the DGV.I have a DGV and I have tried this 2 ways.. creating the columns in the form designer and by adding the columns in code.Heres a snippit of the datagridviewcomboboxcolumn (thats a lot of typing) anyway.. this is the def for it and the surrounding columns:
Dim conx_text_col As New DataGridViewTextBoxColumn
conx_text_col.DefaultCellStyle.BackColor = Color.Teal
conx_text_col.DefaultCellStyle.ForeColor = Color.White
[code].....
I have created a sub that I am using over and over again. However, I am not able to get the values from the database. Screen shots and code attached. I need a second pair of eyes, can't seem to figure out what is wrong.
Form Load
vb
'Populate the drop down lists
PopulateDropDownListFromDB(cboReferrerType, "ReferrerType", "ReferrerName")
[Code]....
I have a large VB/SQL application that I have created a problem in. I have a table of procedures that have an active flag on them. This flag can be toggled through a user screen. Other screens access this same table to populate dropdowns. The values are stored in the table as the ID field (PK). The problem I have is that I am selecting the dropdown values based on the Active flag. If I select a record that has a procedure stored in it that has been made inactive, I get the old Object Not Set to an Instance.... error.
What I want to be able to do is check for the value in the record when populating the dropdown and allow the record to be displayed by bypassing the SQL error and just showing the dropdown value as blank while not altering the record itself. I hope I'm making sense. Code is below.but I'm back in app programming after being a SysAdmin for 20 years and I'm still rusty.[code...]
How can i make a dropdown list with checkboxes ? I have a windows app ( vb.net) and the checkboxlist control is not real an option with the available space on my form.
View 5 RepliesUrgh, I have spent the last couple of hours on this now. I normally end up finding the answer from a bit of Googling, but not with this one. Bit of a headache.
My questions:How can I catch when a user clicks the dropdown arrow on a combobox and prevent the dropdown list from being displayed.How can I then clear and populate the dropdown list and display it programmatically?
I have one agent program remotely connected to a server over the internet. When you click the dropdown arrow on the agent, it queries the server to determine what needs to be in the dropdown list. It then displays the dropdown list. The comboboxes act as filters for the subsequent comboboxes on the GUI. A delay in displaying the dropdown list is perfectly acceptable while retrieving the data. Initially querying all the possibly entries in the dropdown list is not an option because there are so many! Needs to be comboboxes compared to listboxes as the user may also type an entry that is not in the list.
[Code]...
VB.Net / Winform.Is there a component that will look like a Button but when pressed will open like DropDown, but the DropDown wil contains a list of Buttons? Menu bar won't work for me in this case.
View 1 RepliesHow can I add a data to my drop down list came from database? My code is this. And when I try using this:
<form id="form1" runat="server">
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
[Code].....
It got errors in a webpage that says controls are not allowed to be put here. I only have an empty dropdown right now.
<asp:DropDownList ID="DdLocation" runat="server"></asp:DropDownList>
Is there a way to add to the "Show Output From" dropdown list. I've been going in circles on MSDN looking at Listeners, Writers, Trace, Debug, ConsoleTraceListeners etc. with no luck. I really would like my own pane for debug output because I don't want to disable any of the messages in the debug pane, and a lot of stuff gets pumped out there.
I found a way to add a new pane to the output tab through a macro/addin but don't know how, or if, it can be written to through code.
Short of that I'm really just looking for a better/more intuitive way do display debug output. Colored would be nice. I've tried very unsuccessfully to use nLog - but the configuration/documentation left me scratching my head.
Is the output window really what most people settle for?
in an sql table there's an id, first name and last name field. i'd like to concatenate the first and the last name fields and display it as one in a dropdown control.
this is the vb.net code:
con()
sqry = "[SELECT QUERY]"
sqcom = New SqlCommand(sqry, sqcon)
[Code]....
^this code displays only the first name. how do i go about concatenating in asp.net?
I have a web form in which i have droped 6 dropdownlists and each dropdownlist have previous seven dates to open files from a specific folder concatenated with date at the end of file name.Problem is that when i select first dropdown list it opens file fine but when i select a date from anyother dropdownlist to open file then it open the same file which was opened from the first dropdownlist.Please see the code and make correction in it.
[Code]...
I'm trying to make a user control similar to the Windows Vista/7 breadcrumb bar used in windows explorer. However, when I show the drop down menu for a breadcrumb with many sub items, I get a very long list that sometimes exceeds the screen size. In the Windows Vista/7 example however, there are a maximum of 18 items displayed at a time and a scrollbar appears at the right when the number of sub items exceeds this number (18).
[Code]...