troubleshooting Question

Execute Stored Procedure in .NET

Avatar of webdork
webdork asked on
.NET ProgrammingMicrosoft SQL Server 2005
4 Comments1 Solution332 ViewsLast Modified:
.net and sql server 2005

Stored Procedure does not fire. Any ideas why?
<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="iso-8859-1" %>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %>
 
<%@ Import Namespace="System.IO" %>
<%@ Import Namespace="System.Drawing" %>
<%@ Import Namespace="System.Drawing.Drawing2D" %>
<%@ Import Namespace="System.Drawing.Imaging" %>
<script runat="server">
 
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) 
 
  Dim filename As String = "xxxx\"&Request.QueryString("imagename")&""
  Dim filename2 As String = "xxxx\"&Request.QueryString("imagename")&""
 
  If System.IO.File.Exists(fileName) Then
    System.IO.File.Delete(fileName)
  End If
    
  If System.IO.File.Exists(fileName2) Then
    System.IO.File.Delete(fileName2)
  End If
	
End Sub 
 
</script>
 
 
 
<MM:DataSet
runat="Server"
id="Procedure1"
IsStoredProcedure="true"
CreateDataSet="false"
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_XXX") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_XXXX") %>'
CommandText="dbo.sp_xxxx"
SuccessURL='<%# "xxxx.asp?productid="&Request.QueryString("ProductID")&"" %>'
Debug="true"
><Parameters>
<Parameter  Name="@SubProductID"  Value='<%# IIf((Request.QueryString("SubProductID") <> Nothing), Request.QueryString("SubProductID"), "23") %>'  Type="Integer"   Direction="Input" /></Parameters></MM:DataSet>
<MM:PageBind runat="server" PostBackBind="true" />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
</body>
</html>
ASKER CERTIFIED SOLUTION
Éric Moreau
Senior .Net Consultant
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros