C#

munishk wrote:

But can we say that creating sqlconnection is unmanaged resource?

munishk wrote:

SQL server connection should be a managed code

MyObject mo = new MyObject();
...
mo.Dispose():

Image i = Image.FromFile(path);

munishk wrote:

why it is recommended to use connection statements within using?

using 
( 
    PIEBALD.Data.IDatabase db 
= 
    new PIEBLAD.Data.SqlServerDatabase 
    (
        ... 
    ) 
)
{
    ...
}

Santa's Little Helper wrote:

(Mods please delete if I have broken any rules, Sorry!)

Bastard Programmer from Hell
if you can't read my code, try converting it here[^]

atoi_powered wrote:

I, by myself,

pranee24 wrote:

i Tried but its not working any Help

pranee24 wrote:

i Tried but its not working

pranee24 wrote:

i need to get the DataBase Name and File Name from TextBox

pranee24 wrote:

its not working

 string dbName = txtDbName.Text.Trim();
 string fileName1 = txtFileName1.Text.Trim();
 string fileName2 = txtFileName2.Text.Trim();

SqlConnection conn = new SqlConnect(
   "Integrated Security=SSPI;Data Source=DBSRV1;Initial Catalog=master");
SqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sp_attach_db";
cmd.Parameters.Add("@dbname", SqlDbType.NVarChar, 128).Value = dbName;
cmd.Parameters.Add("@filename1", SqlDbType.NVarChar, 260).Value = fileName1;
cmd.Parameters.Add("@filename2", SqlDbType.NVarChar, 260).Value = fileName2;
try
{
   conn.Open();
   cmd.ExecuteNonQuery();
}
finally
{
   conn.Close();
}

Note: Assuming user sending required/valid data from the above textboxes