从数据库asp.net读取datetime值

现在我有编码



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.



 1 条回答