C# brisanje file-a

poruka: 6
|
čitano: 2.731
|
moderatori: XXX-Man, vincimus
1
+/- sve poruke
ravni prikaz
starije poruke gore
17 godina
neaktivan
offline
C# brisanje file-a

Imam problema sa brisanjem file-a, odnosno SQL baze. Dobijem grešku da se ona još koristi.
Malo sam googlao i vidio da bi trebao staviti pooling na false. To sam i napravio u connection string-u, ali nije pomoglo.

Ima tko kavku ideju?

                    System.Net.WebClient Baza = new System.Net.WebClient();
                    Baza.DownloadFile("http://dl.dropbox.com/u/14208/ABC.mdf", "C:\\ABC.mdf");
                    Baza.DownloadFile("http://dl.dropbox.com/u/14208/ABC_log.ldf", "C:\\ABC_log.ldf");

                    System.Data.SqlClient.SqlConnection con;
                    con = new System.Data.SqlClient.SqlConnection();
                    con.ConnectionString ="Data        Source=.\\SQLEXPRESS;AttachDbFilename=C:\\ABC.mdf;IntegratedSecurity=True;            
                    Pooling=False;Connect Timeout=30;User Instance=True";

                    DataSet ds1;
                    ds1 = new DataSet();
                    System.Data.SqlClient.SqlDataAdapter da;

                    string sql = "SELECT * From ABC";
                    da = new System.Data.SqlClient.SqlDataAdapter(sql, con);
                   
                    con.Open();
                    da.Fill(ds1, "ABC");
                    int MaxRow = ds1.Tables["ABC"].Rows.Count;
                    try
                    {
                        int i = 0;
                        for (i = 0; i < MaxRow; i++)
                        {
                            DataRow dRow = ds1.Tables["ABC"].Rows[i];
                            if (textbox1.Text.ToString() == dRow.ItemArray.GetValue(1).ToString() && textbox2.Text.ToString() ==
                            dRow.ItemArray.GetValue(2).ToString())
                            {
                                MessageBox.Show("OK");
                            }
                            else
                            {
                                MessageBox.Show("False");                               
                            }
                        }                        
                    }
                    catch { }

                    con.Close();
                    con.Dispose();;                  
                    System.IO.File.Delete("C:ABC.mdf");
                    System.IO.File.Delete("C:ABC_og.ldf");                 
                }

                catch
                {}
            }    
        } 
    }
}

 
0 0 hvala 0
16 godina
neaktivan
offline
RE: C# brisanje file-a

Probaj sve to ubacit unutar using bloka, znaci

 

using(ode otvori konekciju)

{

// paste-aj doe svoj kod

}

 

// i ode stavi kod za brisanje file-a (baze)

17 godina
protjeran
offline
C# brisanje file-a

Jel ovo web ili Win Forms Aplikacija?

Programko http://programko.bloger.hr
 
0 0 hvala 0
17 godina
neaktivan
offline
RE: C# brisanje file-a
windows form
17 godina
neaktivan
offline
C# brisanje file-a

fali ti backslash. tribalo bi bit ovako

 

System.IO.File.Delete(@"C:\ABC.mdf");

System.IO.File.Delete(@"C:\ABC_og.ldf");     

Checked-out since 1983
 
0 0 hvala 0
17 godina
neaktivan
offline
C# brisanje file-a

Ta mi se greška vjerojatno potkradala tijekom postanja koda.

Kad ubacim kod za brisanje file-a na kraj prvog try/catch bloka izbacim mi grešku, odnosno poruku iz catch dijela koju sam stavio i ostavim onaj na kraju, koji stoji već u postanom kodu, e onda ga obriše. Samo to mi nije rješenje jer dobivam tu poruku iz catch bloka.

 
0 0 hvala 0
1
Nova poruka
E-mail:
Lozinka:
 
vrh stranice