Stored procedure calling problem

Question

0.00/5 (No votes)

See more:

I am getting error table o not found
stored procedure name is "pr_ins_upd_reqdtls"

VB

Dim constr As String = ConfigurationManager.AppSettings("PooledConnectionString")
        Dim sqlcon As New SqlConnection(constr)
        Dim ds As New DataSet()
        'cmd As SqlCommand

        Dim cmd = New SqlCommand("pr_ins_upd_reqdtls", sqlcon)
        cmd.Connection = sqlcon
        cmd.CommandType = CommandType.StoredProcedure

        cmd.Parameters.Clear()
        cmd.CommandText = "pr_ins_upd_reqdtls"
        Dim Var_StrLoginame As String = Session("LoginName")

        cmd.Parameters.AddWithValue("@pa_action", "SEARCHCHK")
        cmd.Parameters.AddWithValue("@pa_tholder", ddlselect.Value)
        If (filter.Value = "I") Then
            cmd.Parameters.AddWithValue("@pa_boid", hdfilter.Value)
            cmd.Parameters.AddWithValue("@pa_req_slip_no", "")
            cmd.Parameters.AddWithValue("@pa_req_date", "")
        ElseIf (filter.Value = "S") Then
            cmd.Parameters.AddWithValue("@pa_boid", "")
            cmd.Parameters.AddWithValue("@pa_req_slip_no", hdfilter.Value)
            cmd.Parameters.AddWithValue("@pa_req_date", "")
        ElseIf (filter.Value = "D") Then
            cmd.Parameters.AddWithValue("@pa_boid", "")
            cmd.Parameters.AddWithValue("@pa_req_slip_no", "")
            Dim pdate As Date
            pdate = ClsDate.GetFormatedDate(hdfilter.Value, "DD/MM/YYYY")
            cmd.Parameters.AddWithValue("@pa_req_date", pdate)
        End If
        cmd.Parameters.AddWithValue("@pa_login_name", Var_StrLoginame)
        'parameters not in use
        cmd.Parameters.AddWithValue("@pa_id", 0)
        cmd.Parameters.AddWithValue("@pa_boname", "")
        cmd.Parameters.AddWithValue("@pa_sholder", "")
        cmd.Parameters.AddWithValue("@pa_chk_yn", 0)
        cmd.Parameters.AddWithValue("@pa_rmks", "")
        cmd.Parameters.Add("@pa_error", SqlDbType.VarChar, 8000)
        cmd.Parameters("@pa_error").DbType = DbType.AnsiString
        cmd.Parameters("@pa_error").Direction = ParameterDirection.Output
        Dim da As New SqlDataAdapter(cmd)
        'da.SelectCommand = cmd
        'da = New SqlDataAdapter(cmd)
        da.Fill(ds, "pr_ins_upd_reqdtls")
        'If ((ds.Tables(0).Rows.Count > 0)) Then
        GridView1.DataSource = ds.Tables(0)
        GridView1.DataBind()
        Dim rowcount As Integer
        rowcount = ds.Tables(0).Rows.Count
        lblsubheader.Text = "Records Found,  " & rowcount & " "
        'End If

z

Posted 28-Apr-11 2:42am

Mayur Gujrathiii

Add a Solution

Comments

Mahendra.p25 28-Apr-11 8:46am

check your stored procedure

jim lahey 28-Apr-11 8:47am

Post the code of your stored procedure, the problem is in there. also, if your SqlCommand is a stored procedure, you don't need to set the CommandText property.

Mayur Gujrathiii 28-Apr-11 8:51am

My stored procedure

USE [DMAT_SVV]
GO
/****** Object: StoredProcedure [citrus_usr].[pr_ins_upd_reqdtls] Script Date: 04/28/2011 10:17:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--select top 1 * from slip_issue_mstr
/*
create table Dis_req_Dtls_mak
(id numeric identity(1,1)
,req_slip_no varchar(100)
,req_date datetime
,Boid varchar(16)
,Boname varchar(150)
,sholder varchar(150)
,tholder varchar(150)
,created_dt datetime
,created_by varchar(100)
,lst_upd_dt datetime
,lst_upd_by varchar(100)
,deleted_ind smallint)

create table Dis_req_Dtls
(id numeric identity(1,1)
,req_slip_no varchar(100)
,req_date datetime
,Boid varchar(16)
,Boname varchar(150)
,sholder varchar(150)
,tholder varchar(150)
,created_dt datetime
,created_by varchar(100)
,lst_upd_dt datetime
,lst_upd_by varchar(100)
,deleted_ind smallint)

*/
ALTER proc [citrus_usr].[pr_ins_upd_reqdtls](@pa_id numeric
, @pa_action varchar(50)
, @pa_req_slip_no varchar(100)
, @pa_req_date datetime
, @pa_boid varchar(16)
, @pa_boname varchar(150)
, @pa_sholder varchar(150)
, @pa_tholder varchar(150)
, @pa_login_name varchar(100)
, @pa_chk_yn smallint
, @pa_rmks varchar(200)
, @pa_error varchar(8000) output
)
as
begin

