Read single piece of data from SqlDataSource to a variable?

First I want to say thanks to the folks how have helped me over the past week or two.

I'm missing a crucial piece of insight. How do I read a single piece of data from a SqlDataSource which only hold one row of data into a declared variable?

string zUserName = SqlDataSource.(get the value in the row that is labeled UserName)

It really doesn't matter to me whether it is an SqlDataSource or some other data container that hold the data I've selected. My goal is to be able to read some data from some predefined datasource into a declared variable.

If I am approaching this problem in the wrong way any advice or article links you could give me would be grealy appreciate.

Thanks, Bill

It's not really meant to do that, but you CAN if you want to by binding the datasource to a hidden field, telling the hidden field to databind, and then picking up its value (Optionally resetting the hidden field to nothing again).

Really want you want is the sqlconnection and sqlcommand for that type of work. SqlDataSource is for populating UI controls with databinding.

Read Backup File Directly?

Is there a way to read a backup file to see if it contains a file without
restoring the backup file? We are missing a record from a table, and I need
to find out when it was deleted. We have nightly backup files of the
database. Is it possible, knowing the database name, the table name, and the
primary key value of the record, to determine if the record exists in a
certain backup file? If not, is there an alternate way to determine when a
particular record was deleted?

Thank you!

NeilNeil (nospam@.nospam.net) writes:

Quote:

Originally Posted by

Is there a way to read a backup file to see if it contains a file
without restoring the backup file?

You can use RESTORE FILELISTONLY to list the backups within a backup file.

Quote:

Originally Posted by

We are missing a record from a table, and I need to find out when it was
deleted. We have nightly backup files of the database. Is it possible,
knowing the database name, the table name, and the primary key value of
the record, to determine if the record exists in a certain backup file?

You need to restore the backup. But you could restore it under a different
name.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Right. I was just that, if I wanted to find out *when* it was deleted, I'd
have to restore the backups one at a time, and look at the database after
each restore to see if it were there.

Thanks,

Neil

"Erland Sommarskog" <esquel@.sommarskog.sewrote in message
news:Xns9955EDFCA1AF8Yazorman@.127.0.0.1...

Quote:

Originally Posted by

Neil (nospam@.nospam.net) writes:

Quote:

Originally Posted by

>Is there a way to read a backup file to see if it contains a file
>without restoring the backup file?

>
You can use RESTORE FILELISTONLY to list the backups within a backup file.
>

Quote:

Originally Posted by

>We are missing a record from a table, and I need to find out when it was
>deleted. We have nightly backup files of the database. Is it possible,
>knowing the database name, the table name, and the primary key value of
>the record, to determine if the record exists in a certain backup file?

>
You need to restore the backup. But you could restore it under a different
name.
>
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

RDLC...Printer Control

