I have a problem that I think is very simple, but I did not find the answer on the net.
I have a listbox that I am using in my program. At a certain moment I bind the listbox to datatable:
[code...]
Does anyone know how to unbind the listbox from the datatable?
add items to listbox by datasource
View 3 RepliesOk I have a Listbox that is populated by a Datasource or the datasource is a listbox. When I try and retrieve the selected item It is blank. How do I retrieve the selectedItem?
View 9 RepliesI started use this code:
ListBox1.DataSource = _
My.Computer.FileSystem.GetDirectoryInfo(_
"blablabaDIR").GetFiles("*.*")
[Code]....
So i got the files on the listbox at debuging.
But can i sort them so the biggest is first?
i import into a list box data from a db. when i try to save listbox it save this text
System.Data.DataRowView
instead text of single item...
how i can get the real text of each item?
I gather MATTER NUMBER and PATENT NUMBERS in a listbox on a dialog form - that I pass to the main form after the dialog closes.I then ask for CASES on subsequent dialog forms and want to have drop downs for MATTER NUMBER and PATENT NUMBERS that "have the suggestions" of what was entered in those list boxes earlier.So - I've been using DATASOURCE for binding to datatables and thought to myself - heh - I can probably set the DATASOURCE of the DROPDOWNS - and it works!
Public AddMatterNumber As ListBox
Public AddPatentApp As ListBox
MatterNumber.DataS
[code].....
I use vb.net and windows form and sqlserver
I added Data Source(Microsoft SQL Server (SqlClient)) to my project. and now I need to change it to ODBC Data Source .
If I set a ListBox.Height = ListBox.PreferredHeight when the control is hidden and IntegralHeight = True, then set it visible:
a) Actual Height reduces by typically 3-5 pixels after redraw (but not 1 pixel per item).
b) PreferredHeight does not not appear to give the correct integral of item heights.
Is there a way to make ListBox calculate the correct integral Height before the ListBox is made visible, so it can be correctly pre-positioned from bottom edge?
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
ListBox1.Visible = False
ListBox1.IntegralHeight = True
[CODE]...
This code bellow to compile a single listBox on form1 to listBox on form2 then listBox on form3.
I want to modified this code to compile 169 of ListBoxs on form1 to 169 listboxs on form2
and 169 listBoxs on form3.Try this code,not need the new coding.
Original code from JoOl and modified by John Anthony oliver
[Code]...
1 when my listbox returns resaults it only brings back 10 how do I set it to return lets say 500
and question 2 is when I click on my links in listbox it's not opening webpage as I would expect it...
This is my code
[Code]...
I am using VB.NET (version 2008). I have two types of items populating in a listbox (checked listbox). For example: lets say one is type "A" and other is "Type B". Their names maybe same so if the user sees those items in listbox then he won;t be able to determine their type until he click on them and checks out its properties. I wanted that I add each item to listbox and colour them so that blue for example means type "A" is there and red means the other. So this way I will be able to know at a glance that how many item of what type is present. I guess it may not be possible to do that in a standard checkedlistbox. I am also using component factory's krypton controls which enhance the gui of an application. But I dunno if I can progress using that.
View 5 RepliesCreate a membership database that has fields for title, first name, surname, address, subs renewal date and membership type (active, social, honorary or life). Make an interface that allows a user to display, sort and create records. Consider the use of drop down boxes to aid error free input.
When i add a new datasource i get to "Select database objects" page and then i get an error message. "Could not load "Microsoft.etc"", im using an access database with pre-created fields.
I cannot add data source in my window applciation;...There is no menu for me to add a new datasource.
View 8 RepliesI have a DetailsView that looks just about perfect. The only thing is, there is one field that actually gets its information from another table. It is an ID field that is linked to another table in the database and I was hoping that there was some way to get that one field in the DetailsView to pull the information from the other table.
Is there a way to maybe add a + (plus sign) next to the PicklistID and then have it show the results of the other query? (SELECT TEXT FROM PICKLIST WHERE PicklistID = @PicklistID???)
UPDATE 1/11/12: The PICKLISTID in the table PICKLIST is not unique or a primary key so I cannot reference it from the SURVEY table. Is there a way to give these 2 columns a relationship so that I can just change my SELECT statement in my DetailsView to include the PICKLISTID?
UPDATE 1/23/12: I'm still stuck on this. I am not getting how to make this work at all.
[Code]...
have 3 dropdown list one has pre set values and my post back works the other 2 has the data from the db when i try using post back on them i don't get anything in my grid view.
<asp:DropDownList ID="ddlname" runat="server" DataSourceID="SqlDataSource1" DataTextField="Venue_Name" DataValueField="Venue_Name" AppendDataBoundItems="True" AutoPostBack="True"> <asp:ListItem Text="All" Value="All" Selected="True"></asp:ListItem> </asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
[Code]...
how do you add information from another datasource into a cell in a data grid which has the relevant information i.e order_bindingsource grid which has the information order id, item id, quantity and cost per item.
The item id I have linked to the Productbindingsource but I also need the information to be shown cost per item which is in data source products.The item id is a drop down box with the items displayed what I need is when an item is selected I need the price to show up in the cost per item box.
I am trying to create an arrayList of people. The variables, or arrays are; first name, last name, age, DOB. I am wanting to load all that into one arrayList and dataBind it so it would look like [code] Loading it into an ASP DataList. SO Fname + Lname + age + DOB are loaded on the same line/index. Not sure how to go about this. I'm sure it's an index issue..but not sure the thought process to even begin to load these elements into the "0" element, then the "1" and so on. Not puling the information from a database, just preset arrays/arrayList. ANY suggestions? ( I have it so it is dataBound to one arrayList entry as in [code] This works fine. But if I wanted to add the last name to the first name on the same line...that's were I am not seeing the connection.
View 5 RepliesHow to declare a datasource?
View 1 RepliesIn one of my projects, I have this line of code that works:
Dim newCustomersRow As EyeBaseDataSet.HistoryRow
newCustomersRow = EyeBaseDataSet.History.NewHistoryRow()
In this new project I'm trying to get the same thing going, but I can't use the Row definition. I type the data set name and don't get an option for the tableRow. I don't know how else to word this, but I need to know what I have to add to the project to give me that control. In the working project it says "Class HistoryRow" and I went to the definition and it took me to the designer and showed me a Partial Public Class with System.Data.DataRow.
How can I set the datasource of an ItemTemplate? Right now I have one that is wrapped by a datarepeater and that is how I databind to it.
<asp:Repeater ID="rptTotal" runat="server">
<ItemTemplate>
<tr>
[Code]....
I have a datalist. I have datatable in javascript. I want to set datatable as datasource to datalist in javascript
View 1 RepliesI have a SQL Compact Database that I've added in my Data Sources. I then have a DataGridView which is filled with all the records in a particular Data Set.There's a button on the same form as the DataGridView that opens another form, which allows the user to add a new row (record) to the DataSet. Currently however, the fields on this form are not related to the columns in the Data Source in any way.
View 6 RepliesI have a datagridview and a column which is DataGridViewComboBoxCell
I want to set datasource for that DataGridViewComboBoxCell?
I list folders in my combobox but I'm trying to sort the folders alphabetically and then numerically or vice versa.
My coding to populate my combobox is
With Combobox1.DataSource =
(From folder In New IO.DirectoryInfo("Path").GetDirectories
Select (folder.Name)
).ToArray
End With
Is it possible to sort the combobox?
I have folders that are numbered like 1, 50, 115, 189 etc.
These should display as
1
50
115
189
however they display as
1
115
189
50
A program that I'm designing for a local jewelry shop to print receipts and what not, there are multiple cashiers. I have written a database in Access with the Cashier ID, First Name, Last Name, PasswordI have added this to my dataset, it shows up as CashierDataSet1. What I need to do is verify the Cashier ID, and the Password match TextBox1, and 2. All the tutorials I have found are for accessing that database on the local hard drive, which would be fine if I could get rid of my UnauthorizedAccessException error. Any ideas or well known tutorials for using a database in a dataset without pulling the text boxes onto the form and creating that navigator ?
View 3 RepliesI currently have a control that called MyGridview that inherits Gridview. It has a paging template within it for customized paging options, and I'm at the point where I want to cache the initial datasource for better performance.I haven't done this in a long time, so perhaps there is a different solution these days with the newer frameworks.Before, I simply used a Cache object that was named whatever the gridview was named. I couldn't use the same gridview name through the application though.Is there a best way to have a cache object, or some other object like a session within the control to store those unique datasets for paging and sorting?
View 1 RepliesWhen I try to change the datasource of my DataGridView, I am loosing the order of the columns and their type(checkboxes,comboboxes) that i specified on designtime! It's like changing the datasource is generating again the datagridview, why ? and How can I change the datasource without losing these information ? on form load i do something like
Private Sub frmGrid_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim Path as string
[Code].....
How can I use the value of a GET form value as a SelectParameter?
View 1 RepliesI have a vb.net window application project that connect to Access database.
I use dataset for all Forms and Reports.
Now I would like to change back end from Access database to SQL Server 2000 database.
I change the connection string(Data source, Data Provider etc)to connect to SQL Server 2000.
But it is not convenience bcos Dataset Designer codes are still connect with OLEDB Provider instead of Sql Client Provider.
So I can't do my application with SQL Server database.
I'm using VB.NET 2003 windows application.i'm trying to display Crystal Reports using CrystalReportViewer.
Code i'm using to display "ZTab.rpt" in CrystalReportViewer when Form_Load
Code: Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]...
for example: if we are using datasource "work.mdb" for "ZTab.rpt" when form_load. when i hit a button, how come i change the datasource to "Employee.mdb" for "ZTab.rpt" during run time using codes. so when form_load it will display ZTab.rpt with datasource "work.mdb" and when i hit a button, it will display ZTab.rpt with datasource "Employee.mdb".