JQuery Validation

TextBox Takes only Integers:

<script type="text/javascript">

function isNumberKey(evt) {

var charCode = (evt.which) ? evt.which : event.keyCode

if (charCode != 46 && charCode > 31 && (charCode < 48 || charCode > 57)) {

return false;

}

else {

return true;

}

}

</script>

call the Function in 

<asp:TextBox runat="server" ID="txtTenantID" onKeyPress="return isNumberKey(event)"></asp:TextBox></span>




Page Load Event IN Javascript:

<script type="text/javascript">
window.onload = function(){
    //do something here
}
</script>

WCF With Json Convertions

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

using Newtonsoft.Json;

using DBUtility;

using log4net;

public class Service:IService

{

public SqlConnection myConn = new SqlConnection(ConfigurationManager.ConnectionStrings["myConnection"].ToString());

string strjson = "";

public string getdetails(int ID)

{

SqlParameter[] sqlParam = new SqlParameter[1];

try

{

sqlParam[0] = new SqlParameter("@id", SqlDbType.Int) { Direction = ParameterDirection.Input, Value = ID };

DataSet ds = new DataSet();

ds = SqlHelper.ExecuteDataset(myConn, CommandType.StoredProcedure, "details", sqlParam);

strjson = JsonConvert.SerializeObject(ds.Tables[0]);

}

catch (Exception ex)

{

throw ex;

}

return strjson;

}

}

DESERIALZATION

using Newtonsoft.Json;

public void getdetails(int tID)

{

DataSet ds = new DataSet();

try

{

string = objClient.getdetails(tID);

#region Lists

List<clsModal> list = JsonConvert.DeserializeObject<List<clsModal>>(strJson);

foreach (var Item in list)

{

lblName.Text =  Item.Name;

lblCity.Text =  Item.City;

lblPhoneNo.Text =  Item .BussinessPhone;

lblAddress.Text =  Item .AddressLine1 + "</br>" +  Item .AddressLine2 + "</br>" + Tenant.AddressLine3;

lblState.Text =  Item .StateName;

lblEmail.Text =  Item .EmailID;

}

grdSummary.DataSource = list;

grdSummary.DataBind();

}

catch (Exception ex)

{

throw ex;

}

#endregion

#region WithDataTables

//Assign Values to a Datatable from Json String

DataTable dt = JsonConvert.DeserializeObject<DataTable>(strJson);

foreach (DataRow dr in dt.Rows)

{

lblName.Text =dr.ItemArray[2].ToString()+"/"+ dr.ItemArray[3].ToString();

lblCity.Text ="";

lblPhoneNo.Text = "";// dr.ItemArray[0].ToString();

lblAddress.Text = dr.ItemArray[6].ToString();

lblState.Text = "";// dr.ItemArray[0].ToString();

lblEmail.Text = dr.ItemArray[13].ToString();

}


//XML Convertion Add root to Json String

string json = "{Root:" + strTransaction + "}";

XmlDocument xml = (XmlDocument)JsonConvert.DeserializeXmlNode(json);

#endregion

}


Validate Selection at DataBase


for String Values:

select ISNULL([Role],'') [Role] from person        

For Integer values

select ISNULL([ID],0) [ID] from person        

if the the Database Column Contins the Null value also it Convert to a Int Value or string String Value Based on the Type.