|
As you've posted no code i'll assume you are loading the entire database table into a System.Data.DataTable and using the Select method to do your filtering. If this is the case, then what you really want to be doing is writing the query such that any filtering of data is done in the database and only the results loaded into the datatable.
Your options for this are limited in Access to using the LIKE keyword in your query.
SELECT * FROM myTable WHERE myColumn LIKE '%something%'
|
|
|
|
|
Right, im fairly new to this so here goes trying to explain a little more...
I load all of the data into the app using tableadapter.Fill as there is data to be refrenced and displayed, but i have created a querey using the dataset designer then i load it using the tableadpater.quereyname. That runs ok but then i have to reload the information back in so it will display all the data. Thats the bit that really takes the time.
I was thinking that surely there is a way that it loads the information once but then when you search it will simply hide records that do not match what your searching for, a filter rather than a search? That way, when you display all the data, it simply removes the filter.
Is that clear what im trying to acheive? Am i way off here?
below is a bit of the code im using....
To get all the data....
this.tecTableAdapter.Fill(this.tecDataSet.History);
Then to search....
this.tecTableAdapter.SearchN(this.tecDataSet.History, sn.Text);
|
|
|
|
|
Seeing as I have no clue what tecTableAdapter represents the code is pretty useless. (I was going to assume it was something like a SqlDataAdapter but that does not have a method SearchN)
However it is clear enough what you are trying to do, just not very clear where you have a problem. If you want to display all the data and it takes too long to load then don't show all the data all in one go. Load up, say, a page of 100 records at a time.
|
|
|
|
|
Hello,
I have a data table which has multiple columns. I want to create another data table with only selected columns.
For Example
If my datatable1 has below columns:
Emp no, Name, Age, Date Of Birth, Join Date
I want to create another datatable with below columns
Name, Age, Date Of Birth
I do not want to loop the datatable and insert the values in another datatable.
Please suggest an optimized way of doing it.
Regards,
Pavas
|
|
|
|
|
mpavas wrote: I have a data table which has multiple columns. I want to create another data table with only selected columns.
For Example
If my datatable1 has below columns:
Emp no, Name, Age, Date Of Birth, Join Date
I want to create another datatable with below columns
Name, Age, Date Of Birth
I do not want to loop the datatable and insert the values in another datatable.
If the destination table already exists, look up the INSERT INTO command... otherwise you might want to look up SELECT INTO
|
|
|
|
|
COULD YOU help me to get a sample for any one of them!
Regards,
Pavas
|
|
|
|
|
Hi,
Iam new to C#.Net. Can anyone help how to write wrapper classes for Streaming media player in C#, and any sample programs on wrapper classes.
|
|
|
|
|
prince nani wrote: any sample programs on wrapper classes.
A wrapper class is usually where a piece of non-OO functionality is wrapped encapsulated in a class so that the callers of the class don't have to deal with the non-OO implementation. There are many classes in the .NET Framework that are wrapper classes around parts of the Win32 API.
You can also get wrapper classes where the class encapsulates complex, but repeated, set of functionality from one or more other classes into a single place. In this case, it would more accurately be called a Façade. The My namespace in VB.NET contains many façade classes.
|
|
|
|
|
To furher add an item to the list, let's mention the Adapter pattern, that is, at the end, a wrapper class.
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
[my articles]
|
|
|
|
|
I have question regarding the datarow(might be silly one)
1) When we create a datarow object from database with certain data, how can we verify that the data is properly loaded in datarow object.
2)In window application, I am filling up a listview with data from DB, Now database is updating regularly. So, i also want that listview reflect the chages accordingly.(like refresh)
How can i acheive this in window application?
|
|
|
|
|
using i want to restrict entering symbols except the "." (dot) how acn i do this ?
|
|
|
|
|
use key handler
regards sindhu tiwari
its me sid
|
|
|
|
|
What? How does this answer the OP? He's asked for a regular expression not gibberish.
|
|
|
|
|
The regular expression "^[^\.]+$" matches a string that is at least one character and has no periods.
Experience is the sum of all the mistakes you have done.
|
|
|
|
|
This regular expression gets all ordinary characters plus the . character.
\w*\.*
|
|
|
|
|
|
|
if (char.IsNumber(e.KeyChar) == false)
{
e.Handled = true;
}
write this in the key press event on a textBox then it will allow only integers
i hope it is useful to u.....![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
its me sid
|
|
|
|
|
Hi,
Consider the following class:
class A{<br />
private int i;<br />
private int j=8;<br />
private int k;<br />
{<br />
int i =j;<br />
}<br />
public Test1a(int k)<br />
{<br />
this.k=k<br />
}<br />
}
...
program is not complie why?
|
|
|
|
|
Because you missed a semicolon after this.k=k?
Regards,
mav
--
Black holes are the places where God divided by 0...
|
|
|
|
|
this.k=k; ......... now
I AM WORKING ON "PLOTTER ROBOT"(FYP).
|
|
|
|
|
Just curious: But didn't the compiler tell you that there was a missing semi-colon? If not what did it say?
|
|
|
|
|
Argghhhh - it was an examination question. Really, do we want numpties like this unleashed on the workforce if they can't spot something simple like this?
|
|
|
|
|
Pete O'Hanlon wrote: Really, do we want numpties like this unleashed on the workforce if they can't spot something simple like this?
In the OP's defence *takes own temperature*, before the compiler warned about missing semi-colons I could be looking at the screen for ages before spotting it. This was especially true in Borland's Turbo C++ (The fist C++ compiler that I used which was DOS based) as it would find fault with everything after the line with the missing semi-colon because it would just get really confused. And I spent ages tracking down dozens of errors that didn't exist.
However, given the small size of the code, it should be easy to spot a missing semi-colon.
|
|
|
|
|
Colin Angus Mackay wrote: This was especially true in Borland's Turbo C++ (The fist C++ compiler that I used which was DOS based) as it would find fault with everything after the line with the missing semi-colon because it would just get really confused. And I spent ages tracking down dozens of errors that didn't exist.
Ah, but experience in those days used to show that clearing one error would normally clear a couple of hundred errors, which was why I always used to start at the errors at the top of the failure to see if they could be the culprit. 9 times out of 10, the error was in the top 2.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
