using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class learning_extjs_19_1_7_CREATE_WNE : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected String Give_me_connection_wne()
{
String str_output_my, str_output_my_2;
String textField1_ID_txt_v, textField2_Titolo_txt_v, textField3_Date_txt_v, textField4_Link_txt_v, textField5_State_txt_v, textField6_Photo_txt_v, my_html_editor_Preface_txt_v, my_html_editor_Abstract_txt_v, my_html_editor_List_txt_v;
String my_html_editor_2_Abstract2_txt_v, my_html_editor_List2_txt_v, my_html_editor_Conclusion_txt_v;
String textField1_ID_txt_v_uk, textField2_Titolo_txt_v_uk, textField3_Date_txt_v_uk, textField4_Link_txt_v_uk, textField5_State_txt_v_uk, textField6_Photo_txt_v_uk, my_html_editor_Preface_txt_v_uk, my_html_editor_Abstract_txt_v_uk, my_html_editor_List_txt_v_uk;
String my_html_editor_2_Abstract2_txt_v_uk, my_html_editor_List2_txt_v_uk, my_html_editor_Conclusion_txt_v_uk;
int i;
int num_car;
int articolo_flag;
textField1_ID_txt_v = Request.Form["textField1_ID_txt_v"];
textField2_Titolo_txt_v = Request.Form["textField2_Titolo_txt_v"];
textField3_Date_txt_v = Request.Form["textField3_Date_txt_v"];
textField4_Link_txt_v = Request.Form["textField4_Link_txt_v"];
textField5_State_txt_v = Request.Form["textField5_State_txt_v"];
textField6_Photo_txt_v = Request.Form["textField6_Photo_txt_v"];
my_html_editor_Preface_txt_v = Request.Form["my_html_editor_Preface_txt_v"];
my_html_editor_Abstract_txt_v = Request.Form["my_html_editor_Abstract_txt_v"];
my_html_editor_List_txt_v = Request.Form["my_html_editor_List_txt_v"];
my_html_editor_2_Abstract2_txt_v = Request.Form["my_html_editor_2_Abstract2_txt_v"];
my_html_editor_List2_txt_v = Request.Form["my_html_editor_List2_txt_v"];
my_html_editor_Conclusion_txt_v = Request.Form["my_html_editor_Conclusion_txt_v"];
textField2_Titolo_txt_v_uk = Request.Form["textField2_Titolo_txt_v_uk"];
textField3_Date_txt_v_uk = Request.Form["textField3_Date_txt_v_uk"];
textField4_Link_txt_v_uk = Request.Form["textField4_Link_txt_v_uk"];
textField5_State_txt_v_uk = Request.Form["textField5_State_txt_v_uk"];
textField6_Photo_txt_v_uk = Request.Form["textField6_Photo_txt_v_uk"];
my_html_editor_Preface_txt_v_uk = Request.Form["my_html_editor_Preface_txt_v_uk"];
my_html_editor_Abstract_txt_v_uk = Request.Form["my_html_editor_Abstract_txt_v_uk"];
my_html_editor_List_txt_v_uk = Request.Form["my_html_editor_List_txt_v_uk"];
my_html_editor_2_Abstract2_txt_v_uk = Request.Form["my_html_editor_2_Abstract2_txt_v_uk"];
my_html_editor_List2_txt_v_uk = Request.Form["my_html_editor_List2_txt_v_uk"];
my_html_editor_Conclusion_txt_v_uk = Request.Form["my_html_editor_Conclusion_txt_v_uk"];
textField1_ID_txt_v = textField1_ID_txt_v.Trim();
textField2_Titolo_txt_v = textField2_Titolo_txt_v.Trim();
textField3_Date_txt_v = textField3_Date_txt_v.Trim();
textField4_Link_txt_v = textField4_Link_txt_v.Trim();
textField5_State_txt_v = textField5_State_txt_v.Trim();
textField6_Photo_txt_v = textField6_Photo_txt_v.Trim();
my_html_editor_Preface_txt_v = my_html_editor_Preface_txt_v.Trim();
my_html_editor_Abstract_txt_v = my_html_editor_Abstract_txt_v.Trim();
my_html_editor_List_txt_v = my_html_editor_List_txt_v.Trim();
my_html_editor_2_Abstract2_txt_v = my_html_editor_2_Abstract2_txt_v.Trim();
my_html_editor_List2_txt_v = my_html_editor_List2_txt_v.Trim();
my_html_editor_Conclusion_txt_v = my_html_editor_Conclusion_txt_v.Trim();
textField2_Titolo_txt_v_uk = textField2_Titolo_txt_v_uk.Trim();
textField3_Date_txt_v_uk = textField3_Date_txt_v_uk.Trim();
textField4_Link_txt_v_uk = textField4_Link_txt_v_uk.Trim();
textField5_State_txt_v_uk = textField5_State_txt_v_uk.Trim();
textField6_Photo_txt_v_uk = textField6_Photo_txt_v_uk.Trim();
my_html_editor_Preface_txt_v_uk = my_html_editor_Preface_txt_v_uk.Trim();
my_html_editor_Abstract_txt_v_uk = my_html_editor_Abstract_txt_v_uk.Trim();
my_html_editor_List_txt_v_uk = my_html_editor_List_txt_v_uk.Trim();
my_html_editor_2_Abstract2_txt_v_uk = my_html_editor_2_Abstract2_txt_v_uk.Trim();
my_html_editor_List2_txt_v_uk = my_html_editor_List2_txt_v_uk.Trim();
my_html_editor_Conclusion_txt_v_uk = my_html_editor_Conclusion_txt_v_uk.Trim();
textField1_ID_txt_v = textField1_ID_txt_v.Replace("'", "''");
textField2_Titolo_txt_v = textField2_Titolo_txt_v.Replace("'", "''");
textField3_Date_txt_v = textField3_Date_txt_v.Replace("'", "''");
textField4_Link_txt_v = textField4_Link_txt_v.Replace("'", "''");
textField5_State_txt_v = textField5_State_txt_v.Replace("'", "''");
textField6_Photo_txt_v = textField6_Photo_txt_v.Replace("'", "''");
my_html_editor_Preface_txt_v = my_html_editor_Preface_txt_v.Replace("'", "''");
my_html_editor_Abstract_txt_v = my_html_editor_Abstract_txt_v.Replace("'", "''");
my_html_editor_List_txt_v = my_html_editor_List_txt_v.Replace("'", "''");
my_html_editor_2_Abstract2_txt_v = my_html_editor_2_Abstract2_txt_v.Replace("'", "''");
my_html_editor_List2_txt_v = my_html_editor_List2_txt_v.Replace("'", "''");
my_html_editor_Conclusion_txt_v = my_html_editor_Conclusion_txt_v.Replace("'", "''");
textField2_Titolo_txt_v_uk = textField2_Titolo_txt_v_uk.Replace("'", "''");
textField3_Date_txt_v_uk = textField3_Date_txt_v_uk.Replace("'", "''");
textField4_Link_txt_v_uk = textField4_Link_txt_v_uk.Replace("'", "''");
textField5_State_txt_v_uk = textField5_State_txt_v_uk.Replace("'", "''");
textField6_Photo_txt_v_uk = textField6_Photo_txt_v_uk.Replace("'", "''");
my_html_editor_Preface_txt_v_uk = my_html_editor_Preface_txt_v_uk.Replace("'", "''");
my_html_editor_Abstract_txt_v_uk = my_html_editor_Abstract_txt_v_uk.Replace("'", "''");
my_html_editor_List_txt_v_uk = my_html_editor_List_txt_v_uk.Replace("'", "''");
my_html_editor_2_Abstract2_txt_v_uk = my_html_editor_2_Abstract2_txt_v_uk.Replace("'", "''");
my_html_editor_List2_txt_v_uk = my_html_editor_List2_txt_v_uk.Replace("'", "''");
my_html_editor_Conclusion_txt_v_uk = my_html_editor_Conclusion_txt_v_uk.Replace("'", "''");
articolo_flag = 0;
if((textField5_State_txt_v == "Aggiornamento Software/Firmware") || (textField5_State_txt_v == "Event - Internal Link") || (textField5_State_txt_v == "News - Internal Link") || (textField5_State_txt_v == "Email - Marketing"))
articolo_flag = 1;
// ----- INSERT of a new elemen -----
String ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath("../../../../../../mdb-database/mpbluca/database/ONCEM_MARKET_DATI_2.mdb");
OleDbConnection cn = new OleDbConnection(ConnString);
String sql_str = "INSERT INTO Tab_NewsEvents (Titolo , Data , Stralcio , Link , TipologiaNews , Preambolo_1 , PrimoElenco , Preambolo_2 , SecondoElenco , Conclusioni , LinkFoto , PosizioneFoto , Articolo ) ";
sql_str = sql_str + " VALUES ('" + textField2_Titolo_txt_v + "','" + textField3_Date_txt_v + "','" + my_html_editor_Preface_txt_v + "','" + textField4_Link_txt_v + "','" + textField5_State_txt_v + "','" + my_html_editor_Abstract_txt_v + "','" + my_html_editor_List_txt_v + "','" + my_html_editor_2_Abstract2_txt_v + "','" + my_html_editor_List2_txt_v + "','" + my_html_editor_Conclusion_txt_v + "','" + textField6_Photo_txt_v + "', 0 ," + articolo_flag + ")";
OleDbCommand comandoSQL = new OleDbCommand(sql_str, cn);
cn.Open();
int records = (int)comandoSQL.ExecuteNonQuery();
cn.Close();
// ----- SELECT ID VALUE -----
DataSet mioDataSet;
OleDbDataAdapter mioDataAdapter;
sql_str = "SELECT MAX(ID) FROM Tab_NewsEvents ";
comandoSQL = new OleDbCommand(sql_str, cn);
cn.Open();
mioDataSet = new DataSet();
mioDataAdapter = new OleDbDataAdapter(comandoSQL);
mioDataAdapter.Fill(mioDataSet, "Tab_NewsEvents");
cn.Close();
int quantiRecord = mioDataSet.Tables["Tab_NewsEvents"].Rows.Count;
str_output_my = "not set";
i = 0;
while (i < quantiRecord)
{
str_output_my = (mioDataSet.Tables["Tab_NewsEvents"].Rows[i][0]).ToString();
i++;
}
// ----- INSERT BY WEB SERVICE -----
str_output_my_2 = "";
com.uk.######.www.Service ws = new com.uk.######b.www.Service();
str_output_my_2 = ws.GiveMe_Insert_WNE(str_output_my, textField2_Titolo_txt_v_uk, textField3_Date_txt_v_uk, textField4_Link_txt_v_uk, textField5_State_txt_v_uk, textField6_Photo_txt_v_uk, my_html_editor_Preface_txt_v_uk, my_html_editor_Abstract_txt_v_uk, my_html_editor_List_txt_v_uk, my_html_editor_2_Abstract2_txt_v_uk, my_html_editor_List2_txt_v_uk, my_html_editor_Conclusion_txt_v_uk);
// ---------------------------------
if (str_output_my_2 != "")
str_output_my = str_output_my + str_output_my_2;
return str_output_my;
}
}
mi pare di aver capito che è questo il file che ti serviva giusto? se così non fosse dimmelo che ti mando anche il .disco se vuoi