表：員工code|Name|Left----+----+----1 | A | Y2 | B | N3 | C | N4 | D | Y5 | E | N6 | F | Y現在我在做， SqlConnection cn=new SqlConnection(); SqlCommand cmd = new SqlCommand(); cn.ConnectionString="<CONNECTION STRING>" List<string> str = new List<string>(); cmd.Connection=cn; cmd.Connection.Open(); cmd.CommandText="Select code from employee where Left='Y'"; SqlDataReader dr=cmd.executeReader(); while(dr.Read()) { str.Add(dr1.GetValue(0).ToString()); } foreach (string p in str) { Response.Write(p); }此代碼僅獲取1個數據，我如何獲取Left ='Y'的所有數據
3 回答
浮云間
TA貢獻1829條經驗 獲得超4個贊
我認為如果您在sql server中使用存儲過程會更好...您可以為查詢創建一個
USE [DBName]
GO
/****** Object: StoredProcedure [dbo].[GetCode] Script Date: 03/05/2018 10:51:19 a.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[GetCode]
(
@Left char
)
AS
BEGIN
SET NOCOUNT ON;
SELECT Code FROM Employee WHERE Employee.Left in (@Left)
END
...
然后，您可以通過以下方式從c＃調用它：
private List<Type> GetCode(string Left)
{
List<Type> List = new List<Type>();
DbConnection();
con.Open();
DynamicParameters Parm = new DynamicParameters();
Parm.Add("@Left", Left, DbType.String, ParameterDirection.Input, 2);
//Parm.Add(nameOfParameter,valueOfParameter,typeOfParameter,directionOfParameter,sizeOfParameter);
List = SqlMapper.Query<Type>(con, "Entities.GetCode", Parm, commandType: CommandType.StoredProcedure).ToList();
con.Close();
return List;
}
- 3 回答
- 0 關注
- 290 瀏覽
添加回答
舉報
0/150
提交
取消