473,659 Members | 2,662 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Lookup like function

I have a page that is used for the user to edit their information on file.
I need to lookup all of their info using their ID. Do I use a lookup
function on each text box/drop down list or should I run a stored procedure.
Is there just a functiont that I can lookup a specific piece of information
and set it equal to txtMyTextBox.Te xt? I just need someone to point me in
the right direction.

Thanks
Nov 19 '05 #1
3 1231
Hi Andy,

You should try and clarify your question, which is very difficult to
understand.
edit their information on file : you mean in a database? If yes, which one? I need to lookup all of their info using their ID : do you mean that the user provides their ID and then you fetch the corresponding data from the db/file, and display that data on screen? Do I use a lookup function on each text box/drop down list : do you mean FOR each text box, etc? or should I run a stored procedure : do you mean "shall I use as many db fetches as there are fields or rather fetch them all at once using something like... mmhhh... dunno, let's call that a DataSet? Is there just a functiont that I can lookup a specific piece of information
and set it equal to txtMyTextBox.Te xt? : do you mean exactly the contrary, i.e. set txtMyTextBox.Te xt to a specific piece of information you would lookup?
Giving a lot more info (like what language you're using, what
database, some context for your program...) would help us set you in
the right direction.

HTH,

Michel
"Andy G" <aj*****@iastat e.edu> wrote in message news:<OG******* *******@TK2MSFT NGP09.phx.gbl>. .. I have a page that is used for the user to edit their information on file.
I need to lookup all of their info using their ID. Do I use a lookup
function on each text box/drop down list or should I run a stored procedure.
Is there just a functiont that I can lookup a specific piece of information
and set it equal to txtMyTextBox.Te xt? I just need someone to point me in
the right direction.

Thanks

Nov 19 '05 #2
I came to a conclusion myself. But thank you very much for the smart A**
coments Michel, I'm sure you feel good about yourself now.
"fd123456" <fd******@hotma il.com> wrote in message
news:c8******** *************** ***@posting.goo gle.com...
Hi Andy,

You should try and clarify your question, which is very difficult to
understand.
edit their information on file : you mean in a database? If yes, which one?
I need to lookup all of their info using their ID : do you mean that the
user provides their ID and then you fetch the corresponding data from the
db/file, and display that data on screen?
Do I use a lookup function on each text box/drop down list : do you mean
FOR each text box, etc?
or should I run a stored procedure : do you mean "shall I use as many db
fetches as there are fields or rather fetch them all at once using something
like... mmhhh... dunno, let's call that a DataSet?
Is there just a functiont that I can lookup a specific piece of
information and set it equal to txtMyTextBox.Te xt? : do you mean exactly the contrary, i.e. set txtMyTextBox.Te xt to a specific piece of information you
would lookup?
Giving a lot more info (like what language you're using, what
database, some context for your program...) would help us set you in
the right direction.

HTH,

Michel
"Andy G" <aj*****@iastat e.edu> wrote in message

news:<OG******* *******@TK2MSFT NGP09.phx.gbl>. .. I have a page that is used for the user to edit their information on file. I need to lookup all of their info using their ID. Do I use a lookup
function on each text box/drop down list or should I run a stored procedure. Is there just a functiont that I can lookup a specific piece of information and set it equal to txtMyTextBox.Te xt? I just need someone to point me in the right direction.

Thanks

Nov 19 '05 #3
Well, next time, don't even ask...

Michel

"Andy G" <aj*****@iastat e.edu> wrote in message news:<u9******* *******@TK2MSFT NGP09.phx.gbl>. ..
I came to a conclusion myself. But thank you very much for the smart A**
coments Michel, I'm sure you feel good about yourself now.
"fd123456" <fd******@hotma il.com> wrote in message
news:c8******** *************** ***@posting.goo gle.com...
Hi Andy,

You should try and clarify your question, which is very difficult to
understand.
edit their information on file : you mean in a database? If yes, which one?
I need to lookup all of their info using their ID : do you mean that the

user provides their ID and then you fetch the corresponding data from the
db/file, and display that data on screen?
Do I use a lookup function on each text box/drop down list : do you mean

FOR each text box, etc?
or should I run a stored procedure : do you mean "shall I use as many db

fetches as there are fields or rather fetch them all at once using something
like... mmhhh... dunno, let's call that a DataSet?
Is there just a functiont that I can lookup a specific piece of

information and set it equal to txtMyTextBox.Te xt? : do you mean exactly the contrary, i.e. set txtMyTextBox.Te xt to a specific piece of information you
would lookup?

Giving a lot more info (like what language you're using, what
database, some context for your program...) would help us set you in
the right direction.

HTH,

Michel
"Andy G" <aj*****@iastat e.edu> wrote in message

news:<OG******* *******@TK2MSFT NGP09.phx.gbl>. .. I have a page that is used for the user to edit their information on file. I need to lookup all of their info using their ID. Do I use a lookup
function on each text box/drop down list or should I run a stored procedure. Is there just a functiont that I can lookup a specific piece of information and set it equal to txtMyTextBox.Te xt? I just need someone to point me in the right direction.

Thanks

Nov 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
19020
by: John Collyer | last post by:
Hi, In assembly language you can use a lookup table to call functions. 1. Lookup function address in table 2. Call the function Like: CALL FUNCTION
1
1989
by: Srini | last post by:
I was reading the "Exceptional C++" of Herb Sutter. In an example, he mentions the following. // In some library header: namespace N { class C{}; } int operator+(int i, N::C) { return i+1; } // A mainline to exercise it: #include <numeric> int main() {
8
2030
by: Lucas Lemmens | last post by:
Dear pythonians, I've been reading/thinking about the famous function call speedup trick where you use a function in the local context to represent a "remoter" function to speed up the 'function lookup'. "This is especially usefull in a loop where you call the function a zillion time" they say. I think this is very odd behavior.
10
3805
by: junky_fellow | last post by:
what are lookup tables ? How can they be used to optimise the code ?
7
2720
by: Juris Krumins | last post by:
I have a problem with postgresql tables. periodicaly, I would say frequently about 5-10 time per hour i have such errors in my server log file: 2004-04-14 12:23:32 ERROR: cache lookup of relation 149064743 failed 2004-04-14 12:23:32 ERROR: Relation "tmp_table1" does not exist 2004-04-14 12:23:32 ERROR: Relation "tmp_table1" does not exist So turn on debugging options and have that's what i got:
4
1537
by: Dilip | last post by:
How did the Koenig lookup come to be associated with templates? If I have something like this: (no template code) namespace X { enum E { e1 }; void f(E) { } }
4
1481
by: Andrea Griffini | last post by:
Hello, I implemented that crazy idea and seems working... in its current hacked state can still pass the test suite (exluding the tests that don't like self generated output on stdout from python) and the stats after the quicktest are IMO impressing: LOAD_GLOBAL = 13666473 globals miss = 58988
13
5583
by: paul.joseph.davis | last post by:
Hi, I've just had my first encounter with two-phase lookup and I'm scratching my head a bit. The idea behind two phase look up is pretty easy to understand, but I have a case that fails to compile although it appears to me that it should. template<typename TYPE> void foo( std::map< int, TYPE pmap )
1
2280
by: joeino | last post by:
I want to do a lookup query and append the record to a history table before editing the data. I created a macro to run the lookup query to append the record to history and it works fine. I did the same with the lookup query that allows the user to edit the record. I then converted them to vb and combined them. Code follows. My thinking is to create a variable dim keyno longint then pass keyno to the lookup queries. I am kind of new...
0
8330
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8746
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8626
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7355
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6178
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5649
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4334
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2749
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1975
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.