C#

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

<br />
Convert.ToInt32(affiche_titre["libelle_titre"].ToString());<br />

<code>
using(SqlConnection connection = new SqlConnection(connectionString){
    connection.Open();
    SqlCommand command = connection.CreateCommand();
    command.CommandText = "your sql statement";
    using(SqlDataReader reader = command.ExecuteReader()){
        while(reader.Read()){
            list.Add((Int32)reader[0]);
        }
    }
}
</code>

using(SqlConnection connection = new SqlConnection(connectionString)) {
    connection.Open();
    using (SqlCommand command = new SqlCommand("your sql statement", connection)) {
        using(SqlDataReader reader = command.ExecuteReader()){
            while(reader.Read()){
                list.Add((Int32)reader[0]);
            }
        }
    }
}

<br />
command.ExecuteReader(CommandBehavior.CloseConnection);<br />

Ennis Ray Lynch, Jr. wrote:

In my younger career I used to use stored procedures exclusively. I have now
moved to embedding the SQL statments in the source files for easier version
control.

shubham salwan wrote:

please send me the code of save button.(c#)

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

protected void btnSave_Click(object sender, EventArgs e)

{
   string connString = "Data Source=ServerName;Initial Catalog=DbName;Integrated Security=True"; SqlConnection conn = new    SqlConnection(connString);
   conn.Open();
     String sql = "INSERT INTO CustomerInfo(FirstName, LastName, Address, Order, Quantity) values ('Sai', 'Prasad',    'Hyderabad', 1, 100)";
SqlCommand cmd = new SqlCommand(sql,conn);
     cmd.ExecuteNonQuery();

   conn.Close();

}

using System.Data.SqlClient;