现在我有编码
string vcode = txtVcode.text;
ddlPurchaseCode.Items.Clear();
串QRY = 从tblPurchasedInfo选择PurchaseCode其中VENDORCODE = '' + VCODE + '' 和BillNo = '' + ddlBillNo.SelectedValue + '' 和而purchaseDate = '' + ddlPurchaseDate.SelectedValue + '';
SqlDataReader rds = cls.showDataFromTable(qry);
while(rds.Read())
{
ddlPurchaseCode.Items.Add(rds [0] .ToString());
} //结束时间
rds.Close();
cls.con.Close();
和数据库设计
Now I have coding
string vcode = txtVcode.text;
ddlPurchaseCode.Items.Clear();
string qry = "select PurchaseCode from tblPurchasedInfo where VendorCode=''" + vcode + "'' and BillNo=''" + ddlBillNo.SelectedValue + "'' and PurchaseDate=''" + ddlPurchaseDate.SelectedValue + "''";
SqlDataReader rds= cls.showDataFromTable(qry);
while (rds.Read())
{
ddlPurchaseCode.Items.Add(rds[0].ToString());
}//end of while
rds.Close();
cls.con.Close();
and Database design
CREATE TABLE [dbo].[tblPurchasedInfo](
[PurchaseCode] [varchar](50) NOT NULL,
[PurchaseDate] [smalldatetime] NOT NULL,
[EntryDate] [smalldatetime] NOT NULL,
[BillNo] [varchar](50) NOT NULL,
[VendorCode] [varchar](50) NOT NULL,
[Purchaseno] [bigint] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
问题是:ddlPurchaseCode(下拉列表)中没有加载数据
你可以帮我做什么。
如果我在数据库中将PurchaseDate设为varchar(50),问题将得到解决,但在其他页面和事务中会出现问题。你可以帮忙解决。
The problem is : Data is not loading in ddlPurchaseCode(Dropdownlist)
Can u help what shoul I do.
If I make PurchaseDate as varchar(50) in database, problem will be solved but it will be problem in other pages and transaction. Can u help how to solve.