Data Fetch

Hello..

i develope a web projects of horoscope or astrology(http://demo.reallianzbussimart.com/allzodiac.aspx), there is an 12 Zodiaz sign and all the data call on this page through the Database , in this page i there is an one sql query -- (Select Top 1 col from colour order by newid(),Select Top 1 num from number order by newid() ,Select Top 1 days from day order by newid() )

then all data call one by one change ..

when the refresh the page the value of all zodiac is change that is wrong ,,,

so what is the quary that one time in day the value off all zodiac is same next day the value has been change.................................

so please help me /.........

tell what is the process to not data change into the page refresh

Ashwnai

Hi Ashwnai,

You do the databinding in the load event of the page right?

You should do the databinding inside a "Not IsPostBack" like:

Protected Sub Page_Load(ByVal senderAs Object,ByVal eAs System.EventArgs)Handles Me.LoadIf Not IsPostBackThen'Do your databinding hereEnd If End Sub

I hope this answers your question ...
Otherwise please reply!

Kind regards,
Wim

|||

This is not solution of my problem

what is databinding , i am using the datagrid in the pages

so please help me

http://demo.reallianzbussimart.com/allzodiac.aspx

when u refresh the page all the zodiac value also change , but this is wrong

Ashwani

|||

ashwanikumar:

select top 1 days from dayorder by newid()

the emphasized generates random number(guid to be exact), so everytime the page is refreshed the order is random.

hth

|||

Ashwani,here are your queries

Select Top 1 col from colour order by newid()

Select Top 1 num from number order by newid()

Select Top 1 days from day order by newid()

if you are keep calling to storeprocedure / query by refreshing it. IT will give you an different result on every refresh click.

Remove order by NewID() because everytime it will generate GUID random ID.

Select Top 1 col from colour

Select Top 1 num from number

Select Top 1 days from day

Please send me the table with data atleast with three rows.

Then i can give you better solution.

DB Master

http://codeproject.wordpress.com

Data Enabled WebSite

I am looking at developing a data enabled web site. I am quite proficient
with SQL server, VB & ASP. For these reasons I have decided to develop the
site in ASP.NET (learning presently) with an SQL Server backend.
I have been told this is not the way to go and the better alternative is PHP
& MySQL.
I would appreciate any feedback re the pros and cosn of each option and
whether there is truth to this or not.
ThanksIf your quite proficient in that why would you want to change? Being
familiar with a tool(s) goes a long way and can help to reduce costs quite a
bit by being more accurate, confident and faster.
--
Andrew J. Kelly
SQL Server MVP
"Murphy" <murphy@.murphy.com> wrote in message
news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> I am looking at developing a data enabled web site. I am quite proficient
> with SQL server, VB & ASP. For these reasons I have decided to develop the
> site in ASP.NET (learning presently) with an SQL Server backend.
> I have been told this is not the way to go and the better alternative is
PHP
> & MySQL.
> I would appreciate any feedback re the pros and cosn of each option and
> whether there is truth to this or not.
> Thanks
>|||Exactly, my thoughts precisely however if the general opinion was that I was
going down the wrong path then i would be forced to learn new tricks in
order to complete the task correctly.
If there general opinion is that it's mrerly a matter of choice then I'll
stay with what I know.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OoFH5sNoDHA.1884@.TK2MSFTNGP09.phx.gbl...
> If your quite proficient in that why would you want to change? Being
> familiar with a tool(s) goes a long way and can help to reduce costs quite
a
> bit by being more accurate, confident and faster.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Murphy" <murphy@.murphy.com> wrote in message
> news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> > I am looking at developing a data enabled web site. I am quite
proficient
> > with SQL server, VB & ASP. For these reasons I have decided to develop
the
> > site in ASP.NET (learning presently) with an SQL Server backend.
> >
> > I have been told this is not the way to go and the better alternative is
> PHP
> > & MySQL.
> >
> > I would appreciate any feedback re the pros and cosn of each option and
> > whether there is truth to this or not.
> >
> > Thanks
> >
> >
>|||Murphy,
Stick with your initial tools. You are building a solution that assumes IIS
and SQL Server, but these are very well accepted technology solutions.
bill burrows
"Murphy" <murphy@.murphy.com> wrote in message
news:uCcCN1NoDHA.2216@.TK2MSFTNGP12.phx.gbl...
> Exactly, my thoughts precisely however if the general opinion was that I
was
> going down the wrong path then i would be forced to learn new tricks in
> order to complete the task correctly.
> If there general opinion is that it's mrerly a matter of choice then I'll
> stay with what I know.
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:OoFH5sNoDHA.1884@.TK2MSFTNGP09.phx.gbl...
> > If your quite proficient in that why would you want to change? Being
> > familiar with a tool(s) goes a long way and can help to reduce costs
quite
> a
> > bit by being more accurate, confident and faster.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "Murphy" <murphy@.murphy.com> wrote in message
> > news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> > > I am looking at developing a data enabled web site. I am quite
> proficient
> > > with SQL server, VB & ASP. For these reasons I have decided to develop
> the
> > > site in ASP.NET (learning presently) with an SQL Server backend.
> > >
> > > I have been told this is not the way to go and the better alternative
is
> > PHP
> > > & MySQL.
> > >
> > > I would appreciate any feedback re the pros and cosn of each option
and
> > > whether there is truth to this or not.
> > >
> > > Thanks
> > >
> > >
> >
> >
>|||Get a decent database structure and access.
You already know sql server so will be able to cunstruct
that easily and a decent stored procedure interface.
Without this there is not hope of building a reliable
efficient system. You can spend the time you would have
spent learning a new database on testing and refining this
one.
Adain you should find it easier to learn and be effective
in (make less serious mistakes) in asp.net than in php if
you already know asp well.
If you go for php and mysql you will just be another
beginner trying to hack together a web site.|||Ignore the advice!
I work day in day out with PHP/MySQL and although they are open source,
reliable and easy to work with, I am now opting to go down the .NET route.
SQL Server is a more powerful database and .NET is a more powerful platform
to code on.
"Murphy" <murphy@.murphy.com> wrote in message
news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> I am looking at developing a data enabled web site. I am quite proficient
> with SQL server, VB & ASP. For these reasons I have decided to develop the
> site in ASP.NET (learning presently) with an SQL Server backend.
> I have been told this is not the way to go and the better alternative is
PHP
> & MySQL.
> I would appreciate any feedback re the pros and cosn of each option and
> whether there is truth to this or not.
> Thanks
>|||Not sure its a good idea to ignore the advice... I'm all .NET myself, but
MySQL and PHP certainly is a good "cost free" alternative. Now that's said;
go with .NET and SQL Server!
--
Carsten Thomsen
Enterprise Development with VS .NET, UML, and MSF
http://www.apress.com/book/bookDisplay.html?bID=105
"Andrew Banks" <banksy@.blablablueyonder.co.uk> wrote in message
news:TD7pb.3738$Yl6.26235112@.news-text.cableinet.net...
> Ignore the advice!
> I work day in day out with PHP/MySQL and although they are open source,
> reliable and easy to work with, I am now opting to go down the .NET route.
> SQL Server is a more powerful database and .NET is a more powerful
platform
> to code on.
> "Murphy" <murphy@.murphy.com> wrote in message
> news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> > I am looking at developing a data enabled web site. I am quite
proficient
> > with SQL server, VB & ASP. For these reasons I have decided to develop
the
> > site in ASP.NET (learning presently) with an SQL Server backend.
> >
> > I have been told this is not the way to go and the better alternative is
> PHP
> > & MySQL.
> >
> > I would appreciate any feedback re the pros and cosn of each option and
> > whether there is truth to this or not.
> >
> > Thanks
> >
> >
>|||As I will be hosting the site with a hosting company who provide the SQL db
etc cost is not an issue to me.
"CT" <carstent@.spammersgoawaydotnetservices.biz> wrote in message
news:%23njCwicoDHA.2732@.TK2MSFTNGP11.phx.gbl...
> Not sure its a good idea to ignore the advice... I'm all .NET myself, but
> MySQL and PHP certainly is a good "cost free" alternative. Now that's
said;
> go with .NET and SQL Server!
> --
> Carsten Thomsen
> Enterprise Development with VS .NET, UML, and MSF
> http://www.apress.com/book/bookDisplay.html?bID=105
> "Andrew Banks" <banksy@.blablablueyonder.co.uk> wrote in message
> news:TD7pb.3738$Yl6.26235112@.news-text.cableinet.net...
> > Ignore the advice!
> >
> > I work day in day out with PHP/MySQL and although they are open source,
> > reliable and easy to work with, I am now opting to go down the .NET
route.
> >
> > SQL Server is a more powerful database and .NET is a more powerful
> platform
> > to code on.
> >
> > "Murphy" <murphy@.murphy.com> wrote in message
> > news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> > > I am looking at developing a data enabled web site. I am quite
> proficient
> > > with SQL server, VB & ASP. For these reasons I have decided to develop
> the
> > > site in ASP.NET (learning presently) with an SQL Server backend.
> > >
> > > I have been told this is not the way to go and the better alternative
is
> > PHP
> > > & MySQL.
> > >
> > > I would appreciate any feedback re the pros and cosn of each option
and
> > > whether there is truth to this or not.
> > >
> > > Thanks
> > >
> > >
> >
> >
>|||If it's for serious use, go .NET/ASP etc.
If it's for a hobby site (say a VA, if you're afollower of my hobby, FS!)
then MySQl, and PHP are good. Although I still use ASP and SQL.
Angus
"Murphy" <murphy@.murphy.com> wrote in message
news:#KHGm4coDHA.2268@.TK2MSFTNGP12.phx.gbl...
> As I will be hosting the site with a hosting company who provide the SQL
db
> etc cost is not an issue to me.
> "CT" <carstent@.spammersgoawaydotnetservices.biz> wrote in message
> news:%23njCwicoDHA.2732@.TK2MSFTNGP11.phx.gbl...
> > Not sure its a good idea to ignore the advice... I'm all .NET myself,
but
> > MySQL and PHP certainly is a good "cost free" alternative. Now that's
> said;
> > go with .NET and SQL Server!
> >
> > --
> > Carsten Thomsen
> > Enterprise Development with VS .NET, UML, and MSF
> > http://www.apress.com/book/bookDisplay.html?bID=105
> > "Andrew Banks" <banksy@.blablablueyonder.co.uk> wrote in message
> > news:TD7pb.3738$Yl6.26235112@.news-text.cableinet.net...
> > > Ignore the advice!
> > >
> > > I work day in day out with PHP/MySQL and although they are open
source,
> > > reliable and easy to work with, I am now opting to go down the .NET
> route.
> > >
> > > SQL Server is a more powerful database and .NET is a more powerful
> > platform
> > > to code on.
> > >
> > > "Murphy" <murphy@.murphy.com> wrote in message
> > > news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> > > > I am looking at developing a data enabled web site. I am quite
> > proficient
> > > > with SQL server, VB & ASP. For these reasons I have decided to
develop
> > the
> > > > site in ASP.NET (learning presently) with an SQL Server backend.
> > > >
> > > > I have been told this is not the way to go and the better
alternative
> is
> > > PHP
> > > > & MySQL.
> > > >
> > > > I would appreciate any feedback re the pros and cosn of each option
> and
> > > > whether there is truth to this or not.
> > > >
> > > > Thanks
> > > >
> > > >
> > >
> > >
> >
> >
>|||Hi
ASP.NET and SQL Server is the way forward.
Good place to get ASP.NET and SQL Server hosting web space is:
http://www.dotnet-webhosting.com/sql-server-hosting/default.aspx
£22/Month (included web space, SQL Server DB and free domain)
Regards
G,
"Angus Lepper" <CEO@.AngusEnterprises.cjb.net> wrote in message news:<OH9CvnCwDHA.1272@.TK2MSFTNGP12.phx.gbl>...
> If it's for serious use, go .NET/ASP etc.
> If it's for a hobby site (say a VA, if you're afollower of my hobby, FS!)
> then MySQl, and PHP are good. Although I still use ASP and SQL.
> Angus
> "Murphy" <murphy@.murphy.com> wrote in message
> news:#KHGm4coDHA.2268@.TK2MSFTNGP12.phx.gbl...
> > As I will be hosting the site with a hosting company who provide the SQL
> db
> > etc cost is not an issue to me.
> >
> > "CT" <carstent@.spammersgoawaydotnetservices.biz> wrote in message
> > news:%23njCwicoDHA.2732@.TK2MSFTNGP11.phx.gbl...
> > > Not sure its a good idea to ignore the advice... I'm all .NET myself,
> but
> > > MySQL and PHP certainly is a good "cost free" alternative. Now that's
> said;
> > > go with .NET and SQL Server!
> > >
> > > --
> > > Carsten Thomsen
> > > Enterprise Development with VS .NET, UML, and MSF
> > > http://www.apress.com/book/bookDisplay.html?bID=105
> > > "Andrew Banks" <banksy@.blablablueyonder.co.uk> wrote in message
> > > news:TD7pb.3738$Yl6.26235112@.news-text.cableinet.net...
> > > > Ignore the advice!
> > > >
> > > > I work day in day out with PHP/MySQL and although they are open
> source,
> > > > reliable and easy to work with, I am now opting to go down the .NET
> route.
> > > >
> > > > SQL Server is a more powerful database and .NET is a more powerful
> platform
> > > > to code on.
> > > >
> > > > "Murphy" <murphy@.murphy.com> wrote in message
> > > > news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> > > > > I am looking at developing a data enabled web site. I am quite
> proficient
> > > > > with SQL server, VB & ASP. For these reasons I have decided to
> develop
> the
> > > > > site in ASP.NET (learning presently) with an SQL Server backend.
> > > > >
> > > > > I have been told this is not the way to go and the better
> alternative
> is
> PHP
> > > > > & MySQL.
> > > > >
> > > > > I would appreciate any feedback re the pros and cosn of each option
> and
> > > > > whether there is truth to this or not.
> > > > >
> > > > > Thanks
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >|||Hi
We offer a very good and reliable service.
http://www.nt-webspace.com
Only £6 / Month and as a special offer we are giving away free domain
till 31st Dec 2003.
Here are the plan details
==========================NO SETUP FEES!
30 day Money Back Guarantee
Windows 2003 ® / IIS ® 6.0 Servers!
24 hour - 7 day a week support!
Unlimited web page updates!
Personal cgi-bin directory
200 MB Disk Space! (Special Offer now 400 MB !! )
Pop3 E-mail boxes with unlimited aliases and auto-responders!
2 GB / Month Bandwidth Transfer!
Microsoft Active Server ?
FTP access for updating web site
Microsoft Access ®/ FoxPro ® Database Support!
Microsoft MS SQL Server 7.0 (£27/mo. additional
Regards
NT-Webspace.com
"Angus Lepper" <CEO@.AngusEnterprises.cjb.net> wrote in message news:<OH9CvnCwDHA.1272@.TK2MSFTNGP12.phx.gbl>...
> If it's for serious use, go .NET/ASP etc.
> If it's for a hobby site (say a VA, if you're afollower of my hobby, FS!)
> then MySQl, and PHP are good. Although I still use ASP and SQL.
> Angus
> "Murphy" <murphy@.murphy.com> wrote in message
> news:#KHGm4coDHA.2268@.TK2MSFTNGP12.phx.gbl...
> > As I will be hosting the site with a hosting company who provide the SQL
> db
> > etc cost is not an issue to me.
> >
> > "CT" <carstent@.spammersgoawaydotnetservices.biz> wrote in message
> > news:%23njCwicoDHA.2732@.TK2MSFTNGP11.phx.gbl...
> > > Not sure its a good idea to ignore the advice... I'm all .NET myself,
> but
> > > MySQL and PHP certainly is a good "cost free" alternative. Now that's
> said;
> > > go with .NET and SQL Server!
> > >
> > > --
> > > Carsten Thomsen
> > > Enterprise Development with VS .NET, UML, and MSF
> > > http://www.apress.com/book/bookDisplay.html?bID=105
> > > "Andrew Banks" <banksy@.blablablueyonder.co.uk> wrote in message
> > > news:TD7pb.3738$Yl6.26235112@.news-text.cableinet.net...
> > > > Ignore the advice!
> > > >
> > > > I work day in day out with PHP/MySQL and although they are open
> source,
> > > > reliable and easy to work with, I am now opting to go down the .NET
> route.
> > > >
> > > > SQL Server is a more powerful database and .NET is a more powerful
> platform
> > > > to code on.
> > > >
> > > > "Murphy" <murphy@.murphy.com> wrote in message
> > > > news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> > > > > I am looking at developing a data enabled web site. I am quite
> proficient
> > > > > with SQL server, VB & ASP. For these reasons I have decided to
> develop
> the
> > > > > site in ASP.NET (learning presently) with an SQL Server backend.
> > > > >
> > > > > I have been told this is not the way to go and the better
> alternative
> is
> PHP
> > > > > & MySQL.
> > > > >
> > > > > I would appreciate any feedback re the pros and cosn of each option
> and
> > > > > whether there is truth to this or not.
> > > > >
> > > > > Thanks
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >|||www.oneandone.co.uk are rather good.
Angus
"NT-Webspace.com" <gbaryah@.hotmail.com> wrote in message
news:792f1e6b.0312120107.7c2f9b03@.posting.google.com...
> Hi
> We offer a very good and reliable service.
> http://www.nt-webspace.com
> Only £6 / Month and as a special offer we are giving away free domain
> till 31st Dec 2003.
> Here are the plan details
> ==========================> NO SETUP FEES!
> 30 day Money Back Guarantee
> Windows 2003 ® / IIS ® 6.0 Servers!
> 24 hour - 7 day a week support!
> Unlimited web page updates!
> Personal cgi-bin directory
> 200 MB Disk Space! (Special Offer now 400 MB !! )
> Pop3 E-mail boxes with unlimited aliases and auto-responders!
> 2 GB / Month Bandwidth Transfer!
> Microsoft Active Server T
> FTP access for updating web site
> Microsoft Access ®/ FoxPro ® Database Support!
> Microsoft MS SQL Server 7.0 (£27/mo. additional
> Regards
> NT-Webspace.com
>
> "Angus Lepper" <CEO@.AngusEnterprises.cjb.net> wrote in message
news:<OH9CvnCwDHA.1272@.TK2MSFTNGP12.phx.gbl>...
> > If it's for serious use, go .NET/ASP etc.
> >
> > If it's for a hobby site (say a VA, if you're afollower of my hobby,
FS!)
> > then MySQl, and PHP are good. Although I still use ASP and SQL.
> >
> > Angus
> > "Murphy" <murphy@.murphy.com> wrote in message
> > news:#KHGm4coDHA.2268@.TK2MSFTNGP12.phx.gbl...
> > > As I will be hosting the site with a hosting company who provide the
SQL
> > db
> > > etc cost is not an issue to me.
> > >
> > > "CT" <carstent@.spammersgoawaydotnetservices.biz> wrote in message
> > > news:%23njCwicoDHA.2732@.TK2MSFTNGP11.phx.gbl...
> > > > Not sure its a good idea to ignore the advice... I'm all .NET
myself,
> > but
> > > > MySQL and PHP certainly is a good "cost free" alternative. Now
that's
> > said;
> > > > go with .NET and SQL Server!
> > > >
> > > > --
> > > > Carsten Thomsen
> > > > Enterprise Development with VS .NET, UML, and MSF
> > > > http://www.apress.com/book/bookDisplay.html?bID=105
> > > > "Andrew Banks" <banksy@.blablablueyonder.co.uk> wrote in message
> > > > news:TD7pb.3738$Yl6.26235112@.news-text.cableinet.net...
> > > > > Ignore the advice!
> > > > >
> > > > > I work day in day out with PHP/MySQL and although they are open
> > source,
> > > > > reliable and easy to work with, I am now opting to go down the
.NET
> > route.
> > > > >
> > > > > SQL Server is a more powerful database and .NET is a more powerful
> > platform
> > > > > to code on.
> > > > >
> > > > > "Murphy" <murphy@.murphy.com> wrote in message
> > > > > news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> > > > > > I am looking at developing a data enabled web site. I am quite
> > proficient
> > > > > > with SQL server, VB & ASP. For these reasons I have decided to
> > develop
> > the
> > > > > > site in ASP.NET (learning presently) with an SQL Server backend.
> > > > > >
> > > > > > I have been told this is not the way to go and the better
> > alternative
> > is
> > PHP
> > > > > > & MySQL.
> > > > > >
> > > > > > I would appreciate any feedback re the pros and cosn of each
option
> > and
> > > > > > whether there is truth to this or not.
> > > > > >
> > > > > > Thanks
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >

