how to store data without creating tables

Question

0.00/5 (No votes)

See more:

Hi,

I have 2 text boxes and one button.When i enter value in textbox it should fetch the details from DB and store that row.Again when i search for a product the previous searched product should also be displayed (In Gridview).

How do i achieve this without creating a table in database ??

Posted 4-Feb-14 0:33am

Challa92

Add a Solution

Comments

astika 4-Feb-14 6:36am

what is your problem?explain in detail

Challa92 4-Feb-14 6:44am

I need to save data without creating a Table in database!

Basically i need to search products quantity vise and store them at a place without manipulating the database.

the products searched should be displayed in gridview(i know how to display it though)
Problem is where to store them??

3 solutions

Solution 2

Is this search just meant to be per-session, or must the same set of values be available for all users? If it's per-session, then just store the results in the Session. If it's meant to be for all users, store the results in the Cache.

Posted 4-Feb-14 0:53am

Pete O'Hanlon

Solution 3

CPallini's solution will work.

However, just in case you are talking about too many such records then may be you want to look at storing in an XML temporarily and keep displaying the data from this XML on the Datagrid.

What I mean is:
1. Fetch the search result first time from the DB and display. Also write it into the XML.
2. On the 2nd search event fetch the results from the DB, add it to the XML and then display from this XML.

Please note that this is only if there are many such operations on your site. Otherwise an in-memory data table is sufficient.

Posted 4-Feb-14 0:54am

CoderPanda

Updated 4-Feb-14 1:09am

v2

Comments

Challa92 4-Feb-14 7:02am

How do i retrieve data from database to xml??

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CPallini · Accepted Answer · 2014-02-04T00:51:00

Solution 1

You could create a in-memory DataTable and bind the latter to the GridView.

Posted 4-Feb-14 0:51am

CPallini