C#

Xarzu wrote:

Is there some sort of SQL command that will test if some sort of SELECT statement will return data

SELECT COUNT(*)...

Xarzu wrote:

The 3rd party software pretty much returns whatever command I give as a query

Xarzu wrote:

Is there any way I can modify my call so that in the return will tell me what call was made that returned the empty dataset?

SELECT COUNT(1) ...

Xarzu wrote:

Is there a way to find out if a query will return data before it is made?

Xarzu wrote:

I have an unusual problem. My code uses a 3rd party dll to make database calls from my silverlight client to a sql server database.

Xarzu wrote:

In my code, I make dozens of calls one after the other. All of the calls execute successfully. But sometimes the result of a successful call is an empty dataset. Is there any way I can modify my call so that in the return will tell me what call was made that returned the empty dataset?

Xarzu wrote:

The 3rd party software pretty much retruns whatever command I give as a query I test in Microsoft Server Management Studio. Is there some sort of SQL command that will test if some sort of SELECT statement will return data and can that return statement contain the ID's or parameters used to make the statement?

Bastard Programmer from Hell

DriveInfo[] drives = DriveInfo.GetDrives();

foreach (DriveInfo d in drives)
{
    Console.WriteLine(d.Name);
    Console.WriteLine(d.DriveType);

    if (d.IsReady == true)
    {
        string label = d.VolumeLabel;
        if (label.Length == 0)
            d.VolumeLabel = "No Label";
        {
        Console.WriteLine(d.VolumeLabel);
        Console.WriteLine(d.AvailableFreeSpace / 1024000000);
        Console.WriteLine(d.TotalSize / 1024000000);
        }
    }
}

string label = d.VolumeLabel;
if (label.Length == 0)
    label = "No Label";
{
Console.WriteLine(label);

DriveInfo[] allDrives = DriveInfo.GetDrives();
long divisorForGiga = 1024 * 1024 * 1024;
foreach (DriveInfo d in allDrives)
{
    String label = d.VolumeLabel;
    if (d.IsReady == true)
    {
        if (d.VolumeLabel == null || d.VolumeLabel.Length == 0)
        {
            // I'm not sure if you can assign to VolumeLabel in any case
            // You'll have to check and see if it works
            d.VolumeLabel = "No Label";
        }
        Console.WriteLine(d.Name);
        Console.WriteLine(d.DriveType);
        Console.WriteLine(d.VolumeLabel);
        Console.WriteLine(d.DriveFormat);
        Console.WriteLine(d.AvailableFreeSpace / divisorForGiga);
        Console.WriteLine(d.TotalFreeSpace / divisorForGiga);
        Console.WriteLine(d.TotalSize / divisorForGiga);
    }
    else
    {
         Console.WriteLine("Drive {0}: is not ready! Maybe there's no media inserted.")
    }
}

if (d.VolumeLabel == null || d.VolumeLabel.Length == 0) {

if (string.IsNullOrEmpty(d.VolumeLabel)) {

if (string.IsNullOrWhitespace(" "))

private void button1_Click(object sender, EventArgs e)
        {
            if (textBox1.Text.Length > 0)
            {
                textBox2.Text = Convert.ToInt32(textBox1.Text, 2).ToString();
            }
            else
            {
                MessageBox.Show("Deger girilecek alan boş.", "HATA!!!", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

void Button1Click(object sender, EventArgs e)
{
    // TODO: Implement Button1Click
 
    if (textBox1.Text.Length > 0)
    {
	try 
	{
	  textBox2.Text = Convert.ToInt32(textBox1.Text, 2).ToString();
	} 
	catch (Exception) 
	{
	  MessageBox.Show("You didn't entered a Binary number !",
		          "Error",MessageBoxButtons.OK,MessageBoxIcon.Error);
	}
                
     }
     else
     {
        MessageBox.Show("You didn't entered a Binary number !",
		         "Error",MessageBoxButtons.OK,MessageBoxIcon.Error);
     }
}