Re: mvc - C# Discussion Boards

27-Jul-15 0:09

hi , for example i have a table named (name)
and a form with a text box and a add button.
i wanna know how do i transfer the data from the textbox into the table( sql server express 2012 , and visual studios 2015 Rc)
sql connecton ......
sqlcommand cmd = new sqlcommand("insert into* .......... <- the part im struggling with

Richard MacCutchan27-Jul-15 0:23

Richard MacCutchan

27-Jul-15 0:23

See https://social.msdn.microsoft.com/Forums/vstudio/en-US/91bd10ce-c83b-4766-920b-2137ddc29908/c-insert-into-sql[^]. There are many samples and tutorials on C# and SQL that Google will find for you, for example http://arcanecode.com/2007/04/24/sql-server-2005-compact-edition-important-component/[^].

jamesmc153527-Jul-15 0:25

27-Jul-15 0:25

thanks

il quickly take a look there

Pete O'Hanlon27-Jul-15 0:35

27-Jul-15 0:35

Have you bought the C# book you were recommended yet?

jamesmc153527-Jul-15 1:03

27-Jul-15 1:03

not yet my finances are kinda flat up now

Pete O'Hanlon27-Jul-15 1:10

27-Jul-15 1:10

So what structured resources are you following to learn C# properly?

jamesmc153527-Jul-15 1:15

27-Jul-15 1:15

i got a few pdfs i read thru that i got from my friend studying c# ,

Sascha Lefèvre27-Jul-15 2:28

Sascha Lefèvre

27-Jul-15 2:28

There's a really good free PDF-book on programming in C#, which you can download here: http://www.introprogramming.info/[^]

If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

jamesmc153527-Jul-15 2:40

27-Jul-15 2:40

thanks man Smile | :)

Pete O'Hanlon27-Jul-15 0:24

Display data from SQL database to HTML page in table format using Angular JS

27-Jul-15 0:24

You should get a decent idea of what needs to be done, here[^]. Look at the first answer to get an idea on how to do this without leaving your code vulnerable to SQL Injection Attacks.

iamcpmember27-Jul-15 0:01

iamcpmember

27-Jul-15 0:01

Hi,

I want to fetch data from SQL database, and display the same on my HTML page in table format using Angular JS.

I am able to get the data in the scope variable, but it is not getting displayed in the HTML page.

Please check the code that I have written below, and help me fixing the issue.

Thanks in advance.

HTML code:

<!DOCTYPE html>

<html>

<head>

    <title>:: View Logs ::</title>

    <script src="Scripts/angular.js"></script>
    <script src="Scripts/angular.min.js"></script>

    <!--<script src="http://ajax.googleapis.com/ajax/libs/angularjs/1.3.14/angular.min.js"></script>-->

    <script src="Scripts/logsController.js"></script>
    <script src="Scripts/jquery-2.1.1.js"></script>
    <script src="Scripts/jquery-2.1.1.min.js"></script>

    <!--<script>
        ViewLogsApp = angular.module('ViewLogsApp', []);
        ViewLogsApp.controller('ViewLogsController', function ($scope, $http) {
            $http.get('data.json').success(function (response) {
                $scope.myData = response;
            });
        });
    </script>-->

</head>

<body>

    <div ng-app="ViewLogsApp">

        <div ng-controller="ViewLogsController">

            <table class="table table-striped">

                    <tr>
                        <th>Log ID</th>
                        <th>User Type</th>
                        <th>User Name</th>
                        <th>Email ID</th>
                        <th>Action Type</th>
                        <th>Section Name</th>
                        <th>Section Details</th>
                        <th>DateTime</th>
                        <th>User IP</th>
                    </tr>

                    <tr ng-repeat="item in logslist">
                        <td>{{item.LogID}}</td>
                        <td>{{item.UserType}}</td>
                        <td>{{item.UserName}}</td>
                        <td>{{item.EmailID}}</td>
                        <td>{{item.ActionType}}</td>
                        <td>{{item.SectionName}}</td>
                        <td>{{item.SectionDetails}}</td>
                        <td>{{item.DateTime}}</td>
                        <td>{{item.UserIP}}</td>
                    </tr>

            </table>

        </div>

    </div>

</body>

</html>

logsController.js code:

angular.module('ViewLogsApp', [])
  .controller('ViewLogsController', [
        '$scope', function ($scope) {

            $scope.logslist = [];

            $scope.load;

            $scope.load = function () {

                $.ajax({
                    type: 'GET',
                    contentType: 'application/json; charset=utf-8',
                    url: 'UserActivityLogs.aspx/getList',
                    success: function (data) {
                        $scope.logslist = data
                        $scope.$apply();
                    }
                });
            }
            $scope.load();

        }
  ]);

WebMethod code:

[System.Web.Services.WebMethod]
[ScriptMethod(UseHttpGet = true, ResponseFormat = ResponseFormat.Json)]
public static List<UserActivityLogsList> getList()
{
    SqlConnection con = new SqlConnection();

    con.ConnectionString = _connstr;
    con.Open();

    var logs = new List<UserActivityLogsList>();

    string get = "select * from UserActivityLogs";
    //string get = "sp_employee";

    SqlCommand cmd = new SqlCommand(get, con);

    SqlDataReader dr = cmd.ExecuteReader();

    while (dr.Read())
    {
        UserActivityLogsList e = new UserActivityLogsList();

        e.LogID = Convert.ToInt32(dr[0]);
        e.UserType = Convert.ToString(dr[1]);
        e.UserName = Convert.ToString(dr[2]);
        e.EmailID = Convert.ToString(dr[3]);
        e.ActionType = Convert.ToString(dr[4]);
        e.SectionName = Convert.ToString(dr[4]);
        e.SectionDetails = Convert.ToString(dr[4]);
        e.DateTime = Convert.ToString(dr[4]);
        e.UserIP = Convert.ToString(dr[4]);

        logs.Add(e);

    }

    con.Close();

    return logs;

}

Clouds come floating into my life, no longer to carry rain or usher storm, but to add color to my sunset sky. ~Rabindranath Tagore

Re: Display data from SQL database to HTML page in table format using Angular JS

Richard MacCutchan27-Jul-15 0:18

Richard MacCutchan

27-Jul-15 0:18

This is not a C# issue. Please use the ASP.NET or Javascript forum, as appropriate.

Picture Viewer.

Member 1186549926-Jul-15 23:07

Member 11865499

26-Jul-15 23:07

So I'm using this command to open a picture in C sharp

Process.Start(@"C:\MyPicture.jpg");

Is there anyway I can open the latest picture in the folder?

Re: Picture Viewer.

Pete O'Hanlon26-Jul-15 23:18