I have a List<string> that contains paths, such as:
[Code]...
Given a given root, such as Root, I would like to "query" this list to return only the first level values, such as:
[Code]...
GOAL: Bind nested ListViews to LINQ generated iQueryable of anonymous type. I want to use LINQ because you can use GroupBy and bind the nested ListView to the 'it' keyword.
SETUP: I have groups of sets of conditions. Each set of conditions is stored in the BillingCodes table. Each group of BillingCodes is stored in the BillingGroups table.
I have a custom object that stores the ID, Name, and NumCodes for each BillingGroup that the user has chosen.I have a collection of these objects called GroupsList that has a list of the groups that the user has chosen.
Problem 1: I can iterate through GroupsList and grab all the IDs. How do I translate the SQL 'WHERE ID IN(a string of comma delineated IDs)' for LINQ to SQL? Is that the best way to do that?
Problem 2: Once I have the list of BillingGroups I need to iterate through each group. For each group, I need to iterate through the BillingCodes. For each BillingCode I need to generate a WHERE clause that has all of the conditions in the BillingCode. I propose something like so:
for each BillingGroup in BillingGroups
for each BillingCode in BillingGroup.BillingCodes
where1 = "..."
next
next
Problem 3: Here's the part where I don't have a clue. I need to dynamically create a query in LINQ to SQL. Keep in mind that I don't know how many groups there'll be or how many codes are in each group.
There are 2 tables:
**transactions**
transaction_id
patient_id
[code]....
I have the following code:
[code]...
The intention is to convert an IList of custom objects to a string equivalent comprising each element in the Ilist. Unfortunately I can't seem to find a way to get the underlying data of the custom object, and of course as in the above example, using object simply gives me a string of types definitions, rather than access to the underlying data.
I recently downloaded VB 2010 Express so i am quite new to the language, but i have worked with dark basic, which seems to b very similar.Anyway, my problem is that i cannot seem to correctly set out my array of a custom type/class. i am trying to create two arrays, one of available entities and another of selected entities of which the user selects the entities to be dealt with in irrelevant ways. i have creates a button (called test) which adds some entities to the available list and all the entities come back the same value but they shouldnt be as you'll c in the code. i have run the step into command a found that "available.item(#).Name = " will change all of the entity's names.As of current i am working with lists as the array kept asking for a 'new' statement but i couldnt figure out where to put it.[code]
View 7 RepliesI have made a custom structure which I have in a list.Dim AllUsers As New List(of mUsers)Structure mUsers Dim mName As String Dim mMadeDate As Date Dim mActivated As BooleanEnd Structure I have populated the list, but now I would like to be able to search it, and to check if something exists inside of it. For example, I would like to check if.If AllUsers.mName.Contains("John Doe") = True Then MsgBox "User John Doe Exists!"
I know if this was simply a List (of String) then .Contains("John Doe") would work. But I cannot figure out how to have it look through the contents of that custom type in the list(of.
Is it wrong? Please suggest me correct way.
Public Function ReadXML() As List(Of String)
Dim list As New List(Of String)
Dim xmlDoc As XDocument = XDocument.Load("C:\MappingFile.xml")
[code].....
I am using a path comparison to find any children tags which works well when there is only 1 tag selected. This is my code for when multiples tags are selected but it is not working. Can you point me in the right direction?
Single Tag Selection (working)
Dim tagpath = uxTags.SelectedItem.Text
lnqCases = From i In lnqCases Where i.HelpDeskTagItems.Any(Function(x)
[code]...
I would like to create a little list in my Windows Form showing a list of custom colors with their 'friendly names'. Technically it can be anything (ListBox, ListView, Panel etc... whatever).
I simply want it to look something like this:
I would like to store data for this list in a simple TXT file in such form:
Quote:
Blue,Blue
Red,Red
#F6A118,My favourite color
#004080,Another color
And of course I would like each element on such list to be clickable, so if I'd click 'My favourite color' it should return the color's HEX value (#F6A118).
I have been using adodb as my database connection to mysql from vb.net, now I want to know if i can create a query string with 2 separate query like so:
vb
dim querystring as string
querystring="update table1 set columname = 'value' where columnname='value';update table2 set columname1 = 'value1' where columnname2='value1'"
Then I can include that to my recorset:
vb
dim rs as adodb.recordset
rs = new adodb.recordset
rs.open(querystring,con, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic)
I am creating a custom checkbox control to add a div after each checkbox in a checkboxlist.The class is below.
Imports System.Web.UI.WebControls
Imports System.ComponentModel
Imports System.Globalization
[Code]...
I want the Function to accept List(Of String), Array & String and similarly return List(Of String), Array & String respectively. The Function simply adds a string (month) to the input collection. I just want to use it for string, array and list with needing to think of conversions.
[Code]...
I'm writing a custom control and I want to add a "MessageText" property of type String:
<Browsable(True),
DefaultValue(""),
Category("CustomControls"),
[code]....
The MessageText property is a multiline text, and the user must be able to set the text using the designer. The problem is that the designer doesn't allow to enter a newline directly for a string property.I want the same behaviour as the system TextBox's Text property, where you can click on the down arrow and write lines in the small text-editor that appears:How do I do that?
it seems always at this time I cant figure out how to do something maybe it has something to do with lunchtime.
Im having trouble using a method that is defined by an outside company
This is a link to their integration guide:
[URL]
This is their documentation for the class Im trying to use
OrderQueryWebService Class
This class is for SID in particular and is made for use with the notification methods. This is for the Order Query Web Service specifically, allowing clients to return the status of transactions for their merchant, whenever they want to.
Methods
/ <summary>
/ Pass through the variables required and receive a list of Transaction
objects showing transaction status
[Code].....
The MerchantCode, the MerchantUsername, the MerchantPassword are all good the List is a custom type called SetComHash.Transaction
Everytime I try adding a string to the list such as the transactionNumber and some other values it gives me a type error:
"Value of type string cannot be converted to 'SetcomHash.Transaction'
I have a List in Do-Loop. That List is collecting some information with programmatically. So, How can I know and end the loop if List repeated in loop.
Code like this:
Dim X As New List(Of String)
Do
------
Loop While X IsNot Nothing
My code can't quit from loop and it repeats the list from first string. I want to know how can I determine the last value of list to change script like this:
Loop While X.Count = 10
For Each s As String In list
If s.Contains("Hello") Then
list.Remove(s) 'ERROR Collection was modified; enumeration operation may not execute.
End If
Next
Why do i get that error?
Does anyone know how to do this? I'm stuck on a boat right now out to sea(Navy) and don't have access to vb.NET, its in my berthing...
So someone clarify this code and see if it works?
Dim index As Integer = list.FindIndex(Function(value As String)
Return value(0) = "STRING HERE"
End Function)
I am trying to make an application which will list all processes in a string when it starts. After it has listed them all I enable my timer, and in the timer there gets checked if the process is in the process list (string), and if it isn't it will add it to my listbox. The only problem is, it's not working, it's never adding an item.
vb.net
Public Class Form1 Dim AllProcesses As String Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'The first check For Each p In System.Diagnostics.Process.GetProcesses() If AllProcesses = "" Then AllProcesses = p.ProcessName Else AllProcesses += "|" + p.ProcessName End
[code]....
Is this function as efficient as I can make it or can it be done more efficiently? It takes a line of text and turns it into an array of values.If the value delimiter exists inside a string delimiter, that value delimiter is incorporatedinto that value. String delimiters are removed from the values, and so is any leading or trailing white space:
Public Function ParseStringDelimiters(ByVal Line As String,
ByVal ValDelimiter As Char, _
ByVal StrDelimiter As Char) As Array
[code].....
I got an object of List<List<string>>I need to bring this into a ist<string>I have no idea how to do this with LINQ.
View 1 RepliesWhat I've done is create a User Control Library (Project) and I've added a single User Control to that project. The control contains a single FlowLayoutPanel, and I created a Property on the control itself to pass the FlowDirection from the Control to its FlowLayoutPanel child.
Build, reference, component appears in the Toolbox and everything works fine, but the property on the control does not appear in the Properties window when I go to edit it at design time.
I'm working in a database on vb.net with sqlite wich hosts a gallery and I want expand the search proprieties.[code]...
I want to filter the results also for image ext (table = images.ext) or one or more parameter...for example:
If the user search "cars ext:jpg width>500" the the database returns all images wich has the tag "cars", has the extension jpg and are bigger than 500 px width
I am using VS/VB 08 together with access 07 for my project. I am trying to fill my datagridview using a custom SQL query where the "where" criteria is altered to accept the column name from the selection of the user. When a user clicks on a column in the datagrid I want that column to be represented in the query. This is what I have but is not working. Is this possible by the way?
[Code]...
[code] i use this line to fill the datagrid Me.tableTableAdapter.Fill(Me.DDataSet.table)how can i fill the datagrid with a custom query?
View 4 RepliesIf you have custom type, and you wish to assign a List(of T) to that custom type[code]...
View 1 RepliesI need two seperate lists, which every item is Integer, String, Bitmap - and one which every item is Integer, String String. However I don't know how to do this, or even where to look - I've googled for custom objects and custom object lists. What I'm trying to do is this.Custom Object1 is Integer, String, Bitmap Custom Object2 is Integer, String, String
In one thread I'll be adding items to List1(Of Object1), and processing them, and adding the results to List2(Of Object2), however I need to be able from other threads to look at the list and say only give me the items where Integer = (my thread ID), is this possible? Any help, or even links to information that would be relevant to this request would be helpful?
Im using the folowing function to return a SelectList. I need a custom format on Descr, but replacing Key.ToString() to Key.ToString("DD/MM/YY") render me the error "Method 'System.String ToString(System.String)' has no supported translation to SQL.". How could i use a custom date format on Descr?
Public Function ReturnDates(ByVal Param_Pesq_Cod As Integer) As SelectList
Dim Qry = From E In DB.Execs _
Where E.Pesq_Cod = Param_Pesq_Cod _
[code]....
I want to develop select query builder in my vb.net application. If user write the "select query" in a richtext box that query will be executed and the result will be displayed in a grid view. Any one send the Sample Application for this
View 1 RepliesVB.Net 2005 SQL server 2005
I have a project I have a dataset that contains tables In the dataset designer, each table has a defaiult FILL command set. I have draged and droped my table as a grid onto my form VB automatically sets up the table adapter, and binding source to make it all work.
in my code, is placed in the form load routine, a tableadapter.fill(dataset.datatable)
Here is my dilemma. The data in my table may have 100's of thousands or rows.
I have presented the user with a front end that allows for filterring and selecting based on several columns. reguardless of how many rows the result set contains, there will always be the same columns in the dataset.
Because there are so many combinations of select query, i do not want to make 20 or 30 custom fillby's in the dataset. I want to make an addhoc select query and have the binding source and table adapters work as expected. I have created a query called "FillByCustom" in the dataset designer attached to the DataTable Adapter section.
My question is this.
If i build a select query that returns the desired rows, how do i place it into the adapter in place of the FILLBYCUSTOM select command, such that it all works as expected?
i'm currently making an app that needs to run a query between two dates. this app will run automatically, so i need to put the dates as today and yesterday, essentially.
[Code]...
Private Sub txtname_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtname.TextChanged
myConnection.Open()
[CODE]...
I want to four digit code like Abneesh than first query finding max of A and second string take string A than code generate like A001----------A999