在主机服务器上找不到表0错误 [英] Cannot find Table 0 error on the host server

问题描述

HI，在我的项目中，当我在Web服务器上获取记录时，它会给出错误找不到找到 表0 "，但在本地服务器上它以正确的方式运行，在本地服务器上没有任何错误，我在本地服务器上使用了点网框架2.0''和数据库sql服务器2005.
谁能帮忙，这很紧急..
提前谢谢.
这是单选按钮的代码.

HI , In my project when i fetch record on the web sever then it give the error, Cannot find Table 0'' but on the local server this is running in proper way, this is not give any error on the local sever, I am using dot net framwork 2.0'' and database sql sever 2005 on the my local server.
Can any one help please, this is urgent..
Thanks in advance.
this is the code for radio button..

protected void rbtnTax_CheckedChanged(object sender, EventArgs e)
    {
        if (rbtnTax.Checked == true)
        {
            rbtnSale.Checked = false;
            enablecontrols();
            lblSaleTax.Text = "TAX INVOICE";
            FillBookInvoiceNoTax();
        }
    }

//...this is  the method...............
public void FillBookInvoiceNoTax()
    {
        DataSet dsBook = new DataSet();
        int BookNo = 0;
        int InvoiceNo = 0;

        dsBook = oAdmin.GetBookNoInvoiceNoTax1();

        string BNo = dsBook.Tables[0].Rows[0][1].ToString();
        string INo = dsBook.Tables[0].Rows[0][0].ToString();

        if (BNo == "" && INo == "")
        {

            DataSet DsBI = new DataSet();
            DsBI = oAdmin.GetBookNoInvoiceNoTax();
            BookNo = Convert.ToInt32(DsBI.Tables[0].Rows[1]["BookNo"].ToString());
            InvoiceNo = Convert.ToInt32(DsBI.Tables[0].Rows[1]["InvoiceNo"].ToString());
            InvoiceNo = InvoiceNo - 1;



        }
        else
        {
            BookNo = Convert.ToInt32(BNo);
            InvoiceNo = Convert.ToInt32(INo);
        }


        if (BookNo == 0 && InvoiceNo == 0)
        {
            BookNo = 1;
            InvoiceNo = 1;
            lblBookNoS.Text = BookNo.ToString();
            lblInvoiceNoS.Text = InvoiceNo.ToString();
        }

        else if (InvoiceNo % 50 == 0)
        {
            BookNo = BookNo + 1;
            InvoiceNo = InvoiceNo + 1;
            lblBookNoS.Text = BookNo.ToString();
            lblInvoiceNoS.Text = InvoiceNo.ToString();
        }
        else
        {
            InvoiceNo = InvoiceNo + 1;
            lblBookNoS.Text = BookNo.ToString();
            lblInvoiceNoS.Text = InvoiceNo.ToString();
        }

    }
//...............this is the claas which i am using..............
 public DataSet GetBookNoInvoiceNoTax()
        {
            DataSet oDs = null;
            SqlDataReader oDR;
            string strSPName;

            try
            {
                strSPName = "GetBookInvoice ";

                oDs = oDU.GetDataSetProc(strSPName);
                return oDs;
            }
            catch
            {
                return oDs;
            }
        }
//..............this is the second class..............
         public DataSet GetBookNoInvoiceNoTax1()
        {
            DataSet oDs = null;
            SqlDataReader oDR;
            string strSPName;

            try
            {
                strSPName = "GetInvoceTaxpurchase ";

                oDs = oDU.GetDataSetProc(strSPName);
                return oDs;
            }
            catch
            {
                return oDs;
            }
        }
//.............this is the stotr  procedure first..................
ALTER PROCEDURE [dbo].[GetInvoceTaxpurchase]
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	SELECT max(InvoiceNo), max(BookNo)
        FROM [Inventry].[dbo].[BookInvoiceTax]
END
//....this is the second procedure.............
ALTER PROCEDURE [dbo].[GetBookInvoice]
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	SELECT * from SetBookInvoice
END

推荐答案

好像查询未返回任何内容.访问任何数据集之前，请先检查该数据集是否完全包含任何表.

调试代码并检查数据集是否返回任何值.

Looks like the query did not return anything. Check first if the the dataset contains any tables at all before accessing any.

debug your code and check if dataset return any value.

这是解决此错误的方法

This is the solution for this error

ALTER PROCEDURE [dbo].[GetInvoceTaxpurchase]
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
 
        -- Insert statements for procedure here
	SELECT max(InvoiceNo), max(BookNo)
        FROM BookInvoiceTax
END

这篇关于在主机服务器上找不到表0错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！