I am new to stored procedures. I want to know how to retrieve string values from stored procedures.
Like i created a website in which when user clicks a particular artists image then it's file location is
picked up from sql server. But im not getting way to retrieve from there through procedures.
create procedure arts
(SELECT ret = Location from Artist_loc
where Artist = @Artist
in aspx.cs page-----------
string Artist = Request.QueryString["art"];
SqlConnection cn = new SqlConnection(@"Data Source=BLACK_RHYMES-PC\MSSMLBIZ;Initial Catalog=Muzik;Integrated Security=True");
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "dbo.arts";
cmd.Parameters.Add("@Artist",SqlDbType.NChar,50).Value = Artist;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = cn;
i got struck after this what lines should i add to retrieve results.....
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)...
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.
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.
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 44: #line 18 "D:\PPL\PPLTest.aspx"
Line 45: using System.Web.UI.SilverlightControls;
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.
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
Set compilation debug="true" to insert debugging
symbols into the compiled page. Because this
affects performance, set this value to true only
The <authentication> section enables configuration
of the security authentication mode used by
ASP.NET to identify an incoming user.
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" />
Hello. Our programmer created a VS2005 Crystal Report that uses the
. 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?
Our programmer created a VS2005 Crystal Report that uses the
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..
i want to get data from database. I am giving connection string in my web.config file
it looks like
<add name="SampleDataBaseConnectionString" connectionString="Data Source=DREDDY9\SQLEXPRESS;Initial Catalog=SampleDataBase;Integrated Security=True"
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);
dr = myCommand.ExecuteReader();
if (dr != null)
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.
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.
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.
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.