C#

private void Add_btn_Click(object sender, System.EventArgs e)
        {
            try
            {
                this.oleDbDataAdapter1.InsertCommand.CommandText =
                    "INSERT INTO Db (p-name, address, ID, dnasequence)" +
                    "VALUES     ('"+ this.textBox3.Text +"','"+this.textBox4.Text+
                    "' , "+ this.textBox1.Text +",'"+ this.textBox2.Text+ "')";

                //open the bridge between the application and the datasource
                this.oleDbConnection1.Open();

                this.oleDbDataAdapter1.InsertCommand.Connection = oleDbConnection1;

                 //execute the qurey
                this.oleDbDataAdapter1.InsertCommand.ExecuteNonQuery();

                //close the connection
                this.oleDbConnection1.Close();

                MessageBox.Show("Record insedted Successfully");

private void up_btn_Click(object sender, System.EventArgs e)
        {
            try
            {
                this.oleDbDataAdapter1.UpdateCommand.CommandText =
                    "UPDATE    Db SET "+
                    "p-name ='"+ this.textBox3.Text +"', address ='"+this.textBox4.Text +
                    "', ID ="+this.textBox1.Text+", dnasequence ='"+ this.textBox2.Text+"'"  +
                     " WHERE  ID ="+ this.textBox1.Text;

                //open the bridge between the application and the datasource
                this.oleDbConnection1.Open();

                this.oleDbDataAdapter1.UpdateCommand.Connection = oleDbConnection1;

                //execute the qurey
                this.oleDbDataAdapter1.UpdateCommand.ExecuteNonQuery();

                //close the connection
                this.oleDbConnection1.Close();

                MessageBox.Show("Record updated Successfully");

mohammed_1983 wrote:

the orginal code is work without any error

cplusplus018 wrote:

I dont even know where to start from

static void Main()
{
}

//cntrl- ID of the parent Check box
//grd - Cliend ID of the HTML Table or GridView in which all the check boxes 
//      are present
// indCat - 1 or 2 indicates call from parent or child

 
function SelectAll(cntrl,grd,indCat)
{
    var grdComp = document.getElementById(grd);          
    
    if(indCat == '1')    
    {
        for(i=1;i<=grdComp.getElementsByTagName('input').length-1;i++)
        {
            grdComp.getElementsByTagName('input')[i].checked = cntrl.checked;
        }
    }
    else if(indCat == '2')
    { 
        var chkInd = true;
        for(i=1;i<=grdComp.getElementsByTagName('input').length-1;i++)
        {                 
            if(grdComp.getElementsByTagName('input')[i].checked == false)
            {
                chkInd = false;
            }                    
        }
        grdComp.getElementsByTagName('input')[0].checked = chkInd;             
    }
}

ronensv wrote:

all the example that i saw i for connection with TCP.IP address and with port.

 

Can someone provide me a simple example of C# code