|
I am having a slight prob I am having a hard time finding out how to use an object and a select statement to get more then one value from a couple of tables I know the select statement I just need to know how to get it into my object.... Any clues maybe a for each statement I am not sure but a basic answer would be cool.
|
|
|
|
|
You'll have to be more specific. Your question is very vague. What object? What exectly are your trying to do? And what do you mean by "get it into my object"?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I am trying to get information like select Lastname, firstname, TimeofAppt from cust, appt, employee, person where P.ID = E.EmpID and C.CustID = A.CustID and E.Empid = A.EMpid and E.EmpID = {var EmployeeID}
The selected values are going into an object that I have create appt Cust and emloyee objects so I can display the information in the tables based on the EmpID that is saved in seperate var
I know how to get the value from one thing into one var but I need more then one..... it doesnt even have to be an object just many vars ....
|
|
|
|
|
I'm assuming you're using SQL Server ... You could write an SQL query to lookup the records you need. It looks like you've already written the bulk of the statement. Check into Parameterized Queries to allow you submit the EmployeeID as a parameter. Try checking out this[^] small example on MSDN.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi there my friend,
this PORT1981, im just a beginner but maybe i can lend you some
extra hand.
can u elaborate to me what you want to do and what problems that keep
bugging you? by doing so, i can analyze the solution precisely as what
you want.
thanks.
Port1981
Beyond the Basic; Underground
ideas(Legal, but not commercially available due to the fact that, we use to develop software which we can earn more income not for the sake of personal satisfaction). Anything about IT.
|
|
|
|
|
Please tell me how can i print html files or AxDHTMLEDLib.AxDHTMLEdit control htmltext.
Nitin Gupta.
INDIA
|
|
|
|
|
I also need to know. Thanks in advance.
|
|
|
|
|
Hi, I have a picture control on the form (I'm using vb.net). I can display a picture on that control by using Image.FromFile and supply the picture path. But my problem is some picture is not good to display in picture box. I want the user to doubleclick on picture box then, it will display the picture in an external editor (such as Paint editor or Ms photo editor). But I don't know the way of the code to do that. Could any one give me a sample code to do that????
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
If the viewer associated with the extension should be started:
<br />
System.Diagnostics.Process p = new System.Diagnostics.Process();<br />
p.StartInfo.FileName = @"C:\test.jpg";<br />
p.Start();<br />
if you want to start a special editor than specifiy its executable name as FileName and give it the right Arguments, e.g.:
<br />
System.Diagnostics.Process p = new System.Diagnostics.Process();<br />
p.StartInfo.Arguments = @"C:\test.jpg";<br />
p.StartInfo.FileName = @"C:\Program Files\MyViewer\MyViewer.exe";<br />
p.Start();<br />
|
|
|
|
|
Thank you very much for your help. That really help me a lot of work  ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
I'm looking for some code that will show how to Hook into another Application from a VB.Net Application.
Specifically to fire off a Menu Item in MS Word.
Many thanks in anticipation.
|
|
|
|
|
How do i move the bottom element in an array to the top
from
Name 1
Name 2
Name 3
to
Name 3
Name 1
Name 2
Thanks in advance folks
|
|
|
|
|
You should use a linked list to do this, not an array.
The answer is simple - remove it from the position where it's not wanted, then insert it where you want it.
Christian
I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer
|
|
|
|
|
I am trying to create an appointment system that also allows for messeages to be taken via a LCD and text input device mounted outside a office door.
The LCD will be connected to a RS232 port in the PC and will talk to the PC via HyperTerminal, However i wanted to know ways in which i can modify Outlook to provide a constent link that updates and allows the LCD to perform searches on the Outlook PC
|
|
|
|
|
|
hi all
i have database of processes and at run time i want to show only the processes which are applied or selected say out of 10 process only five are to b used how to get only those five.... ty
|
|
|
|
|
Your going to have to be alot more specific about what your having a problem with. What database? Or is it an array? What is your selection criteria?
If it's a true database, a simple SQL statement will do the job.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
thanx for thr reply
in my database there are ten process names and only 4 or five process names are applicable to each item so in crystal report or in another form in VB i am passing a query and wanna view the process names which are applicable with that application only my problem is how to display it on form to client so that the process name which are applicable to that item are shown...
let me be more precise suppose there is item :
astraleaf
the processes it undergoes are named:
1. lacquer
2. doming
3.cutting
4.taping
while at time of entering data user is entering the data by selecting the process name out of given ten names...
while at time of displaying the item with process name i want only the process name to be displayed....
does i sound clear... hope u understand the problem now
thanks in advance
|
|
|
|
|
suppose i have one MDI form and mdi from has a tool bar which contains many button for record navigation like
move first,last,next,prev form all mdi child form.suppose i have many mdi child form and there are few common public method declared in mdi child form. and i want wheni will click on navigation button then navigation will happen for active mdi child form. so i have to call the method of active child form but i dont know which is my current mdi child form is active. so please tell me how could i call the public method of active mdi child form without explicitly mention the name of active mdi child form
if possible give me the sample code in vb.net
tbhattacharjee
|
|
|
|
|
Uhhh... Did you look at the list of properties of your MDI Parent form in Intellisense?
There is a property of a form called .ActiveMdiChild which returns the active child form.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
i used ctype(me.ActiveMdiChild.name,Form).Show()
but doesn't work.i think my question is not clear to u.i want to call a public method of child form having name form1 when user will click on the toolbar button of mdi form but i wrote
ctype(me.ActiveMdiChild.name,Form).Show(),this show() method is the public method of active child but i am getting error but when i wrote
ctype(me.ActiveMdiChild.name,frmChild).Show() this works. in a application there could be many child form and i do not want to specify the name of active child form rather i want to call public method of active child
ctype(me.ActiveMdiChild.name,Form).Show() in this way but getting error.
so please tell me how could i call a public method of active child without specifying the active child form name.need sample code
|
|
|
|
|
Anonymous wrote:
ctype(me.ActiveMdiChild.name,Form).Show()
This tries to convert the String, called Name, to a Form object. Obviously, you can't do that! The code your writing is entirely too complex for no reason. Your already using the ActiveMdiChild object. This is all you need because if you look at the docs for this property, it returns a Form object! You don't have to convert the Name of the ActiveMdiChild to a form!
I think you're looking for:
Me.ActiveMdiChild.Show()
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi Everyone,
I want to creat a program where when it starts up it then starts playing these two video's of mine. The problem is that the video's i have are .exe video's. i know that you use the shell command to start the program but how can i make the 2 video's repeat.
Thanks in Advance
|
|
|
|
|
If they are .EXE's, you have little to no control over them. You'll have to get with the manufacturer of the .EXE's to see if there is any documentation on an API that they expose, if at all.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thanks Dude. You see the thing is i can get the 2 video's that are in exe format to play one after the other using the shell command in the load form. But is there any code a can add that makes it just either reload the form at a certain time or once it has finished playing the second video it goes back to the first one??????
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
