Lock Records

I apologize for the cross post but I am using ADO.NET methods and such to
access SQL and I am thinking perhaps both sides will have valuable input for
this.
I have two tables one called QUOTEINFO and one called QUOTEITEMS. One
contains the specifics of the quote and the others contain the actual items
in the quote.
If someone calls up a quote I need to somehow find a way to prevent another
user from modifying the same quote while the other user has it.
I thought about an additional column such as "LOCKED" in QUOTEINFO that
would if the other user attempted to modify the record it would not allow
it. Changing the LOCKED value would be easy enough when they first enter. I
worry though the user may not communicate back to the database though that
they are not finished. (program crash and such.)
Also, once the locking and unlocking is set, I would like to find a way to
record the username of the person locking the quote so I can tell the other
user who is locked out who has locked the quote. That after the lock issue
is resolved will probably be pretty easy.
If it helps, I own the "The Guru's Guide To Transact-SQL" by Ken Henderson
and the ADO.NET book by Sceppa if you know of references within them that
may help.
Sorry to dump all of this on you guys. I just don't know how to handle this.
kelly
KellySELECT <column lists> FROM Table (UPDLOCK)
This lock hint will not block others from reading the data , it ensures
that data has not changed since you last read it
Also use BEGIN TRAN
COMMIT to wrap transactions
"scorpion53061" <scorpion_53061@.nospamhereyahoo.com> wrote in message
news:eAEaA7WUFHA.928@.TK2MSFTNGP15.phx.gbl...
> I apologize for the cross post but I am using ADO.NET methods and such to
> access SQL and I am thinking perhaps both sides will have valuable input
for
> this.
>
> I have two tables one called QUOTEINFO and one called QUOTEITEMS. One
> contains the specifics of the quote and the others contain the actual
items
> in the quote.
>
> If someone calls up a quote I need to somehow find a way to prevent
another
> user from modifying the same quote while the other user has it.
>
> I thought about an additional column such as "LOCKED" in QUOTEINFO that
> would if the other user attempted to modify the record it would not allow
> it. Changing the LOCKED value would be easy enough when they first enter.
I
> worry though the user may not communicate back to the database though that
> they are not finished. (program crash and such.)
>
> Also, once the locking and unlocking is set, I would like to find a way to
> record the username of the person locking the quote so I can tell the
other
> user who is locked out who has locked the quote. That after the lock issue
> is resolved will probably be pretty easy.
>
> If it helps, I own the "The Guru's Guide To Transact-SQL" by Ken Henderson
> and the ADO.NET book by Sceppa if you know of references within them that
> may help.
>
> Sorry to dump all of this on you guys. I just don't know how to handle
this.
>
> kelly
>
> Kelly
>|||Would you mind giving a little more detail on this on how to go about doing
this? What you are saying sounds promising.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:urwb7AXUFHA.3544@.TK2MSFTNGP12.phx.gbl...
> SELECT <column lists> FROM Table (UPDLOCK)
> This lock hint will not block others from reading the data , it ensures
> that data has not changed since you last read it
> Also use BEGIN TRAN
> COMMIT to wrap transactions
>
> "scorpion53061" <scorpion_53061@.nospamhereyahoo.com> wrote in message
> news:eAEaA7WUFHA.928@.TK2MSFTNGP15.phx.gbl...
> for
> items
> another
> I
> other
> this.
>|||use a timestamp/rowversion field, retrieve this with the rest of the record,
when you update use the timestamp value in the where clause, if the record
has been changed by someone else the update fails ( you refresh the data and
present it to the user again for them to re-edit ), if the update works
no-one touched the record since the first user picked it up, thus you are
safe to update it. A timestamp/rowversion field will automatically populate
(on insert) and automatically change its value on update.
"scorpion53061" <scorpion_53061@.nospamhereyahoo.com> wrote in message
news:eAEaA7WUFHA.928@.TK2MSFTNGP15.phx.gbl...
>I apologize for the cross post but I am using ADO.NET methods and such to
>access SQL and I am thinking perhaps both sides will have valuable input
>for this.
>
> I have two tables one called QUOTEINFO and one called QUOTEITEMS. One
> contains the specifics of the quote and the others contain the actual
> items in the quote.
>
> If someone calls up a quote I need to somehow find a way to prevent
> another user from modifying the same quote while the other user has it.
>
> I thought about an additional column such as "LOCKED" in QUOTEINFO that
> would if the other user attempted to modify the record it would not allow
> it. Changing the LOCKED value would be easy enough when they first enter.
> I worry though the user may not communicate back to the database though
> that they are not finished. (program crash and such.)
>
> Also, once the locking and unlocking is set, I would like to find a way to
> record the username of the person locking the quote so I can tell the
> other user who is locked out who has locked the quote. That after the lock
> issue is resolved will probably be pretty easy.
>
> If it helps, I own the "The Guru's Guide To Transact-SQL" by Ken Henderson
> and the ADO.NET book by Sceppa if you know of references within them that
> may help.
>
> Sorry to dump all of this on you guys. I just don't know how to handle
> this.
>
> kelly
>
> Kelly
>|||Hi
Start with this article
http://www.sql-server-performance.c...sql_locking.asp
Well, try do soem searching on internet about such kind of issues
Also , you can add to the table a column with ROWVERSION (TIMESTAMP)
datatype
Now , when the user calls for the data save athe value of this column on the
client and compare the value with the value that in the database just
before the user wants to update the row. If the value on the client and a
value in the database are different raise the message that the row was
update by someone
I know you are looking for locks and lock by whom it is worth to take a look
on above example
"scorpion53061" <scorpion_53061@.nospamhereyahoo.com> wrote in message
news:uYlBoFXUFHA.4092@.TK2MSFTNGP12.phx.gbl...
> Would you mind giving a little more detail on this on how to go about
doing
> this? What you are saying sounds promising.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:urwb7AXUFHA.3544@.TK2MSFTNGP12.phx.gbl...
to
input
allow
enter.
that
>|||See if this helps:
Broadcasting Messages to Multiple Clients
http://msdn.microsoft.com/vbasic/us...net06082004.asp
AMB
"scorpion53061" wrote:

