Providing Several/multiple Lookup Values?
Jun 29, 2009I have a Person.Profile table with columns like
PersonType (Student, Employee)
____ (Male, Female)
MaritalStatus (Single, Married, Widow, Separated)
[code].....
I have a Person.Profile table with columns like
PersonType (Student, Employee)
____ (Male, Female)
MaritalStatus (Single, Married, Widow, Separated)
[code].....
i am using the LookupEdit control from DevExpress fairly heavily in my projects. It is like a combobox, but it is bound to a datasource and can display multiple columns from the datasource. A single column is identified as the "value" column and a single column is identified as the "Display" column.
I use the LookupEdit control on my forms to give users a pick-list of appropriate values for a particulat database field. Each field has its own table in the database holding said values, commonly referred to as a lookup table, and each lookup table is used as the datasource for each paired LookupEdit control. Of course when a form is being filled-in by the user this works great. And it works good when the user opens a saved record into the form and I set the EditValue of the LookupEdit based on the value stored in the database. Pretty basic stuff right?
Now here is the problem... Let's say a lookup value is no longer an appropriate entry and so it is removed from the lookup table. Say I sell cars and one of the fields in the Cars table is Color. And I have a lookup table called CarColors and the selections are: Black, White, Red, and Silver. Now let's say we sold some Red cars in the past, but now we no longer carry Red as an option and we probably never will. So I remove "Red" from my lookup table, and now when I load an old Order into my form the LookupEdit for Car Color value now shows NULL. What is the best way to handle this situation? ProcessNewValue? Set NullText property? Use a bit field in my lookup table for IsActive, and set to FALSE for Red instead of deleting it?
Obviuosly I want to retain the historical values while maintaining a currently valid lookup list. And I know this question goes deeper as there are probably database design considerations like whether or not to put a constraint on the foreign key relationship between the lookup and child table, etc... I should also mentioin I am using LookupEdit control rather than a ComboBox becasue a lot of my lookups have other information like Description, Sort Order, or are coded and thus require a multiple column display.
When I click on button1, employee_id and P values need to be transferred from button1_click to Cal_Category13() and go through all the calculation. After the calculation, udtnew.X and udtnew.MTD values need to be transferred back to button1_Click
I've no problem to return multiple values Cal_Category13().MTD and Cal_Category13().X from Cal_Category13() to button1_Click but i've no idea how to transfer employee_id and p values from button1_click to Cal_Category13().
Program Code
Public Structure PCB
Public Employee_ID As String
Public MTD As Decimal
[Code]......
I have written up troubleshooting documents for my project and would like them included in my program. I remember in VB6 there was a very easy way to do this with a control, where it already has the help document tree set up on the left and you just set it to point to certain files.
Does something like this exist for .NET? I am aware of the HelpProvider control but as far as I know this just puts in tooltips and opens documents on a button press?
I have simple columns and their respective sums. However, I exclude 1 particular value from each sum, like so [code]...
Now I need to exclude another value ("Awaiting Progression") from a second column called "PROGRESSION".
Since I already exclude value based on 1 column called CATEGORY, how do I change my =Sum(Code.ExcludeOthers(Fields!CATEGORY.Value,Fields!ACTION_PLAN_NEW.Value)) to exclude a value from the PROGRESSION column if it's = ("Awaiting Progression") ?
i.e. How do I exclude multiple values, depending on values in 2 columns in SSRS 2005?
How do you provide an image to the program, so the program finds that image on the screen and tells its coordinates. So if I was to provide an image of the start button, the program would tell the coordinates like (2,1000) or something similar.
View 13 RepliesConsider the following :
Dim Length1 As Double = (10* 12) + 5
Dim SqFt1 As Double = 0.0
Dim length2 As Double = Length1 / 12.0
Dim tape As Double = CType(210.0, Double)
'Length2 at this point has a value = 10.41666
SqFt1 = CType(length2 * tape, Double)
[Code]...
Can i copy files into folders without providing full name of the file? Different files will be distributed into different folder, my files have current date at the end, it also has split before the date. I would like to copy the files name before the split. Here is an example
[Code]....
WinFormsApp Login passes information to .php (server based) Login (provided credentials are correct) to DB to retrieve Decryption Key. WinFormsApp then uses Decryption key on Hardcoded encrypted connection string and renders application usable.This would then eliminate the necessity to encrypt/decrypt a connection string at runtime, virtually rendering any unauthorized person with a useless software.
View 1 RepliesI'm having different results when running openfiles.exe manually than when I run it with Process.start() Below is the portion of code making the call. I have read in several places that using the "runas" verb might make a difference since I am running on Win 7 x64, however I am still experiencing different results.
[Code]...
If I have a .dll, isn't it I can place it in a folder providing that the folder is included in the project? since I really do have a problem during publishing.
View 4 RepliesI have a datagridviewcomboboxcolumn which has its .DataPropertyName set to a int field, its .DisplayMember set to a nvarchar field and its .ValueMember set to a int field on a lookup table. I have captured a dataerror which states that the control is trying to push the .DisplayMember(nvarchar) to the .DataPropertyName(int) field. When I load existing data it works fine. When I try to leave the datagridviewcomboboxcolumn after selecting a different value in it or leave it when I add a new row, I get the error. What am I doing wrong?
View 1 RepliesSimple Code lookup to get Description I have a static list of Street Type Abbreviations and their associated Street Type Descriptions: RD to Road. I have the complete list needed. There are 37 elements in the list - 37 Street Type Abbreviations with their associated Descriptions. The lookup will only happen once. The input lookup field is in a single field: stType.
[Code]...
I am using asp.net with vb.net. I have created 2 listboxes; lstselect and lstroles. List boxes lstselect contains all of the available roles that can be added into lstroles. How do I take the roles that have been added into lstroles and make them into a parameter to pulled into my database when the stored procedure runs?
Here is the code for how my list boxes share the roles:
Protected Sub btnRight_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnRight.Click
If lstselect.SelectedIndex <> -1 Then
[Code]....
I am using ASP.NET and C#. I must read a cookie called "TheCookie".TheCookie have about 3 values in them. Cookie1, Cookie2 and Cookie3.How would i get the value in code to read Cookie2's value inside "TheCookie"?
This is how i would read when a cookie only have 1 value, but i dont know what to do when there are multiple vales in the cookie Code for VB.NET
Dim userCookie As HttpCookie userCookie = Request.Cookies("UserEmail")
I am using visual studio 2010/vb trying to display data that is based on a value read from a text file.Currently i can get it to read a text file with only 1 value and get this value into a label. Then by using a SqlDataSource and setting a parameter in the WHERE clause to use the value from the label, it will display the related data in a data GridView.
BUT i would like to be able to read multiple values seperated by a , or next row down in the text file and enter these values into a WHERE bookID in (value1,value2,...)
I have a datagridview control on a form that is filled programatically (dataadapter, dataset ) from a database table (access).
Some of the columns in this table are foreign keys to other tables. Is it possible to have these
columns as combo box columns so the values can be selected directly from the other tables?
I have an Access 2003/2007 application that pulls computer names from my network along with their last know TCPIP address. This data is created by another application. I am trying to use the IP Adresses to install software via a push application that accepts a list of IP Addresses.My app has a history table of every comuter that has been checked to see if the software is installed. I use the Fully Qualified Domain Name to make this verification. I then populate my text file with the IP address of the computers that have not been installed.This all works well if the last know IP address is still valid for that computer.What I am trying to find is a function that I can pass the FQDN to and have it do a NetBios lookup to return the current IP Address from our DNS Servers so I can be sure that the IP addresses I am populating the text file with match the FQDNs of the computers I am trying to push the software to.I found some info on System.Managment.dll. For some reason Access will not let me add it to my library references.Does anyone know of a standard library function I can use to achive this.[code]
View 2 RepliesI am trying to setup a macro to lookup a value. Its very basic, I am trying setup a sheet to build tariff requests for mobile phone deals. so on sheet i will have lots of macro boxes that simply pubulate a table with a value on sheet 2.
Its basically so a sales person can go onto the excel sheet click click click and it will produce a table of all the product on each mobile number connection.
I have a sql query that looks like this
SELECT SUM(A) AS expr1 FROM TREES WHERE (b = ?) AND (c = ?) and (d = ?)
How do I map the parameters? Since its a sum, I cant select multiple rows.
I am converting a DTS update lookup to an SSIS lookup with an update query. So far it doesn't seem to work.
OLD DTS ACTIVE X CODE:
value = DTSLookups("apple").Execute(DTSSource("ID2"))
SQL Query in DTS:
UPDATE TABLE1 SET STAMP="TEST" WHERE (ID = ?)
In SSIS:
Create a lookup, use same above query, and I get an error if I click on column: "Parameter information cannot be derived from SQL statements. Set parameter information before preparing command"
IS there anyway to accomplish this in SSIS with a lookup? Or is there a better way?
in item Search form i can search the item that i want, if i found the item that i need i will select the entire row and fill this row in DataGridView in frmSWSfromGrid.i been able to achieved this same scenario but it uses textboxes.the ff. COde
frm Dialog code
Public Property DepartmentID() As String
Get
[code].....
I'm using this function to return a value from multiple databases across three SQL instances (On the same server). I'm looping though a DataGridView that lists all the databases on one of the three SQL instances.Is there a faster way of doing this? It's quite slow using this method.
Function DatabaseStatus(ByVal SQLServer As String, ByVal Database As String)
Dim myConn As New SqlConnection("Server=" & SQLServer & ";User Id=USER;Password=PASSWORD;Database=" & Database & ";")
Dim Status As String = ""
[code]....
I'm working on a simple miles-per-gallon calculator.
Module Module1
Sub Main()
Dim count As Integer = 0
[code]....
This compiles and works for 1 iteration, after many trials and tribulations . What I need to do is make it run for a user-specified number of iterations (the tankfuls variable) and store those separate results in separate locations in the arrays, then average all of those values at the end (find the overall average MPG).
ok so I am trying to grab a bunch of phone numbers from my html page. I have successfully grabed the first one but I dont know how to get it to loop around and grab the next one and list them out into a listbox. here is the code I have for getting the first value, but how can I make it go in a loop. I have been searching for hours and trying tons of different kinds of loop code but get errors every time.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
WebBrowser1.Navigate("my html page")End SubPrivate Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click TextBox1.Text = WebBrowser1.Document.Body.InnerHtml()End Sub
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
[Code]...
I'd like to create an array of one column from the text box entries (as shown in the picture) when i click the button.[code]...
View 1 RepliesI have a javascript function below to move from select multiple box A which is populated from database to another multiple select box B, in the event of a postback my values in B which are moved over from A got lost. Initially I thought because I included a "runat="server"" tag for server side actions but apparently it's not the case. I read about Form.Request but ain't have a clue how to go about it. I just need to retain those values in multiple select box B.[code]...
View 1 RepliesIs it possible to make a function that returns both a datatable AND a list(of custom class) at the same?In my GUI layer, the main form (the application is MDI) calls this function and it has to fill the datagrid on one of its child forms and it also has to fill lot of other child forms with various information that is calculated from my custom class properties.Both the datatable and the class properties are created from the same external database and that's why I don't want to have two separate functions.
View 3 Replieshow to store or return multiple queries result values into multiple variables.. I'm using a query that return 4 columns but how to.. individual store those results into 4 separate variables.. here is my code
Private Sub FrmAlumnos_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
txtCurrentUser.Text = Login.txtUser.Text
Dim strsql As String
[code]....
I have created a function that takes a Car Registation as its argument and I want it to return 3 values (Make, Model, Price and of course True).The code itself works fine (it returning each Individual value but can't find a way to get ALL of them from 1 function) However I need to actually return all 3 values, and I cannot see how to do this with a simple function.
View 8 Replies