Override The DevExpress Filter Choices In GridControl?
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:
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.
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.
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.
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.
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"))
I have 2 comboboxes, textbox and a cmdbutton. When the user makes a selection in one combobox I want it to filter the choices in the second combobox. Then when the user clicks the button it passes the values from the comboboxes to a stored procedure and populates a datagridview. I am using VB.net 2005 and sql server 2005.
wondering if someone can help me some small issues I am having with building my first project.
1.I have comboboxes that allow users to enter their own choices in and then their choices are displayed into the gridview.
the problem I am having is this is allowing me to duplicate choices. for example:when I run debug to try my boxes, I can type in Johnathan into the combobox as many times as I want to and it adds is to the combobox list..so now I got 10 johnathans in my combo box.and then to make things worse, when I hit the button I made to send choices to display..it causes duplicated choices to show up in the display.What I figure is that it is easier for me to just prevent duplicates in combobox.
2.Lets say on one of 10 comboboxes I got...lets say someone skips the box and doesnt make a choice...my grid will then display the last choice made.. (man o man)for example:John chose in his boxes and is displayed on gridview: Combobox1 (john) Combo2 (5:00 PM) combo3 (waiting)now lets say I come up to the computer and in Combobox1(Dcurvez) Combo2( i skipped and didnt enter a choice) and Combobox3(In Progess)
The display will put Dcurvez....5:00 PM.....In Progress because I didnt make a choice in the time combobox..it put in the last choice (Johns) as 5:00 PM Can someone in very simple terms tell me how to fix this problem?? I am using visual studio 2008 and vb/vb.net as language this is not a webpage, btw. it is for in shop computer just.
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.
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?
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.
I'm new to visual basic and I've put all forths of effort towards this program and I can't get it to work. I know one reason is I don't know how to add my choices to the first two list boxes.
Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim RegistrationFee As Integer Dim LodgingFee As Integer Dim Days As Integer
I have visual basic 2008 express. i am learning through videos at LearnVisualStudio.Net and the next step is to add item which is the sql database. i don't have this as one of my choices? am i suppose to have it with express? if not, can i get it somehow and add it to my Add Item list as one of my choices? I have the local and the server database but the video i'm following has an SQL database. Again i am just learning so be easy on me.
I have two combo boxes, and four buttons. When the user clicks "Add" on the first combo box, it adds a new item to the combo box with "New" and then lets the user rename that item to something else. That "new" item has to have an array of "answers" that go along with that item in the list. What I'm having trouble figuring out is assigning "answers" to the second combobox for each item in the first combobox and changing the second combobox when selecting an item in the first combobox.
We are looking to port our existing classic ASP application to .NET, but we're unsure of what language to use for the new app. I personally would 'prefer' C#, as I'm more familiar and comfortable with that languages way of doing things, but, the original code is VBScript, so it would possibly be easier to port to VB.NET ... One possible situation I fear would be that, because the code is so similar between the two variants of VB, that we might end up getting stuck on something that is not similar between the two, even though it looks like it would work. A shift to a wholly different language might avoid that kind of situation. Does anyone have any practical examples of this kind of situation? Insights to illuminate the issue with? Do the potential benefits of a complete paradigm shift outweigh the gains from a high degree of 'copy-and-paste-ability' ?
i'm trying to display a random messagebox that displays a message associated with a character. the character image displays and the user clicks a button to guess the character if it is correct, one of three messages should randomly appear that is associated with that character (there are 4 characters, so there are 12 possible messages total. 3 for each character) but as it stands now, the picture box on the form displays the character name so the user doesn't have to guess which button to push. i need to remove the name from beneath the picture so only the buttons have the name and the user is forced to guess and i don't have the messages randomly popping up. only a messabebox that says correct i added a message box in the code but i can't figure out how to randomly get the messages associated with the characters to appear?
Imports System.IO Public Class Form1 Dim currImageIndex As Integer = 0 Dim characterNames As String() = New String() {"Donny", "Jesus", "Lebowski", "Walter"}
I'm building a game using the traditional form view on VS2010 and I'm trying to change the colour of a label's text depending on its contents. I believe I've coded that fine, but the problem is that the settings for the label in the designer view pane are overriding my code!Is there a way to disable certain options in the designer view so that my code can work?
I've been trying to write a vb program to help me login to a website! I've managed it with HtmlCollection, but the problem is that on the next page there are a few choices that need checking and it goes kind of crazy. Is there any way to login to the website, fill the choices and then navigate further?
how to save the users radio buttons choices to load into a file. I have a button which controls the If statements to determine the price of the configuration. I was wanting to save these choices that the user made. I thought I could do this by altering the If statements but I don't know if thats the right way. I've got 3 different groupboxes with 3 options in each.
Heres a part of the code for the IF statements:
Private Sub UpdateConfig_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles UpdateConfig.Click If Choice1Option1.Checked = True And Choice2Option1.Checked = True And Choice3Option1.Checked = True Then PriceShow.Text = Prices(0, 1) TextBoxProcessor.Text = Choice1Option1.Text
What is the simplest and most straightforward way to: Create a local dB with a table with 2 fields (a string, a number) Determine is string s is present in the dB Add a record into the table consisting of a string and number Delete a record based on the string Get the record for a particular string Get the record with the highest number
I have a project that has several combo boxes on one form. The selection in a box can affect the possible choices in subsequent boxes. Right now I am using SelectedValueChange to fire the code that loads the choices in the later boxes. There are a number of possible events that I could use:SelectedIndexChangedLeaveLostFocusTextChangedI was wondering if someone could give me a rough idea what the differences are between these. Is there a 'best' evnet to use?Also, I find that most events work when the choice is made with a mouse click but if you click in the box and type in a value an event does not fire. How can I program for the case where the user enters a value by typing it in instead of choosing from the drop down list?
In the following code, a local printer dialog box shows and its choices are implemented in the printout, but if the user goes to a 2nd-level printer dialog box such as by clicking an Advanced or Properties button, choices made therein (such as landscape/portrait or scaling) are not implemented in the printout (prfPrintForm is a PowerPacks.Printing.PrintForm on form frmPlotTrends). Is there something else that must be done to make the 2nd-level dialogs work?
Dim dlrResult As DialogResult = frmPlotTrends.dlgPrintDialog.ShowDialog()If (dlrResult = DialogResult.OK) Then frmPlotTrends.prfPrintForm.PrinterSettings.PrinterName = frmPlotTrends.dlgPrintDialog.PrinterSettings.PrinterName frmPlotTrends.prfPrintForm.PrinterSettings.Copies = frmPlotTrends.dlgPrintDialog.PrinterSettings.Copies frmPlotTrends.prfPrintForm.Print(frmPlotTrends.prfPrintForm.Form, Printing.PrintForm.PrintOption.ClientAreaOnly)End If
I am trying to filter the results of a datagridviw using the bindingsource.filter method.
Dim filters(2) As String ... If Me.txtPartIDFilter.Text = "" Then
[code]....
The issue is in the last line. ID_Part is an Int64 data type filters(0) is a string so the system returns a "Can't perform 'Like' operation on System.Int64 and System.String" error message.As you can see I tried converting the data type, but that failed since it is encased in String.Format()- it's going to be a string no matter what, I suppose.It's almost 1:00 a.m. so I'm not firing on all cylinders.
I am attempting to output data from a list box with the possibility of multiple choices selected(frmPrint) and output the data froma another list box frmMain. The code posted does nothing. I can get this form to output everuthing but multiple items selected by the user. I am a student and I have been working on this problem for a long time with no luck.
Private Sub btnAddBooks_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAddBooks.Click Dim intCount As Integer = 0 ' Counter Dim mainForm As New frmMain ' Form instance Dim strInput As String ' Input
i want to filter date and also time (shortime) for example if Datum.hour="8:15" andalso Datum.day of week "Saturday"or "Monday" now i can only filter date ... this is my filterline objbindingsource.Filter = "Datum > = '" & Dtp1.Value.Date & "'"