> I apologize for the cross post but I am using ADO.NET methods and such to
> access SQL and I am thinking perhaps both sides will have valuable input f
or
> this.
>
> I have two tables one called QUOTEINFO and one called QUOTEITEMS. One
> contains the specifics of the quote and the others contain the actual item
s
> in the quote.
>
> If someone calls up a quote I need to somehow find a way to prevent anothe
r
> user from modifying the same quote while the other user has it.
>
> I thought about an additional column such as "LOCKED" in QUOTEINFO that
> would if the other user attempted to modify the record it would not allow
> it. Changing the LOCKED value would be easy enough when they first enter.
I
> worry though the user may not communicate back to the database though that
> they are not finished. (program crash and such.)
>
> Also, once the locking and unlocking is set, I would like to find a way to
> record the username of the person locking the quote so I can tell the othe
r
> user who is locked out who has locked the quote. That after the lock issue
> is resolved will probably be pretty easy.
>
> If it helps, I own the "The Guru's Guide To Transact-SQL" by Ken Henderson
> and the ADO.NET book by Sceppa if you know of references within them that
> may help.
>
> Sorry to dump all of this on you guys. I just don't know how to handle thi
s.
>
> kelly
>
> Kelly
>
>|||Kelly,
What you want to do is pessimistic concurrency.
It is not standard in ADONET because that is the main difference between
connected and disconnected. Have a look in this newsgroup for it (not that
terrible much messages)
http://groups-beta.google.com/group...arch+this+group
When you real find it important, and it is ASPNET with what you are busy
with, than I would look as well (when you find all the methods proposed with
ADODB for that to difficult) for ADODB where it was more or less the
standard behaviour. Although I would avoid it as much as possible.
I hope this helps,
Cor|||What you are talking about is a pattern called Offline Optimistic Concurrenc
y
(Fowler). The best way is to maintain the offline nature of data retrieval (
get
data, disconnect) and instead check whether the data has changed since you l
ast
retrieved it (As Mark suggested). For this you can use something like timest
amps
or complicated updates statements where you check previously retrieved value
against the same values in the database.
If you need an indicator to the users that someone has the quote "checked ou
t"
ala a SCM program like SourceSafe. Then this will not work. For that I would
recommend using the Offline Pessimistic Lock (Fowler) pattern. In this
situation, you set a flag on the database when you "open" the quote. When
someone else reads that row, they get the data read only. The problem with t
his
scenario is that it gets complicated having to deal with "lock and walk away
"
scenario. The "lock and walk away" is more difficult in that it requires the
ability of an administrator to come in remove the lock and/or lock leases th
at
expire if not renewed after a certain time.
As you can see, this is a very complicated route to take and I would only ta
ke
if absolutely necessary. If there are ways to code around the possibility of
two
people working on the same quote, then do it. It will be easier and faster t
o
develop in the long run.
Thomas
"scorpion53061" <scorpion_53061@.nospamhereyahoo.com> wrote in message
news:eAEaA7WUFHA.928@.TK2MSFTNGP15.phx.gbl...
>I apologize for the cross post but I am using ADO.NET methods and such to
>access SQL and I am thinking perhaps both sides will have valuable input fo
r
>this.
>
> I have two tables one called QUOTEINFO and one called QUOTEITEMS. One cont
ains
> the specifics of the quote and the others contain the actual items in the
> quote.
>
> If someone calls up a quote I need to somehow find a way to prevent anothe
r
> user from modifying the same quote while the other user has it.
>
> I thought about an additional column such as "LOCKED" in QUOTEINFO that wo
uld
> if the other user attempted to modify the record it would not allow it.
> Changing the LOCKED value would be easy enough when they first enter. I wo
rry
> though the user may not communicate back to the database though that they
are
> not finished. (program crash and such.)
>
> Also, once the locking and unlocking is set, I would like to find a way to
> record the username of the person locking the quote so I can tell the othe
r
> user who is locked out who has locked the quote. That after the lock issue
is
> resolved will probably be pretty easy.
>
> If it helps, I own the "The Guru's Guide To Transact-SQL" by Ken Henderson
and
> the ADO.NET book by Sceppa if you know of references within them that may
> help.
>
> Sorry to dump all of this on you guys. I just don't know how to handle thi
s.
>
> kelly
>
> Kelly
>|||Kelly
Some corrections on what I wrote.

