473,857 Members | 2,017 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Saving Query Strings

I have an interface that works with an Access back-end. I would like to
store and/or load user defined query strings per each user (i.e. no user can
access another's queries). The idea I had was a "table" stored with the C#
front-end (not in the Access database), but don't know if this is even
possible. If it is, can someone let me know how? Otherwise, how do other
people handle storing and loading query strings for possible later use?
Mar 14 '07 #1
3 1779


"Nathan Guill" <NG****@Forgema n.comwrote in message
news:ep******** ******@TK2MSFTN GP05.phx.gbl...
>I have an interface that works with an Access back-end. I would like to
store and/or load user defined query strings per each user (i.e. no user
can
access another's queries). The idea I had was a "table" stored with the
C#
front-end (not in the Access database), but don't know if this is even
possible. If it is, can someone let me know how? Otherwise, how do other
people handle storing and loading query strings for possible later use?

Is this for an ASP.Net application? WinForms app? For ASP.Net, I would go
with defining a table within the database that contained such strings. For
the latter, I would go with defining a custom configuration file per user
that is stored within the user directory of the current user. All in all
though, I probably would not be storing such strings anywhere. Depending on
your requirements, you may be able to go about this without using "custom"
query strings.

What is it exactly that is "custom" about these query strings that can't be
made static with additional parameters?

HTH,
Mythran
Mar 15 '07 #2
Sorry, It's for a WinForms app.

I was just thinking that the user might want to save a query that they run a
lot, but is not something I have been asked to develop a standard for. This
way they do not have to reenter the search criteria each time. But now that
I'm thinking about it, these forms are not showing that much data to begin
with, so I think I'm going to leave this capability out as I don't think it
would be that big of a hassle for the user to do...

"Mythran" <ki********@hot mail.comwrote in message
news:03******** *************** ***********@mic rosoft.com...
>

"Nathan Guill" <NG****@Forgema n.comwrote in message
news:ep******** ******@TK2MSFTN GP05.phx.gbl...
I have an interface that works with an Access back-end. I would like to
store and/or load user defined query strings per each user (i.e. no user
can
access another's queries). The idea I had was a "table" stored with the
C#
front-end (not in the Access database), but don't know if this is even
possible. If it is, can someone let me know how? Otherwise, how do
other
people handle storing and loading query strings for possible later use?

Is this for an ASP.Net application? WinForms app? For ASP.Net, I would
go
with defining a table within the database that contained such strings.
For
the latter, I would go with defining a custom configuration file per user
that is stored within the user directory of the current user. All in all
though, I probably would not be storing such strings anywhere. Depending
on
your requirements, you may be able to go about this without using "custom"
query strings.

What is it exactly that is "custom" about these query strings that can't
be
made static with additional parameters?

HTH,
Mythran


Mar 16 '07 #3
Does he write his own query, or select stuff on the screen?

I have written a few apps that provide my users with the ability to run ad
hoc requests against the database. I have a bunch of selection criteria on
the screen that they fill in. I create the query, run it, and return the
data to them.

If you are doing that, you can save the values of all of the controls using
My.Settings in VB (it's also in C#, but has a different name; post back if
you need it), then reload them when the user comes back in. That's what I
do.

If they are actually crafting queries, I would do the same thing. I would
save them to My.Settings and then fill it back in.

Anything you can do to make your users' lives easier makes you look better.
It's the small things that count in an application. I once got kudos from a
top-level manager because I used masked edit boxes for the dates, and he
didn't have to type the slashes. Haha!

If you want more info on saving settings, post back with your language of
choice, and I'll post some code for you.

Robin S.
-------------------------------------------
"Nathan Guill" <NG****@Forgema n.comwrote in message
news:O0******** ******@TK2MSFTN GP02.phx.gbl...
Sorry, It's for a WinForms app.

I was just thinking that the user might want to save a query that they
run a
lot, but is not something I have been asked to develop a standard for.
This
way they do not have to reenter the search criteria each time. But now
that
I'm thinking about it, these forms are not showing that much data to
begin
with, so I think I'm going to leave this capability out as I don't think
it
would be that big of a hassle for the user to do...

"Mythran" <ki********@hot mail.comwrote in message
news:03******** *************** ***********@mic rosoft.com...
>>

"Nathan Guill" <NG****@Forgema n.comwrote in message
news:ep******* *******@TK2MSFT NGP05.phx.gbl.. .
>I have an interface that works with an Access back-end. I would like
to
store and/or load user defined query strings per each user (i.e. no
user
can
access another's queries). The idea I had was a "table" stored with
the
C#
front-end (not in the Access database), but don't know if this is even
possible. If it is, can someone let me know how? Otherwise, how do
other
people handle storing and loading query strings for possible later
use?


Is this for an ASP.Net application? WinForms app? For ASP.Net, I would
go
>with defining a table within the database that contained such strings.
For
>the latter, I would go with defining a custom configuration file per
user
that is stored within the user directory of the current user. All in
all
though, I probably would not be storing such strings anywhere.
Depending
on
>your requirements, you may be able to go about this without using
"custom"
query strings.

What is it exactly that is "custom" about these query strings that can't
be
>made static with additional parameters?

HTH,
Mythran



Mar 17 '07 #4

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

Similar topics

3
1478
by: Michael | last post by:
Hi, I have a map and I want to save it to disk. What is the most efficient method of doing this? As i understand it, maps are stored as a binary tree. Is it balanced or is this implementation dependant? My first thoughts were to iterate through all the entries and just output the string and number to a text file, but when its read in again, if it's balanced then its going to have to do an awful lot of rebalancing as items are re-added!...
2
1624
by: jim_geissman | last post by:
I would like to save a query plan (estimated or actual) created in Query Analyzer -- paste it into a document, or simply print. It doesn't seem to be possible to select and copy the Execution Plan window, and printing it creates microscopic gibberish which is a waste of paper. Is it possible to do this? Set showplan_text is of limited help for the SP I'm looking at -- while analyzing the SP, it reads ahead and complains that a temp...
1
1635
by: MIchael McDowell | last post by:
Anyidea how this might be done using and XML Web Service and the XMLSerialzation class? A pointer to an online example would be deeply appreciated. Thankyou in advance, Michael McD
7
2374
by: MacDermott | last post by:
For a client who wants answers, but doesn't want to bother to learn Access, I've built a cut-down query generator, where they can select fields and criteria. I then compose the appropriate SQL SELECT statement and assign it to a fixed query name. ( qryTemp.SQL= MySQLString) qryTemp is the SourceObject for a subform on a form which I then open. (Note that the query itself is the source object, not a form based on it.) So far, this works...
4
3104
by: tt40 | last post by:
Anyone know how to prevent Access 2002 from automatically breaking all the incorrect joins in a query and then automatically saving the broken query? This is what I would call stupid design behaviour...Access takes your 'broken' query and auto saves it as what I call a 'corrupt' query... 1. Rename some BE tables and attributes 2. Open your FE 3. Open a query in design view that you know to now have broken names
4
3133
by: ulaskaraoz | last post by:
Hi, I have a std::map instance that I want to save into harddisk so that I donot have to recompute it each time. The map itself is keyed by a string and the values are pointers to other objects. Is it possible the whole data structure so that it can be loaded later? Thanks
2
2940
by: Tal Shachar | last post by:
Hi, I have a windows application that needs to save some user preferences to an xml and to load it on the next application run. Saving the preferences is done per user. I know that there is a way of saving it to some path under "Documents and Settings/UserName/...." , but I don't know the correct approach (e.g. path naming convention, how to preserve this per user, etc.) I can use all the assistance I can get (code snippets and some...
17
2751
by: NeoAlchemy | last post by:
I am starting to find more web pages that are using a query parameters after the JavaScript file. Example can be found at www.opensourcefood.com. Within the source you'll see: <script src="/shared/scripts/common.js?revision=1.6" type="text/javascript">. I am trying to see if there is any big deal to this or a best practice that is starting to creep up in the JavaScript community. If this is used only as a way to distinguish what...
5
2332
by: Just_a_fan | last post by:
I tried to put an "on error" statement in a routine and got the message that I cannot user "on error" and a lamda or query expression in the same routine. Help does not list anything useful for explaining a "lamda" expression and so I don't know what one is and I am not doing any database stuff in the entire program. So what does this error message really mean and what can I do to get an On Error into the routine?
0
9923
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10709
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...
1
10806
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
7939
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
7104
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
5773
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4592
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
4189
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3214
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.