My stored procedure is like this.
ALTER PROCEDURE [dbo].[GetImagesByDesignId]
@DesignID bigint,
@RegID bigint,
[code]....
Problem is i want to get datattable as well as imagecount in codebehind.How can i return back datatable and imagecount to codebehind.
I'm Trying to Call the Stored Procedure which has one input Parameter and one output parameter . VB.net code is below
[Code].....
I'm using Telerik RadControls, in my codebehind I have the following function, a portion of which adds buttons to the footer.
[Code]...
I am retrieving the scope_identity of a db entry, and I want to use that variable in a different SqlDataSource, primarily as an but I am unable to access the variable.I have the variable being displayed in a msgbox, and it is displaying properly, I am just unsure how to access it in the SqlDataSource. Here is my code;This is the datasource that inserts the first information and received the scope_identity, as well as the _inserted event;
Code:
<asp:SqlDataSource ID="InsertPatientInfo" runat="server" ConnectionString="<%$ ConnectionStrings:DataConnectionString %>"
providername="<%$ ConnectionStrings:DataConnectionString.ProviderName %>"[code]....
I am working on a Asp.net based project and my requiremnent is to generate a PARTNO with the combination of MaterialType+ProductID and - 4digit random number?
NOTE: ProductID is Primary key and also set it to output parameter for example If material type is 500 and product ID generated 55 and random no generated 5434, then part no become 555-5434 how could I store partno in same table, I am somewhat trying like that
Connection.Open()
Dim trn As SqlClient.SqlTransaction
trn = Connection.BeginTransaction
Using trn
[code]....
I'm creating a tool using windows form which needs to retrieve data from an Oracle database configured to use odp.net using an Oracle Stored Procedure. I'm planning to use the code below for some basic testing. The Stored Procedure is made up of a number of OUT parameters, some of which have been mapped using the datatypes available in .NET, however other parameters are defined as tables (I guess lists) and i'm not sure how to access this data
Try
Dim oraConnString As String = "Data Source=*****;User Id=******;Password=******;"
Dim oraConnection As New OracleConnection(oraConnString)
[Code].....
ALTER PROCEDURE dbo.uspGetOrderTrackingHeaderInfo
@ContractID varchar(9)
, @SalesRepID int
, @StatusID int
, @TypeID int
, @StartDate datetime
[Code]...
We have an c# class, say we have a following method with out parameterpublic class TestCsharpClass{ public Int32 GetNumber(out bool pbNull){ pbnull=true; return 1; }}tlb file for C# project is generated with regasm tool. The above method is called in vb6 application using callbyName Dim number as IntegerDim objTest as TestCsharpClassdim blnNull as Booleannumber = CallByName(objTest,"GetNumber",VbMethod,blnNull) return value 'Number' is fine.But 'blnNull' boolean variable is "False" always.We were unable to get the out parameter value from C# code.Function signatures are defined in the IDL file.Without changing the function signature is it possible to get the resolution/workaround solution for this issue
View 4 RepliesI am having a stored procedure in sql 2005 the procedure is to retrieve year code between two days it works correctly in sql query analyzer and it returns value [code]...
View 2 RepliesI have a sql stored procedure with an output parameter. I'm just trying to read the output parameter in my code and I just cannot get it to work. The error I get is: "Procedure or function 'GetFolderData' expects parameter '@RootName', which was not supplied."
It looks like I am supplying this but it's not working.
Here is my stored procedure:
ALTER PROCEDURE [dbo].[GetFolderData]
(
@RootID int,
[Code].....
Here's a simple code snippet of a larger function as an example.
Using conn as New SqlConnection("conn string")
Using find as new SqlCommand("ExampleProc",conn)
Dim rParam as new SqlParameter("@RESULT",SqlDbType.Int)
[code]....
I know the Output parameter is returned after the SqlDataReader is closed. From what I think I know, the Using statement will call .Dispose on the SqlDataReader, so will that basically wipe out the Output parameter? If so, what is the best method to call a SqlDataReader that also contains Output parameters that closes and disposes everything correctly? Let me add that based on what I've read you only have access to the Output parameter using a SqlDataReader after you call .Close on the SqlDataReader.
in my SQL 2005 database I have defined this stored procedure:
CREATE PROCEDURE [dbo].[CheckOrders] (
@PK_Customer uniqueidentifier,
@Amount bigint OUTPUT)
[code]....
When I check the value of nAmount it stil contains the original value -1 the output value didn't return from the stored procedure although the number of records updated is 0 or more. The procedure was checked, it works and there are records updated and the value of @Amount is SET to a value 0 or more. I just don't get the values back. eventough the parameter @Amount is defined as OUTPUT. I also tried with outParam.Direction = Data.ParameterDirection.InputOutput instead of outParam.Direction = Data.ParameterDirection.Output . Same result. How do I get the value back from the stored procedure?
How can i check if an output parameter is null before i bind it to a asp literal, and if it is null i want to just make the literal [code]...
View 1 RepliesHow would I use a value from an output parameter from a stored procedure in a vb 2005 application. I would like to capture a run date from the procedure and show it on several forms in the app.
View 2 RepliesI'm in the process of switching my application from MSSQL to MYSQL. When I was using MSSQL, I retrieved the last auto increment value via
Private Sub dsImpoundInformation_Inserted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceStatusEventArgs) Handles dsImpoundInformation.Inserted
_impoundId = e.Command.Parameters("impoundId").Value
End Sub
[Code]...
ultimately, I'm just trying to get the last auto increment value but there are other sections of my code in other applications that I plan on switching to MYSQL that depend on output parameters. I have't yet explored using stored procedures but at this time I would like to get this to work in a similar fashion to how I had it with MSSQL.
Output Parameter For Stored Procedure Failing?
View 2 RepliesThe mSSQL server I have a stored procedure. That does not have an output parameter.When I run it in SQL Management Studio so the procedure will output 1 cell.
EX:
create procedure [000].[test]
as
[code].....
My application uses a third party API. This API uses a few functions that returns a value by reference as one of the function parameters. Problem is according to their documentation, the value I am trying to get out of this function is a string pointer.
So if that made no sense, heres an example of the syntax of the function as shown in their documentation:
long ExampleFunction(long ID, long PropNum, char* name, long MaxStringLength)
Input Parameters: ID, PropNum
Output Parameters: name, MaxStringLength
Thats pretty much all the info I've got. Obviously they are not using VB.Net, looks like C to me. I want to get the name output parameter and work with it, but once I get this value, I cant change anything. I know this is because its a pointer (reference type?) but I am still at a loss as to what to do.
I have a very simple stored procedure built in SQL Server 2008 that looks like this.
CREATE PROCEDURE [dbo].[usp_delBannedIP]
-- Set Required Parameters
@RowID int,
[code].....
"Index and length must refer to a location within the string. Parameter name: length" whenever I run this code
[Code]...
We currently have a asp.net website with some modules developed in VB.Net & some in C# (not just classes but also individual aspx pages and code behind). We figur
View 2 RepliesWhat I am trying to do: There are three powershell scripts with different time delays as shown below.I am trying to run them asynchronously in .NET and I followed this article to implement Asyncrhonous programming. Where I am stuck:The I am not able to retrieve output after the events are invoked.The scripts are being called but then the program ends and it shows "Press any key to continue" in console windows.I don't what I am missing here.
Info: JobRequest is a class that I use to pass around information keep track of jobs.
Sub Main()
OurAsyncFunctionCalling("psDelayScript2.ps1", "-arg1 4 -arg2 5", 1)
OurAsyncFunctionCalling("psDelayScript1.ps1", "-arg1 2 -arg2 3", 2)[code]......
I have the following code in my codebehind Page_Load function that sets the default selected value of a dropdownlist in detailsview based on the name of a record returned from a sql data query.Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
[Code]...
How can I change my selecommand, and keep it through the remainder of the page (when using pagination, sorting)?I have a page of checkboxes:
<input type="checkbox" name="checkbox_1" />
<input type="checkbox" name="checkbox_2" />
<input type="checkbox" name="checkbox_3" />
<asp:Button runat="server" Id="CustomButton" text="Create Report" PostBackUrl="report.aspx?"/>
Then on report.aspx I want to generate a standard listview based on the selections in the checkbox.
<asp:ListView runat="server" ID="ReportListView" DataSourceID="ReportListViewSDS">
<LayoutTemplate runat="server">
...<asp:PlaceHolder runat="server" ID="itemPlaceHolder" />...
[code]....
Will the changes i make to the sql command in the PreRender function hold when I have applied pagination or sorting to the listview?
I'd like to impersonate a specific user in code to perform some file manipulation on a remote machine. The problem I'm having is that I am unable to get impersonation to work. I'm using the code from the Microsoft article found here: How to implement impersonation in an ASP.NET application
I'd like direction on how/where to start the debugging process. Here are my files:
Test.aspx:
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Test.aspx.vb" Inherits="TraceFile_Test" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
[Code]....
I replaced real credentials with myUserName, myDomain, and myPassword for the post.
The web server is a Windows 2008 server running IIS 7. I'm not a server guy, so I don't know where to being the troubleshooting process. Is the issue with the code or server side?
Why can I not access to the storyboard when using WPF. In Silverlight, the exact same code works.
Codebehind VB
Public Class UserControl1
Private Sub UserControl1_MouseLeftButtonDown(ByVal sender As Object, ByVal e As System.Windows.Input.MouseButtonEventArgs) Handles Me.MouseLeftButtonDown
[code]....
Get Browsers width in CodeBehind ( C# or Vb.Net )
View 2 Replieset Browsers width in CodeBehind ( C# or Vb.Net
View 6 RepliesI need to get the DataKeyNames in codebehind of my ASP.NET application (VB.NET). How can I get that?
View 2 RepliesI have copy and pasted some VB.NET and some ASP.NET into existing files in my solution from another to fix a common problem. However, the VB isn't recognising the ID of the asp:Panel controls that I've brought over.
<asp:Panel ID="passwordPanel" runat="server" DefaultButton="SaveNewPWD">
passwordPanel.Visible = False