How to set database execute statement

[kirubagari]

Hi Expert,
Kindly highlighten me how to set execute statement in the end of sql,
Attach is my code

     private void InsertintoDB()
        {
 
            string strSQL = "";
 
            string strDBType = System.Configuration.ConfigurationManager.AppSettings["DBType"];
            string strConn = System.Configuration.ConfigurationManager.AppSettings["DB_CONNECTION_STRING1"].ToString();
            string strInsertTableName_Sql = "CIMMGR.[dbo].ANSDATA";
            string strInsertTableName_Ora = "CIMMGR.ANSDATA";
 
 
            if (strDBType == "MSSQL")
            {
                strSQL = "Insert into " + strInsertTableName_Sql + "(EQID,CHAMBERID,MEMO,MESSAGE,REPORTTIME,PARAMETERID,RULEID,ALGORITHMVALUE,RULENAME,WAFER,ALARMACTION,RUNREUSLT)"
                          + " Values(" + this.m_strEQID + "," + this.m_strChamberID + "," + this.m_strDescription + "," + this.m_strMessageText + "," + this.m_parameterId + "," + this.m_ruleId + "," + this.m_RunResult + "," + this.m_algorithmValue + "," + this.m_ruleName + "," + this.m_wafer + "," + this.m_strAlarmAction + "," + this.m_strProcessID + ")";
 
 
            }
            else
            {
                strSQL = "Insert into " + strInsertTableName_Ora + "(EQID,CHAMBERID,MEMO,MESSAGE,REPORTTIME,PARAMETERID,RULEID,ALGORITHMVALUE,RULENAME,WAFER,ALARMACTION,RUNREUSLT)"
                        + " Values(" + this.m_strEQID + "," + this.m_strChamberID + "," + this.m_strDescription + "," + this.m_strMessageText + "," + this.m_parameterId + "," + this.m_ruleId + "," + this.m_RunResult + "," + this.m_algorithmValue + "," + this.m_ruleName + "," + this.m_wafer + "," + this.m_strAlarmAction + "," + this.m_strProcessID + ")";
 
 
            this.logger.LogMsg(@"[ANS] InsertIntoDB", true);
            this.logger.LogMsg(@"[ANS] [SQL]: Insert into " + strInsertTableName_Ora + "(EQID,CHAMBERID,MEMO,MESSAGE,REPORTIME,PARAMETERID,RULEID,ALGORITHMVALUE,RULENAME,WAFER,ALARMACTION,VIEWEVENT)" + " Values(" + this.m_strEQID + "," + this.m_strChamberID + "," + this.m_strDescription + "," + this.m_strMessageText + "," + this.m_parameterId + "," + this.m_ruleId + "," + this.m_RunResult + "," + this.m_algorithmValue + "," + this.m_ruleName + "," + this.m_wafer + "," + this.m_strAlarmAction + "," + this.m_strProcessID + ")",true);
            //return strSQL;
 
            }
 
        }
        //Kiru 1.8.2012 End
        #endregion

[PreethiGowri]

check out this link you get complete details

http://www.csharp-station.com/Tutori.../Lesson01.aspx

[HosseinKhoddami]

use Like this statement

string strQuery = "INSERT INTO Table1(FirstName , LastName , Age) Values ( '{0}' , '{1}' , {2} ) ";
 
strQuery = string.Format(strQuery , txt_FirstName.Text , txt_LastName.Text , Convert.Toint32(txt_Age.Text));
 
 
and Ten you can use strCommand in function like DoCommand(strQuery);
 
 
using system.data.sqlclient; // imports sqlclient on top of your form or class
 
int DoCommand(string strCommand)
{
sqlConnection con = new sqlConnection("your connection string here");
sqlCommand cmd = new sqlCommand(strCommand , con);
 
int i = 0;
con.open();
i=cmd.executeNonQuery();
con.close();
 
return i;
 
}