Help Backup: aspx

Showing posts with label aspx. Show all posts

Friday, March 30, 2012

hide my report toolbar

Hi.

i would like to configure my reports to hide the Toolbar. I'm not using any aspx page to contain my report, I'm just opening it from the server with IE.

is there a way to configure the report thet he does't have any tool bar?

Thanks,

Roy.

Look in the BOL for ULR parametrization, the rc:Toolbar=no should do the job.

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de
|||

Thanks :)

i don't know what is "BOL for ULR ".

but the code was good (i used rc:toolbar=false).

thanks!

|||Just to add, BOL means Books Online which is actually the help of SQL Server. look for the URL access there.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Wednesday, March 7, 2012

help?

I need a little help to get me going.

I have built a web app in visual web developer and made and

inserted an sql db into the site with multiple .aspx pages.

It all compiles and seems great. Info from the db is displayed,however

when it comes to edit, insert or delete it bombs out

" incorrect syntax near'nvarchar' or on delete........'int'

some thing needs to be set to true...

All conection strings seem fine and test ok.

ps, whats the best way to to totally smash your dell laptop to pieces

and send it to pluto?

Have included error

Do you compose the commands on your own ? If yes, try to see what command(text) is actually executed against the database. if not, startup profiler to see the command executed.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

I don,t write the commands yet myself....all key events.

I will check and reply

Many thanks

|||Sure, come back if you have any questions.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Still got this glitch.

Could you have a look at the code for me.....the source code seems all to be ok with the target?

|||Seems that the statements posted do not contain any information about nvarchar, so I guess this is related to any trigger based on the tables. Have alook if there are any triggers which might get fired during the DML process.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Hi jens

thanks for your help recently.

I found out that i was trying to load data to my sql with the details view "tool" ................oops.

My test sql seems to be working like a train now. Also now discovering the full functionality

of sql and can see that im at the bottom of a large hill.

My next problem is publishing.

My hosting package has been upgraded to the version 2.0 asp.net runtime. and has sql enabled.

web dev.......copy function drops all the files into the server nicely and i can see them all.

The problem is it will not unwrap or show, and returns.........you do not have privaleges to view this htm.

All a bit strange to me but?

I have not touched any of the security controls in the config manager or code.

regards Richard uk

Sunday, February 19, 2012

Help..Error connecting to SQL Server

Hi,

I am writing my first aspx file to connect to a standalone SQL Server which is separated from the IIS webserver. The code is

<HTML>
<HEAD>
<TITLE>Store Locator</TITLE>
<script runat="server">
Sub Page_Load(ByVal Sender as Object, ByVal E as EventArgs)
if Not IsPostBack Then
Dim DBConn as OleDbConnection
Dim DBCommand As OleDbDataAdapter
Dim DSPageData as New DataSet
DBConn = New OleDbConnection("Provider=sqloledb;" _
& "server=dailyplanet;" _
& "Initial Catalog=JAVSTORE;" _
& "User Id=javtrader;" _
& "Password=rage123;")
DBCommand = New OleDbDataAdapter _
("Select * " _
& "From JAVInventory " _
& "Where ID > ((Select COUNT(ID) " _
& "From JAVInventory ) - 100)" _
& "Order By ID DESC", DBConn)
DBCommand.Fill(DSPageData, _
"RecentJAVs")
' ddlZipCode.DataSource = _
' DSPageData.Tables("RecentJAVs").DefaultView
' ddlZipCode.DataBind()
End If
End Sub

I used Visual .Net and Web Matrix and was able to connect to the sql server with the Data Connection to view the tables. However, when I use IIS or the Visual .Net debugger to run the aspx file, it get the following error.. please help..

Server Error in '/javtrade' Application.
------------------------

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Source Error:

Line 21: & "From JAVInventory ) - 100)" _
Line 22: & "Order By ID DESC", DBConn)
Line 23: DBCommand.Fill(DSPageData, _
Line 24: "RecentJAVs")
Line 25: ' ddlZipCode.DataSource = _

Source File: c:\inetpub\wwwroot\javtrade\management.aspx Line: 23

Stack Trace:

[OleDbException (0x80004005): [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.]
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
System.Data.OleDb.OleDbConnection.InitializeProvider()
System.Data.OleDb.OleDbConnection.Open()
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
ASP.management_aspx.Page_Load(Object Sender, EventArgs E) in c:\inetpub\wwwroot\javtrade\management.aspx:23
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731Two suggestions, one is to supply a 'server' name of localhost. The second is to make sure that the ASP.NET user has access to the SQL server.

Josh

Friday, March 30, 2012

hide my report toolbar

Wednesday, March 7, 2012

help?

Sunday, February 19, 2012

Help..Error connecting to SQL Server

Help Backup

Blog Archive

About Me