.net - LightSwitch: On New Row, Pull In Parent Info?
Aug 12, 2011
I have a database with two tables in it: People and Logs.I have created a Details page that displays Person information and additionally includes the associated logs records. All of this has just been done by adding a standard details page - not custom coding, etc.When a user clicks on the green + to add a row to the Logs for that person I want to autopopulate a few of the columns. To do this I've opened the Log class and added the following:
Private Sub Log_Created()
Me.Create_Date = Date.Now
End Sub
This works great. But I also want to pull in the card number associated with the person. In the end my code should look something like (pseudo):
Private Sub Log_Created()
Me.Create_Date = Date.Now
Me.CardNumber = SelectedPerson.CardNumber
End Sub
However, I'm not sure exactly how to accomplish this in code?
I was wondering if there was a way of pulling text from a website and the displaying it in a label, text box, etc.My idea isn't malicious in nature, I just want to be able to pull text from a specific page and then compare it with another page.
im having a sql problem for reporting here. here is the table[code]....
i would need to have a column ParentLocationName that directly shows the name of the parent's location as below: --- AssetNameOfficerInChargeIDLocationIDLocationNameParentLocationName IPODSusan6Room 1Building B Sony PS3Fred5Partition 1Building A
is there a way to pull the parent's location name in one sql syntax?
I know I can pull the amount of memory by using My.Computer.Info.TotalPhysicalMemory but I would like it to show like it does under My Computer properties. What do I need to do this?
Is there a DLL or code for class (documented) that can be added to an app to pull movie and TV info down from the IMDB? I have see a lot of older stuff, but nothing documented or working outside of a semi-functional Python piece and am just not ready to wade my way through Python.
I am trying to work with an access database. If this line pulls data from a dataset and puts it into a textbox: TextBox1.Text = Me.A_DataSet.a_Table.Rows(0).Item(0).ToString How would I pull the field name? For Example, in this database I have 3 fields:
I followed tutorial here[URL]..The form runs but I cannot fill it Update: There's no error message I just can't enter the field to type anything: it's read-only
Update 2: I ask the gurus on Microsoft Forum, they tried to answer hard, nobody can find out why. Seems beta is very beta Weirdly I did have this problem on a windows 7 PC not on a Windows 2008 pc
I loaded a Lightswitch program on an XP machine and after load all of the updates it runs fine. I tried to load it on another XP machine with all of the updates loaded and it looks like it installs and it shows up under programs but it looks like it starts to run but then nothing happens, there are no new processes running.
I have a Lightswitch application that is running fine, connects to the database and shows the data just fine. I am trying to write another one using the same database but I get the error "Unable to load data". I can't find anything I've done differently with this application. I can connect to the database in the development window and see the data by using the View/Server Explorer and show table data.
I'd like to insert the application version number into my Lightswitch application title bar, but I haven't found anyway to programatically set the application title.
I have Customer search screen and Customer Detail Screen, On Search set up a ShowLink on Name ,so when ever a user click on Name the Detail Screen Opens with that Customer data.
Whenever i change something into Detail Screen and press save, it Updates the customer. Its Fine.
But i want provide a functionlity of AddNew Record for that customer, So i have put a Button "AddNew" on ScreenCommandBar that clears all the fields in the Detail Screen. But it still Updates the Customer..
How can i code for add new record in Detail Screen?
I have small lightswitch application having CreateNewUser Screen.Screen fields comes from Datatable added in DataSource, I have made all Validattion of fields at DataSource side.However i have added one Custom Control in the screen named : Re-TypePassword.Whenever user click on save button I want to match the Password and Re-TypePassword and want to prompt user a validation message if Password and Re-TypePassword are different.how can i display that validation massage ? ( I mean i want to add validation message to Summary of messages that appears at the top of screen)
This is a challenging one that got me stumped while I was coding today. Suppose I am running the Sub Test1() and Test2() and would like to print out the value of the Shadows method of the instance of the object I am passing in to TestCall() (see below - it is clearer) using the following restrictions:
Can't change the contents of Class A, B, and C Can't change Sub Test1() and Sub Test2() TestCall() can't have an if, select case etc. statement that tries to figure out the type
I have a main form, and some sub forms, and each sub form can have some sub forms. When I have multiple sub forms open, and I try to get data from the parent form, it returns the data from the wrong parent form.For example I have two instances of Mainform.subform running. If I do something like this in a child form of one instance of the subform. It returns data from the other subform.
dim l = Mainform.subform.listofdata
Edit:I am using visual Studio 2008. Winforms, form designed using designer. In my mainform I am doing this
Protected Friend frmMain as Mainform frmmain = new mainform
In frmMain I am doing this
Protected Friend frmsub as new Subform' frmsub = new subform
I am working on a media player, and I would like to setup a local playlist feature. I am using a single ListBox and its "Display-" and "Value-Member" properties. The display is the song's Artist and Name, and the value is the song's file path (i.e 'C:UsersUSERMusicetc.').To write the file path to the .txt file, I believe I can use the following code:[code]
I am making a program, obviously, and I require some assistance. I found an explanation on how to read information from a Text file and have modified it for my needs. Here is my (modded) version:
Public Function GetInfo(ByVal playlistname As String) As String On Error Resume Next Dim PlaylistInfo As String
I'm making a database app. I've finish the search, add new, and add function. What I'm trying to do is to expand the functionality of the add new item function.
I am trying to do is fill out a form with certain info, put the info into an array, and write it to a listbox using loops, arrays, and maybe a function if I need one. This is for VB2010 and here is what I have so far... I think there are ways to make it shorter but I cannot figure it out.... maybe just brain dead from all the coffee I have been drinking!
I would like to know if there is some simple code to release a child control from it's parent control, without having to name the parent control. In pseudocode, I'm looking for something like this:
how to correlate info from a textbox based on a listbox item selection. For example the user will select an item from the listbox, enter say the length of a song in the textbox say 2:00 for song #1, select say song #2, enter the song time for that song say 3:00, click on song #1 again and have the same textbox display the length of that song and be able to do that until there are no more songs on the list.
Can I get info from stored cookie on the local machine. I have a Webbrowser control in a winform, and I would like to output data from a cookie to a label or so.
I am trying to call up different forms based on a basic login screen (thats fine) the part that is not working is that when I put in any information it should pull up one of 2 screens but neither will come up. Any help below is my code so far. (using professional 2010)[code]....
I have two comboboxes and a listBox to display data from several databases. The whole process should be that after an option is selected in the first comboBox, the second comboBox and the listBox are populated. So for example, I could select a Company from the first comboBox, and the second conboBox will be populated with all it's locations while the listBox will first display the location of the headquarters(default location). But the user can then select a different location from the second comboBox if they want to and the listBox will then display the location of that newly selected office location.how do I dynamically pull these data from various databases cause all the companies will have their information in separate DB's. My challenge is how to dynamically pull these data from the various DB's to populate these 3 controls.
I have a form that needs to pull a CSV file into a datagridview, which I have working OK with the code below. VB Private Sub FillDataGridviewWithCSV() Dim strDirectory = Path.GetDirectoryName(ofdCSV.FileName) Dim conString As String = String.Format(ProviderString, strDirectory) ' I extracted the provider string to a separate ' sub to make this post a little easier to read [Code] ..... I have tried many different variations on converting what is in the DataGrid (or what is feeding it) into somthing I can push into the BulkCopy but have not got it to work right.
