I am using the following procedure. But when i running the procedure with multiple values it is getting error as given below. But single value specification is working fine. Ho to use dynamic query. But i am not willing to use it. solve the issue "Conversion failed when converting the varchar value ''1','2'' to data type int." My Query is:
[Code]....
sing VS 2008 at a workstation, I have successfully developed a local, file-system ASP.NET 3.5 website. The wbesite included a membership page with Windows authentication and a web parts page. The SQL Server 2005 ASPNETDB database has been created at an IIS web servr. Using the ASP.Net development server of the workstation, both the membership Membership/WebParts pages at the local website worked very well.
Then, I copied the website to a virtual directory at the IIS web server and creates a remote website for the workstation. Under theASP.NET development server of the workstation, both membership and webparts pages of the remote website at the IIS web server also worked fine.
However, when running these web pages from the IIS web server machine, something wrong happened with the web parts page. (The membership page still worked very well.) For the ASPNETDB database at the IIS web server machine, there is an EXECUTE permission error on an ASPNET stored procedure.
What are the differences between the ASP.NET development server and IIS web sever, which caused the EXECUTE permission error on the ASP.NET S.P.? How to find and fix the errors?
I have developed a MVC web application in both 3.5 and 4.0 versions.I have deployed both applications in IIS6.0 and configured proper asp.net versions in IIS for each website.But after deploying , the 4.0 application is working and 3.5 application is throwing error as "The website declined to show this webpage".I have even used different application pools for the websites.
how to do parellel execution of both the versions.
I am executing a long-running Oracle stored procedure from .NET. The procedure takes about three hours to run. Ideally, the user should be able to kick off the procedure, close the browser, and come back later to check the results.
The problem is that the connection to the Oracle procedure is lost after exactly an hour. As you would expect, the Oracle procedre runs to completion if it is executed from SQL Plus. Strangely enough, it will also run to completion if I run in debug mode on my local machine (I start two threads, one of which executes the procedure. I set a breakpoint on the second thread).
Here is my connection string:
data source= (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=serverx)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=TestSID)))
Some relevant sections from web.config:
<sessionState mode="InProc" cookieless="false" timeout="3000" stateNetworkTimeout="72000"/>
<httpRuntime executionTimeout="18000" maxRequestLength="2097151" />
Any thoughts as to why the connection is being lost in exactly an hour, and what I can do to maintain the connection until the procedure finishes?
Is it possible to return multiple values from a stored procedure? Basically, if I execute the stored proc on the C# side, then on the SQL side I do multiple calculations. Let's say I have 5 int values I need returned to the C# side.
View 4 RepliesI have DAL Layer, from where invoking a stored procedure to insert values into the table.
E.g.:-
[code]....
Now as requirement changed, per client request i have to add values 5 times. So what is the best practice?
Do i call this Stored Procedure 5 times from my DAL?
basically i have two dropdown boxes to filter data and textbox with stored procedure bound to gridview.i want to be able to query data depending on the selected value passed,either using one or more parameter values.
i would like seperate sqlcommands to chose from depending on which controls i select to pass parameters.
i have included a parameter Select(control id) as this is declared by the wizard for stored procedure.
but i am not sure how it is defined on the page and passed to procedure.
[Code]....
I have a stored procedure, which I'm calling from ASP.Net application. I'm facing a problem in stored procedure when comparing values.Please check code below to get further details.
Stored Procedure:
ALTER PROCEDURE [dbo].[MyStoredProcedure]
(@ItemID nvarchar(50), @Weight1 float, @Weight2 float)
-- check remaining/available weight in items table
DECLARE @RemainingWeight float
SET @RemainingWeight = (SELECT RemainingWeight FROM items WHERE ItemID = @ItemID)
[code]...
I am using 3 web controls ,two are cascading dropdownlists used to filter gridview control bound to a datasource.
My question is , How to define multiple queries in stored procedure that takes parameter values from the controls declared using sqldatasource.Also, return all data when i set default control value to say 'null'.
NB: one paramaterised query for cascading dropdownlists and another for other control.
below written question :
1.) What is the name of the OS process in which App Domain resides.
2.)if suppose There are Three Windows application hosted on a same envoirment and two instance is working for each application at a Time, means now total instance are six .what will happen among the below written cases :
a.) There will be six different app domain in a single OS process
b.) There will three app domain(one for each application) in a single OS process and some Parallel thread will be executed in each app domain for another instance.
c.) There will be Three OS process corresponding to each application.
3.) If eveything will remain same except there are three web application in place of windows in point 2, will there be any change in functioning.
I have a linkbutton and when it's clicked it creates a variable (being the text of the linkbutton) and then it needs to run another procedure.Here's how it looks at the moment:
[Code]....
'lookup' is the name of the other procedure I need to run but I don't know what to put in the brackets. I am currently getting the error: No overload for method 'lookup' takes '0' arguments.
Using asp.net MVC in c#, I am making a call to a stored procedure using Linq into my SQL Members table. I have no internal caching on the application, already checked to make sure it is turned off.
Test case:I have my username set to test1. From the website I change my username to test2. The website still shows test1. I go to Management Studio and run my stored procedure called MemberByEmail, it shows test2 correctly.I start simple, refresh my page to see if it's browser cache, still test1. I go to debugging and walk through the code and find that it goes correctly all the way to here to call the database:
/// <summary>Method that is mapped to the dbo.MemberByEmail database procedure.</summary>
/// <returns></returns>
[System.Data.Linq.Mapping.Function(Name="dbo.MemberByEmail")][code]...
Again I ran the stored procedure through Management Studio, and it came up with test2 as the username. I waited for 15 minutes, refreshing the web page every 5 or so, and it never cleared and served the correct test2 from the db. The last strange piece, I ran IISReset and refreshed the page, test2 was returned.
UPDATE: I created a console application to take out the web piece of it. The problem is the same when accessing directly from a console app also, no change.
I am trying to run a Stored Proc in 2008 using the sql agent. I read some posts on here and other places that say you can and I have tried what they said but isn't running. I can execute the proc form a query window and its working fine so its not my proc.I setup a job and then created a step named the step run stored procType: not sure here but I left it at default T-SQLChanged the database to the database where my sp is located Then in command i put exec dbo.sp_myprocname
View 2 RepliesI have a site that calls a long running stored procedure that eventually times out the UI. The procedure simply runs some logic in the database, and kicks of a secondary process. No data is ever returned to the UI, so I don't need the UI to wait for anything.Is there a way to call the stored procedure from the UI and move on without having the UI having to wait for the store procedure to complete?
View 4 RepliesI have a drop down with several option. I would like that if a certain item is select then a certain query will run. I read a post that
azamsharp on 12/23/03 .In that post he suggested to do:
string myProcedure = DropDownList.SelectedItem.value.ToString();
SqlCommand myCommand = new SqlCommand("myProcedure",myConnection);
while reading through the post it seems that this wasn't a great idea.
Here is what I have, but I know there must be a better way. I would like to learn one of those better ways.
[Code]....
Can some assist me with a great sight really explaining multiple contentplaceholders in the masterpage. I having issues, only one of my content holders display when runing the master page. below you will see the content 4 "Example", its not displaying can someone assist me.
[Code]....
I all of a sudden strated getting the following error when running my website. Can anyone tell me how to fix? I am using VWD 2008 with .net 3.5.
Compilation Error
description:
[Code]....
Source File: vbc : Command line Line: 0
Show Detailed Compiler Output:
[Code]....
Version Information:
Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082 An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message: BC2017: could not find library
'C:WINDOWSassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll'
Source Error:
See I want the values from my database to be displayed in textboxes by stored procedure.
I am having knowledge of inserting values to database by using stored procedure.
For Ex: database fields are
1) Studentid
2) Student name
From user i am accepting Student id in 1st textbox.
when user click ok on the button then he would be having
Student name in next textbox by using Stored Procedure..
Language I am using is C# & internal sql database
I am trying to compile simple master page but i keep on getting following error.
Compiler Error Message: CS0426: The type name 'child' does not exist in the type 'System.Web.UI.MasterPage'
Source Error:
[Code]....
Line 140: }Line 141: Line 142: [TemplateContainer(typeof(MasterPage.child))]Line 143: [TemplateInstanceAttribute(System.Web.UI.TemplateInstance.Single)]Line 144: public virtual System.Web.UI.ITemplate Template_head {
I am trying to get cell pading values from the stored procedure on to my gridview....
<ItemTemplate>
I get the fol error: An exception of type 'System.Data.SqlClient.SqlException' Occurred in System.Data.dll but was not handled in user code..Subquery returned more than 1 value. This is not permitted When the subquery Follows =,! =, <, <=,>,> = Or When the subquery is used as an expression.
IF EXISTS (SELECT CustomerId FROM Customers where CustomerId= (SELECT Id FROM @tblCustomers ))
UPDATE Customers
SET Name=(SELECT Name FROM @tblCustomers ), Country=(SELECT Country FROM @tblCustomers )
WHERE CustomerId=(SELECT Id FROM @tblCustomers );
Else
[code]...
Hello all. I created a class that runs fine when using it with web forms, however when i create a Windows service and try to run it I recieve a NullReference error. Im not sure what else to do since the class works fine.Here is a snippet.
The service
public partial class Service1 : ServiceBase
{
//Timer object
Timer RunTime;
QBridge bridge_object = new QBridge()
double test_interval = 40000; //test value
public Service1()
{
InitializeComponent();
}
protected override void OnStart(string[] args)
{
//Send email notification that intakes were pushed
//bridge_object.SendNotification(bridge_object.service_startedtext);
RunTime = new Timer(30000);
//set the elapsed event
RunTime.Elapsed += new ElapsedEventHandler(RunTime_Elapsed);
//RunTime.Interval = SetInterval(); //calculated interval
RunTime.Interval = test_interval; // test interval
RunTime.Enbled = true; //set timer to true
//QBridge bridge_object = new QBridge();
//bridge_object.SendNotification("start");
//SendNotification("start");
}
protected override void OnStop()
{
RunTime.Enabled = false; RunTime.Dispose();
try
{
bridge_object.SendNotification("stop");
}
catch (NullReferenceException nre) { System.Windows.Forms.MessageBox.Show("Error " + nre); }
catch (Exception er) { System.Windows.Forms.MessageBox.Show("Error " + er); }
//SendNotification("end");
}
//Included this to test locally. works fine when just calling the method
protected void RunTime_Elapsed(object source, ElapsedEventArgs e)
{
//SendNotification("run");
try
{
bridge_object.SendNotification(run);
}
catch (NullReferenceException nre) { System.Windows.Forms.MessageBox.Show("Error " + nre); }
catch (Exception er) { System.Windows.Forms.MessageBox.Show("Error " + er); }
}
public void SendNotification(string email_text)
{
MailMessage initial = new MailMessage();
initial.Bcc.Add(new MailAddress(""));
initial.From = new MailAddress("");
initial.Subject = "Web notification";
initial.IsBodyHtml = true;
initial.Body = email_text;
SmtpClient mailClient = new SmtpClient("192.168.1.1");
try
{
mailClient.Send(initial);
}
catch (Exception ex) { }
}
}
Class
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Net.Mail;
using System.IO;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
namespace Intake
{
public class QBridge
{
SqlConnection con =
new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
private string login_error;
public QBridge()
{
}
public void SendNotification(string email_text)
{
MailMessage initial = new MailMessage();
initial.Bcc.Add(new MailAddress(""));
initial.From = new MailAddress("");
initial.Subject = "Web notification";
initial.IsBodyHtml = true;
initial.Body = email_text;
SmtpClient mailClient = new SmtpClient("192.168.1.1");
try
{
mailClient.Send(initial);
}
catch (Exception ex) { }
}
}
}
I want to passed stored procedure parameters from crystal report to pass those parameter dynamically by arraylist because user will pass parameters by using data driven web pages (can be different reports with different parameter). how can i pass through parameter array lists to crystal report setreportparameters fields.
My code;
public void ConfigureReports(ArrayList valuesLists,ArrayList parameterLists) {
rptReportViewer.RefreshReport();
DataBaseHelper.myReportConnectionInfo = new ConnectionInfo();
DataBaseHelper.defineConnection = null;
[Code] ...
I am working on creating a stored procedure that will output a pivot table. In the pivot table will be either the string NULL or a number. How can I reformat this in ASP.NET so the NULL value becomes a blank cell in the gridview and the number (whatever it is) becomes an 'X' ?
View 3 Replies
