Example: CREATE PROCEDURE dbo.QSPStudent ( @option int, @id int, @name varchar(50)=null, @mobile bigint=null, @email varchar(50)=null, @password varchar(50)=null, @confirm_password varchar(50)=null ) AS BEGIN begin if @option...

 public class DataManager     {         string connectionString = "Data Source=(local);Initial Catalog=CompanyDb;Persist Security Info=True;User ID=sa;Password=123";         public int...

Put in Index File... <p>    @using (Html.BeginForm("Index", "Department", FormMethod.Get)) {    <b>Search By:</b>@Html.RadioButton("searchBy", "search",true)<text>Name</text>        @Html.TextBox("search")<input type="submit" value="search" />    }  ...

https://onedrive.live.com/?cid=a0e15b608ffbb6e2#cid=A0E15B608FFBB6E2&id=A0E15B608FFBB6E2%21291