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=,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
  End If
  If System.IO.File.Exists(fileName2) Then
  End If
End Sub 
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_XXX") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_XXXX") %>'
SuccessURL='<%# "xxxx.asp?productid="&Request.QueryString("ProductID")&"" %>'
<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" "">
<html xmlns="">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
É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