> When you real find it important, and it is ASPNET with what you are busy
> with, than I would look as well (when you find all the methods proposed
> with ADODB for that to difficult)
ADONET for that to difficult
It are not that terrible many messages

Lock Question - Should I delete them all??

I have SQL Server 2000 and ASP.NET applications running. It was brought to my attention that some of my applications hitting one of my databases was Timing Out. After a little bit of troubleshooting, I found out it was due to some Locks that existed on my database. I have since then 'Killed Process' and everything seems to be working.

What I did was go to Enterprise Manager, picked the Server --> Management --> Current Activity --> Locks/Object and then found 2 IDs that needed to be killed.

Since then there aren't any hang-ups, but I have noticed under Locks/Objects there are many Process IDs in there. Is it good to Kill all of them? How dangerous is this? All of these processes have the following attributes:

Lock Type = DB
Mode = S
Status = GRANT
Ownder = Sess

I have read BOL and other literature, but can't seem to get the answer I am looking for. And who the heck is Sess?

Your assistance will be greatly appreciated.Don't be worried about this lock, this lock is necessary and you should not kill this process. It is a required System process. The mode is 'S' which menas Shared this is not a strong lock and will not cause deadlocks, so don't worry.

LocalReport: Object-in-Object as DataSource not working?

Hi,
I have a Report (VB.NET 2005), and I'm using Objects as DataSource.
I have the object objCompany, which contains a public property MyAdress
(instance of objAdress). objAdress has a propert Street.
When I add objCompany as a DataSource, I want to be able to show the
Street-property of MyAdress. So I do a drag-and-drop of that property from
the Data Sources - Window to the Report. Everything seems fine: I get a
textbox on my report with Value "=First(Fields!Street.Value,
"MyApplication_objCompany")".
But when I run the report, it doesn't show any value in it...
Does anybody knows why this happens? I somehow think because of the fact
that Street isn't directly on MyApplication_objCompany, but when I change it
into MyApplication_objCompany_MyAdress is complains about the fact that it
doesn't exist...
How should I do this?
Thanks a lot in advance,
PieterI found the solution here for nested objects and reporting services
localreport in the reportviewer:
http://www.gotreportviewer.com/objectdatasources/index.html
Apparently I have to do something like "=First(Fields!MyAdress.Value.Street,
"MyApplication_objCompany")".
It gave me these 2 errors:
The Value expression for the textbox 'Adresse' refers to the field
'ReportAdresse'.
Report item expressions can only refer to fields within the current data set
scope or, if inside an aggregate, the specified data set scope.
The Value expression for the textbox 'textbox19' has a scope parameter that
is not valid for an aggregate function.
The scope parameter must be set to a string constant that is equal to either
the name of a containing group, the name of a containing data region, or the
name of a data set.
But sddenly it started to work...
strange... :-/
"Pieter" <pietercoucke@.hotmail.com> wrote in message
news:u64%23GAkiGHA.1204@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have a Report (VB.NET 2005), and I'm using Objects as DataSource.
> I have the object objCompany, which contains a public property MyAdress
> (instance of objAdress). objAdress has a propert Street.
> When I add objCompany as a DataSource, I want to be able to show the
> Street-property of MyAdress. So I do a drag-and-drop of that property from
> the Data Sources - Window to the Report. Everything seems fine: I get a
> textbox on my report with Value "=First(Fields!Street.Value,
> "MyApplication_objCompany")".
> But when I run the report, it doesn't show any value in it...
> Does anybody knows why this happens? I somehow think because of the fact
> that Street isn't directly on MyApplication_objCompany, but when I change
> it into MyApplication_objCompany_MyAdress is complains about the fact that
> it doesn't exist...
> How should I do this?
> Thanks a lot in advance,
> Pieter
>