if @pa_chk_yn = 0
begin

if @pa_action ='INS'
begin

insert into Dis_req_Dtls
select @pa_req_slip_no
,@pa_req_date
, @pa_boid
, @pa_boname
, @pa_sholder
, @pa_tholder
, getdate()
, @pa_login_name
, getdate()
, @pa_login_name
,1
,NULL
,@pa_rmks

end
if @pa_action ='EDT'
begin

update Dis_req_Dtls
set req_slip_no=@pa_req_slip_no
,req_date=@pa_req_date
,Boid=@pa_boid
,Boname=@pa_boname
,sholder=@pa_sholder
,tholder = @pa_tholder
,remarks = @pa_rmks
,lst_upd_dt = getdate()
,lst_upd_by =@pa_login_name
where id = @pa_id
and deleted_ind = 1

end
if @pa_action ='DEL'
begin

update Dis_req_Dtls
set deleted_ind = 0
,lst_upd_dt = getdate()
,lst_upd_by =@pa_login_name
where id = @pa_id
and deleted_ind = 1

end
if @pa_action ='VALIDATESELECT'
begin
select SLIIM_DPAM_ACCT_NO
, dpam_sba_no , isnull(DPHD_SH_FNAME,'') + ' ' + isnull(DPHD_SH_MNAME,'') +' ' + isnull(DPHD_SH_LNAME,'') sh_holder
, isnull(DPHD_TH_FNAME,'') + ' ' + isnull(DPHD_TH_MNAME,'') +' ' + isnull(DPHD_TH_LNAME,'') th_holder
from slip_issue_mstr , dp_acct_mstr left outer join dp_holder_dtls on dphd_dpam_id = dpam_id
where SLIIM_SLIP_NO_TO = replace(@pa_req_slip_no ,SLIIM_SERIES_TYPE,'')
and sliim_deleted_ind =1
end
if @pa_action ='SEARCH'
begin

select * from Dis_req_Dtls
where req_slip_no = @pa_req_slip_no
and deleted_ind =1

end

end
else if @pa_chk_yn = 1
begin

if @pa_action ='INS'
begin
if not exists(select req_slip_no from Dis_req_Dtls where id = @pa_id)
insert into Dis_req_Dtls_mak
select @pa_req_slip_no
,@pa_req_date
, @pa_boid
, @pa_boname
, @pa_sholder
, @pa_tholder
, getdate()
, @pa_login_name
, getdate()
, @pa_login_name
,0
, @pa_rmks

end
if @pa_action ='EDT'
begin
if not exists(select req_slip_no from Dis_req_Dtls where id = @pa_id and deleted_ind = 1)
begin
update Dis_req_Dtls_mak
set req_slip_no=@pa_req_slip_no
,req_date=@pa_req_date
,Boid=@pa_boid
,Boname=@pa_boname
,sholder=@pa_sholder
,tholder = @pa_tholder
,remarks = @pa_rmks
,lst_upd_dt = getdate()
,lst_upd_by =@pa_login_name
where id = @pa_id
and deleted_ind = 0
END
ELSE
BEGIN
insert into Dis_req_Dtls_mak
select @pa_req_slip_no
,@pa_req_date

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ra-one · Answer 1 · 2011-04-28T02:57:00

Solution 1

hi,

remove

da.Fill(ds, "pr_ins_upd_reqdtls")

from your code and add

da.Fill(ds)

validate for the table check

If ((ds.Tables(0).Rows.Count > 0)) Then

Posted 28-Apr-11 2:57am

Ra-one

Comments

Mayur Gujrathiii 28-Apr-11 9:02am

error:Cannot find table 0