WPF

public static DataTable MSQ(StockValues sv)
{
    using (SqlConnection conn = Database.GetSqlConnection())
    using (SqlCommand cmd = new SqlCommand("SELECT date, stock_symbol, stock_price_open, stock_price_close, stock_price_lo, stock_price_high, stock_price_adj_close, stock_volume FROM NYSE WHERE date BETWEEN @date_from AND @date_to AND stock_symbol LIKE @stock_symbol AND stock_price_open BETWEEN @stock_price_open_from AND @stock_price_open_to AND stock_price_close BETWEEN @stock_price_close_from AND @stock_price_adj_close_to AND stock_price_lo BETWEEN @stock_price_lo_from AND @stock_price_lo_to AND stock_price_high BETWEEN @stock_price_high_from AND @stock_price_high_to AND stock_price_adj_close BETWEEN @stock_price_adj_close_from AND @stock_price_adj_close_to AND stock_volume BETWEEN @stock_volume_from AND @stock_volume_to", conn))
    {
        cmd.Parameters.AddWithValue("@date_from", sv.date_from);
        cmd.Parameters.AddWithValue("@date_to", sv.date_to);
        cmd.Parameters.AddWithValue("@stock_symbol", sv.stock_symbol);
        cmd.Parameters.AddWithValue("@stock_price_open_from", sv.stock_price_open_from);
        cmd.Parameters.AddWithValue("@stock_price_open_to", sv.stock_price_open_to);
        cmd.Parameters.AddWithValue("@stock_price_close_from", sv.stock_price_close_from);
        cmd.Parameters.AddWithValue("@stock_price_close_to", sv.stock_price_close_to);
        cmd.Parameters.AddWithValue("@stock_price_lo_from", sv.stock_price_lo_from);
        cmd.Parameters.AddWithValue("@stock_price_lo_to", sv.stock_price_lo_to);
        cmd.Parameters.AddWithValue("@stock_price_high_from", sv.stock_price_high_from);
        cmd.Parameters.AddWithValue("@stock_price_high_to", sv.stock_price_high_to);
        cmd.Parameters.AddWithValue("@stock_price_adj_close_from", sv.stock_price_adj_close_from);
        cmd.Parameters.AddWithValue("@stock_price_adj_close_to", sv.stock_price_adj_close_to);
        cmd.Parameters.AddWithValue("@stock_volume_from", sv.stock_volume_from);
        cmd.Parameters.AddWithValue("@stock_volume_to", sv.stock_volume_to);
        
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable table = new DataTable();
        da.Fill(table);
        return table;
    }
}

private void buttonFind_Click(object sender, RoutedEventArgs e)
{
    try
    {
        StockValues sv = new StockValues
        {
            stock_symbol = textBoxStockSymbol.Text
        };
        
        DateTime date;
        if (DateTime.TryParse(textBoxDateFrom.Text, out date))
        {
            sv.sv.date_from = date;
        }
        if (DateTime.TryParse(textBoxDateTo.Text, out date))
        {
            sv.date_to = date;
        }
        
        float valueFloat;
        if (float.TryParse(textBoxSPOpenFrom.Text, out valueFloat))
        {
            sv.stock_price_open_from = valueFloat;
        }
        if (float.TryParse(textBoxSPOpenTo.Text, out valueFloat))
        {
            sv.stock_price_open_to = valueFloat;
        }
        if (float.TryParse(textBoxSPCloseFrom.Text, out valueFloat))
        {
            sv.stock_price_close_from = valueFloat;
        }
        if (float.TryParse(textBoxSPCloseTo.Text, out valueFloat))
        {
            sv.stock_price_close_to = valueFloat;
        }
        if (float.TryParse(textBoxSPLowFrom.Text, out valueFloat))
        {
            sv.stock_price_lo_from = valueFloat;
        }
        if (float.TryParse(textBoxSPLowTo.Text, out valueFloat))
        {
            sv.stock_price_lo_to = valueFloat;
        }
        if (float.TryParse(textBoxSPHighFrom.Text, out valueFloat))
        {
            sv.stock_price_high_from = valueFloat;
        }
        if (float.TryParse(textBoxSPHighTo.Text, out valueFloat))
        {
            sv.stock_price_high_to = valueFloat;
        }
        if (float.TryParse(textBoxSPACloseFrom.Text, out valueFloat))
        {
            sv.stock_price_adj_close_from = valueFloat;
        }
        if (float.TryParse(textBoxSPACTo.Text, out valueFloat))
        {
            sv.stock_price_adj_close_to = valueFloat;
        }
        
        int valueInt;
        if (int.TryParse(textBoxSVolumeFrom.Text, out valueInt))
        {
            sv.stock_volume_from = valueInt;
        }
        if (int.TryParse(textBoxSVolumeTo.Text, out valueInt))
        {
            sv.stock_volume_to = valueInt;
        }
    
        DataTable MSQ = DataLayer.Stock.MSQ(sv);
        dataGrid.ItemsSource = MSQ.DefaultView;
    }
    catch (SqlException sqlex)
    {
        MessageBox.Show("Error: " + sqlex.Message, "Exception Sample", MessageBoxButton.OK, MessageBoxImage.Warning);
    }
}

Richard Deeming wrote:

Why are you posting all of these Javascript questions in the WPF forum

Richard Deeming wrote:

or you're stuck in an old document mode.

Sander Rossel wrote:

Does the file jquery-1.10.2.min.js exist?

Sander Rossel wrote:

Why are you working with such an old version of jQuery anyway?

Sander Rossel wrote:

The current version is 3.something I think.

Kevin Marois wrote:

It's relative from where?

Kevin Marois wrote:

What should it be?

<!--Reference the jQuery library. -->
<script src="Scripts/jquery-1.6.4.min.js" "></script>

<!--Reference the SignalR library. -->
<script src="/Scripts/jquery.signalR-2.0.0.js"></script>

<!--Reference the autogenerated SignalR hub script. -->
<script src="/signalr/hubs"></script>

<body>

<pre>
<!--Reference the jQuery library. -->
<script src="Scripts/jquery-1.6.4.min.js" "></script>

<!--Reference the SignalR library. -->
<script src="/Scripts/jquery.signalR-2.0.0.js"></script>

<!--Reference the autogenerated SignalR hub script. -->
<script src="/signalr/hubs"></script>

<script type="text/javascript">
    $(function () {

        proxy.client.NotifyAllClientsOfChanges = function () {

            var searchUrl = "Home/GetData";

            $.ajax({
                url: searchUrl,
                type: "POST",
                success: function (data) {
                    $("#divData").html(data);
                }
            });
        };
    });

<!--Reference the jQuery library. -->
<script src="Scripts/jquery-1.10.2.min.js" "></script>

<!--Reference the SignalR library. -->
<script src="/Scripts/jquery.signalR-2.2.1.js"></script>

Member 12270195 wrote:

call same by some third-party application