im using my method as a search method in my program and it goes like this
For Each dr As DataRow In ds.Tables("Employee").Rows
If (dr("LastName") = "GO") Then
dr(MyColumn1) = "Testing1"
[code]....
is there another way to search for a row, i think in my code it would took time because it will pass through all the rows.
I was wondrening if there is any built in functions to search for a sequence in a string
View 1 Repliesis there a way i can get my datatable to have multiple constraints that are attached to a unique id? an example of what i'm talking about is if i have a unique machine but it's on many lines, can i show that somehow in a datatable? the reason i'm asking is that i have code that sorts the data by line number and shows the relevant machines in a combo box based on the line selection out of another combo box. i'm having to input the data into the datatable (as a starting point for the data base) and it's very tedious. i'm entering machines that have the same name in multiple rows because the line number is different. i can't figure out how i can add multliple values into my line number column so that it will sort properly when queried.an example of what i'm asking with regard to the datatable is as follows:
Machine LineNumber
slicer Line 1, Line 2, Line 4
conveyor belt Line 1, Line 6
So that when called to fill the combo box, the correct one is called.The code i'm using to sort right now is as follows:
Private Sub linecbo_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles linecbo.SelectedIndexChanged
Dim cline As String
[code]....
im having a problem with the Select() method in my datatable. If i want to search in my DataTable for multiple patterns (search function) For string Columns the 'Like' works
[Code]....
Currently I have a gridview bound to a datatable which is populated with groups from the AD. I need to be able to add search functionality so users can type in part of a group name and have the results display only groups that fit their search criteria.
Here's what I have so far.
<asp:TextBox ID="searchParam" runat="server"></asp:TextBox><asp:button ID="btnSearch" runat="server" Text="Search" />
<asp:GridView ID="dgSearchDLs" runat="server" AutoGenerateColumns="False" DataKeyNames="cn" DataSourceID="ObjectDataSource1">
<Columns>
[code]....
This is the original code in c#
public class CategoryRepository: RepositoryBase<Category>, ICategoryRepository
{
public CategoryRepository(IDatabaseFactory databaseFactory)
: base(databaseFactory)
[Code]...
Does anyone has an idea what i should change to let it work and let my UserRepository use the methods in RepositoryBase while implementing the IUserRepository?
1. Can someone show me sample codes on how to do that ?
2. I encountered a problem with the INSERT sql statement. I keep receiving syntax error in insert statement exception. Is there anything wrong with the statement ?
[code]...
I am working with a vb program, but there is something strange on one of my .vb code pagewhen i put the "dot" afther the object name its dont show the methods availables for this objectbut on other vb code pages i can see it. but in this one no.for exmaplethis is a piece of code: Dim sb As New StringBuilder()
View 3 RepliesI am not sure how clear my question is by the title, but I am trying to make Class methods instead of Instance methods in Visual Basic that way I don't have to waste memory and code creating temporary objects to execute methods that don't need instance variables.
I am not sure if you can do that in VB but I know you can in Objective-C by using either a "+" or "-" sign in front of the method declaration. And in C++ (at least I think, I can't remember) you put the static keyword or const keyword in front of the function.How would I do this in VB if it is possible? Or should I just make a separate set of functions that are not members of a class?
Is there a way to nest a datatable into another datatable? I know you can do this with gridviews but thats not what I'm looking for.
Also, I don't want to merge the datatables. What I'm trying to do is have a datatable with 2 columns and each column containing different datatables.
i have a datatable with some data, i need to select some of the data, and put that data in a new datatable.
View 1 RepliesFirst time posting a question..I am trying to write to a table from a vb form and i am getting this message when executing the insertcommand:
Cannot call methods on char. The following is the code that i am using:
[Code]...
I've got several methods that all need to add items to a single list which will eventually be used to populate a listview. I thought about declaring the list at class level so that all of these methods could access it, but it didnt really make sense as the only methods that access this list are Shared methods, so I didnt think it was worth having a list just sat there for the entire time that any instances of the class are created, when in a lot of cases the list would not be used.
So what I ended up doing was just declaring the list in the Shared method that then calls these other methods that need to add to the list, and for each of these methods it calls it passes the list in as an argument. The methods can then add items to the list and as the list is a reference type it updates the underlying list object, so once all of the methods have been called then the list in the calling method is up to date and can be used. Then when that method exits, the list is no longer in scope and so is removed from memory. This all works fine, but it feels a bit... wrong. Would it be better to just declare the list at Class level and not be bothered about the small overhead of the list always being in scope when instances of this class are created that will not even use the list?
EDIT: Actually, thinking about it.. because the methods that use the list are shared then the list would need to be shared as well if it was at class level - so the list would not only be around when instances of the class are created, but all of the time. So it will just be sat in memory for the lifetime of the program wont it? I assume this could make a noticeable impact on memory usage after the list has been filled with data, so I guess if I went down that route then I would have to make sure I cleared the list once I had populated the listview. This is another reason why it just seems much easier and more manageable to declare the list as a local variable in the shared method that then calls the other methods that also add to the list.
currently I am using something like the following:[code]It seems to work fine, but I've seen posts on different blogs and stuff that say string.compare is better for some reason.Is this ok to use or should I be using string.compare()?
View 3 RepliesI wrote some string extension methods in a VB assembly and am unit testing them from a C# project. However, C# acts like it cannot see the the extension methods, when other VB projects reference the VB assembly they have no problem. Both the VB assemebly and the C# test project are targeting .Net 3.5. Is there a way around this?
[Code]...
Whenever we need to handle events, we do it by creating a method which handles the event. Without creating methods; is there some other ways of handling events?
View 6 RepliesWhat faster methods are available for VB to access the internet?I.e. methods which are faster than simply using VB Browser, as people make web bots which access multiple sites quickly which I would imagine meant there is a faster way.
View 4 RepliesI'm not sure I used the right lingo in the subject header. But, here's what I want to do. Let's say I have a class with some variables:
Class XYZ
Public InfoNo1 As Integer
Public InfoStr1 As String = " ".PadRight(200) 'Hahaha
Public InfoStr2 As String = " ".PadRight(100)
End Class
I've been looking around for examples of writing methods that act on variables defined within the class. What I want to do is make it so that doing something like this:
[Code]...
I don't need to know how to write the method, I think I can do that. I need to now how to make the method cause a ".Fixed" option to be added to the class string variables so that assigning a string using that method will cause the variable itself to be equal to the string plus the padding.
Is there a way to annotate functions, subs, properties, and methods so that tool tips will pop-up in the IDE as they're being defined or selected?
View 2 RepliesPublic Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim someproc As Process
[Code]...
I am trying to display value of the field ("UserID") for every row exists in datatable to checkboxlist(make the checkboxlist item selected).
I used for loop, but only the field value from last row of RoleUsers table is selected in the checkboxlist.
Here is my code
Private Sub DisplayRoleUser()
Dim conn As SqlConnection
Dim cmd As SqlCommand
[Code].....
I have a datatable and I apply a filter to the defaultview.rowfilter property of that datatable. If I then loop through the rows collection of the datatable, will I only be able to see those rows that the filter applies to, or will it loop through all the rows?
View 6 RepliesI am working on a project that takes an xml schema and xml data files and places them into a DataTable, the 2 files are generated from a working table that i have written to disk. I wish to load these 2 files into a DataTable. Here is What i have
vb.net
Friend Function CreateTable(ByVal tableName As String) As Boolean
Dim table As New DataTable(tableName)
table.ReadXmlSchema(tableName & ".xsd")
[code]....
this however produces the following error on line 3
Quote:
System.ArgumentException was unhandled Message=DataTable 'get_item_list' does not match to any DataTable in source.
get_item_list is the parameter passed into this function (tableName)
I have a datagridview bound to a datatable setting its datasource property to the datatable. I would like to have a child form that contains a list of columns associated with the datatable that contains a checkbox that will allow the user to hide and show the columns ( I do not know the best control to use here) (I assume this is the easy part as All i need to do is loop through each of the datatable's columns to get the column name)
now I would like save these visible columns on some event like form_closing so that the next time the user opens the form up it will remember the settings
I came across a problem with using a BindingSource as my DataGridViews.DataSource. Whenever I applied a filter to a column in the BindingSource and the user makes changes that don't match the column filter the DataGridViewRows would automatically disappear. A similar thing would happen when applying a Sort to a column. If the user made any changes the DridGirdViewRows would automatically sort causing rows to be moved around. This was not ideal for my application and there isn't anyway to stop this from happening with the BindingSource.
To correct this issue I have to use subsets of data. I use a DataView to apply the filter and sort to the main DataTable, which creates the subset DataTable.The problem is when I use the DataView.ToTable method I loose the Primary Key and RowError information. So I have to reapply this information everytime the user filters or sorts the DataGridView.Is there a better way to get a subset DataTable?[code]...
I have a datatable that has a resource in one field and hours used in another, it looks like this -
Resource Hours Used
Manager 1
Accountant 1
Field Staff 2
Accountant 3
Manager 4
Manager 1
Administrator 6
Field Staff 4
Manager 0.5
Administrator 1
What I want to do is be able to create a summary of the data table above that groups multiple occurrences of a resource and adds up the hours used for that resource, creating a summary that looks like this -
Resource Hours Used
Manager 6.5
Accountant 4
Field Staff 6
Administrator 7
Is there a simple way to assign a populated datatable's columns to another empty datatable? That is, I want to copy a datatable's structure only but not its data.
View 6 RepliesI'm using vb.net 2010.I have a DataSet with a Table and data. MyDataSet1 which contains Table1 I want to create another table that is the same as the Table1 but without data, but it should have the columns, etc.
View 1 RepliesI am getting array of selected datarows from a datatable.select.I use the commands below to get that array or datarows
Dim foundRows() As DataRow
strExpression =
Here is what I tried.I have looked at examples by MS but they all just write to the screen and I have no interest in that.
For Each rowWork In foundRows
dtWork.Rows.Add(rowWork)
Next[code]....
"LineOfBusiness = 'CPP'"
foundRows = modXchange.pdtWork.Select(strExpression)
Now, I want to place the rows from foundrows into an empty data table.I did what I thought was the obvious but that only returns a bunch of rows with no data
load the contents of a query from a dataTable Adapter into a datatable?
View 2 Replies