LocalReport.Render creates PDFs 10x the size of RS 2000

I'm using LocalReport.Render to create PDFs from my VB.Net 2005 application.
The resulting PDF is about 10x the size of the same report rendered from RS
2000. Looking inside the generated PDF file, I see that the main body of the
report is no longer using any compression.
Is there any way to force LocalReport.Render to use the compression that RS
2000 was using?This is a known bug:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=134219&SiteID=1
--
Robert Jeppesen
Durius
http://www.durius.com/
"davedave" <davedave@.discussions.microsoft.com> wrote in message
news:7929FEFC-3427-4864-A817-B3A83269F92D@.microsoft.com...
> I'm using LocalReport.Render to create PDFs from my VB.Net 2005
> application.
> The resulting PDF is about 10x the size of the same report rendered from
> RS
> 2000. Looking inside the generated PDF file, I see that the main body of
> the
> report is no longer using any compression.
> Is there any way to force LocalReport.Render to use the compression that
> RS
> 2000 was using?

localization and RS

Hi,
i want to make a report which could be called in several countries.
My question is, what kind of regional settings do RS use ?
I tried the VB.NET Functions FormatCurrency etc and i
set the regional settings on (server + client) from german to english,
but the currency value is still in german format...
example:
German currency format: 99.999, 99
English format: 99,999. 99
How can i solve this problem?
regards
PatrickWould be nice if someone got an idea!
"Patrick Ruhnow" <pruhnow@.dornbracht.de> schrieb im Newsbeitrag
news:%23rdstRlbEHA.3512@.TK2MSFTNGP12.phx.gbl...
> Hi,
> i want to make a report which could be called in several countries.
> My question is, what kind of regional settings do RS use ?
> I tried the VB.NET Functions FormatCurrency etc and i
> set the regional settings on (server + client) from german to english,
> but the currency value is still in german format...
> example:
> German currency format: 99.999, 99
> English format: 99,999. 99
>
> How can i solve this problem?
> regards
> Patrick
>|||Yes, just set the language property on the entire report or on individual
textboxes. If you set the report language to "Default", then the language
during execution will depend on the requesting client (e.g. in IE: Tools -
Internet Options - Languages). More details on localization are available in
BOL:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_building_v1_31bn.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0vaa.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Patrick Ruhnow" <pruhnow@.dornbracht.de> wrote in message
news:uBz%23$WtcEHA.1764@.TK2MSFTNGP10.phx.gbl...
> Would be nice if someone got an idea!
> "Patrick Ruhnow" <pruhnow@.dornbracht.de> schrieb im Newsbeitrag
> news:%23rdstRlbEHA.3512@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > i want to make a report which could be called in several countries.
> > My question is, what kind of regional settings do RS use ?
> > I tried the VB.NET Functions FormatCurrency etc and i
> > set the regional settings on (server + client) from german to english,
> > but the currency value is still in german format...
> >
> > example:
> > German currency format: 99.999, 99
> > English format: 99,999. 99
> >
> >
> > How can i solve this problem?
> >
> > regards
> > Patrick
> >
> >
>

