WebApi连接数据库

首先在web.config中加上语句连接语句：

<connectionStrings>

<add name="conn" connectionString="user id=sa;Password=123abcd;initial catalog=company;Server=.;Connect Timeout=30;" providerName="System.Data.SqlClient" />

</connectionStrings>

然后再控制器中测试

using Newtonsoft.Json;using System;using System.Collections.Generic;using System.Data;using System.Data.SqlClient;using System.Linq;using System.Net;using System.Net.Http;using System.Text;using System.Web.Http;using System.Web.Http.Cors;using WebApplication.Models;using System.Configuration;namespace WebApplication.Controllers{ public class ValuesController : ApiController { [EnableCors(origins: "*", headers: "*", methods: "*")] // GET api/values public IEnumerable<string> Get() { return new string[] { "value1", "value2" }; }

// GET api/values/5 public Object Get(int id) { //return "value"; try {string connectionString = ConfigurationManager.ConnectionStrings["conn"].ToString();//引用的 using System.Configuration; SqlConnection conn = new SqlConnection(connectionString); //打开数据 conn.Open(); string sql = "select * from information where id=@id"; SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = sql; cmd.Parameters.Add(new SqlParameter("@id", id)); SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(cmd); DataSet dataSet = new DataSet(); sqlDataAdapter.Fill(dataSet); return dataSet; } catch (Exception ex) { return ex; } } // POST api/values [HttpPost] public object Post([FromBody] UserModel userModel) { try { 打开数据 //conn.Open(); //string sql = "INSERT INTO information([idcard],[bianma])VALUES(@idcard,@bianma)"; //SqlCommand cmd = conn.CreateCommand(); //cmd.CommandText = sql; //cmd.Parameters.Add(new SqlParameter("@idcard", "20181026")); //cmd.Parameters.Add(new SqlParameter("@bianma", "1026")); //SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(cmd); //DataSet dataSet = new DataSet(); //sqlDataAdapter.Fill(dataSet); //return dataSet; var strName = String.Format("一个对象，{0},{1}", userModel.bianma,userModel.idcard); return strName;

} catch (Exception ex) { return false; } }

// PUT api/values/5 public void Put(int id, [FromBody]string value) { }

// DELETE api/values/5 public void Delete(int id) { } }}

转载于:https://www.cnblogs.com/agen-su/p/9816550.html

相关资源：ASP.NET WebAPI连接数据库的方法