ansaurus

Question

inserting values in database sql server 2008 in mvc through javascript/

Answer 1

A:

Well i think you can't insert values to database with Javascript directly, you should use some AJAX to send data to server-side backend. Try jQuery Javascript framework, it has lots of convinient methods for it.

Deniss Kozlovs 2009-12-08 07:33:44

Answer 2

A:

if (divid == "Refusal") {
            if (document.getElementById(divid).style.display == "block") {
                document.getElementById(divid).style.display == "none"
                document.getElementById(divid).style.visibility = "hidden";
                if (document.getElementById(divid1).style.display == "none") {
                    document.getElementById(divid1).style.display = "block"
                    document.getElementById(divid1).style.visibility = "visible";
                    var text = document.getElementById("Refusal_Text");
                    text.setAttribute("class", "newtext1");
                    text.value = "Right of First Refusal Date";

                }


            }
        }
        ...

can be cleaned up into:

   function hideVisible(divid, divid1) {
            var occupations = [{name:'Refusal',text:'Right of First Refusal Date', id:4},
                               {name:'Market',text:'Market Research'}];
            while (var x=0;x<occupations.length;x++){
                  if (occupations[x]['name'] == divid){
                        var occupation = occupations[x];
                        break;
                  }
            }
            if (occupation){
            if (document.getElementById(divid).style.display == "block") {
                document.getElementById(divid).style.display == "none"
                document.getElementById(divid).style.visibility = "hidden";
                if (document.getElementById(divid1).style.display == "none") {
                    document.getElementById(divid1).style.display = "block"
                    document.getElementById(divid1).style.visibility = "visible";
                    var text = document.getElementById(divid+"_Text");
                    text.setAttribute("class", "newtext1");
                    text.value = occupation.name;

                }

            }

           post('/newtable', function(xhr) {
              alert('Saved!: '+xhr.responseText);
            }, '?id='+occupation.id);

            }
            else {
                 //Column not found...
            }
        }
    }

function post(url, callback, params) {
    var xhr;

    if(typeof XMLHttpRequest !== 'undefined') xhr = new XMLHttpRequest();
    else {
        var versions = ["Microsoft.XmlHttp",
            "MSXML2.XmlHttp",
            "MSXML2.XmlHttp.3.0",
            "MSXML2.XmlHttp.4.0",
            "MSXML2.XmlHttp.5.0"];

        for(var i = 0, len = versions.length; i < len; i++) {
            try {
                xhr = new ActiveXObject(versions[i]);
                break;
            }
            catch(e){}
        } // end for
    }

    xhr.onreadystatechange = function() {
        if((xhr.readyState < 4) || xhr.status !== 200) return;
        callback(xhr);
    };

    xhr.open('POST', url, true);
    xhr.send(params);



}

Then add an xmlhttp request to post some data to the server, which will return a callback.

CodeJoust 2009-12-08 07:33:54

Thank you very much for ur answer,but I had to ask uthe answer of "Then add an xmlhttp request to post some data to the server, which will return a callback."Please tell me how shall I add the xmlHttp request?

Ritz 2009-12-09 11:42:57

Look at the post function.it creates a xmlhttp object, then sends data to the server, and returns the resulting data as a callback.Just set that url to take the id or name of the new column and create it in the database.(The javascript object above defines the name and text of columns, so you can there add ids and such.

CodeJoust 2009-12-09 13:38:37

ansaurus

tags:

views:

answers:

inserting values in database sql server 2008 in mvc through javascript/

related questions