Advance

1) What this mean: AssociatedControlID 
It tells label, where focus should go once the label is clicked
You need to create the form so that when the user clicks the label the corresponding textbox is selected for input.

id="form1" runat="server">
   

        ID="lblFirstName" runat="server" Text="Enter First Name" AssociatedControlID="txtFirstName" />
        ID="txtFirstName" runat="server" />

        ID="lblLastName" runat="server" Text="Enter Last Name" AssociatedControlID="txtLastName" />
        ID="txtLastName" runat="server" />
   

2) 

page Name

You need to write code that will change the contents of the tag dynamically when the page is loaded
A)    This.hdr1.innerhtml=’ change’
B)    HtmlGenericControl ht = this.FindControl(“hdr1”) as HtmlGenericControls H1.InnerText = “Change”

3) You need to ensure that the application Checks the database every 10 seconds.
     
             

              

How to change Single char from SQL SERVER 
Ex : 001  
       101
       100


create table #A (id int, name varchar(10))

insert into #A values(1,'001'),(2,'101'),(3,'100')



Update #A Set name = (('1') + RIGHT(name,2)) 

Update #A Set name = (LEFT(name,1)+'1') + RIGHT(name,1)

Update #A Set name = (LEFT(name,2)+'1')

function OnBlurTestJson(varValue) {

            var StrValue = varValue.value;

            if (StrValue.length > 0) {

                var dataToSend =

                                {

                                    PassingValue: StrValue

                                };

                $.ajax({

                    url: "Exact Appliaction path and data sending function name",

                    type: "POST",

                    data: dataToSend,

                    success: function (data) {

                        alert("Return value");

                        alert(data);

                    }

                });

            }

        }

public JsonResult GetFunctionName(string PassingValue)
        {

            sqlConnection.Open();
            SqlCommand sqlcmd = new SqlCommand("Store ProcedureName", sqlConnection);
            sqlcmd.CommandType = CommandType.StoredProcedure;
            sqlcmd.Parameters.Add("PassingValue", SqlDbType.VarChar, 50).Value = PassingValue;
            SqlDataAdapter da = new SqlDataAdapter(sqlcmd);
            DataTable dtServices = new DataTable();
            da.Fill(dtServices);
            return Json(dtServices, JsonRequestBehavior.AllowGet);

        }

                                  
How to use Tuple in MVC

In View : @model Tuple

Controller : public ActionResult Index([Bind(Prefix = "Item1")] ApplyVisasModels ObjApplyVisasModels, [Bind(Prefix = "Item2")] TracksModels ObjTracksModels, string command)