Skip to main content
Stack Overflow
  1. About
  3. For Teams

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

Query Database Using JavaScript

I am fairly new to JavaScript and never used Ajax before. I want to add an OnClick to the Index.cshtml, so when a row is clicked, my code will query database (MSSQL)and return results. I have two tables in database, User and Contact. The primary key in User, UID, is the foreign key in Contact. Here's my code:

Controller

 private UserInfoEntities db = new UserInfoEntities();
 public ActionResult Index(){
 var users = from u in db.User orderby u.UID select u;
 return View(users.ToList());
}

View

@<Info.Model.User>
 <script type="text/javascript">
 function showEmail() {
 var tb = document.getElementById("users");
 var rows = tb.rows;
 for (var i = 1; i < rows.length; i++) {
 rows[i].onclick = (function() { 
 //some code that query Contact table using UID
 // and return Contact.Email in a popup windows or something
 });
 }
 }
</script>
<table class="table" id="users" onclick="showEmail()">
 <tr>
 <th>
 @Html.DisplayNameFor(model => model.NAME)
 </th>
 <th>
 @Html.DisplayNameFor(model => model.UID)
 </th>
 </tr> 
@foreach (var item in Model) {
 <tr>
 <td>
 @Html.DisplayFor(modelItem => item.NAME)
 </td>
 <td>
 @Html.DisplayFor(modelItem => item.UID)
 </td> 
 </tr>

Any help is appreciated!

Answer*

Draft saved
Draft discarded
Cancel
3
  • what issue are you facing? Commented Jun 21, 2016 at 11:16
  • When a row is clicked, user.UID of that row is passed ot javascrip code as a parameter, and the code will query Contact table in database on where (user.UID == contact.UID), and return contact.EMAIL Commented Jun 21, 2016 at 11:28
  • not getting you. are you asking about how to pass parameter in it? Commented Jun 22, 2016 at 3:54

default

AltStyle によって変換されたページ (->オリジナル) /