I'm trying to make my datagrids datasource change when you select a particular item from a drop down menu but all I get is blank cells! any ideas? I don't think it is changing the colums property automatically either.
If chooseType.Text = "Add / Edit Players" Then
updateDB.DataSource = PlayersBindingSource
[code].....
I have a dropdown where the items initially are filtered (using a SQL Datasource) based on the selection of another dropdown; however, I have included a checkbox where if checked, the dropdown needs to populate with all data from another datasource How do I programatically remove a datasource that is bound to a control and then define another?
I have the following code, but it errors:
If cbOverrideArea.Checked Then
Me.ddArea.Items.Clear()
[code].....
I have a goal to have dropdowns populate using a string array as the datasource. Re-binding works well in the dropdown event, but if I make a change to a currently selected line item it won't change until I make the box dropdown again. Is there a way to keep this updated without re-binding the data?
Also, this is one of several dropdowns on an MDI child form. I'd like to make sure they're all synced. For instance if one has "Bob" selected and I change Bob's name to "Chris" I need all the "Bob" dropdowns to change to "Chris". Is there a way to do that without having to cycle through all the windows and call a rebind function?
Finally, I want to know if there's a better way to do it than the way I'm doing it. Since all these children have to be synced, the MDI parent holds the String array as a public property and the children each leech off of it.
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 have inherited a database that is moving to the web. Problem is that some of the string fields have html characters....
One example is....
"" without the quotes, IT WON'T SHOW UP IN HERE EITHER, trying something else. At any rate it has < and the > signs with text in the middle.
How can I escape any possible combination of html references.
SelectCommand="usp_getSingleStringData" SelectCommandType="StoredProcedure"
<SelectParameters>
<asp:SessionParameter Name="shrtText" SessionField="shrtText" Type="String" />
[Code]....
What I am trying to do basically is open an access query in a datagrid view and then be able to make changes to the datagrid and then save it back to the database.When I try to save:
Me.BindingSource.EndEdit()
Me.TableAdapter.Update(DataSet)
It says that update is not a member of the tableadapter... Why is that?
I want to place a image with the text "NO IMAGE" in my Repeater when there is no image.What changes must i make in order to achieve this? I want my Repeater datasource to point to an image inside my IMAGE folder in my root directory.
[Code]...
I have a DataGridViewComboBoxColumn, and want to switch the style of the ComboBox control between DropDownList and DropDown (mainly for the text field editing capability). I'd like to do this on a row-by-row basis (at the DataGridViewComboBoxCell level).How would I do that programatically? Or maybe a different way of asking: How do I access the ComboBox control given an object of type DataGridViewComboBoxCell?
View 1 RepliesI want to take a drop down menu. It will contain LastName, FirstName. I want that to select a record from a table. First Name and LastName are two different columns
View 5 RepliesHow to set up a Chart using the new MS Chart control. I want to be able to populate the data via SQL because the user will be able to dynamically change the values via drop downs. The format of the data will be the same (Qty, Time Period) but the Focus of that data will change. I'm honestly not sure where to start, I can draw the chart but I have no idea how to populate it with data via code so it can be changed dynamically.
VBE 2010, and I'm hitting an AccessDB
I have created an application which uses an sql server connection as its datasource. The problem I'm having is that the application needs to work on computer that has no network connection. How Can i change the datasource so that on runtime it can work off a machine that is not connected to a network? The datasource from the sql connection only contains one table with no data. It only needs to be updated with a target folder that can be changed to any location on any computer already written in the code.
The connection string suddenly stands as: Dim MyConnectionString As String = "Data Source=MY-PC;Initial Catalog=ImageLocs;User Id=test;Password=test;Pooling=False"
I had a DataGridView that was bound to a Table in my typed DataSet. I recentyl added a new column to the table in the database and updated the table in the DataSet accordingly.Now, when I go to the DataGridView to update it, the new column does not appear under the "Databound column" list. I tried setting the data source to "None", then reselecting it. Still, it does not show the new column. I then deleted the DataGridView and re-added it to the form. Again, same result. However, when I select the data source, then click "Preview Data", it show the added column.
View 2 RepliesWhenever I setup a database connection, and then drag items from it onto my forms, I get errors! 102 of them to be precise.All I've done is create a data connection, add the datasource, created relationships and then dragged items ome. I've been working with databases for a while and have never had this problem when taking these steps.
View 7 RepliesI have defined a datagrid which has combobox in one of the columns, is there anyway to modify the datasource of the combobox (the source of the list) at run time?
View 2 Repliesjust curious what happens when i set the datasource of a combobox or datagrid or what-not to a dt then when i want to change what's in the combobox etc., i just set the datasource to a new one. i am cleaning as i go but just want to know what happens to the old datasource:
[Code]...
I am trying to populate a VB.net dropdown box which is repeated in a datagrid. Basically I have a bunch of images and the user needs to select from a dropdown listwhat colour the item is so that I can then save it in the database.
Dim DDLPlayColorList = New DropDownList
DDLPlayColorList = dgImages.FindControl("DDLPlayColorList")
Using oConn As New
[Code]....
I'm trying to rig up a ComboBox with a Datagrid dropdown in WPF. I need the the code to be done programmatically and contained in the codebehind. Here's what I've got so far:
[Code]....
This code produces a ComboBox that contains a DataGrid with two columns and seems to look fine. Although when you click on the ComboBox and select one of the rows in the DataGrid the selection in the ComboBox doesn't work properly. (It just shows the colum headers.) I want the value in the first column of the selected row to appear as the ComboBox selection.
anyone know how to do this? build datasource(datatable) with values from a datagrid.
View 1 RepliesIn a windows forms project, I have several combo boxes. The first combo box contains a list of objects. Those objects then have several lists which are used as the datasource's for the successive combo boxes, depending on which item is chosen in the first.
[Code]...
I have create a table called Employee and tried to create a link from DataGrid (in ASP .NET ) control to the datasource. I have created and added the connections tring as all using the wizard. When I need to check generate insert, update, delete statements and pessimistic concurrency the check boxes displayed "disabled".
View 1 RepliesWhen I update a record at table [Product] with the integer that stands for [Supplier Name] from joined table [Suppliers], this does not appear in my datagridview. Instead, I have to reload the table to dataset to make it visible. What about datarelation? Is it better that loading a joined table over the dataset? Note that I have never dealed with datarelations before.. How can I make a datagrid column to show "Supplier Name" instead of recordID that represents this supplier?
View 2 RepliesI am filtering a dataview which is used for a datagrids datasource.At runtime when I apply the filters (using Checkboxes to determine the RowFilter text) I get an additional blank row at the top of my grid. This is then treated like a row & is filtered out with other rows that don't fit the filter criteria but comes back when I remove the filter. Basically, its part of the underlying DAtaview it seems. It's not persisited to database but I can't seem to get rid of it when I'm filtering.
View 7 RepliesIs there a way to check whether a datagrid is assigned a datsource. How can I distinguish a unassigned datagrid from a datagrid that is assigned a datasource.
View 2 RepliesIt's my first time playing with the DataGridView properly and I've hit a little snag...I need to display data in a DataGridView for ease of viewing, and I have a list of all the data. It's a list (of a structure), and I've got no idea how to do this. I can set the datasource as the list, but that doesn't work. I've read up on the topic but don't really understand. Am I forced to use classes not structures in this instance?
View 1 RepliesI am adding records to a database from a modal popup. After hiding the modal popup, the page has not been refreshed (even though I have Re-bound the controls). I have reviewed a few postings on the web about this but the solution still evades me. I have attached my code after removing some of the extra detail.
It seems I need to cause a postback, but I don't know what needs to be changed. Some posts have talked about the extender being misplaced.<asp:Content ID="Content1" ContentPlaceHolderID="Head" Runat="Server">
<div class="divBorder">
<asp:DataGrid id="dgrSessionFolders" runat="server" BorderWidth="2px"
BorderStyle="Solid" BorderColor="#C0C0FF"
[Code]...
I started coding my first "real" stand-alone desktop application in VB 2008 Express. I was led into believing that using SQL Express Compact Edition was the thing to use for my database since it would reside on each PC (laptops) that I installed the program on. I created all my tables and about 6 forms and all was going well until I came to the point where I need to display a grid showing data from multiple tables using what i think is supposed to be a view. Now the problem is that CE doesnt allow views. Here are my questions:
1. Can I convert my CE database file into an SQL Server Express file?
2. Do I have to re-write all my forms that are using the database? I am planning on creating my SQL Server Express database with the same table names and the same field names, data types, etc.
I am not that good with sql/visual basic but I have a sql database hooked up to visual basic and I would like to know how to make a picture box change pictures.
For example:
in sql : picture= 0 in VB: if number = 0 then display.nopicture
in sql: Picture = 1 in vb: if number = 1 then display.Picture01
This is for avatar use in my program.
I have a connection string in my app.config:
Code:
connectionString="data source=.sql2008 ;Database=Database1; Integrated Security=FALSE; Persist Security Info=True;" />
How do I change to another database (one of many) without using multiple strings? Can I change while the connection is open?
Code:
Dim myConn As New SqlConnection(System.Configuration.ConfigurationManager.AppSettings("ConnectionString"))
In my app (written in VS 2003) I use OleDbDataAdapter's to load data. I have some functions that enable be to change the OleDbDataAdapter.SelectCommand.CommandText at run time, by adding a "WHERE" or "HAVING" section to the SQL command, or updating the "WHERE " or "HAVING" section. This way I have have generic load data functions. (load all invoices for Customer 123, load all invoices for the year 2009, or load all invoices for Customer 123 for the year 2009).
With the new VS 2008 TableAdapter, the TableAdaper.CommandCollection property is Protected. How can I edit the TableAdaper.CommandCollection(0).CommandText at run time?
I have a report viewer that i would like to display different data in depending on the report button that the user clicks. The data is stored in access databases. I am able to retreive the data and display the initial report but i have not been able to change the report/data that is being displayed.
View 1 Replies