Localizable Data in a SQL Database

Hello all,
I'm working on an ASP.NET with a SQL server for database. Some of the tables, for example, contain information such as different types of Fabrics (silk, cotton, etc..) . I'd like to have this table localizable (English and French for instance).

Is this possible ? Is there an equivalent of resource files in SQL server ?
Or do I have to do this manually ? (have 2 separate fields in the table for those 2 locales)

SQL Server provides the storage structure, but it doesn't do anything for translating. You will have to translate the data, provide different columns for it, and select the appropriate column based on a locale in your application

localhost is not mapped to server name

Hi,
It is a long time that I have been using my box and have some .NET apps
running on it which use a connection string with Server=localhost and I have
not had any problem yet. Today I have updated my box Windows with recent
HotFixes (well I am not 100% sure it is the reason of this problem) and
after that my applications can not login database, and get this exception
"System.Data.SqlClient.SqlException: SQL Server does not exist or access
denied".
When I changed server name from localhost to real server name they are
working properly.
Any advice is welcomed.
Thanks
Mike(local) instead of localhost
2005 Microsoft MVP C#
Robbe Morris
http://www.masterado.net
http://www.mastervb.net
"masoud bayan" <masoud_bayan@.hotmail.com> wrote in message
news:ujOrVWe7EHA.3644@.TK2MSFTNGP09.phx.gbl...
> Hi,
>
> It is a long time that I have been using my box and have some .NET apps
> running on it which use a connection string with Server=localhost and I
> have
> not had any problem yet. Today I have updated my box Windows with recent
> HotFixes (well I am not 100% sure it is the reason of this problem) and
> after that my applications can not login database, and get this exception
> "System.Data.SqlClient.SqlException: SQL Server does not exist or access
> denied".
> When I changed server name from localhost to real server name they are
> working properly.
>
> Any advice is welcomed.
>
> Thanks
> Mike
>
>

localhost is not mapped to server name

Hi,
It is a long time that I have been using my box and have some .NET apps
running on it which use a connection string with Server=localhost and I have
not had any problem yet. Today I have updated my box Windows with recent
HotFixes (well I am not 100% sure it is the reason of this problem) and
after that my applications can not login database, and get this exception
"System.Data.SqlClient.SqlException: SQL Server does not exist or access
denied".
When I changed server name from localhost to real server name they are
working properly.
Any advice is welcomed.
Thanks
Mike
(local) instead of localhost
2005 Microsoft MVP C#
Robbe Morris
http://www.masterado.net
http://www.mastervb.net
"masoud bayan" <masoud_bayan@.hotmail.com> wrote in message
news:ujOrVWe7EHA.3644@.TK2MSFTNGP09.phx.gbl...
> Hi,
>
> It is a long time that I have been using my box and have some .NET apps
> running on it which use a connection string with Server=localhost and I
> have
> not had any problem yet. Today I have updated my box Windows with recent
> HotFixes (well I am not 100% sure it is the reason of this problem) and
> after that my applications can not login database, and get this exception
> "System.Data.SqlClient.SqlException: SQL Server does not exist or access
> denied".
> When I changed server name from localhost to real server name they are
> working properly.
>
> Any advice is welcomed.
>
> Thanks
> Mike
>
>

Locale stuff

Hi,

You might just be able to save me downloading and installing SQL Server French...

I'm having localization problems with some .NET code - and I might be able to solve the problem if I know how SQL is parsed in different locales. Say my table MyTable contains a float column FloatColumn. In English, I would say
SELECT * FROM MyTable WHERE FloatColumn = 2.3

If my locale was, say for argument's sake, French, would I have to write
SELECT * FROM MyTable WHERE FloatColumn = 2,3
?

Thanks for your help,
TI prefer to dodge this bullet altogether, and make .NET do the work. Use a question mark in your query rather than a constant, and (if necessary) code the constant into your application. A bit messy, but it gets around the localization problems.

-PatP

Local reports with ADO.NET Dataset help

