Click here to Skip to main content
15,889,808 members
Home / Discussions / C#
   

C#

 
QuestionSimple calculation with double or float numbers Pin
Mario 5614-Apr-14 13:13
Mario 5614-Apr-14 13:13 
AnswerRe: Simple calculation with double or float numbers Pin
Dave Kreskowiak14-Apr-14 15:13
mveDave Kreskowiak14-Apr-14 15:13 
GeneralRe: Simple calculation with double or float numbers Pin
Mario 5615-Apr-14 2:31
Mario 5615-Apr-14 2:31 
GeneralRe: Simple calculation with double or float numbers Pin
Dave Kreskowiak15-Apr-14 14:36
mveDave Kreskowiak15-Apr-14 14:36 
AnswerRe: Simple calculation with double or float numbers Pin
harold aptroot14-Apr-14 21:38
harold aptroot14-Apr-14 21:38 
GeneralRe: Simple calculation with double or float numbers Pin
Mario 5615-Apr-14 2:43
Mario 5615-Apr-14 2:43 
GeneralRe: Simple calculation with double or float numbers Pin
harold aptroot15-Apr-14 2:48
harold aptroot15-Apr-14 2:48 
QuestionI can not add record to my table Pin
ehabaziz200114-Apr-14 8:37
ehabaziz200114-Apr-14 8:37 
I can not add record to my table as this code as written in :

http://www.homeandlearn.co.uk/csharp/csharp_s12p10.html[^]

