if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UP_WGCase_Table_GetList]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UP_WGCase_Table_GetList]
GO
------------------------------------
--用途:查询记录信息
--项目名称:CodematicDemo
--说明:
--时间:2009-4-7 17:46:36
------------------------------------
CREATE PROCEDURE UP_WGCase_Table_GetList
AS
SELECT
ID,Data,CarNum,TonNum,ConsigneeNum,Waterkou,NowNum,UnitPrice,Amount,Ash,Sulpur,GValue,Vdaf,Other,Railwayfreight,BillPrice,BillAmount,QuotationUnit,QUnitPrice,QAmount,Spread,Res
FROM [WGCase_Table]GO
这个存储过程怎么改改,可以让GRIDVIEW显示出来是中文的
drop procedure [dbo].[UP_WGCase_Table_GetList]
GO
------------------------------------
--用途:查询记录信息
--项目名称:CodematicDemo
--说明:
--时间:2009-4-7 17:46:36
------------------------------------
CREATE PROCEDURE UP_WGCase_Table_GetList
AS
SELECT
ID,Data,CarNum,TonNum,ConsigneeNum,Waterkou,NowNum,UnitPrice,Amount,Ash,Sulpur,GValue,Vdaf,Other,Railwayfreight,BillPrice,BillAmount,QuotationUnit,QUnitPrice,QAmount,Spread,Res
FROM [WGCase_Table]GO
这个存储过程怎么改改,可以让GRIDVIEW显示出来是中文的
与存储过程无关的
CREATE PROCEDURE UP_WGCase_Table_GetList
AS
SELECT
ID as 编号,Data as 数据,CarNum as 汽车数量...
也SELECT
ID as 序号,Data as 数据,...
FROM [WGCase_Table]