- Data:
- 2009-03-18 09:38:12 (17 years ago)
- Lokalizacja:
- branches/TruckExpo
- Pliki:
-
- 4 zmodyfikowane
-
BazaReklam/Properties/AssemblyInfo.cs (zmodyfikowane) (1 diff)
-
BazaReklam/app.config (zmodyfikowane) (1 diff)
-
BrMerger/App.config (zmodyfikowane) (1 diff)
-
BrMerger/Form1.cs (zmodyfikowane) (4 diffs)
Legenda:
- Bez zmian
- Dodane
- Usunięte
-
branches/TruckExpo/BazaReklam/Properties/AssemblyInfo.cs
r436 r456 30 30 // 31 31 [assembly: AssemblyVersion("1.0.0.0")] 32 [assembly: AssemblyFileVersion("1.0.0.8 3")]32 [assembly: AssemblyFileVersion("1.0.0.84")] -
branches/TruckExpo/BazaReklam/app.config
r452 r456 8 8 <connectionStrings> 9 9 <clear /> 10 <add name="BAZA_REKLAM_LOCAL" connectionString="Data Source= .\sql2k;Initial Catalog=BAZA_REKLAM;Persist Security Info=True"10 <add name="BAZA_REKLAM_LOCAL" connectionString="Data Source=10.0.0.21;Initial Catalog=BAZA_REKLAM;Persist Security Info=True" 11 11 providerName="System.Data.SqlClient" /> 12 12 <add name="BAZA_REKLAM" connectionString="Data Source=sql.ct.com.pl;Initial Catalog=BAZA_REKLAM;Persist Security Info=True" 13 13 providerName="System.Data.SqlClient" /> 14 <add name="BAZA_REKLAM_TEST" connectionString="Data Source=sql.ct.com.pl;Initial Catalog=BAZA_REKLAM_TEST;Persist Security Info=True"15 providerName="System.Data.SqlClient" />16 <!--<add name="Baza_Reklam.Properties.Settings.BAZA_REKLAMConnectionString1"17 connectionString="Data Source=DOROTA-PC\SQL2005MSDN;Initial Catalog=BAZA_REKLAM;Integrated Security=True"18 providerName="System.Data.SqlClient" />19 <add name="Baza_Reklam.Properties.Settings.BAZA_REKLAM" connectionString="Data Source=DOROTA-PC\SQL2005MSDN;Initial Catalog=BAZA_REKLAM;Integrated Security=True"20 providerName="System.Data.SqlClient" />21 <add name="Baza_Reklam.Properties.Settings.BAZA_REKLAM_PROMO"22 connectionString="Data Source=DOROTA-PC\SQL2005MSDN;Initial Catalog=BAZA_REKLAM;Integrated Security=True" />23 <add name="Baza_Reklam.Properties.Settings.testowe" connectionString="Data Source=sql.ct.com.pl;Initial Catalog=BAZA_REKLAM_TEST;User ID=sa"24 providerName="System.Data.SqlClient" />25 <add name="Baza_Reklam.Properties.Settings.BAZA_REKLAM_TESTConnectionString"26 connectionString="Data Source=WSIEDZIK\SQL2005DEV;Initial Catalog=BAZA_REKLAM_TEST;Integrated Security=True"27 providerName="System.Data.SqlClient" />28 <add name="Baza_Reklam.Properties.Settings.Baza_ReklamConnectionString"29 connectionString="Data Source=HP-LAPTOP\sql2k;Initial Catalog=Baza_Reklam;User ID=sa;Password=mageroni"30 providerName="System.Data.SqlClient" />-->31 14 </connectionStrings> 32 15 <applicationSettings> -
branches/TruckExpo/BrMerger/App.config
r448 r456 5 5 <add key="TruckExpo.DbName" value="Truck_Expo" /> 6 6 7 <add key="BazaReklam.ConnectionString" value="Data Source= .\sql2k;Initial Catalog=Baza_Reklam;Persist Security Info=True;User=sa;Password=mageroni;" />8 <add key="TruckExpo.ConnectionString" value="Data Source= .\sql2k;Initial Catalog=Truck_Expo;Persist Security Info=True;User=sa;Password=mageroni;" />7 <add key="BazaReklam.ConnectionString" value="Data Source=sql.ct.com.pl;Initial Catalog=Baza_Reklam;Persist Security Info=True;User=sa;Password=9ar6u$ek;" /> 8 <add key="TruckExpo.ConnectionString" value="Data Source=sql.ct.com.pl;Initial Catalog=Truck_Expo;Persist Security Info=True;User=sa;Password=9ar6u$ek;" /> 9 9 </appSettings> 10 10 </configuration> -
branches/TruckExpo/BrMerger/Form1.cs
r455 r456 31 31 private void RunProcess() 32 32 { 33 SqlTransaction tr1 = null;33 //SqlTransaction tr1 = null; 34 34 35 35 SqlConnection conn1 = null; … … 84 84 = nKontakty = nKONTAKTY_Log = nKLIENCI_Log = nKlienci_Tytul = nOferty_Main = nSheduler = nKl_Klienci = 0; 85 85 86 tr1 = conn3.BeginTransaction();87 cmd3.Transaction = tr1;86 //tr1 = conn3.BeginTransaction(); 87 //cmd3.Transaction = tr1; 88 88 89 89 int nRead = 0; … … 737 737 //test: anulujemy operacjê 738 738 //tr1.Rollback(); 739 tr1.Commit();740 tr1 = null;739 //tr1.Commit(); 740 //tr1 = null; 741 741 742 742 conn1.Close(); … … 767 767 catch (Exception ex) 768 768 { 769 if (tr1 != null)770 {771 tr1.Rollback();772 tr1 = null;773 }769 //if (tr1 != null) 770 //{ 771 // tr1.Rollback(); 772 // tr1 = null; 773 //} 774 774 775 775 MessageBox.Show(ex.ToString());