data driven web site

I am using vb .net 2003 with msde.

I have downloaded microsoft`s vbsdk setup and have it working pretty well until I get to the login page and the provided credentials will not work.

The sample tells me to set permissions in the dacl editor.

1:What is the dacl editor and how do I use it?

2:What do I set permissions to?

I have been through the code provided over and over and can`t seem to find anything wrong,So I figure maybe this is the problem.

Any help will be appreciated.

Davco

Hi,

this is a SQL Server related forum and this seems more like a problem within the SDk walkthrough. perhpas it would be better to try your question in the ASP.NET forums.

HTH, jens K. Suessmeyer.

http://www.sqlserver2005.de

Data Driven Subscriptions

I read somewhere that Data Driven Subscriptions are only for Enterpise Edition.
In this case, why is it available in the Standard edition web interface of
the Report Manager?Data driven subscriptions are not available with Standard edition
(http://www.microsoft.com/sql/reporting/productinfo/features.asp). The
button is probably there because the subscription types are not
configurable.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Minas Papageorgiou" <MinasPapageorgiou@.discussions.microsoft.com> wrote in
message news:5C3CF96E-15DC-45F0-9C81-E4B913FDAECB@.microsoft.com...
> I read somewhere that Data Driven Subscriptions are only for Enterpise
Edition.
> In this case, why is it available in the Standard edition web interface of
> the Report Manager?sql

Data Cubes using MS Analysis Services

I need to use cubes in VS 2005 web project. I have no clue how to create cubes or use them in my web page. I am familiar with Reporting Services but not cubes.

thanks in advance!

In SQL Server 2005 it depends on where your data is comming from, if you have a Data Warehouse running you can create the Cubes in Analysis Service but SQL Server 2005 also comes with UDM(unified dimension modeling) stripping the Algebra and moving to calculus in one step, some thing you need tools like Hyperion to do in SQL Server 2000. Try the link below for some SQL Server 2005 Analysis resources including UDM. Hope this helps.

http://www.mosha.com/msolap/yukon.htm

|||Thanks Caddre. I am sure I will find lots of info there. I also found this link: http://www.microsoft.com/technet/prodtechnol/sql/default.mspx.|||

Hi,

I have created a cube using MS Analysis Services 2005. I have a fact table that contains 6 different measures (actualUSrevenue, actualEURrevenue,Qty) and (scheduledUSrevenue,scheduledEURrevenue,scheduledQty). How do I break these up into two separate groups of measures.

I will be taking these separate measure groups to build a stacked column chart with both actual and scheduled in the same column but each in a separate series.

thanks,

marilyn

marilyn.beaudreau@.philips.com

|||

There is very good sample code from Microsoft in the file below and the second link is a tutorial to get you started. Hope this helps.

http://www.microsoft.com/downloads/details.aspx?FamilyID=790d631b-bff9-4f4a-b648-e9209e6ac8ad&DisplayLang=en

http://www.databasejournal.com/article.php/1459531

Data Convertion Error

I am using SQL server 2005, Visual Web Developer 2005 express (for right now). Can get the stored procedure to run fine if I do not return the CityID.

Stored Procedure

ALTER Procedure [dbo].[WDR_CityAdd1]

(

@.CountryID int,

@.CityName nvarchar(50),

@.InternetAvail bit,

@.FlowersAvail bit,

@.CityID int OUTPUT

)

AS

IF EXISTS(SELECT 'True' FROM city WHERE CityName = @.CityName AND CountryID = @.CountryID)

BEGIN

SELECT

@.CityID = 0

END

ELSE

BEGIN

INSERT INTO City

(

CountryID,

CityName,

InternetAvail,

FlowersAvail

)

VALUES

(

@.CountryID,

@.CityName,

@.InternetAvail,

@.FlowersAvail

)

SELECT

@.CityID = 'CityID' ( I have also tried = @.@.Identity but that never returned anything it is an identity column 1,1)

END

Here is the code on the other end. I have not included all the parameters, but should get a sense of what I am doing wrong.

Dim myCommand As New SqlCommand("WDR_CityAdd1", dbConn)

myCommand.CommandType = CommandType.StoredProcedure

Dim parameterCityName As New SqlParameter("@.CityName", SqlDbType.NVarChar, 50)

parameterCityName.Value = CityName

myCommand.Parameters.Add(parameterCityName)

Dim parameterCityID As New SqlParameter("@.CityID", SqlDbType.Int, 4)

parameterCityID.Direction = ParameterDirection.Output

myCommand.Parameters.Add(parameterCityID)

Try

dbConn.Open()

myCommand.ExecuteNonQuery()

dbConn.Close()

Return (parameterCityID.Value).ToString (have played with this using the .tostring and not using it)

'AlertMessage = "City Added"

Catch ex As Exception

AlertMessage = ex.ToString

End Try

Here is the error I get. So what am I doing wrong? I figured maybe in the stored procedure. CityID is difined in the table as an int So why is it telling me that it is a varchar when it is defined in the stored procedure, table and code as an int? Am I missing something?

System.Data.SqlClient.SqlException: Conversion failed when converting the varchar value 'CityID' to data type int. at System.Data.SqlClient.SqlConnection.OnError

Thanks

Jerry

There are a couple of issues:

grbourque wrote:

...

SELECT @.CityID = 'CityID'

...

Return (parameterCityID.Value).ToString (have played with this using the .tostring and not using it)

...

--> Conversion failed when converting the varchar value 'CityID' to data type int.

In this location,

SELECT @.CityID = 'CityID'

You are attempting to assign the @.CityID (an integer) the string value 'CityID'. That is what caused the error you reported.

I suggest using SCOPE_IDENTITY to capture the IDENTITY value of the last row entered by the current user/session.

SET @.CityID = SCOPE_IDENTITY()

Also, the RETURN value 'should' be an integer, and you are attempting to return a string value.

('Normally', one would use the RETURN value for success/failure reporting.)

Somewhere prior to the RETURN statement, you 'should' assign the parameterCityID value to a previously declared variable, then use that variable in your application.

|||

Arnie

I had tried playing around with the 'cityID' fieldname and was getting different error messages. I have re-written the code with your help and it works. Sometimes this just amazes me. I do appreciate the help. Maybe with time I will be able to help others as I get a handle on this.

Jerry

Data Conversion (String to DateTime)

I am trying to insert data from a web form to a SQL Database. I am receiving the following error: {"String was not recognized as a valid Boolean."} I am also receiving a similar error for text boxes that have dates.

Below is the code that I am using:

<asp:SqlDataSource

id="SqlDataSource1"

runat="server"

connectionstring="<%$ ConnectionStrings:ConnMktProjReq %>"

selectcommand="SELECT LoanRepName,Branch,CurrentDate,ReqDueDate,ProofByEmail,ProofByEmail,FaxNumber,ProjectExplanation,PrintQuantity,PDFDisc,PDFEmail,LoanRepEmail FROM MktProjReq"

insertcommand="INSERT INTO MktProjReq(LoanRepName, Branch, CurrentDate, ReqDueDate, ProofByEmail, ProofByEmail, FaxNumber, ProjectExplanation, PrintQuantity, PDFDisc, PDFEmail, LoanRepEmail) VALUES (@.RepName, @.BranchName, @.Date, @.DueDate, @.ByEmail, @.ByFax, @.Fax, @.ProjExp, @.PrintQty, @.Disc, @.Email, @.RepEmail)">

<InsertParameters>

<asp:FormParameterName="RepName"FormField="LoanRepNameBox"/>

<asp:FormParameterName="BranchName"FormField="BranchList"/>

<asp:FormParameterName="Date"FormField="CurrentDateBox"Type="DateTime"/>

<asp:FormParameterName="DueDate"FormField="ReqDueDateBox"Type="DateTime"/>

<asp:FormParameterName="ByEmail"FormField="ProofByEmailCheckbox"Type="boolean"/>

<asp:FormParameterName="ByFax"FormField="ProofByFaxCheckbox"Type="boolean"/>

<asp:FormParameterName="Fax"FormField="FaxNumberBox"/>

<asp:FormParameterName="ProjExp"FormField="ProjectExplanationBox"/>

<asp:FormParameterName="PrintQty"FormField="PrintQuantityBox"/>

<asp:FormParameterName="Disc"FormField="PDFByDiscCheckbox"Type="boolean"/>

<asp:FormParameterName="Email"FormField="PDFByFaxCheckbox"Type="boolean"/>

<asp:FormParameterName="RepEmail"FormField="LoanRepEmailBox"/>

</InsertParameters>

</asp:SqlDataSource>

protectedvoid Button1_Click(object sender,EventArgs e)

{

SqlDataSource1.Insert();

}

I have been searching forums for parsing data, but I haven't found anything that works. Can anyone provide guidance.

Thank you,

Paul

What about remove (cross out in the following) the Type="boolean" for these formfields:

<asp:FormParameterName="ByEmail"FormField="ProofByEmailCheckbox"Type="boolean" />

<asp:FormParameterName="ByFax"FormField="ProofByFaxCheckbox" Type="boolean" />

<asp:FormParameterName="Disc"FormField="PDFByDiscCheckbox" Type="boolean" />

<asp:FormParameterName="Email"FormField="PDFByFaxCheckbox" Type="boolean" />

|||

Thank you, that ended the exception errors.

Paul

data connection behind firewall

Hello,

I am trying to connect a web app to a SQL 2005 that is behind a firewall.

The challenge is this, the SQL is behind a firewall and the webserver is at a different location. From my desktop development environment, I connect through a VPN first and then can point to the internal IP of the DB server. This works fine as long as the VPN is connected.

But how do I do this from a hosted web application that is not on my local machine or using my VPN?

Is there some sort of tunneling Connection that I can use within code?

thanks

As you are going to deploy the web site to a remote location, to have SQL Connection via Tabular Data Stream would require opening up extra ports (1433 and 1434) - since the days of the Slammer worm, I doubt if any person in charge of a company network would allow these ports to be opended up to the outside world.

Can you deploy a copy of the database to the remote site? You could use SQL Express provided the database size was within 2Gb. Alternatively you write a web service, which only require Port 80 to be open through the firewall from your external host into your DMZ.

|||

Thanks for the reply. The challenge is that there is a database collecting live survey data...and that DB is in a different physical location behind a firewall, etc.

The application I am writting is on a different server/ different building, etc. The DB server has VPN access to it but I don't know how to include that in my code so that my app can talk to it and pull the live data.

(and you are correct, just opening those ports would be dangerous.)

|||

In which case you need to have the database both on the remote server on within your LAN. As it is a survey database, would i be correct to asume that data is only every inserted (unlil a survey is deleted en-mass)?

In which case include a web service on your remote server, set only to respond to the IP address of your LAN. Depending on the senitivity of your data you may elect to run HTTPS for the web service.

The key point is identifying batches of records to copy. Without knowing your database, I cannot comment of the best means of setting up the database to do this. If only inserting as I have suggested that you need a method that will return a manageable block of records. This method will be called by a Windows Service on a machine within your LAN which will then call a "make it so" stored procedure on your local database.

The required ports will be already open from your LAN out and into your remote IIS server.

Data Connection

So after a few hours of banging my head against my computer, here I am. :)