The icon in the preview bar is missing, what I am doing wrong that I cannot
get it to display?On May 10, 6:09 pm, "Chris Marsh" <cma...@.synergy-intl.com> wrote:
> The icon in the preview bar is missing, what I am doing wrong that I cannot
> get it to display?
If I'm understanding you correctly, it sounds like that the basic
images that are part of the reporting software are not deployed to (or
do not exist in) the correct path (relative to the Reports/Report
Server virtual directories) on the Report Manager. Sorry that I could
not be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||Actually, if I run it from the dev studio it displays and works it's when I
put the controls on our Dashboad page (IE7 browser) that we've created where
only the printer doesn't appears as well as the bottom scroll bar. The Zoom,
Back button, all the others work but not the Printer or the bottom scroll
bar.
I think this must be a bug with IE7 and SSRS. I spoke with an associate of
mine and he complained about the bottom scroll bar not displaying in IE7.
If anyone has a suggestion that would be great otherwise I guess I pay MS
for a call to post a bug with them.
Thanks!
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1178853619.144114.216290@.e51g2000hsg.googlegroups.com...
> On May 10, 6:09 pm, "Chris Marsh" <cma...@.synergy-intl.com> wrote:
>> The icon in the preview bar is missing, what I am doing wrong that I
>> cannot
>> get it to display?
>
> If I'm understanding you correctly, it sounds like that the basic
> images that are part of the reporting software are not deployed to (or
> do not exist in) the correct path (relative to the Reports/Report
> Server virtual directories) on the Report Manager. Sorry that I could
> not be of further assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||Before paying I suggest posting in the web forums. That is where the MS
people hang out. You might get an answer there.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:%233W7r79kHHA.4684@.TK2MSFTNGP03.phx.gbl...
> Actually, if I run it from the dev studio it displays and works it's when
> I put the controls on our Dashboad page (IE7 browser) that we've created
> where only the printer doesn't appears as well as the bottom scroll bar.
> The Zoom, Back button, all the others work but not the Printer or the
> bottom scroll bar.
> I think this must be a bug with IE7 and SSRS. I spoke with an associate of
> mine and he complained about the bottom scroll bar not displaying in IE7.
> If anyone has a suggestion that would be great otherwise I guess I pay MS
> for a call to post a bug with them.
> Thanks!
> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
> news:1178853619.144114.216290@.e51g2000hsg.googlegroups.com...
>> On May 10, 6:09 pm, "Chris Marsh" <cma...@.synergy-intl.com> wrote:
>> The icon in the preview bar is missing, what I am doing wrong that I
>> cannot
>> get it to display?
>>
>> If I'm understanding you correctly, it sounds like that the basic
>> images that are part of the reporting software are not deployed to (or
>> do not exist in) the correct path (relative to the Reports/Report
>> Server virtual directories) on the Report Manager. Sorry that I could
>> not be of further assistance.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>|||Thanks Bruce - but what forum are you suggesting and I will gladly post
away.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uaL38N%23kHHA.3928@.TK2MSFTNGP02.phx.gbl...
> Before paying I suggest posting in the web forums. That is where the MS
> people hang out. You might get an answer there.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
> news:%233W7r79kHHA.4684@.TK2MSFTNGP03.phx.gbl...
>> Actually, if I run it from the dev studio it displays and works it's when
>> I put the controls on our Dashboad page (IE7 browser) that we've created
>> where only the printer doesn't appears as well as the bottom scroll bar.
>> The Zoom, Back button, all the others work but not the Printer or the
>> bottom scroll bar.
>> I think this must be a bug with IE7 and SSRS. I spoke with an associate
>> of mine and he complained about the bottom scroll bar not displaying in
>> IE7.
>> If anyone has a suggestion that would be great otherwise I guess I pay MS
>> for a call to post a bug with them.
>> Thanks!
>> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
>> news:1178853619.144114.216290@.e51g2000hsg.googlegroups.com...
>> On May 10, 6:09 pm, "Chris Marsh" <cma...@.synergy-intl.com> wrote:
>> The icon in the preview bar is missing, what I am doing wrong that I
>> cannot
>> get it to display?
>>
>> If I'm understanding you correctly, it sounds like that the basic
>> images that are part of the reporting software are not deployed to (or
>> do not exist in) the correct path (relative to the Reports/Report
>> Server virtual directories) on the Report Manager. Sorry that I could
>> not be of further assistance.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>>
>|||I think I found the web forum for Reporting Services:
http://forums.microsoft.com/TechNet/ShowForum.aspx?ForumID=82&SiteID=17
Shirley
"Chris Marsh" wrote:
> Thanks Bruce - but what forum are you suggesting and I will gladly post
> away.
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uaL38N%23kHHA.3928@.TK2MSFTNGP02.phx.gbl...
> > Before paying I suggest posting in the web forums. That is where the MS
> > people hang out. You might get an answer there.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
> > news:%233W7r79kHHA.4684@.TK2MSFTNGP03.phx.gbl...
> >> Actually, if I run it from the dev studio it displays and works it's when
> >> I put the controls on our Dashboad page (IE7 browser) that we've created
> >> where only the printer doesn't appears as well as the bottom scroll bar.
> >> The Zoom, Back button, all the others work but not the Printer or the
> >> bottom scroll bar.
> >>
> >> I think this must be a bug with IE7 and SSRS. I spoke with an associate
> >> of mine and he complained about the bottom scroll bar not displaying in
> >> IE7.
> >>
> >> If anyone has a suggestion that would be great otherwise I guess I pay MS
> >> for a call to post a bug with them.
> >>
> >> Thanks!
> >>
> >> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
> >> news:1178853619.144114.216290@.e51g2000hsg.googlegroups.com...
> >> On May 10, 6:09 pm, "Chris Marsh" <cma...@.synergy-intl.com> wrote:
> >> The icon in the preview bar is missing, what I am doing wrong that I
> >> cannot
> >> get it to display?
> >>
> >>
> >> If I'm understanding you correctly, it sounds like that the basic
> >> images that are part of the reporting software are not deployed to (or
> >> do not exist in) the correct path (relative to the Reports/Report
> >> Server virtual directories) on the Report Manager. Sorry that I could
> >> not be of further assistance.
> >>
> >> Regards,
> >>
> >> Enrique Martinez
> >> Sr. Software Consultant
> >>
> >>
> >>
> >
> >
>
>|||This brings you to the SQL Server forums. Then click on Reporting Services.
MS is pretty much abandoning newsgroups. This newsgroup was starting to die
down and I was contemplating moving to it myself.
http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:OhkbjI$kHHA.4112@.TK2MSFTNGP04.phx.gbl...
> Thanks Bruce - but what forum are you suggesting and I will gladly post
> away.
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uaL38N%23kHHA.3928@.TK2MSFTNGP02.phx.gbl...
>> Before paying I suggest posting in the web forums. That is where the MS
>> people hang out. You might get an answer there.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
>> news:%233W7r79kHHA.4684@.TK2MSFTNGP03.phx.gbl...
>> Actually, if I run it from the dev studio it displays and works it's
>> when I put the controls on our Dashboad page (IE7 browser) that we've
>> created where only the printer doesn't appears as well as the bottom
>> scroll bar. The Zoom, Back button, all the others work but not the
>> Printer or the bottom scroll bar.
>> I think this must be a bug with IE7 and SSRS. I spoke with an associate
>> of mine and he complained about the bottom scroll bar not displaying in
>> IE7.
>> If anyone has a suggestion that would be great otherwise I guess I pay
>> MS for a call to post a bug with them.
>> Thanks!
>> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
>> news:1178853619.144114.216290@.e51g2000hsg.googlegroups.com...
>> On May 10, 6:09 pm, "Chris Marsh" <cma...@.synergy-intl.com> wrote:
>> The icon in the preview bar is missing, what I am doing wrong that I
>> cannot
>> get it to display?
>>
>> If I'm understanding you correctly, it sounds like that the basic
>> images that are part of the reporting software are not deployed to (or
>> do not exist in) the correct path (relative to the Reports/Report
>> Server virtual directories) on the Report Manager. Sorry that I could
>> not be of further assistance.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>>
>>
>

