I am essentially trying to create a list of records in VB.net using the 1.1 framework.It seems that I should be using an object even though I have only properties but no methods (more like a traditional record), I would like to store a list of objects, how can I create the list and add an instance of the object to the list.I do have sample code that almost works but it is too poor for public display.
View 3 RepliesI have been playing with VB6 for quite a few years now and I can normally get by ok on my own.I finally made the move to VB.net, but I am totally lost.I have started writing a program that is basically a planner. It helps the user organize and plan activities with a client.I have created the ui and have added a BindingNavigator and it happily pulls in the records from my Access database which I can cycle through.What I would like it to be able to do is, allow the user to see all the current records (maybe in a flexgrid), select which record he/she would like to view, then the entire record is populated into the ui.I would have no problem in vb6 of course...but I could do with a little help in vb.net (2008).My main problem is I think is, once the flexgrid is populated, how to create the event that allows the user to view and update that record once in the ui.
View 2 RepliesI finally made the move to VB.net, but I am totally lost.I have started writing a program that is basically a planner. It helps the user organize and plan activities with a client.
I have created the ui and have added a BindingNavigator and it happily pulls in the records from my Access database which I can cycle through.What I would like it to be able to do is, allow the user to see all the current records (maybe in a flexgrid), select which record he/she would like to view, then the entire record is populated into the ui.
I would have no problem in vb6 of course...but I could do with a little help in vb.net (2008).My main problem is I think is, once the flexgrid is populated, how to create the event that allows the user to view and update that record once in the ui.
i have issue returning a list in a web method. here is the code
<WebMethod()> _
Public Function getTags(para_parents As String) As List(Of getTypeDetailsByParentName_Result)()
Dim context As New PPEntities
[code]....
the error is
Value of type 'System.Collections.Generic.List(Of SaftyonRoad.getTypeDetailsByParentName_Result)' cannot be converted to '1-dimensional array of System.Collections.Generic.List(Of SaftyonRoad.getTypeDetailsByParentName_Result)'
I have Customers table in a database. I'd like to create List of CustomerNames using entity framework 4.1. How can I do that in Visual Basic?
Dim customerNames = (From c In _context.Customers
Select New With {c.CustomerName}).ToList()
brings a list of anonymous objects.
This is my function:
Public Function GetAllEmployee() As List(Of Employees)
Return DB.Employees.Select(Function(q) New With {q.EmployeeID, q.LastName,q.FirstName}).ToList()
End Function
I'm getting an error:
Value of type System.Collections.Generic.List(Of <anonymous type>) cannot be converted to System.Collections.Generic.List(Of NorthwindModel.Employees).
I've seen many examples in LINQ but i'm not able to reproduce the same result in vb.net.
I have following code: Dim context As New MyModel.Entities()
Dim rnd As New System.Random()Dim gardens As List(Of Tuin) = (From t In context.Gardens Where _
t.Approved = True And _
Not t.Famous = True _
Order By rnd.Next() _
Select t).ToList()
[Code]...
I have learned to create programs in VB.NET with Visual Studio, but the downside of that is that i need the .NET framework, which is not on every computer. Can I create a program in VB.NET without it needing the .NET framework? If yes, what tools do i need?
View 1 RepliesI have .net framework 2.0 . and I want to create an Excel sheet from vb.net programming. I have searched in google but didn't get the correct one. It was all for .net framework 3.5 or higher.
View 1 RepliesI need to create a pdf file dynamically in vb.net. It needs to contain several images and lines of text. I am using VS 2003, so whatever solution I use will need to be compatible with the .net 1.1 framework. The current method I am using is wpcubed, but this requires that all images be converted to bmp format before adding them to the pdf, which can be extremely slow when dealing with a large number of images.
I am aware that there are an awful lot of other 3rd party products that claim to do this, and I have had a search through them. But without registering, downloading, installing and writing code to use each of them in turn, it is very difficult to differentiate between them. So far I have looked into evo pdf and pdfsharp,tallcomponents, [URL] but none seem to work with .net 1.1. (Although they don't make this abundantly clear.)
I have 2 List (of T) populated with the following
Dim curweekFolder As String
curweekFolder = String.Concat("c:", curweek_date.SelectedItem)
Dim preweekFolder As String
preweekFolder = String.Concat("c:", preweek_date.SelectedItem)
[code]....
I first wanted to identify which files matched in filename and list those in ListBox1, the following that was suggested on this forum worked very well (I added the minus last 19 characters as they would be different).
ListBox1.Items.AddRange(curlist.Where(Function(fi) prelist.Any(Function(fi2) fi.Name.Length - 19 = fi2.Name.Length - 19 AndAlso fi.LastWriteTime = fi2.LastWriteTime AndAlso fi.Length = fi2.Length)).ToArray)Now I need to populate ListBox2 with the files that do not match in each List (of T), again without looking at the last 19 characters. So for example if the first List (of T) had A.txt, B.txt and C.txt and the second List (of T) had A.txt and B.txt then ListBox1 would have A.txt and B.txt while ListBox2 would have C.txt.
I have been asked to create a Framework to be the basis of all our drafting toolsets. The approach I think is best is to outline all of the Classes that will be required (Text, dimensions etc), identify routines and properties required for the Classes and document in a spreadsheet.
View 2 Replieshow can i add records from list view to database ex. im going to have a transaction i will add products as many as i ordered in my listview and then i insert it into my database with the 1 transaction number it should be like this:
[code]...
I'm looking for a simple and efficient way to sort up to 60,000 strings that are 3000 chars long in reverse order and save them back out to a text file.
I originally thought of a doubly linked list, but then I realized that we aren't privileged enough to have pointers.
Is there some other way I can create an efficient linked list without pointers?
I have created a database with a couple of records to get started, also I have attemted to implement the database in my forms. I want to add, delete, edit and save new records into the database so when I use it or re open the program the entered data will still be there. Also, after I have implemented these things, I would like to be able to import data from the database into textfields or comboboxes. I have a basic email client and I would like to import these contacts into the datafields. However, I will be trying to achieve that later.I am trying not to use the data connection wizards as I am learning the code as I go along. I have been reading up on databases for about 2 days not and i'm still struggling.This is to add contacts with the fields.I have 7 labels with text boxes, using the naming convention lblFName or txtFName etc;
-First Name,
-Last Name,
-Nickname,
-Email,
-Phone number,
-Address and
-DOB
I have 4 buttons;
-Add record
-Delete record
-Save record
-Next record
-Previous record
I don't know whether to use datagridview, listboxes or something else to display the records.This is to give you an idea of what I have done so far.However, I cannot find a way; despite my best efforts over the last 5 days to link the database that is located in the same folder as my program.If anyone could point me in the right direction on how to code this into my program, or post some links of which I can read, learn and understand the code.
If I create a list for a TextBox:
[Code]....
I am able to only add controls that are of type TextBox. My question to you is, can I create a List to hold more than one control type or do I have to create a list for each control type?
I have two properties ("FIRST_NAME" and "LAST_NAME") I need to access as a single property (e.g. "FULL_NAME"). Is there a way for me to add a property to my entity model that contains the combine value of FIRST_NAME and LAST_NAME?
View 1 RepliesIt might be funny , but I'll ask anyway : is it allowed to create a program with VS2008 while at the same time it will use the Microsoft framework 4.0 ? I am asking because I use VS2008 while at the same time I have the impression that framework 4.0 is "lighter" than 3.5 .
View 7 RepliesIn general Combo Box looks for the strings in the list that Start with the text that typed in the textbox portion of combo box.
I want a feature in combo box which do not just look in the starting of the strings, insted they shold search the maching strings within any part of records i.e. If User types 'Ja' in textbox portion, the the list should show following maches with highlighting the mached records
Micle Jackson
Sandeep B Jakhotya
Javid Akhatar
Suresh Jadhav
Jackie Chan like this.
Similar control is already used by Yahoo Web Site for Search Assistance in its Web Search Combo box. Here if we type say 'bush', it will populate following records
george w bush
jenna bush
bush shoe
bush game
hot dog bush
I want the same with Visual Basic for Windows Form Applications.
i'm having problem saving my records into database here's my code
[Code]...
I have a problem finding strings that do not exist in a column in a database. I am going to use linq but its more the 'way' of doing I am concerned with.
I have strings like;
MEAL
GPST
EXLEG
EXLG ...etc
I need to find records that does not have this list of strings in, so for example DBML BUT sometimes I can have the string MEALDBML, or more concatenated. So this is a known string of MEAL and unknown string of DBML. I would then want to see that record. I do not know the unknown strings up front, so its a case of feeding in the strings I know are ok, and finding one that are outside that list. I was also thinking of regex?
How to query a record in vb.net using combo or textbox via linq to sql like the search engine? Just like when you search in google or youtube, once you typed in the initial string on the textbox or combo box it will show a drop-down list. I tried to use it in my application using linq method but the problem is it would duplicate on the first string that you entered on the dropdown list if that record exist on your database after you press the space key. I used the code below which duplicates the records on the drop-down list when you type in your string after the space key.
I just want it to be like in any search engine that when you type in the string or your initial string, it will display on the drop-down list all the records from the database that contains the string you entered without duplication. In my case, I'm trying to query a name from my database. This is how it should work, For example, if you type an initial string in the textbox or combo box a named 'Mark', it should display all the names from the database containing 'Mark' into the drop-down list before it changes into its final string that you entered.
Here is the codes I used:
Private Sub ComboBox1_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles
ComboBox1.TextChanged
Dim db As New MultipleDatabaseOperationDataContext
Dim search As String
search = ComboBox1.Text
[Code] .....
II am trying to create a toggle button that switches a list to a range and then back to a list if needed. I am able to get it to do both but when I add an item to the list, convert to a range and then convert back to a list it leaves off the last items I entered.I tried to work in a code to select all cells but I must not be putting it in the right place.This is what I have so far:
ActiveSheet.ListObjects.Add(xlSrcRange, Range("$A$3:$AE$7"), , xlYes).Name = _
"List1"
I realize the problem is the $AE$7 (the $A$3 is correct)
i am trying to create a list of list in that i would like to work on multiple accounts at the same time. lets say i have 5 accounts. every account has a seperate name. each account has a few fields. so i though of having a list of bookkeeping (with 5 accounts) and a list of accounts (with expense, income, tax, status, etc as fields). [code] and if the idea of using list of list works how do i loop through both lists.
View 6 RepliesI would like to create list of child objects from list of parent object. Like If i have list of bookingroom which has one member room then i would like to create list of room from it.
eg. code:
Dim BookingRoomList As List(Of BookingRoom) = New List(Of BookingRoom)
Dim RoomList As List(Of Room) = New List(Of Room)
BookingRoomList = BookingRooms.FillGrid()
[Code]....
Is there any short cut method instead of iterating over for earch?
This is probably a really basic question - but I have a list of items (custom objects) being passed from one winform (.net 3.5) to another. I want to create a local list to store changes that only get persisted if the user clicks save. Currently if the user clicks cancel - the changes are still applied in the first form because I assume the objects are reference type.I have the save working as it calls a service layer to do the save and then refreshes the other form - but not the cancel.
View 1 RepliesIn entity framework we can use 3 approaches model first , code first , database first but each one of them needs manual hand touch(means creating database or create model or write the POCO class codes or entity class codes) before proceeding to the next step ( using EF in context ).What if I want to create database and tables and table relationships programatically and still want to have to features of EntityFramework 4.3.
To be more specific ,from this example http://support.microsoft.com/kb/307283 we can create database , tables and everything using SQL command but we can't have the advantages of entity framework. So if we want to have that what should we do? To give the ability to create dynamic table fields those steps will not be sufficient. In all 3 steps database , table and table columns are fixed. There is no way that a user can create new tables or columns dynamically. http:[url].... in this post , it shows how to create manual db, tables and etc using SQL but it is based on ADO.NET but I want Entity Manager to do that.
I am writing a small program to update data in a SharePoint list. Now where I cannot develop or use applications for SharePoint unless I am on a SharePoint server, I thought I would cheat the system by using Access to link to SharePoint lists, and then use Visual Basic to play with the Access tables. I need additional functionality other than what VBA can provide me, so that is why I am using the VB layer.Is it possible that this is not permitted? Whenever I try to update an item in the table, I receive the message:
"cannot update '(expression)'; field not updatable"
The word 'expression' here is not a filler I added, this is the actual error.If I try to make the edit manually in the table using Access, it works fine (I haven't tried it through Access VBA yet...).
How my code works is this:I have a Dataset added to the project which connects to the Access database. I add one of the tables to the dataset and create a Class object to reference the table adapter (essentially a Data Access Layer). I can read all of the data fine, and when a change is made in SharePoint, my application sees the updates when it refreshes. But when I try to write back to the table I get the error message above.
For
Each r As
DataRow In TableAdapter.GetData.Select("Name LIKE '*" & FileName &
"*'")
[code]....
There are other columns in the table and some of them have default null values. I only want to update these two fields, but it almost seems like this is not possible. I thought I might be somehow opening the Dataset in a Read Only mode, but I can't seem to find that option anywhere.
I want to display the correct records in my SectionName dropdown list whenever the user select/check an radio button (Elem or HS). No radio button is checked during design time but when I run the app, the SectionName dropdown list show Elem records. also when I checked the HS radio button the SectionName dropdown list records does not changed at all..
Private Sub frmLoading_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If cnn.State = ConnectionState.Closed Then cnn.Open()
[Code]....
Usually when I need to create a DB with excel files(in order to get records that I need), I used following
HTML
Excelconnection = New OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0; data source=" + mypath + "; Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'")
Excelconnection.Open()[code]....
where mypath contains path of excel files.Now I have a file with no extension where structure is: each record is separated by space and row are more than 65535.I saw that with csv file I can solve this issue but I don't know if OLEDB connection to csv file works fine.I don't want to create several sheets.