利用C# 使用sql stored procedure
SearchShopInfo result = new SearchShopInfo();
shopObj getBuffer = new shopObj();
SqlConnection dbConn = SqlConnectStrings.HiLifePrd_Mall();
dbConn.Open();
//預存程序設定部份
SqlCommand sqlComm = new SqlCommand("EXEC 商店_查詢 " +
"@搜尋條件=@p1 , " +
"@商店類型=@p2, " +
"@起筆數=@p3, " +
"@迄筆數=@p4, " +
"@總筆數=@p5 output"
, dbConn);
//參數設定部份
sqlComm.Parameters.Add("@p1", SqlDbType.NVarChar, 50).Value = searcher;
sqlComm.Parameters.Add("@p2", SqlDbType.Int, 15).Value = type;
sqlComm.Parameters.Add("@p3", SqlDbType.Int, 15).Value = 1;
sqlComm.Parameters.Add("@p4", SqlDbType.Int, 15).Value = 10;
SqlParameter count = sqlComm.Parameters.Add("@p5", SqlDbType.Int, 32);
count.Direction = ParameterDirection.Output;
SqlDataReader reader = sqlComm.ExecuteReader();
if (reader != null)
{
while (reader.Read())//取得結果資料部份
{
getBuffer.name = reader["商店名"].ToString();
result.shopinfo.Add(getBuffer);
}
reader.Close();
result.dataCount = Convert.ToInt32(count.Value);//取得output參數部份
}
return result;
留言列表