SQLServer2005 9.00.1314.06 Sep 2 2005 21:10:31Frameworkversion 2.0

G

Guest

SELECT @@Version
Microsoft SQL Server 2005 - 9.00.1314.06 (Intel X86)
Sep 2 2005 21:10:31
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

csc /?
Microsoft (R) Visual C# 2005 Compiler version 8.00.50727.26
for Microsoft (R) Windows (R) 2005 Framework version 2.0.50727

In an ASP.NET application, I am using an SqlDataSource.
The SelectCommand is executing a stored procedure.
The stored procedure is executed and it records into the event log an "EXEC
xp_logevent 60000, @sqlSelectStatement, informational", and returns a result
set when the control parameter is a DropDownList, but not when the control
parameter is a TextBox.

<asp:controlparameter
name="tableName"
controlid="DropDownListTableName"
propertyname="SelectedValue"
ConvertEmptyStringToNull=true
Type="string"
/>

<asp:controlparameter
name="sequenceOrderIdFrom"
controlid="TextBoxTitle"
PropertyName="Text"
ConvertEmptyStringToNull=true Type="Int32"
Direction="InputOutput" />
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,755
Messages
2,569,536
Members
45,011
Latest member
AjaUqq1950

Latest Threads

Top