public class Language_Codes    {        public int Id { get; set; }        public string code { get; set; }        public string Name { get; set; }    }

public CodeEntity()            : base("DefaultConnection")        {        }        public DbSet<Language_Codes> Language_Code{get;set;}
}

<connectionStrings>    <add name="DefaultConnection" connectionString="server=.;database=LanguageCode;uid=sa;pwd="      providerName="System.Data.SqlClient" />  </connectionStrings>

CodeEntity dbcontext = new CodeEntity();

 public ActionResult Index()        {            List<Language_Codes> list=  dbcontext.Language_Code.ToList();            return View(list);        }

@model IEnumerable<Translator.Models.Language_Codes>@{    ViewBag.Title = "Index";}<table  class ="table table-striped">    <tr>        <td>            <label>要翻译的文本</label>            <textarea id="text" class="form-control"   rows="5"></textarea>        </td>        <td>            将            <select id="from" class="form-control">                <option value=http://www.mamicode.com/"1">请选择</option>                @foreach (var item in Model)                {                    <option id="@item.Id" value=http://www.mamicode.com/"@item.code">@item.Name</option>                }            </select>            翻译成            <select id="to" class="form-control">                <option value=http://www.mamicode.com/"1">请选择</option>            </select>            <button id="submit" class="btn btn-default">翻译</button>        </td>        <td>            <label>翻译的文本</label>            <textarea id="transtext" class="form-control" rows="5"></textarea>        </td>    </tr>    </table>
在layout.cshtml中添加

1   <div class="navbar-collapse collapse">2                 <ul class="nav navbar-nav">3                     <li>@Html.ActionLink("主页", "Index", "Home")</li>4                     <li>@Html.ActionLink("关于", "About", "Home")</li>5                     <li>@Html.ActionLink("联系方式", "Contact", "Home")</li>6                     <li>@Html.ActionLink("翻译", "Index", "Translator")</li>7                 </ul>8             </div>

效果如下

五.利用AJAX动态加载数据

1.加载LanguageCode
首先在控制器中添加一个LoadLanguageCode来处理加载语言代码请求

 public ActionResult LoadLanguageCode(int id)        {            List<Language_Codes> list = dbcontext.Language_Code.Where(c=>c.Id!=id).ToList();            return Json(list);        }

在Scripts文件夹添加一个translator.js文件，并在视图中添加此文件的引用<script src="http://www.mamicode.com/~/Scripts/translator.js"></script>
给第一个select注册一个事件，每次select中选项更改时我们去加载第二个select的选项
document.getElementById("from").onchange=function()
    {
        var selectedid = $(":selected","#from").attr("id");
        $.ajax(
            {
                url: "../Translator/LoadLanguageCode",
                type: "post",
                data: { id: selectedid },
                success: function (_JsonData)
                {
                    $(‘#to‘).empty();
                    for (var i = 0; i < _JsonData.length; i++) {
                        $(‘#to‘).append($(‘<option‘ + ‘  id=‘ + _JsonData[i].Id + ‘  value=http://www.mamicode.com/‘ + _JsonData[i].code + ‘>‘ + _JsonData[i].Name + ‘‘));
                    }
                }
            })
    }
2.向microsoft请求服务
在TranslatorController添加 Translate方法

 [HttpPost]        public ActionResult Translate(string from,string to,string text)        {            AdmAuthentication adm = new AdmAuthentication("zuin", "Ursm3pji3Fcha+70plJFrAbHT/Y00F7vyKdXlWLusmc=");            //string text = textBox1.Text;            //string from = "zh-CHS";//"zh-CHS"            //string to = "en";            string uri = "http://api.microsofttranslator.com/v2/Http.svc/Translate?text=" + System.Web.HttpUtility.UrlEncode(text) + "&from=" + from + "&to=" + to;            string authToken = "Bearer" + " " + adm.token.access_token;            HttpWebRequest httpWebRequest = (HttpWebRequest)WebRequest.Create(uri);            httpWebRequest.Headers.Add("Authorization", authToken);            WebResponse response = null;            try            {                response = httpWebRequest.GetResponse();                using (Stream stream = response.GetResponseStream())                {                    System.Runtime.Serialization.DataContractSerializer dcs = new System.Runtime.Serialization.DataContractSerializer(Type.GetType("System.String"));                    string translation = (string)dcs.ReadObject(stream);                    return Json(translation);                }            }            catch            {                string code = "fail";                return Json(code);            }        }
给“翻译”按钮注册事件

  $(‘#submit‘).click( function ()    {        var formvalue =http://www.mamicode.com/$("#from").val();             var tovalue = http://www.mamicode.com/$("#to").val();        var textvalue = http://www.mamicode.com/$("#text").val();        $.ajax(            {                url: "../Translator/Translate",                type: "post",                data: {from: formvalue, to: tovalue, text:textvalue },                success: function (_JsonData) {                    $(‘#transtext‘).empty();                    if (_JsonData=http://www.mamicode.com/=‘fail‘) {                        alert("失败！,请联系管理员或使用微软必应在线翻译");                    }                    else {                        document.getElementById("transtext").innerHTML = _JsonData;                                         }                }            })    }    )