|
greendragons wrote: set @ret = select Location from Artist_loc
where Artist = @Artist
It should be
Select TOP 1 @ret = Location from Artist_loc where Artist= @Artist
SET will only be used when you initialize variable like
SET @x = 10
Hope you got the difference between the two. 
|
|
|
|
|
Sry...still giving incorrect syntax near keword select 
|
|
|
|
|
The code he gave you is correct. I suggest you buy a book on SQL, and ask SQL questions in the SQL forums.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
have you done like this ?
Create procedure arts
@Artist nchar(50),
@Ret NVARCHAR(40) OUTPUT
AS
begin
Select TOP 1 @ret = Location from Artist_loc
where Artist = @Artist
end
|
|
|
|
|
Hi,
I have an asp.net application on the local server. I had to make some changes to the code so i copied the website to my personal system and made the changes. I had to include mysql ado.net connector, as some retrieval needed to be done from mysql database.
I installed mysql ado.net connector on my pc but haven't installed it on the server. Because of this , the asp.net site when deployed to server throws an error of an unrecognized assembly.
Though , the solution is to install ado.net connector on the server... but i want to know if there is another way in which i only copy the dll file and it works (as is the case with windows application where dlls reside in bin folder)...
Thanx in advance
|
|
|
|
|
I would expect that putting the dll in the bin directory is all you would need to do. Installing it probably puts it in the GAC, but I don't know why that would be necessary.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
|
Hi,
I currently host a site with Godaddy. I use a wildcard SSL. I recently added a sub-domain under the director "intranet". I cannot get it to work. According to godaddy the issue is with my configuration files. They say all subdomains must run in medium trust. I modified my config files correctly - I think .. but it still does not work. I think the issue is with godaddy.
here is my root config.web file:
<?xml version="1.0"?>
<configuration>
<appSettings/>
<system.web>
<compilation debug="true">
<assemblies>
<add assembly="MySql.Data, Version=5.2.3.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/></assemblies></compilation>
<authentication mode="Windows"/>
<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />
</customErrors>
</system.web>
<location allowOverride="true" path="intranet">
<system.web>
<trust level="Medium" originUrl="" />
</system.web>
</location>
<system.net>
</system.net>
<system.webServer>
<httpProtocol>
<customHeaders>
<clear/>
<add name="X-UA-Compatible" value="IE=EmulateIE7"/>
</customHeaders>
</httpProtocol>
</system.webServer>
</configuration>
here is my intranet config.web file:
<?xml version="1.0"?>
<configuration>
<appSettings/>
<system.web>
<trust level="Medium" originUrl="" />
<httpHandlers>
<add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false"/>
</httpHandlers>
<compilation debug="true">
<assemblies>
<add assembly="MySql.Data, Version=5.2.3.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/>
</assemblies>
</compilation>
<authentication mode="Forms"/>
<customErrors mode="Off">
</customErrors>
<httpRuntime useFullyQualifiedRedirectUrl="true"/>
</system.web>
</configuration>
|
|
|
|
|
Might then be that your dll cannot run in a partial trust environment
(you'll need to recompile the dll to allow partially trusted callers)
Have a look at this[^] post
|
|
|
|
|
Do you agree that my config files are correct?
|
|
|
|
|
It does look correct, cannot see anything wrong...
|
|
|
|
|
I'm trying to deploy a new webpage and keep getting the following error:
The type or namespace name 'SilverlightControls' does not exist in the namespace 'System.Web.UI'
The error is complaining about SilverlightControls yet I'm not using any Silverlight at all. There is no reference to Silverlight anywhere in my page. This error occurs when I deploy the page to the server and try to run it from there. I've currently trimmed my example back to a single page with a single asp:Button on it and I'm still getting the error.
My best guess is that it's a reference issue but no amount of clean building or profanity seems to clear it up.
Anyone run into this before or know what's going on?
I'm about to try relocating the server to the parking lot by way of the roof.
EDIT: And Poof. The error disappeared as mysteriously as it appeared. I still don't know what happened/changed but it's working now.
|
|
|
|
|
thrakazog wrote: I'm about to try relocating the server to the parking lot by way of the roof.
ROTFL !!!
Is it possible that your web.config is referencing silverlight, for some reason, and then it's not installed on the server, hence the error ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
I've gutted the everything from the web.config at this point. The server already hosts a couple Silverlight pages so if I was trying to use Silverlight it should have all the files it needs. But at this point I'm basically down to a "hello world" page and the error remains.
When I look at the Compilation Source for the error it contains:
Line 43:
Line 44: #line 18 "D:\PPL\PPLTest.aspx"
Line 45: using System.Web.UI.SilverlightControls;
Line 46:
This using statement line just doesn't exist in any of the code I wrote. The server seems to be creating it out of thin air and then complaining about it.
web.config
<?xml version="1.0"?>
<!--
Note: As an alternative to hand editing this file you can use the
web admin tool to configure settings for your application. Use
the Website->Asp.Net Configuration option in Visual Studio.
A full list of settings and comments can be found in
machine.config.comments usually located in
\Windows\Microsoft.Net\Framework\v2.x\Config
-->
<configuration>
<appSettings/>
<connectionStrings/>
<system.web>
<!--
Set compilation debug="true" to insert debugging
symbols into the compiled page. Because this
affects performance, set this value to true only
during development.
-->
<compilation debug="true">
</compilation>
<!--
The <authentication> section enables configuration
of the security authentication mode used by
ASP.NET to identify an incoming user.
-->
<authentication mode="Windows"/>
<!--
The <customErrors> section enables configuration
of what to do if/when an unhandled error occurs
during the execution of a request. Specifically,
it enables developers to configure html error pages
to be displayed in place of a error stack trace.
<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />
</customErrors>
-->
</system.web>
</configuration>
|
|
|
|
|
Wow - that sounds pretty insane.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Hello. Our programmer created a VS2005 Crystal Report that uses the
calendar control
. It seems to work fine when viewed locally but when we
publish it to the web server which is W2K Server the Calendar control's
image is not showing with a red X and some text box fields look like they're
enabled but can't click on to them. Does anyone know what we need to do to
make the Calendar control and other text box fields work when we publish
them to our webserver?
Thanks in advance.
|
|
|
|
|
amitamit099 wrote: Our programmer created a VS2005 Crystal Report that uses the
calendar control
I think you mean Calendar control in the web page that used as input to your report. I think the image path applied to the calendar control is not present there. Check whether you have deployed the images when you publish.
We often exclude image folder and see its working with WebDev server and publish to get this nasty errors.. 
|
|
|
|
|
hi Friends,
i want to get data from database. I am giving connection string in my web.config file
it looks like
<connectionStrings>
<add name="SampleDataBaseConnectionString" connectionString="Data Source=DREDDY9\SQLEXPRESS;Initial Catalog=SampleDataBase;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
from the codebehind file i am trying to accesses data from the DB, The code which i written is mentioned below
string sqlStatement = "select * from Student_Table";
String dataBaseConnection = WebConfigurationManager.ConnectionStrings["SampleDataBaseConnectionString"].ConnectionString;
//String dataBaseConnection = "Data Source=ddaya;Initial Catalog=SampleDataBase;Integrated Security=True";
SqlConnection myConnection = new SqlConnection(dataBaseConnection);
SqlCommand myCommand = new SqlCommand(sqlStatement, myConnection);
SqlDataReader dr;
myConnection.Open();
dr = myCommand.ExecuteReader();
if (dr != null)
{
Response.Write("Successfully Executed");
}
myConnection.Close();
but still it was giving an error like
Cannot open database "SampleDataBase" requested by the login. The login failed.
Login failed for user 'DREDDY9\ASPNET'.
but through sql server i am able to open the DB and i can query.
any solution for this.
|
|
|
|
|
yes.. thats a quite a general problem.
Follow the steps :
1. Connect to SQL Server Management Studio and login to your server using Console.
2. Go to Security -> Logins -> Right click and select New Login.
3. In login name type DREDDY9\ASPNET, click OK.
Now Move to the yourDataBase Tree node -> security - > users -> Right click -> New User - > Type ASPNET -> and choose Login Name as DREDDY9\ASPNET from browse.
Now I think it will work now. 
|
|
|
|
|
HOw pie chart can be created dynamically by taking data from database.
Please help me out by explaining with an example. Or any references willl do. i searched in net and other forums but was not able to get reference code with "inputs taken from database".
Thanks in advance.
Thanks,
Santa
|
|
|
|
|
why dont you use RDLC reporting tool to generate PIE charts.
It will be easier to do that. Just design the report with Pie chart in it and load in ReportViewer control on your website. 
To do that just look at this article
here.[^]
It would be a great task to create the image yourself in the server and present that to the client on the fly.
|
|
|
|
|
I will not be able to do that as i am creating aspx and .cs files dynamically from XML/XSL from windows application. Movw all these created aspx and .cs files to a newly created web application. SO i will not be able to do in above said process. I need some code for manipualationa nd display of Pie chart in asp.net for a WEB APPLICATION.
Thanks in advance.
Thanks,
Santa
|
|
|
|
|
|
I saw this link before itself. In this they are just drawimg the pie chart with their own inputs, i need this inouts to come from DB. Please help me with some code example.
Thanks,
Santa
|
|
|
|
|
yes.. I know. In that article it is doing using Random function, so that data always comes at random. Use SQL data instead of Random.
Minor modifications will give you the output.. I guess..
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