RC1 oledb provider missing registry key

The RC1 installer (and the previous beta too) doesn't write in the following registry key:

[HKEY_CLASSES_ROOT\CLSID\{32CE2952-2585-49a6-AEFF-1732076C2945}\OLE DB Provider]
@.="Microsoft SQL Server CE 3.0 OLE DB Provider for Windows"

so this provider doesn't appear on the oledb "Data Link Properties" panels. Manually entering the above key solves the problem. The last summer CTP version has been done this trick.

Excellent - thanks for the info

Rare behavior

Hi!
My SQL Server has a rare behavior ... some times I can't find database objects like sp's, relations, etc (objects missing). So, I think in scenes:
* security
* virus (like slammer)
* SQLServer becomes "crazy"
Dou you have been in this problem? How did you solve it?
Thanks so much in advance
Note: The SQL server has not installed any service pack. It exists a firewall too.
What does "can't find" mean? Can you show an example, including syntax used
to create objects, syntax used to "find" objects, and what error messages
you receive?
"Han" <anonymous@.discussions.microsoft.com> wrote in message
news:B97DD589-BE7E-4BB6-8824-C7FE40399BC0@.microsoft.com...
> Hi!
> My SQL Server has a rare behavior ... some times I can't find database
objects like sp's, relations, etc (objects missing). So, I think in scenes:
> * security
> * virus (like slammer)
> * SQLServer becomes "crazy"
> Dou you have been in this problem? How did you solve it?
> Thanks so much in advance
> Note: The SQL server has not installed any service pack. It exists a
firewall too.
>
|||Sorry! I meant when a check my db I notice disappearance of objects (some relations, sp's etc.). Usually I use SQL Server Entreprise Manager.

Rare behavior

Hi!
My SQL Server has a rare behavior ... some times I can't find database objec
ts like sp's, relations, etc (objects missing). So, I think in scenes:
* security
* virus (like slammer)
* SQLServer becomes "crazy"
Dou you have been in this problem? How did you solve it?
Thanks so much in advance
Note: The SQL server has not installed any service pack. It exists a firewal
l too.What does "can't find" mean? Can you show an example, including syntax used
to create objects, syntax used to "find" objects, and what error messages
you receive?
"Han" <anonymous@.discussions.microsoft.com> wrote in message
news:B97DD589-BE7E-4BB6-8824-C7FE40399BC0@.microsoft.com...
> Hi!
> My SQL Server has a rare behavior ... some times I can't find database
objects like sp's, relations, etc (objects missing). So, I think in scenes:
> * security
> * virus (like slammer)
> * SQLServer becomes "crazy"
> Dou you have been in this problem? How did you solve it?
> Thanks so much in advance
> Note: The SQL server has not installed any service pack. It exists a
firewall too.
>|||Sorry! I meant when a check my db I notice disappearance of objects (some re
lations, sp's etc.). Usually I use SQL Server Entreprise Manager.