Tharinda D. Marasingha

1. In the step one you have to download or call CDN of jquery.min.js

<script src="http://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.5.1.min.js" type="text/javascript"></script>

2. Add textbox in the view by using html helper

@Html.TextBox("Textbox1")

3. And then code the script like this

<script type="text/javascript">

$(document).ready(function () {
$("#Textbox1").keydown(function (event) {
if (event.shiftKey) {
event.preventDefault();
}
if (event.keyCode == 46 || event.keyCode == 8) {
}
else {
if (event.keyCode < 95) {
if (event.keyCode < 48 || event.keyCode > 57) {
event.preventDefault();
}
}
else {
if (event.keyCode < 96 || event.keyCode > 105) {
event.preventDefault();
}
}
}
});
});

</script>

code is 100% work and fine because I have experimented above codes

thank you
Happy coding...!

In this article, I am discussing how to save records to database which added virtually to Gridview

It is very simple and here, I am not going to discuss how to connect with database and etc.. .

Above article we have done all of the operation in Gridview like “Add new, Edit, Delete” and this is continuation of those articles.

First you have to put all the data into DataTable from ViewState[“GrData”] and using “foreach” loop find the rows in your GridView. Check the code……

protected void saveDetails()
        {
            //calling Model and Property classes
             DetailsModel dmodel = new DetailsModel(connectionString());
             DetailProperty dproperty = new DetailProperty();
            //---------------------------------------------------------------

                    //put all ViewState["GrdData"] to DataTable
                    DataTable dt = (DataTable)ViewState["GrdData"];

                        // loop the rows added in Gridview
                        foreach (GridViewRow row in gdView.Rows)
                         {
                            //find the rows under the column names and assign the value of rows To property
                            dproperty.Name = dt.Rows[row.DataItemIndex]["Name"].ToString();
                            dproperty.Address=dt.Rows[row.DataItemIndex]["Address"].ToString();
                            dproperty.Gender = dt.Rows[row.DataItemIndex]["Gender"].ToString();
                            //calling data insert method
                                dmodel.insertDetails(dproperty);
                          }
                          //after saving clear the Datatable
                          dt.Clear();
                         //bind the DataTable to GridView
                         this. gdView.DataSource = dt;
                         this.gdView.DataBind();
          }

Tharinda D. Marasingha

How to type only numbers in MVC textbox

How to Save virtually added Gridview records to database