For clarity: a DataView does not make a physical copy of data. The DataView
lays an efficient pointer structure over the top of the data which returns
the underlying data that matches the filter criteria in the appropriate
order. The filter and sort methods operate on pointers--not on the data. You
I agree with your approach here. Thank you for taking the time to offer me
suggestions. I think that this is the most promising and most reasonable
solution for what I am doing and based on the fact that I already have 8 of
the 12 written this way and the other 4 are mostly written this way. I a
Ignore this.. got ObjectDataSource confused with a ObjectDataReader ..
groan .
Regards ,
Ben
> -Original Message-
> From: Unmoderated discussion of advanced .NET topics.
[mailto:ADVANCED-
> [EMAIL PROTECTED] On Behalf Of Ben Kloosterman
> Sent: Thursday, 7 July 2005 10:33 AM
> To: ADVA
I believe so. That's why I have been leaning towards parsing the XML
myself. I am still looking at various ways to pull the
dataset/dataview/datatable apart as some of the posting have pointed out.
-Original Message-
From: Unmoderated discussion of advanced .NET topics.
[mailto:[EMAIL PR
I think filter which supports simple selects is the best you've got with a
dataset.
-Original Message-
From: Unmoderated discussion of advanced .NET topics.
[mailto:[EMAIL PROTECTED] On Behalf Of Pardee, Roy
Sent: Wednesday, July 06, 2005 9:31 AM
To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM
Sub
Most OR Mappers don't work like this either ... It forces the class to
be inherited from a base class which is worse than the problem.
ObjectDataSource is probably a poor mans objectspace which got pulled
from 2.0 and put in LongHorn , groan..
Ben
> -Original Message-
> From: Unmode
Personally I feel datasets completely fall down in complicated scenarios
.. I used to be a fan but experience has taught me otherwise. I still
use them for quick and dirties though .
For you scenario why even query ? Surely some simple code can filter the
data to what you need .
Ie foreach (Na
I'm bringing a couple of new people onto my construction project as
electricians. They are not familiar at all with electrical work and they
aren't really certain what they should be doing, and how they should be
doing it. Does anyone know of a good summary/how-to for electricians to get
them start
Good afternoon everyone,
I'm bringing a couple of new people into a project as testers. They are
not familiar with testing at all, and aren't really sure what they
should be doing, and how they should be doing it. Does anyone know of a
good summary/how-to for testers? I'm thinking about basic stuf
omg - that select statement!! LOL
So before I even explore that, my point is to actually persist the data in
an already queried format.
So backing up from your (omg ) query... and keeping in mind that you said
there will only be about 12 rows of data per table, why not do a query in
SQL that will
Julie,
I would very much like to take your approach. I am getting lost where you
say that you pick out what you need from the datatable. That is what I am
really struggling to do.
Take a look at my SQL select statement (below) that I am struggle to convert
to using a dataset or just XML parsing
In a Business Layer with Busines Entities with CRUD Behaviors (has
described here [1] at Cap. 'Defining Custom Business Entity Components with
CRUD Behaviors') typically
1) the Update() method have zero parameters
2) the Update() method is in a Business Entity class say Author, while the
SelectAuth
Bruises on forehead remind me that "not as sexy" falls short of the mark ;-)
Nobody has mentioned embedded databases. To the extent that these might support
ansi sql, your mileage may vary.
SQLite: http://www.sqlite.org
Firebird SQL http://firebird.sf.net/
Whether using jet or one the above, if
Can somebody help me understand the antipathy to jet here? Isn't the
amount of data contemplated here small enough?
You can no-touch deploy an app that uses jet as an offline cache--I
don't think you can do that with mssql (unless you know that all your
clients already have a valid mssql instal
Unmoderated,
If you want to skip them you can use [NonSerializable], but I suspect you
want to programatically figure it out. In that case, you'll need to
implement IXmlSerializable.
Thanks,
Shawn Wildermuth
http://adoguy.com
C# MVP, MCSD.NET, Author and Speaker
->-Original Message-
->
I agree
Unless the data set is small I wouldn't even entertain the idea of using a
dataset, Access/.mdb
More and more are going towards the use of an 'express/light' version of the
resource manager (RDBM) on the client side. SQL Server Express (desktop
version of SQL Server 2005) has built in fac
I wouldn't mess with ADOX (tho I imagine you could use com interop if
you really wanted to). I'd create it manually in msaccess (empty) as a
template & then do a file copy to create the new one. When connected,
you have one set of dataadapters that draw data from the db into your
dset, and anothe
I'd think installing a server db on client pcs for such a small amount
of data would be overkill (and wouldn't having the offline data in mssql
make it tough to update the structure of the client-side db?).
What's not to love about jet for this situation?
-Original Message-
From: Unmode
If his needs are for pocket sized computers (I don't recall that he stated
this), the compact framework version of SQL server might also be an option
for offline persistence of his SQL server data:
See: http://msdn.microsoft.com/SQL/SQLCE/default.aspx
I would recommend not using SQL and Jet for o
I thnk you are getting into muddy waters here, Jon.
I do something like what you are doing. Query from SQL Server, get datasets
and then persist those to xml on the local machine for offline use.
Some of the data is just lists and I can use them in their entirety. So my
SQL Query creates the resu
The only thing you'll need to look into in the future is VS2005 uses a
different ResourceManager subclass by default (when you set the Localizable
property to true) so when you switch to 2005, take a look at what it does to
make sure you'll still be able to compile.
Adam..
> -Original Message
I think we are on the same page now. Your first paragraph explains exactly
what I am wanting to do. I figure that I should just rebuild the MDB file
each time a sync event occurs between the client and server. Doing so
should keep any issues with the MDB file from being a problem. The only MDB
Adam Sills wrote:
> Then all of the properties of all of your controls are retrieved from the
> resource manager instead of being retrieved directly from the code
file. To
> hook in here, here's what I did:
>
> 1) create a non-visual component (class that derives from IComponent) and
> add it to e
How do you get access to ADOX, which seems to be the only way to create an
MDB file?
-Original Message-
From: Unmoderated discussion of advanced .NET topics.
[mailto:[EMAIL PROTECTED] On Behalf Of Pardee, Roy
Sent: Wednesday, July 06, 2005 11:31 AM
To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM
H... Well, maybe the thing to do is to code up a routine that will
simply slurp the authoritative data out of the db & stash it in a
client-side .mdb, and then do all your SQL wrangling against the local
copy. When your app detects that it's connected (or on some other
regular schedule that m
Hello experts,
Here is another interesting question. I have a simple class that is defined
like this:
public class BusinessCard
{
public string FirstName;
public string LastName;
public string Address;
}
when I am XML-serializing this I get something such as:
Lance
Armstrong
We have a similar branding process here, and to go the resource assembly
route all you'd need to do is create your own ResourceManager subclass. Are
you using the Localizable property of the controls to put everything into a
resx file or are you doing it by hand? (the Localizable property forces al
Good Afternoon,
I am in the process ofresearching ApplicationContext methods for a class I
am creating.
The run down is this:
1) I execute an .exefile.
2) It in turn runs aclass that I will call ApplicationContextMain
(creates the initialApplicationCont
I think my originally posting may have been a little confusing. I realize
that there is not SQL engine in ADO.Net, but there is
Dataset.Tables().Select(), which I guess is just another way to filter. I
simply wanted to point out what kind of work I need to do on the client
side. I need to recrea
I am not sure that's required. Anyway, I figured out what the difference
was. Although I said in my original message that I had anonymous access set
up in the directory security settings for my web service - apparently, that
was not active. After unchecking and rechecking that option, a call into t
Have a look at the config system. I think this will allow you to do what
you want
mark
-Original Message-
From: Unmoderated discussion of advanced .NET topics.
[mailto:[EMAIL PROTECTED] On Behalf Of Barnaby Gray
Sent: Wednesday, July 06, 2005 9:35 AM
To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM
Of course... you are using windows So this was an inappropriate
response... Doh!
> -Original Message-
> From: Bailey, Mark [mailto:[EMAIL PROTECTED]
> Sent: July 6, 2005 12:04 PM
> To: 'Unmoderated discussion of advanced .NET topics.'
> Subject: RE: [ADVANCED-DOTNET] Windows Form brand
Sorry if I misunderstood but it sounds similar to something we did here
(dynamically setting captions). Our approach was to use a user control.
E.g.
The control will use the page name it is on, and id to read its caption
from an xml file (using xpath), or in your case from whatever stores the
good point Paul. I guess it wasn't inferred
I do use xml to persist data for offline use in the way that Jon is asking
about. But the stored xml lines up with what would be returned from SQL in a
query, rather than lining up with the raw database itself.
Maybe a direction for Jon is to look at s
As a suggestion: Always perform your filtering and sorting on the client
dataset object (see the documentation for the DataView object) and fill your
dataset object from the complete set of rows needed when you are online.
That way you can have identical business logic and UI code. You do not want
Thanks for the reply,
Yea it answers my question. At least you are seeing
the line breaks. What
I see are no line breaks and one huge paragraph
bunched together. That's not
how I wrote it, so when I saw this I was concerned
that this is how it was
coming out. At least I know its on my end now,
I have a C# .NET application with lots of strings added through the
visual designer (thus stored in the form's .resx file) specifying the
application's company name and product name .
What I want to do is change all of these instances to tags, for example
or and then dynamically replace these t
Can someone verify my formatting on this email? Is it
me, or does this look
like I wrote in one big line with no paragraphs?
The email im talking about is the one directly below
here. Does it look
fine?
-Original Message-
From: Unmoderated discussion of advanced .NET topics.
[mailto:[EMA
There is no client-side SQL engine in ado.net. I think the thing that
comes closest is the jet engine (the thing that gets exercised when you
move data in & out of an .mdb file). Jet has a pretty nice
implementation of SQL, tho there are some annoying limitations
(subqueries come to mind).
I'd a
Jon-
this is a common misconception with people newly working with disconnected
data. SELECT is for querying against databases (such as SQL Server). Once
you have a data in your ADO.NET objects (eg DataSet, DataTable) you can do
things like filter and sort with a DataView, join tables with a
DataRe
I've doing what I would think would be a very common use of ADO.Net, but I
cannot find much info on this in any of my book or online. What I'm doing
seems pretty simple.
I have an app that can run in both a disconnted and connected state. When
it is disconnected, it is disconnected from the SQL
Is machineName\ASPNET a member of the domain that has access to the Web
resource?
Eduard Lascu <[EMAIL PROTECTED]> wrote:Hello everybody,
I have a Web Service that's hosted on one machine. There is a difference
between calling it from the same machine or from a different machine in the
network:
Look at the Assembly class within the System.Reflection namespace. It has a
property called GlobalAssemblyCache that is a boolean, indicating whether or
not the assembly is in the GAC.
Hope this helps!
Christopher Reed
Web Applications Supervisor
Information Technology
City of Lubbock
[EMAIL P
Can someone please advise me on how I can add logic that dynamically sets
the session state's CookieMode property to UseUri or UseCookies on a *per
user* basis?
In other words, depending on our business rules and logic, there are times
when I need to set a particular visitor's session to use the U
Hi all,
I have the path of some dlls like -
reference.Path
"C:\\WINDOWS\\Microsoft.NET\\Framework\\v2.0.50215\\System.Xml.dll"
reference.Path
"C:\\JaproTestPerforce\\JaproTestWorkspace\\MasterProject\\dev\\src\\_Ma
sterSub1Lib\\cs\\obj\\Debug\\MasterSub1Lib.dll"
> More painful than about 10 years of manual rewrites?
Many apologies, Jon. I did not mean to suggest that you should abandon your
question in pursuit of a doomed mega-rewrite. I agree that such a thing
would be, er, doomed. I only meant that the "backward channel" solution was
sufficiently pai
46 matches
Mail list logo
