I am doing a projectin VB 2008..I ave list of data being displayed in listview and it gets stored in DB..The problem is,i am unable to filter particular data based on some constraints like date,client etc.. How can i filter data based on various constraints..As i am new to VB,
View 5 RepliesI'm trying to write a class that will be in charge of persisting application options. Since the options need to be persisted the values that I'm sent must be serialisable.
Initially I thought I've be able to write a method with a signature like this[code]...
I am looking to find the best way to do the following: Filter data based on the drop down filters, as long as I am within the same product category (e.g. toys, puzzles, etc...), but in different web forms (product grid and product detail).So if I select toys under $25, I need the filter to the toys in a grid format, but if I click to view the detail I need the filter information so I can filter the related items display.Display certain filters depending on the product category.Right now I believe that if I build a user control and session variables that I should be able to accomplish this.
EDIT: Right now I am using the page_load event to update the data and would like to avoid AJAX for right now.
I have a datagridview1 which i want to filter on text in textbox.
I want gridview to display all rows which contains textbox.text.
in short I just want to have constantly running in the background something to display in LB8 the the contents of LB 2 that contain what is typed in TB1
1Private Sub Name_Change_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
2Dim filtertext As Integer
3filtertext = ListBox2.FindString(TextBox1.Text)
4ListBox8.Items.Add(filtertext)
5End Sub
my question is how to filter other comboboxes based in first combobox whish is having same data as all.i am using visual basic 2010 and a ms access database which is connected with code.a vb form have five comboboxes and all comboboxes are field with same data with this code:
Private Sub loadsubject()
Dim OleDBC As New OleDbCommand
Dim OleDBDR As OleDbDataReader
[code].....
There were three similar questions in StackOverFlow but none gave an answer.. If have found why this error in occurring but don't know the fix. I am using Strongly Typed Dataset for my project which is created as a dll for DAL. I have added the Sql Server Table into this dataset using the designer and has created a DataAdapter
[Code]...
I am creating a project in VB.NET in which one of the reports require that the name of employees should be displayed as column names and whatever work they have done for a stated period should appear in rows below that particular column.Now as it is clear, the columns will have to be added at runtime. Am using an ODBC Data source to populate the grid. Also since a loop will have to be done to find out the work done by employees individually, so the number of rows under one column might be less or more than the rows in the next column.Is there a way to create an empty data table and then update its contents based on columns and not add data based on addition of new rows.
View 1 RepliesI am trying to filter a ListBox based on the presence of a string. Basically, if there is a ListItem that doesn't contain the string then I want to remove all ListItems that do contain the string. Here is what I have tried:
Dim Item As ListItem
For Each Item In CtheList.Items
If Item.Text.IndexOf("W:") = -1 Then
[Code].....
I've got a datacontext and created a binding source using LINQ to sql but cannot filter said bindingsource. The supportsfilter of the bindingsource is set to false ? why ? I can't find any info to say that I cannot filter a binding source based on a linq query.[code]
View 3 RepliesI have a Query to Display values in grid view, now i wanted impose certain condition in query to filter the values.I have FABDue(date column) and FABComp(date column)columns in a table.I need to check following two conditions in query
1.Records which does not contain FABdue date in FABDue column, then those records should not be listed in Grid view.
2.Rcords which are having FabComp(column) date then those records should not be listed in grid view
[Code]...
I have a datagridview that's taking a while to load because my table contains almost 5000 records. How can I provide an easy way for clients to filter the grid based on a product name. I was thinking of having labels with each alphabet on my form and when they click a label it filters the bindingsource according to the chosen alphabet. this seems like an awkward solution though.
View 2 RepliesI am Working VB.NET 08 Windows Appl.I Have Combobox and DataGridView in the Form.In the Combobx Having Names list Called "SurName".In The DataGridView on of the Column is "SurName".So when change the data on the Combobx list the dataGridView is Filtering and displaying the values correctly.For this i wrote a code in Select IndexChanged or SelectionCommitedChange Event.
But now my task is when i Type the text in the Combobox the related data should be filter in the DataGridView.If i type any letter in the Combbox the datagridview rows starts filter.
For Ex: Names are like 'Mali', 'Malu','Maal','Mouli'.
If i type 'M' letter in the Combobox then 4 rows Filter in the DataGridView.
If i Type 'Ma' then 3 rows ,
If i type 'Mal' then 2 rows,
If i type 'Mali' then 1 row.
I have a database with a table that is a child to many other tables. I am using this child table as a datasource for a datagridview. I am using comboboxes to display specific fields in any parent tables, instead of the user seeing the foreign key. Everything is fine. However, I would like to filter the BindingSource based on text matches between any of the fields in the child table and the corresponding fields of the parent tables.
[Code]...
I think my question is discriptive, or as Microsoft in the Documentation for Data Grid the question is, How do I have a combo box column display a sub set of data based upon the value of a different combo box column?
[Code]...
I am trying to learn the new methods in .net, but, I cant see a way to step through the data like you can in an ado recordset. I want to pull data from a table once, then split the data with a filter, then step through the rows gathering the dtata till eof. Clear the filter and reset it for the next batch.
View 1 RepliesI have a form with 4 comboboxes and a button. The first combobox is enabled, but the rest of the controls are disabled. When the form is opened I fill the first combobox (cbxMethod) with a datatable. When the user selects something in cbxMethod the next combobox (cbxStudy) will be filled and so on. When the last combobox (cbxAnalyte) has a selected value I want to enable the button and give it focus so the user can move forward with the program. I basically want to force the user to move from one combobox to the other, until all are filled.I am currently using the SelectionValueChange event, but this event only fires when the user changes the value with their mouse or hits the Enter key, not when the user hits the Tab key.
Public Class frmCalculatedAnalyte
Private cv_dt As New DataTable
Public Sub New()
[code]....
I have the a function that is declared like so: Public Sub Modify(Of SIMType As {New, DAOBase})(ByVal obj As SIMType)
I also have a class called Products which is declared like so:
Public Class Products Inherits DAOBase
So as you can see, if I were to call this function like so:
Modify(Of Products)(new Products())
This would not be an issue. The issue actually arises when I try to cast the object being past in to its real type. For example: both do not work. I get a Value of type SIMTYPE cannot be converted to IMS.Products error. Im assuming this is because I am using generics. Is there a way to adjust my function to allow for a casting operation like I am trying to do? In the end, what I need is a reference of the actual type (Products in this case) to the object.
Can some one explain what constraints are in this application?
View 11 RepliesConsider the following extension method:
<Extension()> _
Public Function Satisfies(Of T)(ByVal subject As T, ByVal specification As ISpecification(Of T)) As Boolean
Return specification.IsSatisfiedBy(subject)
End Function
This works as expected if subject is the exact class being operated on by the specification. However, if the specification is examining the super-class of T, this extension will not work unless subject is explicitly cast to the super-class. Is there a way I can avoid this? So far, the best I've been able to come up with is:
[Code]...
Since I (apparently) can't get this to work exactly as I'd like in VB.NET due to limitations in the language itself, is my second attempt the safest/most efficient way to do this?
I am starting to play with extension methods and i came across with this problem:In the next scenario i get a: "extension method has a type constraint that can never be satisfied"
Public Interface IKeyedObject(Of TKey As IEquatable(Of TKey))
ReadOnly Property InstanceKey() As TKey
End Interface
[Code]...
I'm trying to use a DataTable to get the schema of a SQL Server DB.But, when try to detect the ForeignKeys, the constraints collection only brings the UNIQUE constraints.
Private Sub ShowConstraints(ByVal tableName As String)
Dim table As DataTable = New DataTable(tableName)
Using connection As SqlConnection = New SqlConnection(GetConnectionString)
[code]....
How can I get the ForeignKey Constraints?
How do I add constraints to image resizing code? I want the image to be no larger then 165x146. The below code does not hold the constraint when image is 525x610.[code]
View 1 RepliesI have a generic function in VB.Net. I also have two classes called A and B. Is it possible to allow the generic constraints on my function to allow the Type to be either class A or B? Class A and B do not share any base classes except for object.
View 1 RepliesI have a table (Projects) which is linked to projectVersions on projectID..projectVersions contains several columns on which I'd like to filter a returned project (and associated projectVersions) list. For example there is a "capacity" column and a "country" column. I am doing a filtered list of projects on one page and I'd like to include all projects where any one of the associated projectVersions has a capacity of 750ml and a country of "France" for example.It may be that a particular parameter is not set and so I pass a zero to indicate not to filter on that.I guess this needs some kind of subquery as when I try and do something like this: [code] it doesn't work as the "xxx" bit, being one-to-many, expects me to specify an item to get at the entities within and yet I want to query where ANY of the associated versions match one of the criteria.
View 1 RepliesI'm working on my first real asp.net web application and I'm kind of stumped on the best place and method to trap and handle database constraint violations. Suppose I have a unique constraint on a column and a user inputs something that would violate that unique constraint. Do I catch it in the business layer by making a call to the database to check of the value exists for that column or do I let it go all the way to the database and let it throw an exception and handle that in my application?
I don't like the latter answer- because it makes sense to handle as much as you can in the business layer before it reaches the database. But it's also somewhat problematic as my application is driven by procedures that implement basic CRUD operations on all tables. So in order for me to enforce uniqueness in the business layer, I need to create a procedure for every possible constraint so I can do a look up before an update or insert. That just seems tedious... and I'm duplicating business rules as they exist in both the database and the business layer, so if something changes, not only do I have to change the database, but I have to change the procedure and the application code.
So is there a right way or a good way to enforce these database constraints in application code or should I be looking at a way to catch exceptions thrown by the database and present them in a user-friendly way?
I keep getting this error message (see image). What's weird is it's coming from a "typed" dataset that is bound to a DataGridView and even though I get this message, the DGV still loads with all the data. I've bound this dataset to the DGV thru the designer. Here is the line of code that is erroring out:
Me.adpItemMaster.Fill(Me.JewelryDBDataSet18.tblItemMaster)
I checked the table and the primaryKey for the tblItemMaster is unique for each row.
When I use the dataAdapter.fill(ds,tableName), it reports an error: "Failed to enable constraints."Yes, I changed the selectcommand.I know if I modified the selectcommand, and if it will take diffrent columns result, this error will be reported.
[Code]...
I want to filter data on the textchange event on listview so I use dataview to filter data. Issue in the below code is, I use dataview inside for each so that it checks only one condition that is last value only it takes, I want to check value in s1 with dataview and remaining value should bind with listview. E.g.: if I type an in textbox it should list all the item values starting with an value like anandha kumar, anna etc. Suppose I keep the value anandha kumar and anna in array s1. I should list all other values expect the array values like antony etc... in listview.
protected void TextBox1_TextChanged(object sender, EventArgs e) {
dvProducts = (DataView)Session["ListViewItems"];
string serachText = EscapeLikeValue(TextBox1.Text);
string lvValues = hdRetailCustomerGroup.Value;
string trim = lvValues.Replace(" ", "");
[Code] .....
I have an arraylist that holds a subset of names found in my database. I need to write a query to get a count of the people in the arraylist for certain sections i.e. There is a field "City" in my database from the people in the arraylist of names I want to know how many of them live in Chicago, how many live in New York etc.
how I might set up an sql statement to handle this. I think somehow I have to pass the subset of names to sql somehow.
Here is a sample how I am writing my sql in my code
Public Shared Function GetCAData(ByVal employeeName As String) As DataTable
Dim strQuery As String = "SELECT EMPLID, EMPLNME, DISP_TYPE, BEGIN_DTE FROM Corr WHERE (EMPLNME = @name)"
[Code]....
I need a way to create a function using your sql statement to return a datatable object of names and the parameters would be city, and the List of names.
The above example isnt the sql I am looking for its just a skeleton of what the function would look like that I want to create.
So then you would use the function by iterating through all the cities passing in the same set of names each time in the fron end.