C#

string commandText = "Select SUM(Hesap) From Gecmis Where MasaNo = @MasaNo";
SqlCommand cmdGelir = new SqlCommand(commandText, sqlBaglanti);
                cmdGelir.Parameters.Add("@MasaNo", SqlDbType.NChar);
                cmdGelir.Parameters["@MasaNo"].Value = "Gelir"; 

SqlCommand cmdGelir = new SqlCommand("Select SUM(Hesap) From Gecmis Where MasaNo = 'Gelir'", sqlBaglanti);

float diger = 0F;
SqlCommand cmdGelir = new SqlCommand("Select SUM(Hesap) From Gecmis Where MasaNo = 'Gelir'", sqlBaglanti);
                if (cmdGelir.ExecuteScalar().ToString() != "0" && cmdGelir.ExecuteScalar().ToString() != "") diger = float.Parse(cmd.ExecuteScalar().ToString().Trim());

float diger = 0F;
SqlCommand cmdGelir = new SqlCommand("Select SUM(Hesap) From Gecmis Where MasaNo = 'Gelir'", sqlBaglanti);
diger = (float) cmdGelir.ExecuteScalar();

   Two extra database accesses
   Three unnecessary int-to-string conversions
   One unnecessary Trim operation (with the output guaranteed to equal the input)
   One unnecessary Parse operation
   Six unneccessary string creations!

And probably a Partridge in a Pear Tree!

OriginalGriff wrote:

I ask again: what is the field definition of "MasaNo"?

Bernhard Hiller wrote:

What does "is not working" mean

SqlCommand cmdGelir = new SqlCommand("Select SUM(Hesap), MasaNo From Gecmis Where MasaNo = 'Gelir' Group By MasaNo", sqlBaglanti);

private void timer1_Tick(object sender, EventArgs e) {
    label1.Visible = !label1.Visible;
}

//  using System.Text.RegularExpressions;

/// <summary>
///  Regular expression built for C# on: Sat, Feb 26, 2011, 07:38:05 AM
///  Using Expresso Version: 3.0.3634, http://www.ultrapico.com
///  
///  A description of the regular expression:
///  
///  [Protocol]: A named capture group. [\w+]
///      Alphanumeric, one or more repetitions
///  :\/\/
///      :
///      Literal /
///      Literal /
///  [Domain]: A named capture group. [[\w@][\w.:@]+]
///      [\w@][\w.:@]+
///          Any character in this class: [\w@]
///          Any character in this class: [\w.:@], one or more repetitions
///  Literal /, zero or one repetitions
///  Any character in this class: [\w\.?=%&=\-@/$,], any number of repetitions
///  
///
/// </summary>
public static Regex regex = new Regex(
      "(?<Protocol>\\w+):\\/\\/(?<Domain>[\\w@][\\w.:@]+)\\/?[\\w\\."+
      "?=%&=\\-@/$,]*",
    RegexOptions.IgnoreCase
    | RegexOptions.CultureInvariant
    | RegexOptions.IgnorePatternWhitespace
    | RegexOptions.Compiled
    );


// This is the replacement string
public static string regexReplace = 
      "<Hello>";


//// Replace the matched text in the InputText using the replacement pattern
// string result = regex.Replace(InputText,regexReplace);

//// Split the InputText wherever the regex matches
// string[] results = regex.Split(InputText);

//// Capture the first Match, if any, in the InputText
// Match m = regex.Match(InputText);

//// Capture all Matches in the InputText
// MatchCollection ms = regex.Matches(InputText);

//// Test to see if there is a match in the InputText
// bool IsMatch = regex.IsMatch(InputText);

//// Get the names of all the named and numbered capture groups
// string[] GroupNames = regex.GetGroupNames();

//// Get the numbers of all the named and numbered capture groups
// int[] GroupNumbers = regex.GetGroupNumbers();

String str= Encoding.ASCII.GetString(buffer, 0, bytes);