Database

MsSQL_conn1.ConnectionString = "Server = " & frmMain.txtMyServer.Text<br />
 MsSQL_conn1.ConnectionString += "; User=RWIN" & "; Password=AVM" & "; Database =" & frmMain.txtMyDatabase.Text & ";Connect Timeout=30; Integrated Security = SSPI"

delete from EXCHANGE_STOCKS
where STOCK_ID not in (select distinct SYMBOL,EXCHANGE,(select top 1 STOCK_ID from EXCHANGE_STOCKS where SYMBOL = es.SYMBOL and EXCHANGE = es.EXCHANGE) as STOCK_ID
from EXCHANGE_STOCKS as es)

<br />
    bool InsertWorkFlowPP()<br />
    {<br />
        if (Sel.IsAuthenticated())<br />
        {<br />
            try<br />
            {<br />
                using (OleDbConnection myconn = new OleDbConnection())<br />
                {<br />
                    OleDbCommand mycomm;<br />
                    string sSQL = "INSERT INTO PP_WF(Personnel_ID,Photo_Location,pp_Name,Position,";<br />
                    sSQL += "Highlights,Education,Projects,";<br />
                    sSQL += "Full_Description,Summary,Company_ID,WF_STATUS,Is_CEO)";<br />
                    sSQL += " VALUES(@Personnel_ID,@Photo_Location,@pp_Name,@Position,";<br />
                    sSQL += "@Highlights,@Education,@Projects,@Full_Description,@Summary,@Company_ID,@WF_STATUS,@Is_CEO);";<br />
                    myconn.ConnectionString = ConfigHelper.GetWFString();<br />
                    mycomm = new OleDbCommand(sSQL, myconn);<br />
                    mycomm.Parameters.AddWithValue("@Personnel_ID", System.Convert.ToInt32(Labelcode.Text));<br />
                    mycomm.Parameters.AddWithValue("@Photo_Location", picture.ImageUrl);<br />
                    mycomm.Parameters.AddWithValue("@pp_Name", name.Text.Trim());<br />
                    mycomm.Parameters.AddWithValue("@Position", position.Text.Trim());<br />
                    mycomm.Parameters.AddWithValue("@Highlights", highlights.Text.Trim());<br />
                    mycomm.Parameters.AddWithValue("@Education", education.Text.Trim());<br />
                    mycomm.Parameters.AddWithValue("@Projects", projects.Text.Trim());<br />
                    mycomm.Parameters.AddWithValue("@Full_Description", longbio.Text.Trim());<br />
                    mycomm.Parameters.AddWithValue("@Summary", shortbio.Text.Trim());<br />
                    mycomm.Parameters.AddWithValue("@Company_Id",Sel.GetCookies("Company_id"));<br />
                    mycomm.Parameters.AddWithValue("@WF_STATUS", "NA");<br />
                    mycomm.Parameters.AddWithValue("@is_CEO", chkCEO.Checked.ToString());<br />
                    myconn.Open();<br />
                    mycomm.ExecuteNonQuery();<br />
                    return true;<br />
                }<br />
            }<br />
            catch (Exception)<br />
            {<br />
            }<br />
            finally<br />
            {<br />
            }<br />
        }<br />
        return false;<br />
    }<br />