using System; using System.Collections.Generic; using System.Linq; using System.Net; using System.Net.Http; using System.Web.Http; using System.Net.Http.Formatting; using System.Data; using MvcMusicStore.Models; using System.Data.Entity; using System.Configuration; using System.Data.SqlClient; namespace MvcMusicStore.Controllers { public class ExtJSApiController : ApiController { public dynamic ReviewDataGet(FormDataCollection form) { string conn = ConfigurationManager.ConnectionStrings["MvcMusicStoreContext"].ConnectionString; DataTable dt = new DataTable(); string strCheck = form.Get("x"); string strAlbumID = form.Get("AlbumID"); string strTitle = form.Get("Title"); using (SqlConnection sqlConnection = new SqlConnection(conn)) { string strSql = "SELECT * FROM Albums WHERE AlbumID LIKE @AlbumID AND Title LIKE @Title"; SqlCommand sqlCommand = new SqlCommand(strSql, sqlConnection); sqlCommand.Parameters.AddWithValue("@AlbumID", "%" + strAlbumID + "%"); sqlCommand.Parameters.AddWithValue("@Title", "%" + strTitle + "%"); sqlConnection.Open(); dt.Load(sqlCommand.ExecuteReader()); } DataSet ds = new DataSet(); ds.Tables.Add(dt); return new ApiResponse() { success = true, msg = "", ds = ds }; } public dynamic AlbumComboGet() { DataTable dt = new DataTable(); using (SqlConnection sqlConnection = new SqlConnection(conn)) { string strSql = "SELECT AlbumID AS 'TEXT',AlbumID AS 'VALUE' FROM Albums"; SqlCommand sqlCommand = new SqlCommand(strSql, sqlConnection); sqlConnection.Open(); dt.Load(sqlCommand.ExecuteReader()); } return dt; } } public class ApiResponse { public DataSet ds { get; set; } public string msg { get; set; } public bool success { get; set; } } }
2014年10月22日 星期三
ASP.NET MVC Web API 資料庫處理 using
訂閱:
張貼留言 (Atom)
沒有留言:
張貼留言