The code as followed :
C#
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace _46_creating_databse_01_sql_express_02
{
    public partial class Form1 : Form
    {
        public Form1() { InitializeComponent(); }
        
            
            DatabaseConnection objConnect;
            string conString;
            DataSet ds;
            DataRow dRow;
            int MaxRows;
            int inc = 0;
        
        private void Form1_Load_1(object sender, EventArgs e)
        {
            try
            {
                objConnect = new DatabaseConnection();
                conString = Properties.Settings.Default.employeesConnectionString;
                
                objConnect.connection_string = conString;
                objConnect.Sql = Properties.Settings.Default.sql;
                
                ds = objConnect.GetConnection;
                MaxRows = ds.Tables[0].Rows.Count;
                
                NavigateRecords();

            }
            catch (Exception err)
            {
                MessageBox.Show(err.Message);
            }

        }
        private void NavigateRecords()
        {
            dRow = ds.Tables[0].Rows[inc];
            txtFirstName.Text = dRow.ItemArray.GetValue(1).ToString();
            txtSurname.Text = dRow.ItemArray.GetValue(2).ToString();
            txtJobTitle.Text = dRow.ItemArray.GetValue(3).ToString();
            txtDepartment.Text = dRow.ItemArray.GetValue(4).ToString();
            labelUpdate();
        }

        private void labelUpdate()
        {

            label6.Text = "Record " + (inc + 1) + " of " + MaxRows;

        }

        private void button2_Click(object sender, EventArgs e)
        {
            if (inc != MaxRows - 1)
            {
                inc++;
                NavigateRecords();
            }
            else
            {
                MessageBox.Show("No More Rows");
            }
        }

        private void button3_Click(object sender, EventArgs e)
        {
            if (inc > 0)
            {
                inc--;
                NavigateRecords();
            }
            else
            {
                MessageBox.Show("first Record");
            }
        }

        private void button4_Click(object sender, EventArgs e)
        {
            if (inc != 0)
            {
                inc = 0;
                NavigateRecords();
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {
            if (inc != MaxRows - 1)
            {
                inc = MaxRows - 1;
                NavigateRecords();
            }
        }

        private void button6_Click(object sender, EventArgs e)
        {
            txtFirstName.Clear();
            txtSurname.Clear();
            txtJobTitle.Clear();
            txtDepartment.Clear();

            btnAddNew.Enabled = false;
            btnSave.Enabled = true;
            btnCancel.Enabled = true;
        }

        private void btnCancel_Click(object sender, EventArgs e)
        {
            NavigateRecords();
            btnCancel.Enabled = false;
            btnSave.Enabled = false;
            btnAddNew.Enabled = true;
        }

        private void button7_Click(object sender, EventArgs e)
        {
            DataRow row = ds.Tables[0].NewRow();
            row[1] = txtFirstName.Text;
            row[2] = txtSurname.Text;
            row[3] = txtJobTitle.Text;
            row[4] = txtDepartment.Text;

            ds.Tables[0].Rows.Add(row);
            try
            {
                objConnect.UpdateDatabase(ds);
                MaxRows = MaxRows + 1;
                inc = MaxRows - 1;
                MessageBox.Show("database updated");
            }
            catch (Exception err)
            {
                MessageBox.Show(err.Message);
            }
            btnCancel.Enabled = false;
            btnSave.Enabled = false;
            btnAddNew.Enabled = true;



        }

        private void button9_Click(object sender, EventArgs e)
        {
            DataRow row = ds.Tables[0].Rows[inc];
            
            row[1] = txtFirstName.Text;
            row[2] = txtSurname.Text;
            row[3] = txtJobTitle.Text;
            row[4] = txtDepartment.Text;
            try
            {
                objConnect.UpdateDatabase(ds);
                MessageBox.Show("Record Updated");
            }
            catch (Exception err)
            {
                MessageBox.Show(err.Message);
            }

        }


        }
    }

SuggestionRe: I can not add record to my table Pin
Richard Deeming14-Apr-14 8:53
mveRichard Deeming14-Apr-14 8:53 
GeneralRe: I can not add record to my table Pin
ehabaziz200117-Apr-14 11:52
ehabaziz200117-Apr-14 11:52 
QuestionHow to reuse event Pin
Member 1034709214-Apr-14 4:30
Member 1034709214-Apr-14 4:30 
AnswerRe: How to reuse event Pin
OriginalGriff14-Apr-14 5:08
mveOriginalGriff14-Apr-14 5:08 
AnswerRe: How to reuse event Pin
Dave Kreskowiak14-Apr-14 5:09
mveDave Kreskowiak14-Apr-14 5:09 
GeneralRe: How to reuse event Pin
Member 1034709215-Apr-14 18:39
Member 1034709215-Apr-14 18:39 
GeneralRe: How to reuse event Pin
Dave Kreskowiak15-Apr-14 18:44
mveDave Kreskowiak15-Apr-14 18:44 
GeneralRe: How to reuse event Pin
lukeer15-Apr-14 20:54
lukeer15-Apr-14 20:54 
GeneralRe: How to reuse event Pin
Dave Kreskowiak16-Apr-14 1:26
mveDave Kreskowiak16-Apr-14 1:26 
GeneralRe: How to reuse event Pin
Member 1034709216-Apr-14 1:08
Member 1034709216-Apr-14 1:08 
GeneralRe: How to reuse event Pin
Dave Kreskowiak16-Apr-14 1:27
mveDave Kreskowiak16-Apr-14 1:27 
GeneralRe: How to reuse event Pin
Member 1034709216-Apr-14 4:21
Member 1034709216-Apr-14 4:21 
QuestionC# use all controls on different form Pin
t..bdiesel14-Apr-14 2:35
t..bdiesel14-Apr-14 2:35 
AnswerRe: C# use all controls on different form Pin
joost.versteegen14-Apr-14 20:42
joost.versteegen14-Apr-14 20:42 
GeneralRe: C# use all controls on different form Pin
t..bdiesel15-Apr-14 3:56
t..bdiesel15-Apr-14 3:56 
GeneralRe: C# use all controls on different form Pin
t..bdiesel15-Apr-14 4:02
t..bdiesel15-Apr-14 4:02 
GeneralRe: C# use all controls on different form Pin
joost.versteegen15-Apr-14 4:48
joost.versteegen15-Apr-14 4:48 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.