ජාවා-ස්ක්‍රිප්ට් සිහලෙන් - 1

Javascript Lesson 1 Part 2

C# + SQL Example #1

* Gets max row count
* Inserts a new row (value number greater than max rows)
* Displays row values

[CODE]


            string connString = "Server=localhost;Database=cshptest;Uid=root;"; // Select DB
            MySqlConnection conn = new MySqlConnection(connString);
            MySqlCommand command = conn.CreateCommand();
            // Command to count the rows
            conn.Open();
            command.CommandText = "SELECT COUNT(*) FROM csdat";
            int rows = Convert.ToInt32(command.ExecuteScalar());
            int newrows = rows + 1;
            conn.Close();
            // Insert a new data row, with the value greater than last index value (ex. 5 + 1 = 6)
            command.CommandText = "Insert into csdat (id,dataT) values('" + newrows + "','" + newrows + "');";
            conn.Open();
            command.ExecuteNonQuery();
            conn.Close();
            MySqlDataReader reader;
            // Read data in each row
            for (int i = 0; i <= rows; i++)
            {
                string cnt = i.ToString();
                conn.Open();
                command.CommandText = "Select dataT from csdat where id=" + cnt; // Select column from table
             
                reader = command.ExecuteReader();
                while (reader.Read())
                {
                    MessageBox.Show(reader["dataT"].ToString()); // extract data from column
                }
                conn.Close();
            }

[/CODE]

C# Database Programming Start-up Guide. Free E-Book

  So you wanna learn the basics of C# database programming? Then read along this booklet, and you’ll learn how to build your own database programs. In this guide we are going to create a Movies library for a Movies rental shop.  It’ll demonstrate things like: how to iterate and retrieve data from databases and display them on forms, how to add new data into databases, how to search a database, and how to display filtered data from the database etc.