How to insert this table columns and rows in SQL server with ASP.NET

Question

0.00/5 (No votes)

See more:

ASP.NET

<div ng-app="MyApp" ng-controller="MyController">
    <h4>Customers</h4>
    <hr/>
    <table cellpadding="0" cellspacing="0">
        <tr>
            <th>symbol</th>
            <th>bidPrice</th>
            <th>bidQty</th>
        </tr>
        <tbody ng-repeat="m in Customers">
            <tr>
                <td>{{m.symbol}}</td>
                <td>{{m.bidPrice}}</td>
                <td>{{m.bidQty}}</td>
            </tr>
        </tbody>
    </table>
</div>
        
<script type="text/javascript">
    var app = angular.module('MyApp', [])
    app.controller('MyController', function ($scope, $http, $window) {
        var get = $http({
            method: "GET",
            url: "https://api3.binance.com/api/v3/ticker/bookTicker"
        });

        get.success(function (data, status) {
            $scope.Customers = data;
        });

        get.error(function (data, status) {
            $window.alert(data.Message);
        });
    });
</script>

What I have tried:

C#

string sql = "INSERT INTO NameTable (symbol,bidPrice,bidQty) VALUES (@symbol,@bidPrice,@bidQty)";
   using (SqlCommand command = new SqlCommand(sql, conn))
   {
       command.Parameters.AddWithValue("@symbol", "symbol");
       command.Parameters.AddWithValue("@bidPrice", "bidPrice");
       command.Parameters.AddWithValue("@bidQty", "bidQty");
       command.ExecuteNonQuery();
   }

Posted 26-Aug-23 7:24am

Member 16069108

Updated 28-Aug-23 9:26am

Deeksha Shenoy

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2023-08-26T08:47:00

Solution 2

Probably, you need to change this:

C#

command.Parameters.AddWithValue("@symbol", "symbol");
command.Parameters.AddWithValue("@bidPrice", "bidPrice");
command.Parameters.AddWithValue("@bidQty", "bidQty");

To this:

C#

command.Parameters.AddWithValue("@symbol", symbol);
command.Parameters.AddWithValue("@bidPrice", bidPrice);
command.Parameters.AddWithValue("@bidQty", bidQty);

Posted 26-Aug-23 8:47am

OriginalGriff

Comments

Richard Deeming 29-Aug-23 4:20am

And probably clear out the parameters collection after executing the query. :)

OriginalGriff 29-Aug-23 5:15am

Hey, one problem at a time ... :D

It's in a using block, so the whole command will be Disposed when finished with, which will Dispose the parameters etc.

Dave Kreskowiak · Answer 2 · 2023-08-26T08:38:00

You haven't provided enough information. You didn't describe a problem you're having with this code, not any error messages.

The HTML/Javscript code you posted makes no attempt to call a controller method to put any data in the database and the SQL code you posted is incomplete so it's pretty much impossible to tell you what's going on and why.

One thing I will say is your parameters code is trying to insert the strings "symbol", "bidPrice", and "bidQty" into the database, not any actual data.