C#

si_69 wrote:

I am trying to create a generic method for calling stored procedures

si_69 wrote:

Can anyone advise

public static bool WriteToDatabase(
    string sql,
    System.Data.CommandType commandType,
    out string errorText,
    params System.Tuple<string,object>[] values
)
{
    bool success = true;
    errorText = null;

    using (System.Data.IDbConnection connection = new System.Data.SqlClient.SqlConnection(ConnectionString))
    {
      try
      {
        using (System.Data.IDbCommand command = connection.CreateCommand() )
        {
          command.CommandText = sql ;
          command.CommandType = commandType ;

          foreach (System.Tuple<string,object> param in values )
          {
            System.Data.IDbDataParameter p = command.CreateParameter() ;
            p.ParameterName = param.Item1 ;
            p.Value = param.Item2 ;
            command.Parameters.Add(p);
          }

         connection.Open();
         command.ExecuteNonQuery();
        }
      }
      catch ( System.Exception err )
      {
        success = false ;
        errorText = err.ToString() ;
      }
      finally
      {
         connection.Close();
      }
    }

    return ( success ) ;
}

    WriteToDatabase
    (
      "blah blah blah"
    ,
      System.Data.CommandType.Text
    ,
      out error
    ,
      new System.Tuple<string,object> ( "@date" , System.DateTime.Now )
    ) ;

TextBox1.Text = System.IO.File.ReadAllText(inputFileName);
//Modify the text in the TextBox
System.IO.File.WriteAllLines(outputFileName, TextBox1.Text);

 sr = new StreamReader(filename);
while (!sr.EndOfStream)
{
  if (txtBox.Text.Trim() == "")
   {
  txtBox.Text = sr.ReadLine();
   }
   else
   {
    txtBox.Text = txtBox.Text + Environment.NewLine + sr.ReadLine();
    }
}

using System.IO;

Happy Coding...

Member 8143513 wrote:

I want to store hash table in compound file.