I'm trying to use a local report in a Windows Forms application that
uses an ado.net dataset. The trouble is that I'm trying to figure out
how to access data within related tables. If the dataset has a table
called Customers with two records in it, how do I go about displaying
the data from a particular customer in a particular place? Can I choose
the row to show based upon a key in a separate table? That would be
ideal. Any ideas? I've searched and found no answers.
Thanks,
BrianHi Brian, I'm running with the same problem.
For some reason all I see it's one of the DataTable's data...
have you figured this out yet?
Best regards,
Sebasti=E1n
On Oct 26, 8:18 pm, Brian Vallelunga <brian.vallelu...@.gmail.com>
wrote:
> I'm trying to use alocalreport in a Windows Forms application that
> uses an ado.netdataset. The trouble is that I'm trying to figure out
> how to access data within related tables. If the dataset has a table
> called Customers with two records in it, how do I go about displaying
> the data from a particular customer in a particular place? Can I choose
> the row to show based upon a key in a separate table? That would be
> ideal. Any ideas? I've searched and found no answers.
> > Thanks,
> > Brian|||I started to look into local reports and decided it was a pain for this very
reason. However, I do know what you need to do conceptually. Nothing has
changed as far as how to solve the problem in the design of the reports. A
server report can be turned into a local report (you just rename the rdl
file to rdlc). Indeed, my suggestion on how to develop is to develop inside
the report designer (even if no server you can design and preview). Then
once working bring it into you app.
Now, in RS the way you handle master detail is by sub reports. That has not
changed. For local reports you have to do the same thing. You have to tie
into an event in the sub report to take the parameter and give the sub
report the appropriate data. So, let's say that you have a dataset all
populated. The main report is tied to the data table for the master. Then
you have the sub report and you tie the subreport parameter to a field of
the master table record. In the event you then would need to filter the
appropriate data table and set the source of the subreport to that. Note
that this event will be called for each record in the master.
Hope this helps at least conceptually on what you need to do.
After seeing all the hoops I would have to go through, I decided to stay
with server based reports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<sebastiangomezcorrea@.gmail.com> wrote in message
news:1162385028.994774.52040@.k70g2000cwa.googlegroups.com...
Hi Brian, I'm running with the same problem.
For some reason all I see it's one of the DataTable's data...
have you figured this out yet?
Best regards,
Sebastián
On Oct 26, 8:18 pm, Brian Vallelunga <brian.vallelu...@.gmail.com>
wrote:
> I'm trying to use alocalreport in a Windows Forms application that
> uses an ado.netdataset. The trouble is that I'm trying to figure out
> how to access data within related tables. If the dataset has a table
> called Customers with two records in it, how do I go about displaying
> the data from a particular customer in a particular place? Can I choose
> the row to show based upon a key in a separate table? That would be
> ideal. Any ideas? I've searched and found no answers.
> Thanks,
> Brian|||Hey Bruce, thanks for the reply.
Even though I'm working with local reports, I have to ask... how do you
do what I'm trying with rdl reports? Is there some kind of wizzard or
something?
TIA
On Nov 1, 12:08 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> I started to look into local reports and decided it was a pain for this v=ery
> reason. However, I do know what you need to do conceptually. Nothing has
> changed as far as how to solve the problem in the design of the reports. A
> server report can be turned into a local report (you just rename the rdl
> file to rdlc). Indeed, my suggestion on how to develop is to develop insi=de
> the report designer (even if no server you can design and preview). Then
> once working bring it into you app.
> Now, in RS the way you handle master detail is by sub reports. That has n=ot
> changed. For local reports you have to do the same thing. You have to tie
> into an event in the sub report to take the parameter and give the sub
> report the appropriate data. So, let's say that you have a dataset all
> populated. The main report is tied to the data table for the master. Then
> you have the sub report and you tie the subreport parameter to a field of
> the master table record. In the event you then would need to filter the
> appropriate data table and set the source of the subreport to that. Note
> that this event will be called for each record in the master.
> Hope this helps at least conceptually on what you need to do.
> After seeing all the hoops I would have to go through, I decided to stay
> with server based reports.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <sebastiangomezcor...@.gmail.com> wrote in messagenews:1162385028.994774.5=2040@.k70g2000cwa.googlegroups.com...
> Hi Brian, I'm running with the same problem.
> For some reason all I see it's one of the DataTable's data...
> have you figured this out yet?
> Best regards,
> Sebasti=E1n
> On Oct 26, 8:18 pm, Brian Vallelunga <brian.vallelu...@.gmail.com>
> wrote:
>
> > I'm trying to use alocalreport in a Windows Forms application that
> > uses an ado.netdataset. The trouble is that I'm trying to figure out
> > how to access data within related tables. If the dataset has a table
> > called Customers with two records in it, how do I go about displaying
> > the data from a particular customer in a particular place? Can I choose
> > the row to show based upon a key in a separate table? That would be
> > ideal. Any ideas? I've searched and found no answers.
> > > Thanks,
> > > Brian- Hide quoted text -- Show quoted text -

