Category: Blog

Block statements Declaration statements Expression statements Selection statements Iteration statements Jump statements Try catch statements Checked and unchecked Lock statement

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 =1 select name, mobile from...

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

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" />    }     </p> ---DepartmentController  public ActionResult...

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