GridControl Doesn't Display The Data It Contains?
May 27, 2010
I am using DevExpress GridControl to display information from my database through a stored procedure (ie. SELECT * FROM aTable). Unfortunately when I run the program it doesn't display any of the information, columns, etc. It displays an empty table. I know that there is information contained by the GridView though as I have print statements that return the row count. Specifically:Console.WriteLine(GridView2.RowCount) ' returns the number of rows that should be displayedConsole.WriteLine(myTable.Rows.Count) ' returns the number of rows that should be displayedWhat should I do so that the actual data within the table (DataTable) and the DataView is displayed to the user. I know the row count is correct as when I add/remove a record the row count correlates by incrementing/decrementing.
View 1 Replies
ADVERTISEMENT
Oct 13, 2011
I am currently programming within Visual Studio 2010 using VB.Net and DevExpress V10.2 Winforms. I currently have a DevExpress GridControl that contains two DevExpress GridViews.So there is the main view and the subgrid (similar to the DevExpress demo for Master-Detail Grids - example with WinForms and better view with ASPxGridView). Currently the data for the grid is fetched into a DataSet:
If myDataSet.Tables.Count > 0 Then
myDataSet.Relations.Add("Details", myDataSet.Tables(0).Columns("id"), myDataSet.Tables(1).Columns("id"))
[code].....
View 2 Replies
Nov 23, 2009
I have a VB 2008 application with multiple DataPicker fields. The data is binded to SQL database. On the form load I set the checkBox for each date to false if there is no date in the field. Noticed that if I make changes to some dates for record 1 in the table, save it and scroll to the next record - I see the date that I just changed for record 1 - also on records 2 and 3. Why is it happening? I don't have that problem if I use text fields to display the dates. I had encountered the same problem with different project and just switched to text boxes. With this new project?
View 15 Replies
Sep 22, 2010
I have a SQL stored procedure that I bind to a Silverlight Datagrid. That works ok, the problem is when I use the same stored procedure to bind a different dataset to the same grid, it doesn't display the new data, only empty columns from the last dataset that was bound. What is going on here? I tried to set the grid = Nothing and I tried using Datagrid1.columns.clear() but that didn't work.
View 3 Replies
Jun 29, 2011
I just inserted data into my sql database. Actually, I want to retrieve it automaticallyinto
View 1 Replies
Apr 23, 2009
I need to quickly demonstrate a project and decided to create a user control that is connected to an Access database through pure simple data connections (create the dataset and drag it on the control.)When I build the project and add the usercontrol to panel control on the main form, no data is shown in the datagrid.When I add the data components directly on the main form, the data is displayed properly. why I can't get my databound user control to display the data on my main form?
View 2 Replies
Jun 1, 2011
In trying to test some graphic features, I am trying to get them to display on load so button doesn't have to be pressed. I used the following code as suggested from forum. Message boxes run but ellipses aren't displayed until button is clicked which is what I am trying to avoid!
Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Button1.PerformClick()
Button1_Click(Nothing, Nothing)
[code]....
View 5 Replies
Nov 2, 2010
I want to be able to create the checkbox control object in a gridcontrol and place it in every cell in a column because it has the functionality
I need with optional text built into the control. Does anyone know how to do this using vb.net, not C#.
View 5 Replies
Oct 5, 2011
I am currently programming in Visual Studio 2010 within VB.NET and am using DevExpress v10.2, specifically WinForms. In the DevExpress GridControl at runtime you can click on the right side of the column header and choose which values in the column you want to show. For example if your table contained:
Name1 Checked
Name2 Unchecked
Name3 Unchecked
Name4 Checked
Then if you click on the right side of the checkbox's header you can choose checked (or unchecked) and it would display only the data that is checked (or unchecked). In this case with checked you would have:
Name1 Checked
Name4 Checked
I was wondering if there was some way to override the names so instead of letting me choose checked or unchecked I could override it with 'owned' and 'rented' or 'active' and 'inactive' based on what the checkbox represents in that specific column.
View 1 Replies
Jul 21, 2011
I am using VB.net within Visual Studio 2008. I currently have GridControl where one of the columns fetches a real number from the database. Whenever I try to remove the value I get a red 'X' saying that the input string is not the right format even though I know it can display null because the row underneath fetched a null value for that column.
View 1 Replies
Oct 1, 2010
I am using VB2008 on Win XP SP3 and an relatively new using this language. I would like orientation or advice on how to proceed given the following:I execute an SQL statement, such as select * from MyTable where FieldX='aaa'An exception happens. Now I need to attempt to determine what went wrong:1. Cable was cut2. Syntax error in SQL3. PC where SQL Server is running crashed4. Timed outI need to attempt to recover from this issue. I have basically 2 options: It is a glitch that self corrects after a period of time, so I can just go ahead and retry the operation a few times. Option 2: It is something permanent, so no matter how many times I retry, the error will persist.
View 3 Replies
May 5, 2011
Using DevExpress 10.2 within Visual Studio 2008 with VB.Net I have created a single gridcontrol that contains two different gridviews. The gridviews are related using an id column. Basically if there are related details about a row in the first gridview then the user can click on the plus sign to see all the related details. When I have any row on the first gridview I am able to get the focused row. Yet when I have the focus on any of the rows in the second gridview I am unable to get the focused row or the content of the row.
[Code]...
Is there any way to get the value in id from the focused inner gridview? Or at least figure out the parent row and grab the id value from there?
View 1 Replies
Jan 25, 2012
I found out how to keep track of the currently expanded grouped rows by using 2 events:
- gridview.GroupRowExpanded
- gridview.GroupRowCollapsed
Where I increase or decrement an integer that keeps track of how many group rows are currently expanded. I am now tackling the problem of what to do if the user expands or collapses all of the group rows. I currently know when this is done by checking the e.RowHandle. Any way to find the total number of groups rows currently in the GridView (something like rowcount for normal rows) so I know how many to set the tracking integer to.
For Example: If my current count is 2 and the total number of groups are 15 then when the Expand All is fired the current count is set to 15 rather than 3.
View 1 Replies
Jan 6, 2012
I am currently using DevExpress 10.2 within Visual Studio 2010. I am printing the contents of the GridControl (with both one and two GridViews contained within). This shows all the current visible columns (and not the invisible columns) and all the data in a viewable manner.
My issue is the print preview always shows all the grouped rows and the master-detail rows fully expanded. I want to make it so that if the user has none of the groups or rows expanded then the print preview displays the grid with none of the groups or rows expanded. Also if the user expands the first group and rows fully then only the first group and rows will be expanded in the print preview and none other.
[Code]....
View 1 Replies
Aug 1, 2011
I am writing a VB.Net program. In my Main form, I ask the user if he has an old file that he wants me to convert first. If he says "yes", I start converting the file, loading the records into an Access database. I want to update a line on the form, showing my progress. But the form doesn't display until AFTER the entire file is converted (and loaded into the database). That means the user has to look at a form for 2-3 minutes without knowing if the program is actually processing, or is hanging up (looping).
I don't understand what is going on, and so I don't know what to do about it. I'm sure SOMEONE with experience has come across this situation before.
View 3 Replies
Apr 25, 2010
How can I check for my combo box to have a selected item? I want to display a message box if the user doesn't select anything from my combo box.
View 3 Replies
Nov 29, 2011
I have below code in my Form Load event handler but the ListView doesn't show any column headers. I want the column headers to be displayed.
[code]...
View 1 Replies
Jul 9, 2010
I am building a form that will load individual items(from individual files) or a catalog of items(from a list of items). I then click the item I want to use to select it. Everything works correctly, when I click an item it selects the correct stitch. The only problem is, it doesn't display correctly when I load from a catalog. I can open individual items and it works fine. When I load a catalog it doesn't display the images correctly.
[Code]...
View 1 Replies
Feb 28, 2012
Cannot get list box to display each increment and cannot get data to save correctly in order to display.
Public Class Projectile_Motion
Dim initialHeight As Double ' Holds beginning height
Dim initialVelocity As Double ' holds velocity
[code]....
View 14 Replies
Oct 29, 2009
QuoteI would like to display my password from database (MS Access)into datagrid but in invisible. Below is my coding retrieve data from database, but my password is visible,
con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = " & connectionpath
con.Open()
[Code].....
View 7 Replies
May 28, 2010
I have just received an interesting feedback from a VB.NET customer using our product - for some reason intellisense hidden a certain enumeration value.After a small testing I have found that this is likely a bug in IntelliSense: [URL]..To be honest, I did not expect this problem with such a basic stuff like this. Have you seen this in the past? For me, it doesn't work in all VS versions...
Anyway, feel free to track this issue if you are coding in VB.NET.
View 1 Replies
Feb 24, 2010
I'm trying to put data in my listview but the data doesn't show in my listview.
When i put this code in my form i dont have any problem but when i put this inside the module the data doesn't show up.
Code:
Public Sub getEmployee(ByVal myConnString As String)
Dim mySelectQuery As String = "SELECT names FROM employee ORDER BY ID ASC"
Dim myConnection As New MySqlConnection(myConnString)
[Code].....
View 2 Replies
Jun 22, 2010
So, I am trying to post a few fields to a form, submit it, and trap the response. Seems simple enough, but what I get back is the source for the page and not the response.[code]...
View 1 Replies
Jul 18, 2012
why my crystal report dosesnt show any of my data.
View 2 Replies
Jul 14, 2009
in my form..there's a couple of textboxes..these textboxes display data from the database using databinding method..
when i click on my delete button to delete the data displayed in those textboxes...the data will be gone from the textboxes...but when i check my database..the data is still there....what happen??..how do i delete the data from the textboxes..AS WELL AS from the database?
here's my delete button code
Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click
Dim intresult As Integer
[Code].....
View 12 Replies
Aug 15, 2011
I have insert data to MS.Access and re-load data to DataGridView, it's always do at LoadAllData() but some time datagridview is not refresh.
[Code]...
View 3 Replies
May 17, 2011
I'm using an OleDbDataReader to loop through my imported excel file and it gets everything in the file except for the first row. How can I specify that I want to see this header row?
[Code]....
View 1 Replies
Aug 25, 2009
I wrote an application that connect to a SQL Server Db and fill some tables in dataset and calculate some functions based on record's items. But I can't run this application on other pc correctly. some tables fills in dataset and I can retrieve the data, but some tables not fill.
View 3 Replies
Dec 8, 2008
I'm working on a timekeeping application in Visual Basic 2008 and am having trouble formatting a timespan for display. Here's how I want to the information:If a positive number my Label will be: lblTimespan.txt will show as "12 Hours And 15 Minutes" This works fine.If its a negative number I want to display it as "(12 Hours And 15 Minutes)'[ in red. The problem is that I can't get rid of the minus sign. [code] Thr Replace doesn't seem to want to replace the "-", can anyone suggest what to do?
View 2 Replies
Mar 4, 2010
I don't understand what's going on here I published my project, and when I create new records and save them, everything gets saved and shows up each time I run the program.I open the database in SQL Server and none of the tables have the new data, but it still shows up when I run the program each time.
View 15 Replies