无法找到主机服务器上的表0错误:嗨,在我的项目时,我获取Web服务器上记录,然后它给错误,能不能找到表0",但在本地服务器上这是正确的方式运行,这是不给任何的地方SEVER上的错误,我正在使用净范筹点2.0和SQL数据库断绝2005年在我的本地服务器。
可以请任何人的帮助,这是迫切..
在此先感谢。
这是单选按钮的代码.. 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