Backstory: A few weeks ago I installed web matrix and MSDE Rel A so I could create some .NET pages from my local machine, connect to a remote SQL Server 2000 database, and then post the .NET pages on the web server. All went well, I could connect to the datasource it brought up the table column names, everything was perfectly working (should've been my first hint to leave well enough alone). Well today, I think, "hey you know I want to give this new Visual Studio 2005 Express Edition a try". So I install it. I thought that if web matrix was that simple to connect, create and post "surely" VSE would be too, but with more features. I also read how I should go ahead and install SQL Server express and SQL Server Managment Studio Express, so I did.

So I go to create a datasource in VSE, but VSE had other plans. An error message popped up. Something to the effect, "An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be cuased by the fact that under the default settings SQL Server does not allow remote connections..." I noticed that it said something about SQL Server 2005 so I figured I'd need to change that so I used the Microsoft SQL Server (OLE DB). It returned the error "[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied". I flipped back over to web matrix and now it doesn't work either. I have tried referencing the server by servername\db_name and ip address as well. All result in the same.

Any thoughts on how to get me going?

Try .\SQLEXPRESS

Data change event

Let's say I want to have a Web page that will be showing live data change in
a SQL table? Is it possible to have on SQL side some kind of listener that
will propogate changes to the Web page?
ThanksMarkgoldin wrote:
> Let's say I want to have a Web page that will be showing live data change
in
> a SQL table? Is it possible to have on SQL side some kind of listener that
> will propogate changes to the Web page?
I've always done the opposite, have the Web page query the database
whenever it needs to be refreshed. Even if you build a component with
ActiveX or Java it would still require the client to continually connect
to the data source to determine if there were changes. If you aren't
particular about how it works then just have the Web page refresh itself
on a regular basis, it's alot easier.
gorf|||If you are using SQL Server 2005, then lookup Query Notification in BOL. If
you are using an earlier version, then, as far as I know, you have to have
your application poll the database to look for changes.
"Markgoldin" <Markgoldin@.discussions.microsoft.com> wrote in message
news:D9064F07-0DB3-4687-B562-DF800DD8DA64@.microsoft.com...
> Let's say I want to have a Web page that will be showing live data change
> in
> a SQL table? Is it possible to have on SQL side some kind of listener that
> will propogate changes to the Web page?
> Thanks

Data access, DataReaders, DataSets, web pages and controls

I have a question about loading data on the page lode event. The question is more conceptual then how to.

Using C#, I would like to make a call to a SQL 2000 Server, with the use of a stored procedure return one row with eleven fields. Then use the data to fill five different controls. There is no manipulation of the data it is just presented as information. With a DataReader and the GetValues method using the resultant array I can fill the controls (or can I), or with a DataSet and the Load method do the same thing. Now this code can be placed in the code behind page or it can be implemented in a class. This is the only page that uses this combination of fields and controls; however I would think a more generic call to the data could be made then pick and chose the fields as needed. What process makes the most sense? Is what I just described even possible (as yet I haven't tried it)?

As always thanks in advance for any thoughts, comments, and suggestions.

hi Darel

i think u can create a function in a class and call that function in code behind. that function will return a dataset. u cannot use datareader as u have to fill more than one control in a function call.

Data access in a variable

Hello Friends

i have one problem, i have to need fatch the data from database .

in the web form i take three grid view and i put the query "Select Top 1 coloum1 from tanlename order by newid()" .

when the data came from database there is no sequence series . so i want to take fatch the data from database in variable like int a , b , c and call the data in those variable

and put up in the feild

example :- welcome to Mr "Data call from data base (1) " how are you "Data call from data base (2)" bbye and "Data call from data base (3)"

Answer "- welcome to Mr "ASHWANI" how are you FINE OR NOT" bbye and "TAKE CARE"

there is all capslock on value came from databse and these value in the web page store in a variable

like int a ;

int b;

int c;

please help me please i have a huge problem

Ashwnai

Hi ashwani2kumar,

Not 100% sure what you mean. How do you fetch those data from your database? what does you select query look like?

welcome to Mr "Data call from data base (1) " how are you "Data call from data base (2)" bbye and "Data call from data base (3)"

Answer "- welcome to Mr "ASHWANI" how are you FINE OR NOT" bbye and "TAKE CARE"

If your string is fixed, i mean, those "welcoem to, how are you ..etc" stuff are fixed, i think you can assemble that string within a stored procedure, like this:

create procedure sp_string par1_defination,par2_defination,// i don't know how do you fetch those data, so, fill in those query parameters by yourself@.ret_str varchar(200) outputasdeclare @.str1 varchar(20),@.str2 varchar(20),@.str3 varchar(30)select @.str1=Namefrom table1 where// your query 1select @.str2=colnamefrom table2 where// your query 2select @.str3=colnamefrom table3 where// your query 3set @.ret_str='welcome to Mr'+@.str1+'how are you'+@.str2+'bbye and'+@.str3return

Hope my suggestion helps

data

I am making a web site of a magazin and when i try to store data in the tabl
e
,the data was larger . and i asked how can i store the large text in the
table and if it possible to store text file?how can i store the large text
--See my previous post on your thread for storing text.
As long as the text is less than 8000 bytes you can use varchar
(nvarchar(4000)). For a size above this limit
you can use TEXT (2^31 - 1 (2.147.483.647) bytes or 2^30 - 1 (1.073.741.823)
bytes -->NTEXT.
-store text file
You are able to store binary data, such as files:
"Generally speaking, you use text to store huge ASCII character strings,
ntext for Unicode character strings, and image for binary image data. "
It can store up to (2^31 - 1 (2.147.483.647) bytes .
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Zoza" <Zoza@.discussions.microsoft.com> schrieb im Newsbeitrag
news:DD62FB13-CB0A-4A8C-A946-84D1ACA5A8F7@.microsoft.com...
>I am making a web site of a magazin and when i try to store data in the
>table
> ,the data was larger . and i asked how can i store the large text in the
> table and if it possible to store text file?|||Thanks
I really try to use txt and ntxt to specify the type of data ,but when i try
to store data it was very large.
I want to make a table of news that contain title of news and the details of
news ,no problem of storing title,but the details of news was no longer.
I can't know what i do?
"Jens Sü?meyer" wrote:

> how can i store the large text
> --See my previous post on your thread for storing text.
> As long as the text is less than 8000 bytes you can use varchar
> (nvarchar(4000)). For a size above this limit
> you can use TEXT (2^31 - 1 (2.147.483.647) bytes or 2^30 - 1 (1.073.741.82
3)
> bytes -->NTEXT.
> -store text file
> You are able to store binary data, such as files:
> "Generally speaking, you use text to store huge ASCII character strings,
> ntext for Unicode character strings, and image for binary image data. "
> It can store up to (2^31 - 1 (2.147.483.647) bytes .
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Zoza" <Zoza@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:DD62FB13-CB0A-4A8C-A946-84D1ACA5A8F7@.microsoft.com...
>
>|||Was the data tool arge for the ntext / text column. I wonder that if so any
human would ever read this article containing more than 2^31 bytes ? Or what
did you want to say with "it was very large".
And what does "details of news was no longer" mean ?
Jens Suessmeyer.
"Zoza" <Zoza@.discussions.microsoft.com> schrieb im Newsbeitrag
news:F8DA783D-0A94-4347-AE48-72E96E8628CC@.microsoft.com...
> Thanks
> I really try to use txt and ntxt to specify the type of data ,but when i
> try
> to store data it was very large.
> I want to make a table of news that contain title of news and the details
> of
> news ,no problem of storing title,but the details of news was no longer.
> I can't know what i do?
> "Jens Smeyer" wrote:
>

Dashboard Custom Report Error : The 'version_string' parameter ismissing a value

I get errors like this " Report Parameter 'sql_handle' was not found.
I can not find anything in newsgroups or web. Anyone else get this or
have an idea. Here are my install details:
Downloaded and installed Performance Dash Board
Installed setup.sql in MSDB on server to be monitored
@.@.VERSION = Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
All standard reports work just fine. These custom reports a AWESOME
and I can't wait to see them.
Thank you!
Erik
Reading instructions is always good..DUH... You have to go through the
main dash board RDL and then its all cool.
This is SOO COOL!!!!
Are there any other custom RDL files out there on websites to
download?
Erik

Dashboard Custom Report Error : The 'version_string' parameter is

I get errors like this " Report Parameter 'sql_handle' was not found.
I can not find anything in newsgroups or web. Anyone else get this or
have an idea. Here are my install details:
Downloaded and installed Performance Dash Board
Installed setup.sql in MSDB on server to be monitored
@.@.VERSION = Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
All standard reports work just fine. These custom reports a AWESOME
and I can't wait to see them.
Thank you!
ErikReading instructions is always good..DUH... You have to go through the
main dash board RDL and then its all cool.
This is SOO COOL!!!!
Are there any other custom RDL files out there on websites to
download?
Erik

Damaged PDF files

Hi,
I have created a web application with ASP.Net 2.0. I also have created a
report using Reporting Services 2005. After showing the report on the
screen, I give the suer the possibility to export to report. One of the
possibilities is PDF. Now we have some troubles with this export.
On some PC's after saving or opening the PDF we got the message :
"There was an error opening this document. The file is damaged and could
not be repaired"
It only appears on some PC's, on other PC's exporting the same documents
works fine. It also didn't have any effect on the version of Acrobat. The
problems comes with Acro v 5, 7 and 8. Even after upgrading, deinstalling,
rebooting, installing a newer version the problem still exists on those PC's.
So I hope that someone have a solution for this as we don't know if it's a
problem with reporting services or with acrobat.
Txs in advance.On Apr 30, 4:36 am, Cipidos <Cipi...@.discussions.microsoft.com> wrote:
> Hi,
> I have created a web application with ASP.Net 2.0. I also have created a
> report using Reporting Services 2005. After showing the report on the
> screen, I give the suer the possibility to export to report. One of the
> possibilities is PDF. Now we have some troubles with this export.
> On some PC's after saving or opening the PDF we got the message :
> "There was an error opening this document. The file is damaged and could
> not be repaired"
> It only appears on some PC's, on other PC's exporting the same documents
> works fine. It also didn't have any effect on the version of Acrobat. The
> problems comes with Acro v 5, 7 and 8. Even after upgrading, deinstalling,
> rebooting, installing a newer version the problem still exists on those PC's.
> So I hope that someone have a solution for this as we don't know if it's a
> problem with reporting services or with acrobat.
> Txs in advance.
I've never seen this occur before; however, from what you are saying,
it seems that it is a non-Reporting Services issue. Traditionally, if
it was SSRS, then all of the machines would be behaving the same way.
It may not be related to Acrobat either; however, I'm not sure what
could be causing the problem (missing Adobe update, missing MS Office
update, etc). Sorry that I could not be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Dabase Creation

Is it possible to create a database structure in MS-Access and somehow import it into Visual Web Developer 2005 Express or SQL Server Management Studio 2005 Express?

Yes.

In MSAccess, go to the Tools->Database Utilities menu. Select the Upsizing Wizard.

If you are lucky, it will work. If not, there are other options (DTS).

Customizing Report Viewer Webpart of SQL Reporting Services in integration mode in MOSS200

Hi All,
I do have a question about the report viewer web part in SharePoint 2007 /
SharePoint Services 3.0. We like to have a custom report parameter section,
is it possible to modify or extend the SharePoint Report Viewer web part? Or
do we have to create one ourselves. If so, have can we do that, how does the
webpart technically work.. I need some hints on how to start.If I wrote my
own Report Viewer webpart, how must it connect to the Report List web part
etc?
Kind regards,Petersee this at :
http://blogs.sqlxml.org/bryantlikes/articles/628.aspx
Not sure whether its has a parameter section
But this one should have at : http://aspalliance.com/729
Hope that helps
Patrick
"Peter Bons" <Peter@.giessen.nl> wrote in message
news:EE1C71F9-931C-48F8-A916-613F2AABD5C5@.microsoft.com...
> Hi All,
> I do have a question about the report viewer web part in SharePoint 2007 /
> SharePoint Services 3.0. We like to have a custom report parameter
> section, is it possible to modify or extend the SharePoint Report Viewer
> web part? Or do we have to create one ourselves. If so, have can we do
> that, how does the webpart technically work.. I need some hints on how to
> start.If I wrote my own Report Viewer webpart, how must it connect to the
> Report List web part etc?
> Kind regards,
>|||As far as I can tell, the Report Viewer web part simply creates an IFRAME
and creates a URL to render the report within it.
It implements the web part interface that allows it to accept connections
and when you connect the Report List web part to it, it gets the report name
from the Report List web part to use in creating the URL.
Creating your own Report Viewer web part should be fairly simple. You just
need to build a URL and render it in the IFRAME. There are examples of this
on the web - I think one was referenced in another post.
The options you can set in a URL can be found here:
http://msdn2.microsoft.com/en-us/library/ms152835.aspx
"Peter Bons" <Peter@.giessen.nl> wrote in message
news:EE1C71F9-931C-48F8-A916-613F2AABD5C5@.microsoft.com...
> Hi All,
> I do have a question about the report viewer web part in SharePoint 2007 /
> SharePoint Services 3.0. We like to have a custom report parameter
> section, is it possible to modify or extend the SharePoint Report Viewer
> web part? Or do we have to create one ourselves. If so, have can we do
> that, how does the webpart technically work.. I need some hints on how to
> start.If I wrote my own Report Viewer webpart, how must it connect to the
> Report List web part etc?
> Kind regards,
>

Customizing Report

Hi All,

Really need advise and help out there!

I'm using CR11 with SQL d/b platform. I did manage to publish the report via web. But have some issues here:

1) Can I enable user to choose which paper size to print? How?

2) Is it possible to allow user to specify the sorting order in the report? How?

Please! Appreciate any help..Thanks

Regards,
Mee1) No idea!
2) Have a parameter; base a formula on the parameter; sort on the formula.|||Hi JaganEllis

Thanks. So you mean that do I need to customize from the backend or just simply create formula to sort the records. Hmm, let me do some try and error.

Well, I really need helps to resolve the problem.

Thanks for your concern