Comments by Member 9961335 (Top 33 by date)

@model IEnumerable<mytecbits_knockout_bootstrap_mvc_sample.models.leave_management_leave_taken>

@{
ViewBag.Title = "Index";
Layout = "~/Views/Shared/_Layout.cshtml";
}

Index

<p>
@Html.ActionLink("Create New", "Create")
</p>
<table class="table table-bordered">
<tr>
<th>
#
</th>
<th>
First Name
</th>
<th>
Leave Type
</th>
<th>
Leave Date
</th>
<th>
Status
</th>

<th></th>
</tr>

@foreach (var item in Model) {
<tr>
<td>
@Html.DisplayFor(modelItem => item.Innovation_Management_User.pk_user_id)
</td>
<td>
@Html.DisplayFor(modelItem => item.Innovation_Management_User.user_firstname)
</td>
<td>
@Html.DisplayFor(modelItem => item.Leave_Management_Leave_Type.leave_type)
</td>
<td>
@Html.DisplayFor(modelItem => item.leave_days)
</td>
<td>
@Html.DisplayFor(modelItem => item.leave_status)
</td>

<td>
@Html.ActionLink("Edit", "Edit", new {id=item.pk_leave_taken_id /* id=item.PrimaryKey */ }) |

</td>
</tr>
}

</table>

yeah

just simple html table using enity framework

i am using entityframework only

no !leave_status value in my database are 0 1 2
but when i display it on table i want to show it as a b c instead of 0 1 2

no !leave_status value in my database are 0 1 2
but when i display it on table i want to show it as a b c instead of 0 1 2

i am not i am actually asking a way to implement those the function of rowbound

Works Fine Man :D :D...
bur when i update the page i get
Store update, insert, or delete statement affected an unexpected number of rows (0)
error
because in database the variable is defined as int but this process returns me string

Works Fine Man :D :D...
bur when i update the page i get
Store update, insert, or delete statement affected an unexpected number of rows (0)
error

I need to create a Dropdown list for Leave_status where i can select text values instead of integer in view

Finally :D made it work mate! I should reinstall sql server and create a new server instance.Thanks Mate :D

but i dont have one :/

can u post me ur connection string for reference ?

Can i know what version of sql server u used ? i used sql server express 2012

add name="InnovationManagement_ConnString"
connectionString="Data Source=(localdb)\test
Initial Catalog=CSPproject-v2
providerName="System.Data.SqlClient"

i am not able to add connection string :/ and i really must thank u for ur efforts so far

<connectionstrings>
<add name="ConnString" connectionstring="data source = david-pc; initial catalog=database; user=typeyourusername; password=typeyourpassword;">

ssms:server name :(localdb)\test ,username =WINCTRL-G28QT7G\Ash
<pre lang="xml">
<connectionstrings>
<add name="InnovationManagement_ConnString" connectionstring="Data Source=(localdb)\test;Initial Catalog=CSPproject-v2;" providername="System.Data.SqlClient">
</pre>

yeah

Error: 26 – Error Locating Server/Instance

no :(

DB.Innovation_Management_UserDataTable UTbl = UTA.GetDataByLogin(TextBox_email.Text, TextBox_password.Text); i get an error in this line

I would be great help if u check whether i project is working
http://sourceforge.net/projects/lms-dml/

Actually i don't have password and when i hit run i get

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Before

<pre lang="xml"><connectionStrings>
<add name="InnovationManagement_ConnString" connectionString="Data Source=(local);Initial Catalog=LMS;User ID=sa;Password=Password1" providerName="System.Data.SqlClient"/>
</connectionStrings></pre>

After i created a database named CSPproject-v2 using server (localdb)\test so i changed the string into

<pre lang="xml"><connectionStrings>
<add name="InnovationManagement_ConnString" connectionString="Data Source=(localdb)\test;Initial Catalog=CSPproject-v2;" providerName="System.Data.SqlClient"/>
</connectionStrings></pre>

Can't get you..i am very new to programming..

problem is that i cannot connect to updated database..
The source provided me an sql script which i ran using sql server management studio which created a database.
now all i need is to connect the update database to the asp.net project..