Local processing, ReportViewer and PDF

I hope this is the right Newsgroup, if not I'd be glad for directions to the
right one.
Regarding the ReportViewer control shipped with VS.NET 2005 Beta 2, I've
seen that in local processing mode the only renderer is Excel. Does anybody
know if this will be like that also in the final version of VS.NET 2005 ?
Does anybody know any commercial PDF rendering extension for the
ReportViewer?
Thanks,
Ethem AzunAfter writing this, I just run into these;
http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=b5f3f1cf-4614-474e-b423-0fa9c35f09e1
http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=7acce9a3-35f5-4f6b-8789-236db4b45a03
Ethem Azun
"Ethem Azun" wrote:
> I hope this is the right Newsgroup, if not I'd be glad for directions to the
> right one.
> Regarding the ReportViewer control shipped with VS.NET 2005 Beta 2, I've
> seen that in local processing mode the only renderer is Excel. Does anybody
> know if this will be like that also in the final version of VS.NET 2005 ?
> Does anybody know any commercial PDF rendering extension for the
> ReportViewer?
> Thanks,
> Ethem Azun

Local mode in asp.net web app

Dear all,
Can i use local mode of reporting service in asp.net web application?yes, if you use VS2005 you can create and use RDLC reports based on your own
datasets.
no server required.
abd there is a webcontrol in the toolbox to render the report
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:2EBBBA15-EC80-417E-9755-071685810970@.microsoft.com...
> Dear all,
> Can i use local mode of reporting service in asp.net web application?

Local Database Access Issues

Hello,

I have a local SQL Server database installed with Visual Studio .NET. I'm trying to create a SQL Server login ID to access a database on this local database. I gave it access to all of the databases with public (the one I'm using it also has DBO and execute permissions on all procs). When I try to login to it through SQL Server Query Analyzer (and also using an ASP.NET application), I get the following error:

Login failed for 'dbuser'. Reason: Not associated with a trusted SQL Server connection.

How do I set up a SQL Server login to access the database?

Thanks,

Brianin Enterprise Manager if you xpand the databases tab and then YourDatabase theres a tab called Users. You can add the dbuser over there.

hth

Loading XML to SLQ Server

Whats the best way to load XML into SQL Server..
For example just a single XML file..
thanks
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
A previous post to the newsgroup:
"In SQL Server 2000 you have two main options - using the OPENXML technology
or using the SQLXML BulkLoad technology. Choosing between these two options
is largely a matter of personal choice in terms of what technologies you
feel most comfortable with. OPENXML is a technology that runs in the server
while and requires a reasonable level of familiarity with T-SQL. SQLXML
BulkLoad runs on the client and requires no T-SQL but you need to generate
an Annotated XSD to determine the mapping between the XML and the database.
One other thing to consider is the size of the data being loaded. OPENXML
loads the entire XML into memory on the server so if you are loading large
amounts of data you may want to go with a BulkLoad solution.
You can get more information on OPENXML in SQL BOL or online at
http://msdn.microsoft.com/library/de...oa-oz_5c89.asp
SQLXML documentation is at
http://msdn.microsoft.com/library/de...nch_SQLXML.asp
or you can check out http://www.sqlxml.org/ for some extra info on these
technologies."
I should also add that if you want to develop your application by using
..Net, you may want to use Dataset as well. Dataset has also a drawback of
loading all data into memory similar to OpenXml.
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:OKM$bJGoEHA.4068@.tk2msftngp13.phx.gbl...
> Whats the best way to load XML into SQL Server..
> For example just a single XML file..
> thanks
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.