472,353 Members | 1,704 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,353 software developers and data experts.

1026 - Could not find stored procedure-help me URGENT...

1
hi i'm a newbie plez help me...

i'm facing this prob while running the program... can anybody help me...?

1026 - Could not find stored procedure 'dbo.SP_AccountListing'.SP_AccountListing

after i open the table then --> open vendor

public bool OpenVendorListing(AccountListingCls accListingCls)
{
bool bOK = false;
try
{
if (!this.OpenTableWithSP("tblVendorListing", "SP_AccountListing", ref dsUser))
this._errmsg = this.GetErrorMsg;
else
{
if (dsUser.Tables["tblVendorListing"].Rows.Count > 0)
{
DataRow dr = dsUser.Tables["tblVendorListing"].Rows[0];
accListingCls.CompanyID = dr["code"].ToString();
accListingCls.CompanyName = dr["name"].ToString();
accListingCls.Add1 = dr["add1"].ToString();
accListingCls.Add2 = dr["add2"].ToString();
accListingCls.Add3 = dr["add3"].ToString();
accListingCls.Add4 = dr["add4"].ToString();
accListingCls.OfficePhone = dr["tel"].ToString();
accListingCls.Fax = dr["fax"].ToString();
accListingCls.CreditLimit = dr["credit_limit"].ToString();
//email
}
bOK = true;
}

}
catch (Exception ex)
{
_errmsg = "OpenVendorListing->" + ex.Message;

}
return bOK;
}
Sep 22 '06 #1
0 1962

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Norman Scheinin | last post by:
I have an Access 2000 database connected to a SQL Server and am trying to execute my first stored procedure. I created the stored procedure and...
0
by: Nashat Wanly | last post by:
HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET and Visual C# .NET View products that this article applies to. This article was...
4
by: serge | last post by:
I tried all the INFORMATION_SCHEMA on SQL 2000 and I see that the system tables hold pretty much everything I am interested in: Objects names...
4
by: Rhino | last post by:
Is it possible for a Java Stored Procedure in DB2 V7.2 (Windows) to pass a Throwable back to the calling program as an OUT parameter? If yes,...
8
by: Thomasb | last post by:
With a background in MS SQL Server programming I'm used to temporary tables. Have just started to work with DB2 ver 7 on z/OS and stumbled into the...
4
by: T.S.Negi | last post by:
Hello All, I want to Find out list of tables, views and stored procedure used in vb form. If any body have any idea about it, pls.let me know. ...
3
by: taru | last post by:
Env: DB2 UDB 8.1 on AIX We are executing a db2 sql stored procedure which is invoked from a java client. The stored procedure contains few...
2
by: hooterbite | last post by:
I am using an object datasource to call a stored procedure to update an SQL table. THE STORED PROCEDURE WORKS FINE! THE OBJECTDATASOURCE WORKS...
1
by: den 2005 | last post by:
Hi everybody, I created several stored procedure in a local sql server 2005 express database, now when I call/execute them in the asp.net 2.0 web...
3
by: comp_databases_ms-sqlserver | last post by:
This post is related to SQL server 2000 and SQL Server 2005 all editions. Many of my stored procedures create temporary tables in the code. I want...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
0
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
0
Oralloy
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...
0
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....
0
BLUEPANDA
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.