Ecoer Logo
VOTING POWER100.00%
DOWNVOTE POWER100.00%
RESOURCE CREDITS100.00%
REPUTATION PROGRESS0.00%
Net Worth
0.060USD
STEEM
0.000STEEM
SBD
0.109SBD
Effective Power
5.007SP
├── Own SP
0.126SP
└── Incoming Deleg
+4.882SP

Detailed Balance

STEEM
balance
0.000STEEM
market_balance
0.000STEEM
savings_balance
0.000STEEM
reward_steem_balance
0.000STEEM
STEEM POWER
Own SP
0.126SP
Delegated Out
0.000SP
Delegation In
4.882SP
Effective Power
5.007SP
Reward SP (pending)
0.041SP
SBD
sbd_balance
0.000SBD
sbd_conversions
0.000SBD
sbd_market_balance
0.000SBD
savings_sbd_balance
0.000SBD
reward_sbd_balance
0.109SBD
{
  "balance": "0.000 STEEM",
  "savings_balance": "0.000 STEEM",
  "reward_steem_balance": "0.000 STEEM",
  "vesting_shares": "204.286620 VESTS",
  "delegated_vesting_shares": "0.000000 VESTS",
  "received_vesting_shares": "7939.373186 VESTS",
  "sbd_balance": "0.000 SBD",
  "savings_sbd_balance": "0.000 SBD",
  "reward_sbd_balance": "0.109 SBD",
  "conversions": []
}

Account Info

nameroxy19
id787134
rank533,906
reputation968479416
created2018-03-02T15:02:33
recovery_accountsteem
proxyNone
post_count4
comment_count0
lifetime_vote_count0
witnesses_voted_for0
last_post2018-03-30T07:32:15
last_root_post2018-03-30T07:32:15
last_vote_time2018-03-30T18:50:39
proxied_vsf_votes0, 0, 0, 0
can_vote1
voting_power0
delayed_votes0
balance0.000 STEEM
savings_balance0.000 STEEM
sbd_balance0.000 SBD
savings_sbd_balance0.000 SBD
vesting_shares204.286620 VESTS
delegated_vesting_shares0.000000 VESTS
received_vesting_shares7939.373186 VESTS
reward_vesting_balance83.723386 VESTS
vesting_balance0.000 STEEM
vesting_withdraw_rate0.000000 VESTS
next_vesting_withdrawal1969-12-31T23:59:59
withdrawn0
to_withdraw0
withdraw_routes0
savings_withdraw_requests0
last_account_recovery1970-01-01T00:00:00
reset_accountnull
last_owner_update1970-01-01T00:00:00
last_account_update2018-03-04T06:49:21
minedNo
sbd_seconds0
sbd_last_interest_payment1970-01-01T00:00:00
savings_sbd_last_interest_payment1970-01-01T00:00:00
{
  "active": {
    "account_auths": [],
    "key_auths": [
      [
        "STM7outcY3dBjhR1KfZitgXPnugjRhCAbtjqAqsMgJCqLTsTLpPmo",
        1
      ]
    ],
    "weight_threshold": 1
  },
  "balance": "0.000 STEEM",
  "can_vote": true,
  "comment_count": 0,
  "created": "2018-03-02T15:02:33",
  "curation_rewards": 0,
  "delegated_vesting_shares": "0.000000 VESTS",
  "downvote_manabar": {
    "current_mana": 2035914951,
    "last_update_time": 1779083679
  },
  "guest_bloggers": [],
  "id": 787134,
  "json_metadata": "{\"profile\":{\"cover_image\":\"\",\"profile_image\":\"https://img.esteem.ws/ig3e385504.jpg\"}}",
  "last_account_recovery": "1970-01-01T00:00:00",
  "last_account_update": "2018-03-04T06:49:21",
  "last_owner_update": "1970-01-01T00:00:00",
  "last_post": "2018-03-30T07:32:15",
  "last_root_post": "2018-03-30T07:32:15",
  "last_vote_time": "2018-03-30T18:50:39",
  "lifetime_vote_count": 0,
  "market_history": [],
  "memo_key": "STM6HPNcMb1MNkFfDwm8XEAqh3wYwTdwh8uZU2nF8aajVZC9yjPAr",
  "mined": false,
  "name": "roxy19",
  "next_vesting_withdrawal": "1969-12-31T23:59:59",
  "other_history": [],
  "owner": {
    "account_auths": [],
    "key_auths": [
      [
        "STM8jQJVBnqh49LqzQbr476wcJPKUAUREqdHKFXiJ5gk7fwtWUVWj",
        1
      ]
    ],
    "weight_threshold": 1
  },
  "pending_claimed_accounts": 0,
  "post_bandwidth": 0,
  "post_count": 4,
  "post_history": [],
  "posting": {
    "account_auths": [
      [
        "utopian.app",
        1
      ]
    ],
    "key_auths": [
      [
        "STM7pitPpw1MtbU4WYHF94vWSjypbmojmvJRNFMTHrVGhXuebPUCH",
        1
      ]
    ],
    "weight_threshold": 1
  },
  "posting_json_metadata": "{\"profile\":{\"cover_image\":\"\",\"profile_image\":\"https://img.esteem.ws/ig3e385504.jpg\"}}",
  "posting_rewards": 82,
  "proxied_vsf_votes": [
    0,
    0,
    0,
    0
  ],
  "proxy": "",
  "received_vesting_shares": "7939.373186 VESTS",
  "recovery_account": "steem",
  "reputation": 968479416,
  "reset_account": "null",
  "reward_sbd_balance": "0.109 SBD",
  "reward_steem_balance": "0.000 STEEM",
  "reward_vesting_balance": "83.723386 VESTS",
  "reward_vesting_steem": "0.041 STEEM",
  "savings_balance": "0.000 STEEM",
  "savings_sbd_balance": "0.000 SBD",
  "savings_sbd_last_interest_payment": "1970-01-01T00:00:00",
  "savings_sbd_seconds": "0",
  "savings_sbd_seconds_last_update": "1970-01-01T00:00:00",
  "savings_withdraw_requests": 0,
  "sbd_balance": "0.000 SBD",
  "sbd_last_interest_payment": "1970-01-01T00:00:00",
  "sbd_seconds": "0",
  "sbd_seconds_last_update": "1970-01-01T00:00:00",
  "tags_usage": [],
  "to_withdraw": 0,
  "transfer_history": [],
  "vesting_balance": "0.000 STEEM",
  "vesting_shares": "204.286620 VESTS",
  "vesting_withdraw_rate": "0.000000 VESTS",
  "vote_history": [],
  "voting_manabar": {
    "current_mana": "8143659806",
    "last_update_time": 1779083679
  },
  "voting_power": 0,
  "withdraw_routes": 0,
  "withdrawn": 0,
  "witness_votes": [],
  "witnesses_voted_for": 0,
  "rank": 533906
}

Withdraw Routes

IncomingOutgoing
Empty
Empty
{
  "incoming": [],
  "outgoing": []
}
From Date
To Date
steemdelegated 4.882 SP to @roxy19
2026/05/18 05:54:39
delegateeroxy19
delegatorsteem
vesting shares7939.373186 VESTS
Transaction InfoBlock #106150207/Trx 5c34c4230be8f1eed3936e8ce31310c1a3591029
View Raw JSON Data
{
  "block": 106150207,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "roxy19",
      "delegator": "steem",
      "vesting_shares": "7939.373186 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2026-05-18T05:54:39",
  "trx_id": "5c34c4230be8f1eed3936e8ce31310c1a3591029",
  "trx_in_block": 0,
  "virtual_op": 0
}
steemdelegated 3.214 SP to @roxy19
2026/05/13 02:50:12
delegateeroxy19
delegatorsteem
vesting shares5227.162781 VESTS
Transaction InfoBlock #106003243/Trx 7cfa62124c5de6ecd0876b3ab11b4f56277b7b80
View Raw JSON Data
{
  "block": 106003243,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "roxy19",
      "delegator": "steem",
      "vesting_shares": "5227.162781 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2026-05-13T02:50:12",
  "trx_id": "7cfa62124c5de6ecd0876b3ab11b4f56277b7b80",
  "trx_in_block": 0,
  "virtual_op": 0
}
steemdelegated 4.890 SP to @roxy19
2026/04/26 05:06:54
delegateeroxy19
delegatorsteem
vesting shares7951.888942 VESTS
Transaction InfoBlock #105517701/Trx 14f88c34ebe65e900bfc1ce53810df1b989667f2
View Raw JSON Data
{
  "block": 105517701,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "roxy19",
      "delegator": "steem",
      "vesting_shares": "7951.888942 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2026-04-26T05:06:54",
  "trx_id": "14f88c34ebe65e900bfc1ce53810df1b989667f2",
  "trx_in_block": 0,
  "virtual_op": 0
}
steemdelegated 3.240 SP to @roxy19
2026/01/23 23:00:57
delegateeroxy19
delegatorsteem
vesting shares5268.709600 VESTS
Transaction InfoBlock #102870037/Trx 3a6663cc9d66b891602c5789e0f138059dd8deea
View Raw JSON Data
{
  "block": 102870037,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "roxy19",
      "delegator": "steem",
      "vesting_shares": "5268.709600 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2026-01-23T23:00:57",
  "trx_id": "3a6663cc9d66b891602c5789e0f138059dd8deea",
  "trx_in_block": 0,
  "virtual_op": 0
}
steemdelegated 3.341 SP to @roxy19
2024/12/17 18:11:15
delegateeroxy19
delegatorsteem
vesting shares5432.928797 VESTS
Transaction InfoBlock #91316256/Trx b0fe4d419ed0504ee211f75a805a9556056410e3
View Raw JSON Data
{
  "block": 91316256,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "roxy19",
      "delegator": "steem",
      "vesting_shares": "5432.928797 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2024-12-17T18:11:15",
  "trx_id": "b0fe4d419ed0504ee211f75a805a9556056410e3",
  "trx_in_block": 6,
  "virtual_op": 0
}
steemdelegated 3.445 SP to @roxy19
2023/11/14 09:52:39
delegateeroxy19
delegatorsteem
vesting shares5602.062329 VESTS
Transaction InfoBlock #79870411/Trx 5dcd7198161817f0d2d8a499a9e530e38b0c19ff
View Raw JSON Data
{
  "block": 79870411,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "roxy19",
      "delegator": "steem",
      "vesting_shares": "5602.062329 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2023-11-14T09:52:39",
  "trx_id": "5dcd7198161817f0d2d8a499a9e530e38b0c19ff",
  "trx_in_block": 0,
  "virtual_op": 0
}
steemdelegated 5.251 SP to @roxy19
2023/09/22 09:56:42
delegateeroxy19
delegatorsteem
vesting shares8538.971115 VESTS
Transaction InfoBlock #78362330/Trx 5c3d5ea914caa31124e70ee108dda30b66a99649
View Raw JSON Data
{
  "block": 78362330,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "roxy19",
      "delegator": "steem",
      "vesting_shares": "8538.971115 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2023-09-22T09:56:42",
  "trx_id": "5c3d5ea914caa31124e70ee108dda30b66a99649",
  "trx_in_block": 0,
  "virtual_op": 0
}
steemdelegated 5.387 SP to @roxy19
2022/11/03 17:27:51
delegateeroxy19
delegatorsteem
vesting shares8761.022553 VESTS
Transaction InfoBlock #69120141/Trx 1e025c98250062f659bb50ed612b2946a492f9f9
View Raw JSON Data
{
  "block": 69120141,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "roxy19",
      "delegator": "steem",
      "vesting_shares": "8761.022553 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2022-11-03T17:27:51",
  "trx_id": "1e025c98250062f659bb50ed612b2946a492f9f9",
  "trx_in_block": 3,
  "virtual_op": 0
}
steemdelegated 5.522 SP to @roxy19
2022/01/17 22:42:00
delegateeroxy19
delegatorsteem
vesting shares8981.130154 VESTS
Transaction InfoBlock #60823435/Trx d8d42372da1ebeb37f13d657892c8ed62bb4a49e
View Raw JSON Data
{
  "block": 60823435,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "roxy19",
      "delegator": "steem",
      "vesting_shares": "8981.130154 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2022-01-17T22:42:00",
  "trx_id": "d8d42372da1ebeb37f13d657892c8ed62bb4a49e",
  "trx_in_block": 32,
  "virtual_op": 0
}
steemdelegated 5.636 SP to @roxy19
2021/06/14 05:53:54
delegateeroxy19
delegatorsteem
vesting shares9165.324442 VESTS
Transaction InfoBlock #54613781/Trx b85ca54b7902ab527ac3e96881dba1b9efb12895
View Raw JSON Data
{
  "block": 54613781,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "roxy19",
      "delegator": "steem",
      "vesting_shares": "9165.324442 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-06-14T05:53:54",
  "trx_id": "b85ca54b7902ab527ac3e96881dba1b9efb12895",
  "trx_in_block": 2,
  "virtual_op": 0
}
steemdelegated 5.751 SP to @roxy19
2020/12/11 16:06:45
delegateeroxy19
delegatorsteem
vesting shares9352.746416 VESTS
Transaction InfoBlock #49361058/Trx d01587c8e680a10e1b0fa24033c9e6b2ddd4e1ed
View Raw JSON Data
{
  "block": 49361058,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "roxy19",
      "delegator": "steem",
      "vesting_shares": "9352.746416 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-12-11T16:06:45",
  "trx_id": "d01587c8e680a10e1b0fa24033c9e6b2ddd4e1ed",
  "trx_in_block": 2,
  "virtual_op": 0
}
steemdelegated 1.176 SP to @roxy19
2020/12/06 09:42:30
delegateeroxy19
delegatorsteem
vesting shares1912.543513 VESTS
Transaction InfoBlock #49212584/Trx 824e438300a69b62746a1a7e1e3651896fe20ede
View Raw JSON Data
{
  "block": 49212584,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "roxy19",
      "delegator": "steem",
      "vesting_shares": "1912.543513 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-12-06T09:42:30",
  "trx_id": "824e438300a69b62746a1a7e1e3651896fe20ede",
  "trx_in_block": 3,
  "virtual_op": 0
}
steemdelegated 5.755 SP to @roxy19
2020/12/05 19:44:27
delegateeroxy19
delegatorsteem
vesting shares9358.954270 VESTS
Transaction InfoBlock #49196140/Trx dbde604a10222956350af24b1ebe1998bada922c
View Raw JSON Data
{
  "block": 49196140,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "roxy19",
      "delegator": "steem",
      "vesting_shares": "9358.954270 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-12-05T19:44:27",
  "trx_id": "dbde604a10222956350af24b1ebe1998bada922c",
  "trx_in_block": 4,
  "virtual_op": 0
}
steemdelegated 1.181 SP to @roxy19
2020/11/03 02:01:30
delegateeroxy19
delegatorsteem
vesting shares1920.017158 VESTS
Transaction InfoBlock #48270030/Trx 664c7eb33e98ff486975a5710f657cf756f875f9
View Raw JSON Data
{
  "block": 48270030,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "roxy19",
      "delegator": "steem",
      "vesting_shares": "1920.017158 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-11-03T02:01:30",
  "trx_id": "664c7eb33e98ff486975a5710f657cf756f875f9",
  "trx_in_block": 0,
  "virtual_op": 0
}
steemdelegated 5.879 SP to @roxy19
2020/05/09 10:45:12
delegateeroxy19
delegatorsteem
vesting shares9561.759629 VESTS
Transaction InfoBlock #43222905/Trx 7c067e33ab4bdc8941674eef5aff328ac896b93a
View Raw JSON Data
{
  "block": 43222905,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "roxy19",
      "delegator": "steem",
      "vesting_shares": "9561.759629 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-05-09T10:45:12",
  "trx_id": "7c067e33ab4bdc8941674eef5aff328ac896b93a",
  "trx_in_block": 9,
  "virtual_op": 0
}
steemdelegated 1.201 SP to @roxy19
2020/05/08 15:06:33
delegateeroxy19
delegatorsteem
vesting shares1953.311140 VESTS
Transaction InfoBlock #43199894/Trx c7f30a152a638815f7cd2d02a2fe65cf7142f413
View Raw JSON Data
{
  "block": 43199894,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "roxy19",
      "delegator": "steem",
      "vesting_shares": "1953.311140 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-05-08T15:06:33",
  "trx_id": "c7f30a152a638815f7cd2d02a2fe65cf7142f413",
  "trx_in_block": 3,
  "virtual_op": 0
}
2020/03/05 10:34:06
authorsteemitboard
bodyCongratulations @roxy19! You received a personal award! <table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@roxy19/birthday2.png</td><td>Happy Birthday! - You are on the Steem blockchain for 2 years!</td></tr></table> <sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@roxy19) and compare to others on the [Steem Ranking](https://steemitboard.com/ranking/index.php?name=roxy19)_</sub> **Do not miss the last post from @steemitboard:** <table><tr><td><a href="https://steemit.com/steemitboard/@steemitboard/use-your-witness-votes-and-get-the-community-badge"><img src="https://steemitimages.com/64x128/https://cdn.steemitimages.com/DQmTugCUsoXX762vg1CuHRrpnPbfnjPogp8iCGv7F2kSVuj/image.png"></a></td><td><a href="https://steemit.com/steemitboard/@steemitboard/use-your-witness-votes-and-get-the-community-badge">Use your witness votes and get the Community Badge</a></td></tr></table> ###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) to get one more award and increased upvotes!
json metadata{"image":["https://steemitboard.com/img/notify.png"]}
parent authorroxy19
parent permlinkc-inserting-data-from-a-windows-form-application-into-ms-access-database-using-vs2013-step-by-step
permlinksteemitboard-notify-roxy19-20200305t103406000z
title
Transaction InfoBlock #41383512/Trx 219674bc330c1b35804427cee7f49cfec2fa1613
View Raw JSON Data
{
  "block": 41383512,
  "op": [
    "comment",
    {
      "author": "steemitboard",
      "body": "Congratulations @roxy19! You received a personal award!\n\n<table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@roxy19/birthday2.png</td><td>Happy Birthday! - You are on the Steem blockchain for 2 years!</td></tr></table>\n\n<sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@roxy19) and compare to others on the [Steem Ranking](https://steemitboard.com/ranking/index.php?name=roxy19)_</sub>\n\n\n**Do not miss the last post from @steemitboard:**\n<table><tr><td><a href=\"https://steemit.com/steemitboard/@steemitboard/use-your-witness-votes-and-get-the-community-badge\"><img src=\"https://steemitimages.com/64x128/https://cdn.steemitimages.com/DQmTugCUsoXX762vg1CuHRrpnPbfnjPogp8iCGv7F2kSVuj/image.png\"></a></td><td><a href=\"https://steemit.com/steemitboard/@steemitboard/use-your-witness-votes-and-get-the-community-badge\">Use your witness votes and get the Community Badge</a></td></tr></table>\n\n###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) to get one more award and increased upvotes!",
      "json_metadata": "{\"image\":[\"https://steemitboard.com/img/notify.png\"]}",
      "parent_author": "roxy19",
      "parent_permlink": "c-inserting-data-from-a-windows-form-application-into-ms-access-database-using-vs2013-step-by-step",
      "permlink": "steemitboard-notify-roxy19-20200305t103406000z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-03-05T10:34:06",
  "trx_id": "219674bc330c1b35804427cee7f49cfec2fa1613",
  "trx_in_block": 7,
  "virtual_op": 0
}
steemdelegated 5.994 SP to @roxy19
2019/06/21 01:35:12
delegateeroxy19
delegatorsteem
vesting shares9747.447354 VESTS
Transaction InfoBlock #33980162/Trx efe17689c696fd33f9a84defaa3f3ed8d451a8d4
View Raw JSON Data
{
  "block": 33980162,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "roxy19",
      "delegator": "steem",
      "vesting_shares": "9747.447354 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-06-21T01:35:12",
  "trx_id": "efe17689c696fd33f9a84defaa3f3ed8d451a8d4",
  "trx_in_block": 7,
  "virtual_op": 0
}
2019/03/02 17:20:09
authorsteemitboard
bodyCongratulations @roxy19! You received a personal award! <table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@roxy19/birthday1.png</td><td>Happy Birthday! - You are on the Steem blockchain for 1 year!</td></tr></table> <sub>_[Click here to view your Board](https://steemitboard.com/@roxy19)_</sub> **Do not miss the last post from @steemitboard:** <table><tr><td><a href="https://steemit.com/carnival/@steemitboard/carnival-2019"><img src="https://steemitimages.com/64x128/http://i.cubeupload.com/rltzHT.png"></a></td><td><a href="https://steemit.com/carnival/@steemitboard/carnival-2019">Carnival Challenge - Collect badge and win 5 STEEM</a></td></tr></table> ###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) and get one more award and increased upvotes!
json metadata{"image":["https://steemitboard.com/img/notify.png"]}
parent authorroxy19
parent permlinkc-inserting-data-from-a-windows-form-application-into-ms-access-database-using-vs2013-step-by-step
permlinksteemitboard-notify-roxy19-20190302t172009000z
title
Transaction InfoBlock #30806437/Trx 35ee761b65aa12e5b63052a60a39301b419f7c41
View Raw JSON Data
{
  "block": 30806437,
  "op": [
    "comment",
    {
      "author": "steemitboard",
      "body": "Congratulations @roxy19! You received a personal award!\n\n<table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@roxy19/birthday1.png</td><td>Happy Birthday! - You are on the Steem blockchain for 1 year!</td></tr></table>\n\n<sub>_[Click here to view your Board](https://steemitboard.com/@roxy19)_</sub>\n\n\n**Do not miss the last post from @steemitboard:**\n<table><tr><td><a href=\"https://steemit.com/carnival/@steemitboard/carnival-2019\"><img src=\"https://steemitimages.com/64x128/http://i.cubeupload.com/rltzHT.png\"></a></td><td><a href=\"https://steemit.com/carnival/@steemitboard/carnival-2019\">Carnival Challenge - Collect badge and win 5 STEEM</a></td></tr></table>\n\n###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) and get one more award and increased upvotes!",
      "json_metadata": "{\"image\":[\"https://steemitboard.com/img/notify.png\"]}",
      "parent_author": "roxy19",
      "parent_permlink": "c-inserting-data-from-a-windows-form-application-into-ms-access-database-using-vs2013-step-by-step",
      "permlink": "steemitboard-notify-roxy19-20190302t172009000z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-03-02T17:20:09",
  "trx_id": "35ee761b65aa12e5b63052a60a39301b419f7c41",
  "trx_in_block": 29,
  "virtual_op": 0
}
steemdelegated 6.116 SP to @roxy19
2018/06/29 18:53:18
delegateeroxy19
delegatorsteem
vesting shares9946.532972 VESTS
Transaction InfoBlock #23754090/Trx 73600431ea885a56351cc78b34a2e007daa2c214
View Raw JSON Data
{
  "block": 23754090,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "roxy19",
      "delegator": "steem",
      "vesting_shares": "9946.532972 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-06-29T18:53:18",
  "trx_id": "73600431ea885a56351cc78b34a2e007daa2c214",
  "trx_in_block": 27,
  "virtual_op": 0
}
2018/03/30 18:50:39
authorroxy19
permlinkc-inserting-data-from-a-windows-form-application-into-ms-access-database-using-vs2013-step-by-step
voterroxy19
weight10000 (100.00%)
Transaction InfoBlock #21135399/Trx 1935ccfd44f8e9296d2db40d820c51442791883b
View Raw JSON Data
{
  "block": 21135399,
  "op": [
    "vote",
    {
      "author": "roxy19",
      "permlink": "c-inserting-data-from-a-windows-form-application-into-ms-access-database-using-vs2013-step-by-step",
      "voter": "roxy19",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-30T18:50:39",
  "trx_id": "1935ccfd44f8e9296d2db40d820c51442791883b",
  "trx_in_block": 41,
  "virtual_op": 0
}
roxy19upvoted (100.00%) @roxy19 / hello-everyone
2018/03/30 18:50:24
authorroxy19
permlinkhello-everyone
voterroxy19
weight10000 (100.00%)
Transaction InfoBlock #21135394/Trx 8e021588442142be4042cc49af2f7d9c9eb07b5a
View Raw JSON Data
{
  "block": 21135394,
  "op": [
    "vote",
    {
      "author": "roxy19",
      "permlink": "hello-everyone",
      "voter": "roxy19",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-30T18:50:24",
  "trx_id": "8e021588442142be4042cc49af2f7d9c9eb07b5a",
  "trx_in_block": 4,
  "virtual_op": 0
}
2018/03/30 08:56:24
authorroj
bodyYour contribution cannot be approved because it does not follow the [Utopian Rules](https://utopian.io/rules). **Related Rule:** - Only contributions made to open source projects with a GitHub repository can be approved. **Clarifications and Suggestions:** - There is no proper GitHub repository for C# or Visual Studio since they are not open source projects, so contributions on those projects cannot be approved. The repository you linked belongs to Visual Studio Code and it's not related with the tutorial or Visual Studio itself. You can contact us on [Discord](https://discord.gg/uTyJkNm). **[[utopian-moderator]](https://utopian.io/moderators)**
json metadata{"tags":["utopian-io"],"community":"utopian","app":"utopian/1.0.0"}
parent authorroxy19
parent permlinkc-inserting-data-from-a-windows-form-application-into-ms-access-database-using-vs2013-step-by-step
permlinkre-roxy19-c-inserting-data-from-a-windows-form-application-into-ms-access-database-using-vs2013-step-by-step-20180330t085623443z
title
Transaction InfoBlock #21123517/Trx 784a0a18af1383e6c5e20bb6a1a0f260009d1077
View Raw JSON Data
{
  "block": 21123517,
  "op": [
    "comment",
    {
      "author": "roj",
      "body": "Your contribution cannot be approved because it does not follow the [Utopian Rules](https://utopian.io/rules).\n\n**Related Rule:**\n- Only contributions made to open source projects with a GitHub repository can be approved.\n\n**Clarifications and Suggestions:**\n- There is no proper GitHub repository for C# or Visual Studio since they are not open source projects, so contributions on those projects cannot be approved. The repository you linked belongs to Visual Studio Code and it's not related with the tutorial or Visual Studio itself.\n\nYou can contact us on [Discord](https://discord.gg/uTyJkNm).\n**[[utopian-moderator]](https://utopian.io/moderators)**",
      "json_metadata": "{\"tags\":[\"utopian-io\"],\"community\":\"utopian\",\"app\":\"utopian/1.0.0\"}",
      "parent_author": "roxy19",
      "parent_permlink": "c-inserting-data-from-a-windows-form-application-into-ms-access-database-using-vs2013-step-by-step",
      "permlink": "re-roxy19-c-inserting-data-from-a-windows-form-application-into-ms-access-database-using-vs2013-step-by-step-20180330t085623443z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-30T08:56:24",
  "trx_id": "784a0a18af1383e6c5e20bb6a1a0f260009d1077",
  "trx_in_block": 16,
  "virtual_op": 0
}
2018/03/30 08:38:09
authorroxy19
body### **What Will I Learn?** Things we could learn from it • Create a database using MS Access • Create a Windows Form Project using Visual Studio 2013 • Connect the Windows Form Project to the database • How to Insert data from Windows Form Project to database #### Requirements Simple materials to follow this tutorial • Installed Visual Studio 2013 in to your desktop/laptop • Installed Microsoft Office with MS Access in your desktop/laptop #### Difficulty - Basic #### Tutorial Contents The contents of this tutorial are learning on how to create a database using MS Access, how to create a Windows Forms Application and connect to the database and inserting a data to the database. **Let's Start** CREATE A DATABASE USING MS ACCESS Open Microsoft Office ![step 1.JPG](https://cdn.utopian.io/posts/5bb306e29a67c7e7102e48249be2cf96055bstep_1.JPG) 1. Click Blank Database to create a fresh database without any data 2. Click Folder icon ![step 2.jpg](https://cdn.utopian.io/posts/3313048b0631bcd2047b62947bcda72f8b49step_2.jpg) 3.Change file name into myDB and choose Microsoft Office Access Database (2002-2003 format) and click OK. ![step 3.JPG](https://cdn.utopian.io/posts/a688e20c4c3974aba0e7039094aabf469169step_3.JPG) 4.See file name if has **.mdb** as an extension of the file name you created and then click Create button. ![step 4.jpg](https://cdn.utopian.io/posts/751aa97efb06faa6141fb0b6ca9782bc2649step_4.jpg) 5.Right click Table1 and choose Design View to add some entities to our table. ![step 5.JPG](https://cdn.utopian.io/posts/f2c364c9c276c87c2175174417649e8768e9step_5.JPG) 6.Change Table name Table1 into **Person** then click OK. ![step 6.JPG](https://cdn.utopian.io/posts/acd8df752d8768725f595ed50ab52029ede3step_6.JPG) 7.Add those Field Name with the corresponding Data Type and make sure to save it. Ctrl + S shortcut for SAVE. Field Name: ID Data Type: Number Field Name: Firstname Data Type: Text Field Name: Lastname Data Type: Text Field Name: Age Data Type: Number Field Name: Address Data Type: Text After saving the table you may now close the database you created for the mean time. **Next,** CREATE WINDOWS FORM PROJECT (VS2013) Open Visual Studio 2013 ![step 7.JPG](https://cdn.utopian.io/posts/245a912b6ed437dd8c236a93afd155ed3972step_7.JPG) 1.Click New Project ![step 8.JPG](https://cdn.utopian.io/posts/c2618b62240a22cd266157edf1968d4fdf51step_8.JPG) 2.Choose Visual C#, Windows and choose Windows Forms Application and click OK. After this, we need to connect our Windows Form Application to our database we created earlier. You need to locate your database you created earlier. Basically it will be saved in My Documents in your Computer/Laptop. After Locating it, COPY it and PASTE it in the Debug Folder of your Project. To open the debug folder ![Untitled.jpg](https://cdn.utopian.io/posts/d2b9f150de4b7eadec7968555a6d988ed5b4Untitled.jpg) - Right click Project File name and Click Open Folder in File Explorer. go to bin\debug and Paste the database there. After this, let move to the next step. we will add not the Connection string to our database and to do that we need to create New Class. ![step 9.jpg](https://cdn.utopian.io/posts/c707eec560b5b0d51ae42b3bb8fa15079c11step_9.jpg) 3.Right click File name choose Add new New Item... ![step 10.JPG](https://cdn.utopian.io/posts/75bb3103b0083f57b7ed4e09d981b6587bb4step_10.JPG) 4.Change Class1.cs name into **Connection.cs** 5.after changing it click Add Button below. ![step 15.JPG](https://cdn.utopian.io/posts/45134b6c8e42c521ce94b6749f5767c47f0estep_15.JPG) See Code below. ``` C# using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Data; using System.Data.OleDb; using System.Windows.Forms; namespace WindowsFormsApplication1 { class Connection { public static string dbconnect = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Application.StartupPath + "\\myDB.mdb"; public static OleDbConnection con = new OleDbConnection(dbconnect); public static void DB() { try { con.Open(); } catch (Exception e) { MessageBox.Show(e.Message); } } } } ``` After adding those code, lets go back to our main form to Add some items. ![step 16.JPG](https://cdn.utopian.io/posts/1ce9c0a9ab72ff32a94040c94691f402d794step_16.JPG) 7.Add all these items to your Form also the labels. to change the text of the labels Right Click the label and choose properties then look for the Text properties so that you can change the text of the label in your desired text. After that, we will now add the main code to save data to our database. ![step 17.jpg](https://cdn.utopian.io/posts/909d501a3eb7c5fe9ccf7a63b8668e6e5dc6step_17.jpg) 8.Double click SAVE button in your form. ![step 18.JPG](https://cdn.utopian.io/posts/9c4b1b4c411287ec57423f31717acd52995dstep_18.JPG) 9.Add this line of code above. ![step 19.JPG](https://cdn.utopian.io/posts/092fe7b18c87b2306bb84112f288326a1403step_19.JPG) 10.copy this line of codes here. See the codes below. ``` 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; using System.Data.OleDb; namespace WindowsFormsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { Connection.con.Open(); string save = "Insert into Person(ID, Firstname, Lastname, Age, Address)VALUES("+textBox1.Text+", '"+textBox2.Text+"', '"+textBox3.Text+"', "+textBox4.Text+", '"+textBox5.Text+"')"; OleDbCommand command = new OleDbCommand(save, Connection.con); command.ExecuteNonQuery(); MessageBox.Show("Successfully saved"); Connection.con.Close(); } } } ``` Now, we will run the codes. ![step 20.JPG](https://cdn.utopian.io/posts/aa61534c1532288c46c434b80b8f270d6d2estep_20.JPG) 11.Click start to run the codes. ![finish.JPG](https://cdn.utopian.io/posts/f1c94017e1405abbe13d42a91e8b38ec1c1cfinish.JPG) 12.Add some data to your textbox after that click save button. ID: 1 Firstname: roxy Lastname: roxy Age: 23 Address: Philippines # Hope you learn something with this turorial # Thank you! <br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@roxy19/c-inserting-data-from-a-windows-form-application-into-ms-access-database-using-vs2013-step-by-step">Utopian.io - Rewarding Open Source Contributors</a></em><hr/>
json metadata{"community":"utopian","app":"utopian/1.0.0","format":"markdown","repository":{"id":41881900,"name":"vscode","full_name":"Microsoft/vscode","html_url":"https://github.com/Microsoft/vscode","fork":false,"owner":{"login":"Microsoft"}},"pullRequests":[],"platform":"github","type":"tutorials","tags":["utopian-io","tutorial","philippines","steemph","programming"],"links":["https://cdn.utopian.io/posts/5bb306e29a67c7e7102e48249be2cf96055bstep_1.JPG","https://cdn.utopian.io/posts/3313048b0631bcd2047b62947bcda72f8b49step_2.jpg","https://cdn.utopian.io/posts/a688e20c4c3974aba0e7039094aabf469169step_3.JPG","https://cdn.utopian.io/posts/751aa97efb06faa6141fb0b6ca9782bc2649step_4.jpg","https://cdn.utopian.io/posts/f2c364c9c276c87c2175174417649e8768e9step_5.JPG","https://cdn.utopian.io/posts/acd8df752d8768725f595ed50ab52029ede3step_6.JPG","https://cdn.utopian.io/posts/245a912b6ed437dd8c236a93afd155ed3972step_7.JPG","https://cdn.utopian.io/posts/c2618b62240a22cd266157edf1968d4fdf51step_8.JPG","https://cdn.utopian.io/posts/d2b9f150de4b7eadec7968555a6d988ed5b4Untitled.jpg","https://cdn.utopian.io/posts/c707eec560b5b0d51ae42b3bb8fa15079c11step_9.jpg","https://cdn.utopian.io/posts/75bb3103b0083f57b7ed4e09d981b6587bb4step_10.JPG","https://cdn.utopian.io/posts/45134b6c8e42c521ce94b6749f5767c47f0estep_15.JPG","https://cdn.utopian.io/posts/1ce9c0a9ab72ff32a94040c94691f402d794step_16.JPG","https://cdn.utopian.io/posts/909d501a3eb7c5fe9ccf7a63b8668e6e5dc6step_17.jpg","https://cdn.utopian.io/posts/9c4b1b4c411287ec57423f31717acd52995dstep_18.JPG","https://cdn.utopian.io/posts/092fe7b18c87b2306bb84112f288326a1403step_19.JPG","https://cdn.utopian.io/posts/aa61534c1532288c46c434b80b8f270d6d2estep_20.JPG","https://cdn.utopian.io/posts/f1c94017e1405abbe13d42a91e8b38ec1c1cfinish.JPG"],"image":["https://cdn.utopian.io/posts/5bb306e29a67c7e7102e48249be2cf96055bstep_1.JPG","https://cdn.utopian.io/posts/3313048b0631bcd2047b62947bcda72f8b49step_2.jpg","https://cdn.utopian.io/posts/a688e20c4c3974aba0e7039094aabf469169step_3.JPG","https://cdn.utopian.io/posts/751aa97efb06faa6141fb0b6ca9782bc2649step_4.jpg","https://cdn.utopian.io/posts/f2c364c9c276c87c2175174417649e8768e9step_5.JPG","https://cdn.utopian.io/posts/acd8df752d8768725f595ed50ab52029ede3step_6.JPG","https://cdn.utopian.io/posts/245a912b6ed437dd8c236a93afd155ed3972step_7.JPG","https://cdn.utopian.io/posts/c2618b62240a22cd266157edf1968d4fdf51step_8.JPG","https://cdn.utopian.io/posts/d2b9f150de4b7eadec7968555a6d988ed5b4Untitled.jpg","https://cdn.utopian.io/posts/c707eec560b5b0d51ae42b3bb8fa15079c11step_9.jpg","https://cdn.utopian.io/posts/75bb3103b0083f57b7ed4e09d981b6587bb4step_10.JPG","https://cdn.utopian.io/posts/45134b6c8e42c521ce94b6749f5767c47f0estep_15.JPG","https://cdn.utopian.io/posts/1ce9c0a9ab72ff32a94040c94691f402d794step_16.JPG","https://cdn.utopian.io/posts/909d501a3eb7c5fe9ccf7a63b8668e6e5dc6step_17.jpg","https://cdn.utopian.io/posts/9c4b1b4c411287ec57423f31717acd52995dstep_18.JPG","https://cdn.utopian.io/posts/092fe7b18c87b2306bb84112f288326a1403step_19.JPG","https://cdn.utopian.io/posts/aa61534c1532288c46c434b80b8f270d6d2estep_20.JPG","https://cdn.utopian.io/posts/f1c94017e1405abbe13d42a91e8b38ec1c1cfinish.JPG"],"moderator":{"account":"roj","time":"2018-03-30T08:38:03.643Z","flagged":true,"reviewed":false,"pending":false},"questions":[],"score":null}
parent author
parent permlinkutopian-io
permlinkc-inserting-data-from-a-windows-form-application-into-ms-access-database-using-vs2013-step-by-step
titleC# INSERTING DATA FROM A WINDOWS FORM APPLICATION INTO MS ACCESS DATABASE USING VS2013 STEP BY STEP
Transaction InfoBlock #21123152/Trx 70092ef3c51a72666a4848f27c38d353b1cf585f
View Raw JSON Data
{
  "block": 21123152,
  "op": [
    "comment",
    {
      "author": "roxy19",
      "body": "### **What Will I Learn?**\nThings we could learn from it\n\n•\tCreate a database using MS Access\n\n•\tCreate a Windows Form Project using Visual Studio 2013\n\n•\tConnect the Windows Form Project to the database\n\n•\tHow to Insert data from Windows Form Project to database\n\n\n#### Requirements\nSimple materials to follow this tutorial \n\n•\tInstalled Visual Studio 2013 in to your desktop/laptop\n\n•\tInstalled Microsoft Office with MS Access in your desktop/laptop\n\n\n#### Difficulty\n\n- Basic\n\n#### Tutorial Contents\nThe contents of this tutorial are learning on how to create a database using MS Access, how to create a Windows Forms Application and connect to the database and inserting a data to the database.\n\n**Let's Start**\n\nCREATE A DATABASE USING MS ACCESS\n\nOpen Microsoft Office\n\n![step 1.JPG](https://cdn.utopian.io/posts/5bb306e29a67c7e7102e48249be2cf96055bstep_1.JPG)\n\n1. Click Blank Database to create a fresh database without any data\n2. Click Folder icon\n\n![step 2.jpg](https://cdn.utopian.io/posts/3313048b0631bcd2047b62947bcda72f8b49step_2.jpg)\n\n3.Change file name into myDB and choose Microsoft Office Access Database (2002-2003 format) and click OK.\n    \n![step 3.JPG](https://cdn.utopian.io/posts/a688e20c4c3974aba0e7039094aabf469169step_3.JPG)\n\n4.See file name if has **.mdb** as an extension of the file name you created and then click Create button.\n\n![step 4.jpg](https://cdn.utopian.io/posts/751aa97efb06faa6141fb0b6ca9782bc2649step_4.jpg)\n\n5.Right click Table1 and choose Design View to add some entities to our table.\n\n![step 5.JPG](https://cdn.utopian.io/posts/f2c364c9c276c87c2175174417649e8768e9step_5.JPG)\n\n6.Change Table name Table1 into **Person** then click OK.\n\n![step 6.JPG](https://cdn.utopian.io/posts/acd8df752d8768725f595ed50ab52029ede3step_6.JPG)\n\n7.Add those Field Name with the corresponding Data Type and make sure to save it.\nCtrl + S shortcut for SAVE.\n\nField Name: ID\n\n Data Type: Number\n\nField Name: Firstname\n\n Data Type: Text\n\nField Name: Lastname\n\n Data Type: Text\n\nField Name: Age\n\n Data Type: Number\n\nField Name: Address\n\n Data Type: Text\n\nAfter saving the table you may now close the database you created for the mean time.\n\n**Next,**\n\nCREATE WINDOWS FORM PROJECT (VS2013)\n\nOpen Visual Studio 2013\n\n![step 7.JPG](https://cdn.utopian.io/posts/245a912b6ed437dd8c236a93afd155ed3972step_7.JPG)\n\n1.Click New Project\n\n![step 8.JPG](https://cdn.utopian.io/posts/c2618b62240a22cd266157edf1968d4fdf51step_8.JPG)\n\n\n2.Choose Visual C#, Windows and choose Windows Forms Application and click OK.\n\nAfter this, we need to connect our Windows Form Application to our database we created earlier.\nYou need to locate your database you created earlier.\nBasically it will be saved in My Documents in your Computer/Laptop.\nAfter Locating it, COPY it and PASTE it in the Debug Folder of your Project.\nTo open the debug folder\n\n\n![Untitled.jpg](https://cdn.utopian.io/posts/d2b9f150de4b7eadec7968555a6d988ed5b4Untitled.jpg)\n\n- Right click Project File name and Click Open Folder in File Explorer.\n\ngo to bin\\debug and Paste the database there. After this, let move to the next step.\nwe will add not the Connection string to our database and to do that we need to create\nNew Class.\n\n![step 9.jpg](https://cdn.utopian.io/posts/c707eec560b5b0d51ae42b3bb8fa15079c11step_9.jpg)\n\n3.Right click File name choose Add new New Item...\n\n![step 10.JPG](https://cdn.utopian.io/posts/75bb3103b0083f57b7ed4e09d981b6587bb4step_10.JPG)\n\n4.Change Class1.cs name into **Connection.cs**\n\n5.after changing it click Add Button below.\n\n![step 15.JPG](https://cdn.utopian.io/posts/45134b6c8e42c521ce94b6749f5767c47f0estep_15.JPG)\nSee Code below.\n\n``` C#\nusing System;\nusing System.Collections.Generic;\nusing System.Linq;\nusing System.Text;\nusing System.Threading.Tasks;\n\nusing System.Data;\nusing System.Data.OleDb;\nusing System.Windows.Forms;\n\nnamespace WindowsFormsApplication1\n{\n    class Connection\n    {\n        public static string dbconnect = \"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\" + Application.StartupPath + \"\\\\myDB.mdb\";\n        public static OleDbConnection con = new OleDbConnection(dbconnect);\n\n        public static void DB()\n        {\n            try\n            {\n                con.Open();\n            }\n            catch (Exception e)\n            {\n                MessageBox.Show(e.Message);\n            }\n        }\n    \n    }\n}\n\n\n\n```\n\nAfter adding those code, lets go  back to our main form to Add some items.\n\n![step 16.JPG](https://cdn.utopian.io/posts/1ce9c0a9ab72ff32a94040c94691f402d794step_16.JPG)\n\n7.Add all these items to your Form also the labels.\n\nto change the text of the labels Right Click the label and choose properties then look for the Text properties so that you can change the text of the label in your desired text. After that, we will now add the main code to save data to our database.\n\n![step 17.jpg](https://cdn.utopian.io/posts/909d501a3eb7c5fe9ccf7a63b8668e6e5dc6step_17.jpg)\n\n8.Double click SAVE button in your form.\n\n![step 18.JPG](https://cdn.utopian.io/posts/9c4b1b4c411287ec57423f31717acd52995dstep_18.JPG)\n\n9.Add this line of code above.\n\n![step 19.JPG](https://cdn.utopian.io/posts/092fe7b18c87b2306bb84112f288326a1403step_19.JPG)\n\n10.copy this line of codes here.\n\nSee the codes below.\n``` C#\nusing System;\nusing System.Collections.Generic;\nusing System.ComponentModel;\nusing System.Data;\nusing System.Drawing;\nusing System.Linq;\nusing System.Text;\nusing System.Threading.Tasks;\nusing System.Windows.Forms;\n\nusing System.Data.OleDb;\n\nnamespace WindowsFormsApplication1\n{\n    public partial class Form1 : Form\n    {\n        public Form1()\n        {\n            InitializeComponent();\n        }\n\n        private void button1_Click(object sender, EventArgs e)\n        {\n            Connection.con.Open();\n            string save = \"Insert into Person(ID, Firstname, Lastname, Age, Address)VALUES(\"+textBox1.Text+\", '\"+textBox2.Text+\"', '\"+textBox3.Text+\"', \"+textBox4.Text+\", '\"+textBox5.Text+\"')\";\n            OleDbCommand command = new OleDbCommand(save, Connection.con);\n            command.ExecuteNonQuery();\n            MessageBox.Show(\"Successfully saved\");\n            Connection.con.Close();\n\n        }\n    }\n}\n\n```\nNow, we will run the codes.\n\n![step 20.JPG](https://cdn.utopian.io/posts/aa61534c1532288c46c434b80b8f270d6d2estep_20.JPG)\n\n11.Click start to run the codes.\n\n![finish.JPG](https://cdn.utopian.io/posts/f1c94017e1405abbe13d42a91e8b38ec1c1cfinish.JPG)\n\n12.Add some data to your textbox after that click save button.\n\nID: 1\n\nFirstname: roxy\n\nLastname: roxy\n\nAge: 23\n\nAddress: Philippines\n\n# Hope you learn something with this turorial\n# Thank you!\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n<br /><hr/><em>Posted on <a href=\"https://utopian.io/utopian-io/@roxy19/c-inserting-data-from-a-windows-form-application-into-ms-access-database-using-vs2013-step-by-step\">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>",
      "json_metadata": "{\"community\":\"utopian\",\"app\":\"utopian/1.0.0\",\"format\":\"markdown\",\"repository\":{\"id\":41881900,\"name\":\"vscode\",\"full_name\":\"Microsoft/vscode\",\"html_url\":\"https://github.com/Microsoft/vscode\",\"fork\":false,\"owner\":{\"login\":\"Microsoft\"}},\"pullRequests\":[],\"platform\":\"github\",\"type\":\"tutorials\",\"tags\":[\"utopian-io\",\"tutorial\",\"philippines\",\"steemph\",\"programming\"],\"links\":[\"https://cdn.utopian.io/posts/5bb306e29a67c7e7102e48249be2cf96055bstep_1.JPG\",\"https://cdn.utopian.io/posts/3313048b0631bcd2047b62947bcda72f8b49step_2.jpg\",\"https://cdn.utopian.io/posts/a688e20c4c3974aba0e7039094aabf469169step_3.JPG\",\"https://cdn.utopian.io/posts/751aa97efb06faa6141fb0b6ca9782bc2649step_4.jpg\",\"https://cdn.utopian.io/posts/f2c364c9c276c87c2175174417649e8768e9step_5.JPG\",\"https://cdn.utopian.io/posts/acd8df752d8768725f595ed50ab52029ede3step_6.JPG\",\"https://cdn.utopian.io/posts/245a912b6ed437dd8c236a93afd155ed3972step_7.JPG\",\"https://cdn.utopian.io/posts/c2618b62240a22cd266157edf1968d4fdf51step_8.JPG\",\"https://cdn.utopian.io/posts/d2b9f150de4b7eadec7968555a6d988ed5b4Untitled.jpg\",\"https://cdn.utopian.io/posts/c707eec560b5b0d51ae42b3bb8fa15079c11step_9.jpg\",\"https://cdn.utopian.io/posts/75bb3103b0083f57b7ed4e09d981b6587bb4step_10.JPG\",\"https://cdn.utopian.io/posts/45134b6c8e42c521ce94b6749f5767c47f0estep_15.JPG\",\"https://cdn.utopian.io/posts/1ce9c0a9ab72ff32a94040c94691f402d794step_16.JPG\",\"https://cdn.utopian.io/posts/909d501a3eb7c5fe9ccf7a63b8668e6e5dc6step_17.jpg\",\"https://cdn.utopian.io/posts/9c4b1b4c411287ec57423f31717acd52995dstep_18.JPG\",\"https://cdn.utopian.io/posts/092fe7b18c87b2306bb84112f288326a1403step_19.JPG\",\"https://cdn.utopian.io/posts/aa61534c1532288c46c434b80b8f270d6d2estep_20.JPG\",\"https://cdn.utopian.io/posts/f1c94017e1405abbe13d42a91e8b38ec1c1cfinish.JPG\"],\"image\":[\"https://cdn.utopian.io/posts/5bb306e29a67c7e7102e48249be2cf96055bstep_1.JPG\",\"https://cdn.utopian.io/posts/3313048b0631bcd2047b62947bcda72f8b49step_2.jpg\",\"https://cdn.utopian.io/posts/a688e20c4c3974aba0e7039094aabf469169step_3.JPG\",\"https://cdn.utopian.io/posts/751aa97efb06faa6141fb0b6ca9782bc2649step_4.jpg\",\"https://cdn.utopian.io/posts/f2c364c9c276c87c2175174417649e8768e9step_5.JPG\",\"https://cdn.utopian.io/posts/acd8df752d8768725f595ed50ab52029ede3step_6.JPG\",\"https://cdn.utopian.io/posts/245a912b6ed437dd8c236a93afd155ed3972step_7.JPG\",\"https://cdn.utopian.io/posts/c2618b62240a22cd266157edf1968d4fdf51step_8.JPG\",\"https://cdn.utopian.io/posts/d2b9f150de4b7eadec7968555a6d988ed5b4Untitled.jpg\",\"https://cdn.utopian.io/posts/c707eec560b5b0d51ae42b3bb8fa15079c11step_9.jpg\",\"https://cdn.utopian.io/posts/75bb3103b0083f57b7ed4e09d981b6587bb4step_10.JPG\",\"https://cdn.utopian.io/posts/45134b6c8e42c521ce94b6749f5767c47f0estep_15.JPG\",\"https://cdn.utopian.io/posts/1ce9c0a9ab72ff32a94040c94691f402d794step_16.JPG\",\"https://cdn.utopian.io/posts/909d501a3eb7c5fe9ccf7a63b8668e6e5dc6step_17.jpg\",\"https://cdn.utopian.io/posts/9c4b1b4c411287ec57423f31717acd52995dstep_18.JPG\",\"https://cdn.utopian.io/posts/092fe7b18c87b2306bb84112f288326a1403step_19.JPG\",\"https://cdn.utopian.io/posts/aa61534c1532288c46c434b80b8f270d6d2estep_20.JPG\",\"https://cdn.utopian.io/posts/f1c94017e1405abbe13d42a91e8b38ec1c1cfinish.JPG\"],\"moderator\":{\"account\":\"roj\",\"time\":\"2018-03-30T08:38:03.643Z\",\"flagged\":true,\"reviewed\":false,\"pending\":false},\"questions\":[],\"score\":null}",
      "parent_author": "",
      "parent_permlink": "utopian-io",
      "permlink": "c-inserting-data-from-a-windows-form-application-into-ms-access-database-using-vs2013-step-by-step",
      "title": "C# INSERTING DATA FROM A WINDOWS FORM APPLICATION INTO MS ACCESS DATABASE USING VS2013 STEP BY STEP"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-30T08:38:09",
  "trx_id": "70092ef3c51a72666a4848f27c38d353b1cf585f",
  "trx_in_block": 32,
  "virtual_op": 0
}
2018/03/30 07:32:15
allow curation rewardstrue
allow votestrue
authorroxy19
extensions[[0,{"beneficiaries":[{"account":"utopian.pay","weight":2500}]}]]
max accepted payout1000000.000 SBD
percent steem dollars10000
permlinkc-inserting-data-from-a-windows-form-application-into-ms-access-database-using-vs2013-step-by-step
Transaction InfoBlock #21121834/Trx 192b5070a505adda4ec21cea9a6249684f2e9816
View Raw JSON Data
{
  "block": 21121834,
  "op": [
    "comment_options",
    {
      "allow_curation_rewards": true,
      "allow_votes": true,
      "author": "roxy19",
      "extensions": [
        [
          0,
          {
            "beneficiaries": [
              {
                "account": "utopian.pay",
                "weight": 2500
              }
            ]
          }
        ]
      ],
      "max_accepted_payout": "1000000.000 SBD",
      "percent_steem_dollars": 10000,
      "permlink": "c-inserting-data-from-a-windows-form-application-into-ms-access-database-using-vs2013-step-by-step"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-30T07:32:15",
  "trx_id": "192b5070a505adda4ec21cea9a6249684f2e9816",
  "trx_in_block": 27,
  "virtual_op": 0
}
2018/03/30 07:32:15
authorroxy19
body### **What Will I Learn?** Things we could learn from it • Create a database using MS Access • Create a Windows Form Project using Visual Studio 2013 • Connect the Windows Form Project to the database • How to Insert data from Windows Form Project to database #### Requirements Simple materials to follow this tutorial • Installed Visual Studio 2013 in to your desktop/laptop • Installed Microsoft Office with MS Access in your desktop/laptop #### Difficulty - Basic #### Tutorial Contents The contents of this tutorial are learning on how to create a database using MS Access, how to create a Windows Forms Application and connect to the database and inserting a data to the database. **Let's Start** CREATE A DATABASE USING MS ACCESS Open Microsoft Office ![step 1.JPG](https://cdn.utopian.io/posts/5bb306e29a67c7e7102e48249be2cf96055bstep_1.JPG) 1. Click Blank Database to create a fresh database without any data 2. Click Folder icon ![step 2.jpg](https://cdn.utopian.io/posts/3313048b0631bcd2047b62947bcda72f8b49step_2.jpg) 3.Change file name into myDB and choose Microsoft Office Access Database (2002-2003 format) and click OK. ![step 3.JPG](https://cdn.utopian.io/posts/a688e20c4c3974aba0e7039094aabf469169step_3.JPG) 4.See file name if has **.mdb** as an extension of the file name you created and then click Create button. ![step 4.jpg](https://cdn.utopian.io/posts/751aa97efb06faa6141fb0b6ca9782bc2649step_4.jpg) 5.Right click Table1 and choose Design View to add some entities to our table. ![step 5.JPG](https://cdn.utopian.io/posts/f2c364c9c276c87c2175174417649e8768e9step_5.JPG) 6.Change Table name Table1 into **Person** then click OK. ![step 6.JPG](https://cdn.utopian.io/posts/acd8df752d8768725f595ed50ab52029ede3step_6.JPG) 7.Add those Field Name with the corresponding Data Type and make sure to save it. Ctrl + S shortcut for SAVE. Field Name: ID Data Type: Number Field Name: Firstname Data Type: Text Field Name: Lastname Data Type: Text Field Name: Age Data Type: Number Field Name: Address Data Type: Text After saving the table you may now close the database you created for the mean time. **Next,** CREATE WINDOWS FORM PROJECT (VS2013) Open Visual Studio 2013 ![step 7.JPG](https://cdn.utopian.io/posts/245a912b6ed437dd8c236a93afd155ed3972step_7.JPG) 1.Click New Project ![step 8.JPG](https://cdn.utopian.io/posts/c2618b62240a22cd266157edf1968d4fdf51step_8.JPG) 2.Choose Visual C#, Windows and choose Windows Forms Application and click OK. After this, we need to connect our Windows Form Application to our database we created earlier. You need to locate your database you created earlier. Basically it will be saved in My Documents in your Computer/Laptop. After Locating it, COPY it and PASTE it in the Debug Folder of your Project. To open the debug folder ![Untitled.jpg](https://cdn.utopian.io/posts/d2b9f150de4b7eadec7968555a6d988ed5b4Untitled.jpg) - Right click Project File name and Click Open Folder in File Explorer. go to bin\debug and Paste the database there. After this, let move to the next step. we will add not the Connection string to our database and to do that we need to create New Class. ![step 9.jpg](https://cdn.utopian.io/posts/c707eec560b5b0d51ae42b3bb8fa15079c11step_9.jpg) 3.Right click File name choose Add new New Item... ![step 10.JPG](https://cdn.utopian.io/posts/75bb3103b0083f57b7ed4e09d981b6587bb4step_10.JPG) 4.Change Class1.cs name into **Connection.cs** 5.after changing it click Add Button below. ![step 15.JPG](https://cdn.utopian.io/posts/45134b6c8e42c521ce94b6749f5767c47f0estep_15.JPG) See Code below. ``` C# using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Data; using System.Data.OleDb; using System.Windows.Forms; namespace WindowsFormsApplication1 { class Connection { public static string dbconnect = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Application.StartupPath + "\\myDB.mdb"; public static OleDbConnection con = new OleDbConnection(dbconnect); public static void DB() { try { con.Open(); } catch (Exception e) { MessageBox.Show(e.Message); } } } } ``` After adding those code, lets go back to our main form to Add some items. ![step 16.JPG](https://cdn.utopian.io/posts/1ce9c0a9ab72ff32a94040c94691f402d794step_16.JPG) 7.Add all these items to your Form also the labels. to change the text of the labels Right Click the label and choose properties then look for the Text properties so that you can change the text of the label in your desired text. After that, we will now add the main code to save data to our database. ![step 17.jpg](https://cdn.utopian.io/posts/909d501a3eb7c5fe9ccf7a63b8668e6e5dc6step_17.jpg) 8.Double click SAVE button in your form. ![step 18.JPG](https://cdn.utopian.io/posts/9c4b1b4c411287ec57423f31717acd52995dstep_18.JPG) 9.Add this line of code above. ![step 19.JPG](https://cdn.utopian.io/posts/092fe7b18c87b2306bb84112f288326a1403step_19.JPG) 10.copy this line of codes here. See the codes below. ``` 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; using System.Data.OleDb; namespace WindowsFormsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { Connection.con.Open(); string save = "Insert into Person(ID, Firstname, Lastname, Age, Address)VALUES("+textBox1.Text+", '"+textBox2.Text+"', '"+textBox3.Text+"', "+textBox4.Text+", '"+textBox5.Text+"')"; OleDbCommand command = new OleDbCommand(save, Connection.con); command.ExecuteNonQuery(); MessageBox.Show("Successfully saved"); Connection.con.Close(); } } } ``` Now, we will run the codes. ![step 20.JPG](https://cdn.utopian.io/posts/aa61534c1532288c46c434b80b8f270d6d2estep_20.JPG) 11.Click start to run the codes. ![finish.JPG](https://cdn.utopian.io/posts/f1c94017e1405abbe13d42a91e8b38ec1c1cfinish.JPG) 12.Add some data to your textbox after that click save button. ID: 1 Firstname: roxy Lastname: roxy Age: 23 Address: Philippines # Hope you learn something with this turorial # Thank you! <br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@roxy19/c-inserting-data-from-a-windows-form-application-into-ms-access-database-using-vs2013-step-by-step">Utopian.io - Rewarding Open Source Contributors</a></em><hr/>
json metadata{"community":"utopian","app":"utopian/1.0.0","format":"markdown","repository":{"id":41881900,"name":"vscode","full_name":"Microsoft/vscode","html_url":"https://github.com/Microsoft/vscode","fork":false,"owner":{"login":"Microsoft"}},"pullRequests":[],"platform":"github","type":"tutorials","tags":["utopian-io","tutorial","philippines","steemph","programming"],"links":["https://cdn.utopian.io/posts/5bb306e29a67c7e7102e48249be2cf96055bstep_1.JPG","https://cdn.utopian.io/posts/3313048b0631bcd2047b62947bcda72f8b49step_2.jpg","https://cdn.utopian.io/posts/a688e20c4c3974aba0e7039094aabf469169step_3.JPG","https://cdn.utopian.io/posts/751aa97efb06faa6141fb0b6ca9782bc2649step_4.jpg","https://cdn.utopian.io/posts/f2c364c9c276c87c2175174417649e8768e9step_5.JPG","https://cdn.utopian.io/posts/acd8df752d8768725f595ed50ab52029ede3step_6.JPG","https://cdn.utopian.io/posts/245a912b6ed437dd8c236a93afd155ed3972step_7.JPG","https://cdn.utopian.io/posts/c2618b62240a22cd266157edf1968d4fdf51step_8.JPG","https://cdn.utopian.io/posts/d2b9f150de4b7eadec7968555a6d988ed5b4Untitled.jpg","https://cdn.utopian.io/posts/c707eec560b5b0d51ae42b3bb8fa15079c11step_9.jpg","https://cdn.utopian.io/posts/75bb3103b0083f57b7ed4e09d981b6587bb4step_10.JPG","https://cdn.utopian.io/posts/45134b6c8e42c521ce94b6749f5767c47f0estep_15.JPG","https://cdn.utopian.io/posts/1ce9c0a9ab72ff32a94040c94691f402d794step_16.JPG","https://cdn.utopian.io/posts/909d501a3eb7c5fe9ccf7a63b8668e6e5dc6step_17.jpg","https://cdn.utopian.io/posts/9c4b1b4c411287ec57423f31717acd52995dstep_18.JPG","https://cdn.utopian.io/posts/092fe7b18c87b2306bb84112f288326a1403step_19.JPG","https://cdn.utopian.io/posts/aa61534c1532288c46c434b80b8f270d6d2estep_20.JPG","https://cdn.utopian.io/posts/f1c94017e1405abbe13d42a91e8b38ec1c1cfinish.JPG"],"image":["https://cdn.utopian.io/posts/5bb306e29a67c7e7102e48249be2cf96055bstep_1.JPG","https://cdn.utopian.io/posts/3313048b0631bcd2047b62947bcda72f8b49step_2.jpg","https://cdn.utopian.io/posts/a688e20c4c3974aba0e7039094aabf469169step_3.JPG","https://cdn.utopian.io/posts/751aa97efb06faa6141fb0b6ca9782bc2649step_4.jpg","https://cdn.utopian.io/posts/f2c364c9c276c87c2175174417649e8768e9step_5.JPG","https://cdn.utopian.io/posts/acd8df752d8768725f595ed50ab52029ede3step_6.JPG","https://cdn.utopian.io/posts/245a912b6ed437dd8c236a93afd155ed3972step_7.JPG","https://cdn.utopian.io/posts/c2618b62240a22cd266157edf1968d4fdf51step_8.JPG","https://cdn.utopian.io/posts/d2b9f150de4b7eadec7968555a6d988ed5b4Untitled.jpg","https://cdn.utopian.io/posts/c707eec560b5b0d51ae42b3bb8fa15079c11step_9.jpg","https://cdn.utopian.io/posts/75bb3103b0083f57b7ed4e09d981b6587bb4step_10.JPG","https://cdn.utopian.io/posts/45134b6c8e42c521ce94b6749f5767c47f0estep_15.JPG","https://cdn.utopian.io/posts/1ce9c0a9ab72ff32a94040c94691f402d794step_16.JPG","https://cdn.utopian.io/posts/909d501a3eb7c5fe9ccf7a63b8668e6e5dc6step_17.jpg","https://cdn.utopian.io/posts/9c4b1b4c411287ec57423f31717acd52995dstep_18.JPG","https://cdn.utopian.io/posts/092fe7b18c87b2306bb84112f288326a1403step_19.JPG","https://cdn.utopian.io/posts/aa61534c1532288c46c434b80b8f270d6d2estep_20.JPG","https://cdn.utopian.io/posts/f1c94017e1405abbe13d42a91e8b38ec1c1cfinish.JPG"]}
parent author
parent permlinkutopian-io
permlinkc-inserting-data-from-a-windows-form-application-into-ms-access-database-using-vs2013-step-by-step
titleC# INSERTING DATA FROM A WINDOWS FORM APPLICATION INTO MS ACCESS DATABASE USING VS2013 STEP BY STEP
Transaction InfoBlock #21121834/Trx 192b5070a505adda4ec21cea9a6249684f2e9816
View Raw JSON Data
{
  "block": 21121834,
  "op": [
    "comment",
    {
      "author": "roxy19",
      "body": "### **What Will I Learn?**\nThings we could learn from it\n\n•\tCreate a database using MS Access\n\n•\tCreate a Windows Form Project using Visual Studio 2013\n\n•\tConnect the Windows Form Project to the database\n\n•\tHow to Insert data from Windows Form Project to database\n\n\n#### Requirements\nSimple materials to follow this tutorial \n\n•\tInstalled Visual Studio 2013 in to your desktop/laptop\n\n•\tInstalled Microsoft Office with MS Access in your desktop/laptop\n\n\n#### Difficulty\n\n- Basic\n\n#### Tutorial Contents\nThe contents of this tutorial are learning on how to create a database using MS Access, how to create a Windows Forms Application and connect to the database and inserting a data to the database.\n\n**Let's Start**\n\nCREATE A DATABASE USING MS ACCESS\n\nOpen Microsoft Office\n\n![step 1.JPG](https://cdn.utopian.io/posts/5bb306e29a67c7e7102e48249be2cf96055bstep_1.JPG)\n\n1. Click Blank Database to create a fresh database without any data\n2. Click Folder icon\n\n![step 2.jpg](https://cdn.utopian.io/posts/3313048b0631bcd2047b62947bcda72f8b49step_2.jpg)\n\n3.Change file name into myDB and choose Microsoft Office Access Database (2002-2003 format) and click OK.\n    \n![step 3.JPG](https://cdn.utopian.io/posts/a688e20c4c3974aba0e7039094aabf469169step_3.JPG)\n\n4.See file name if has **.mdb** as an extension of the file name you created and then click Create button.\n\n![step 4.jpg](https://cdn.utopian.io/posts/751aa97efb06faa6141fb0b6ca9782bc2649step_4.jpg)\n\n5.Right click Table1 and choose Design View to add some entities to our table.\n\n![step 5.JPG](https://cdn.utopian.io/posts/f2c364c9c276c87c2175174417649e8768e9step_5.JPG)\n\n6.Change Table name Table1 into **Person** then click OK.\n\n![step 6.JPG](https://cdn.utopian.io/posts/acd8df752d8768725f595ed50ab52029ede3step_6.JPG)\n\n7.Add those Field Name with the corresponding Data Type and make sure to save it.\nCtrl + S shortcut for SAVE.\n\nField Name: ID\n\n Data Type: Number\n\nField Name: Firstname\n\n Data Type: Text\n\nField Name: Lastname\n\n Data Type: Text\n\nField Name: Age\n\n Data Type: Number\n\nField Name: Address\n\n Data Type: Text\n\nAfter saving the table you may now close the database you created for the mean time.\n\n**Next,**\n\nCREATE WINDOWS FORM PROJECT (VS2013)\n\nOpen Visual Studio 2013\n\n![step 7.JPG](https://cdn.utopian.io/posts/245a912b6ed437dd8c236a93afd155ed3972step_7.JPG)\n\n1.Click New Project\n\n![step 8.JPG](https://cdn.utopian.io/posts/c2618b62240a22cd266157edf1968d4fdf51step_8.JPG)\n\n\n2.Choose Visual C#, Windows and choose Windows Forms Application and click OK.\n\nAfter this, we need to connect our Windows Form Application to our database we created earlier.\nYou need to locate your database you created earlier.\nBasically it will be saved in My Documents in your Computer/Laptop.\nAfter Locating it, COPY it and PASTE it in the Debug Folder of your Project.\nTo open the debug folder\n\n\n![Untitled.jpg](https://cdn.utopian.io/posts/d2b9f150de4b7eadec7968555a6d988ed5b4Untitled.jpg)\n\n- Right click Project File name and Click Open Folder in File Explorer.\n\ngo to bin\\debug and Paste the database there. After this, let move to the next step.\nwe will add not the Connection string to our database and to do that we need to create\nNew Class.\n\n![step 9.jpg](https://cdn.utopian.io/posts/c707eec560b5b0d51ae42b3bb8fa15079c11step_9.jpg)\n\n3.Right click File name choose Add new New Item...\n\n![step 10.JPG](https://cdn.utopian.io/posts/75bb3103b0083f57b7ed4e09d981b6587bb4step_10.JPG)\n\n4.Change Class1.cs name into **Connection.cs**\n\n5.after changing it click Add Button below.\n\n![step 15.JPG](https://cdn.utopian.io/posts/45134b6c8e42c521ce94b6749f5767c47f0estep_15.JPG)\nSee Code below.\n\n``` C#\nusing System;\nusing System.Collections.Generic;\nusing System.Linq;\nusing System.Text;\nusing System.Threading.Tasks;\n\nusing System.Data;\nusing System.Data.OleDb;\nusing System.Windows.Forms;\n\nnamespace WindowsFormsApplication1\n{\n    class Connection\n    {\n        public static string dbconnect = \"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\" + Application.StartupPath + \"\\\\myDB.mdb\";\n        public static OleDbConnection con = new OleDbConnection(dbconnect);\n\n        public static void DB()\n        {\n            try\n            {\n                con.Open();\n            }\n            catch (Exception e)\n            {\n                MessageBox.Show(e.Message);\n            }\n        }\n    \n    }\n}\n\n\n\n```\n\nAfter adding those code, lets go  back to our main form to Add some items.\n\n![step 16.JPG](https://cdn.utopian.io/posts/1ce9c0a9ab72ff32a94040c94691f402d794step_16.JPG)\n\n7.Add all these items to your Form also the labels.\n\nto change the text of the labels Right Click the label and choose properties then look for the Text properties so that you can change the text of the label in your desired text. After that, we will now add the main code to save data to our database.\n\n![step 17.jpg](https://cdn.utopian.io/posts/909d501a3eb7c5fe9ccf7a63b8668e6e5dc6step_17.jpg)\n\n8.Double click SAVE button in your form.\n\n![step 18.JPG](https://cdn.utopian.io/posts/9c4b1b4c411287ec57423f31717acd52995dstep_18.JPG)\n\n9.Add this line of code above.\n\n![step 19.JPG](https://cdn.utopian.io/posts/092fe7b18c87b2306bb84112f288326a1403step_19.JPG)\n\n10.copy this line of codes here.\n\nSee the codes below.\n``` C#\nusing System;\nusing System.Collections.Generic;\nusing System.ComponentModel;\nusing System.Data;\nusing System.Drawing;\nusing System.Linq;\nusing System.Text;\nusing System.Threading.Tasks;\nusing System.Windows.Forms;\n\nusing System.Data.OleDb;\n\nnamespace WindowsFormsApplication1\n{\n    public partial class Form1 : Form\n    {\n        public Form1()\n        {\n            InitializeComponent();\n        }\n\n        private void button1_Click(object sender, EventArgs e)\n        {\n            Connection.con.Open();\n            string save = \"Insert into Person(ID, Firstname, Lastname, Age, Address)VALUES(\"+textBox1.Text+\", '\"+textBox2.Text+\"', '\"+textBox3.Text+\"', \"+textBox4.Text+\", '\"+textBox5.Text+\"')\";\n            OleDbCommand command = new OleDbCommand(save, Connection.con);\n            command.ExecuteNonQuery();\n            MessageBox.Show(\"Successfully saved\");\n            Connection.con.Close();\n\n        }\n    }\n}\n\n```\nNow, we will run the codes.\n\n![step 20.JPG](https://cdn.utopian.io/posts/aa61534c1532288c46c434b80b8f270d6d2estep_20.JPG)\n\n11.Click start to run the codes.\n\n![finish.JPG](https://cdn.utopian.io/posts/f1c94017e1405abbe13d42a91e8b38ec1c1cfinish.JPG)\n\n12.Add some data to your textbox after that click save button.\n\nID: 1\n\nFirstname: roxy\n\nLastname: roxy\n\nAge: 23\n\nAddress: Philippines\n\n# Hope you learn something with this turorial\n# Thank you!\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n<br /><hr/><em>Posted on <a href=\"https://utopian.io/utopian-io/@roxy19/c-inserting-data-from-a-windows-form-application-into-ms-access-database-using-vs2013-step-by-step\">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>",
      "json_metadata": "{\"community\":\"utopian\",\"app\":\"utopian/1.0.0\",\"format\":\"markdown\",\"repository\":{\"id\":41881900,\"name\":\"vscode\",\"full_name\":\"Microsoft/vscode\",\"html_url\":\"https://github.com/Microsoft/vscode\",\"fork\":false,\"owner\":{\"login\":\"Microsoft\"}},\"pullRequests\":[],\"platform\":\"github\",\"type\":\"tutorials\",\"tags\":[\"utopian-io\",\"tutorial\",\"philippines\",\"steemph\",\"programming\"],\"links\":[\"https://cdn.utopian.io/posts/5bb306e29a67c7e7102e48249be2cf96055bstep_1.JPG\",\"https://cdn.utopian.io/posts/3313048b0631bcd2047b62947bcda72f8b49step_2.jpg\",\"https://cdn.utopian.io/posts/a688e20c4c3974aba0e7039094aabf469169step_3.JPG\",\"https://cdn.utopian.io/posts/751aa97efb06faa6141fb0b6ca9782bc2649step_4.jpg\",\"https://cdn.utopian.io/posts/f2c364c9c276c87c2175174417649e8768e9step_5.JPG\",\"https://cdn.utopian.io/posts/acd8df752d8768725f595ed50ab52029ede3step_6.JPG\",\"https://cdn.utopian.io/posts/245a912b6ed437dd8c236a93afd155ed3972step_7.JPG\",\"https://cdn.utopian.io/posts/c2618b62240a22cd266157edf1968d4fdf51step_8.JPG\",\"https://cdn.utopian.io/posts/d2b9f150de4b7eadec7968555a6d988ed5b4Untitled.jpg\",\"https://cdn.utopian.io/posts/c707eec560b5b0d51ae42b3bb8fa15079c11step_9.jpg\",\"https://cdn.utopian.io/posts/75bb3103b0083f57b7ed4e09d981b6587bb4step_10.JPG\",\"https://cdn.utopian.io/posts/45134b6c8e42c521ce94b6749f5767c47f0estep_15.JPG\",\"https://cdn.utopian.io/posts/1ce9c0a9ab72ff32a94040c94691f402d794step_16.JPG\",\"https://cdn.utopian.io/posts/909d501a3eb7c5fe9ccf7a63b8668e6e5dc6step_17.jpg\",\"https://cdn.utopian.io/posts/9c4b1b4c411287ec57423f31717acd52995dstep_18.JPG\",\"https://cdn.utopian.io/posts/092fe7b18c87b2306bb84112f288326a1403step_19.JPG\",\"https://cdn.utopian.io/posts/aa61534c1532288c46c434b80b8f270d6d2estep_20.JPG\",\"https://cdn.utopian.io/posts/f1c94017e1405abbe13d42a91e8b38ec1c1cfinish.JPG\"],\"image\":[\"https://cdn.utopian.io/posts/5bb306e29a67c7e7102e48249be2cf96055bstep_1.JPG\",\"https://cdn.utopian.io/posts/3313048b0631bcd2047b62947bcda72f8b49step_2.jpg\",\"https://cdn.utopian.io/posts/a688e20c4c3974aba0e7039094aabf469169step_3.JPG\",\"https://cdn.utopian.io/posts/751aa97efb06faa6141fb0b6ca9782bc2649step_4.jpg\",\"https://cdn.utopian.io/posts/f2c364c9c276c87c2175174417649e8768e9step_5.JPG\",\"https://cdn.utopian.io/posts/acd8df752d8768725f595ed50ab52029ede3step_6.JPG\",\"https://cdn.utopian.io/posts/245a912b6ed437dd8c236a93afd155ed3972step_7.JPG\",\"https://cdn.utopian.io/posts/c2618b62240a22cd266157edf1968d4fdf51step_8.JPG\",\"https://cdn.utopian.io/posts/d2b9f150de4b7eadec7968555a6d988ed5b4Untitled.jpg\",\"https://cdn.utopian.io/posts/c707eec560b5b0d51ae42b3bb8fa15079c11step_9.jpg\",\"https://cdn.utopian.io/posts/75bb3103b0083f57b7ed4e09d981b6587bb4step_10.JPG\",\"https://cdn.utopian.io/posts/45134b6c8e42c521ce94b6749f5767c47f0estep_15.JPG\",\"https://cdn.utopian.io/posts/1ce9c0a9ab72ff32a94040c94691f402d794step_16.JPG\",\"https://cdn.utopian.io/posts/909d501a3eb7c5fe9ccf7a63b8668e6e5dc6step_17.jpg\",\"https://cdn.utopian.io/posts/9c4b1b4c411287ec57423f31717acd52995dstep_18.JPG\",\"https://cdn.utopian.io/posts/092fe7b18c87b2306bb84112f288326a1403step_19.JPG\",\"https://cdn.utopian.io/posts/aa61534c1532288c46c434b80b8f270d6d2estep_20.JPG\",\"https://cdn.utopian.io/posts/f1c94017e1405abbe13d42a91e8b38ec1c1cfinish.JPG\"]}",
      "parent_author": "",
      "parent_permlink": "utopian-io",
      "permlink": "c-inserting-data-from-a-windows-form-application-into-ms-access-database-using-vs2013-step-by-step",
      "title": "C# INSERTING DATA FROM A WINDOWS FORM APPLICATION INTO MS ACCESS DATABASE USING VS2013 STEP BY STEP"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-30T07:32:15",
  "trx_id": "192b5070a505adda4ec21cea9a6249684f2e9816",
  "trx_in_block": 27,
  "virtual_op": 0
}
roxy19received 0.109 SBD, 0.051 SP author reward for @roxy19 / hello-everyone
2018/03/10 11:23:21
authorroxy19
permlinkhello-everyone
sbd payout0.109 SBD
steem payout0.000 STEEM
vesting payout83.723386 VESTS
Transaction InfoBlock #20551622/Virtual Operation #10
View Raw JSON Data
{
  "block": 20551622,
  "op": [
    "author_reward",
    {
      "author": "roxy19",
      "permlink": "hello-everyone",
      "sbd_payout": "0.109 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "83.723386 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-10T11:23:21",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 10
}
roxy19updated their account properties
2018/03/04 06:49:21
accountroxy19
json metadata{"profile":{"cover_image":"","profile_image":"https://img.esteem.ws/ig3e385504.jpg"}}
memo keySTM6HPNcMb1MNkFfDwm8XEAqh3wYwTdwh8uZU2nF8aajVZC9yjPAr
posting{"account_auths":[["utopian.app",1]],"key_auths":[["STM7pitPpw1MtbU4WYHF94vWSjypbmojmvJRNFMTHrVGhXuebPUCH",1]],"weight_threshold":1}
Transaction InfoBlock #20373568/Trx c38d4d97db211e6f7d05851927ca33a73f109754
View Raw JSON Data
{
  "block": 20373568,
  "op": [
    "account_update",
    {
      "account": "roxy19",
      "json_metadata": "{\"profile\":{\"cover_image\":\"\",\"profile_image\":\"https://img.esteem.ws/ig3e385504.jpg\"}}",
      "memo_key": "STM6HPNcMb1MNkFfDwm8XEAqh3wYwTdwh8uZU2nF8aajVZC9yjPAr",
      "posting": {
        "account_auths": [
          [
            "utopian.app",
            1
          ]
        ],
        "key_auths": [
          [
            "STM7pitPpw1MtbU4WYHF94vWSjypbmojmvJRNFMTHrVGhXuebPUCH",
            1
          ]
        ],
        "weight_threshold": 1
      }
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-04T06:49:21",
  "trx_id": "c38d4d97db211e6f7d05851927ca33a73f109754",
  "trx_in_block": 21,
  "virtual_op": 0
}
2018/03/03 20:41:39
authorroxy19
bodynice idea
json metadata{"tags":["dlive"],"app":"steemit/0.1"}
parent authorjerrybanfield
parent permlink553d2432-1f0a-11e8-8d9c-0242ac110002
permlinkre-jerrybanfield-553d2432-1f0a-11e8-8d9c-0242ac110002-20180303t204921177z
title
Transaction InfoBlock #20361419/Trx 1ab407ac45e5510eb2ad3a15b5a655cc7749e752
View Raw JSON Data
{
  "block": 20361419,
  "op": [
    "comment",
    {
      "author": "roxy19",
      "body": "nice idea",
      "json_metadata": "{\"tags\":[\"dlive\"],\"app\":\"steemit/0.1\"}",
      "parent_author": "jerrybanfield",
      "parent_permlink": "553d2432-1f0a-11e8-8d9c-0242ac110002",
      "permlink": "re-jerrybanfield-553d2432-1f0a-11e8-8d9c-0242ac110002-20180303t204921177z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-03T20:41:39",
  "trx_id": "1ab407ac45e5510eb2ad3a15b5a655cc7749e752",
  "trx_in_block": 46,
  "virtual_op": 0
}
2018/03/03 19:22:12
authorwelcome-to-steem
bodyWelcome to steemit! I am a bot built for the purposes of welcoming new users! You are receiving this message as you have used the #introduceyourself tag! I know that steemit may seem very overwhelming to you right now but don't worry. There's a learning curve to everything so just be patient and you'll be churning out posts and becoming a part of something great in no time! Also if there are any questions that you may have, then just ask your questions on any of my blog posts and I'll be more than happy to assist you with whatever questions you may have! I will also be creating a basic starting out guide for all minnows and newcomers on my blog so do give it a read as that might help answer many of your questions! Have fun and I wish you LOADS of success on here! :) Also. you can call upon originalworks whenever something you post is your own content like this: @originalworks Regards @welcome-to-steem
json metadata{"tags":["introduceyourself"],"users":["originalworks","welcome-to-steem"],"app":"steemit/0.1"}
parent authorroxy19
parent permlinkhello-everyone
permlinkre-roxy19-hello-everyone-20180303t192213857z
title
Transaction InfoBlock #20359830/Trx 7cd552d655e534c5223052224e664963e9b97052
View Raw JSON Data
{
  "block": 20359830,
  "op": [
    "comment",
    {
      "author": "welcome-to-steem",
      "body": "Welcome to steemit!\nI am a bot built for the purposes of welcoming new users! You are receiving this message as you have used the #introduceyourself tag! I know that steemit may seem very overwhelming to you right now but don't worry. There's a learning curve to everything so just be patient and you'll be churning out posts and becoming a part of something great in no time!\n\nAlso if there are any questions that you may have, then just ask your questions on any of my blog posts and I'll be more than happy to assist you with whatever questions you may have! I will also be creating a basic starting out guide for all minnows and newcomers on my blog so do give it a read as that might help answer many of your questions!\n\nHave fun and I wish you LOADS of success on here! :)\n\nAlso. you can call upon originalworks whenever something you post is your own content like this: @originalworks\n\nRegards\n@welcome-to-steem",
      "json_metadata": "{\"tags\":[\"introduceyourself\"],\"users\":[\"originalworks\",\"welcome-to-steem\"],\"app\":\"steemit/0.1\"}",
      "parent_author": "roxy19",
      "parent_permlink": "hello-everyone",
      "permlink": "re-roxy19-hello-everyone-20180303t192213857z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-03T19:22:12",
  "trx_id": "7cd552d655e534c5223052224e664963e9b97052",
  "trx_in_block": 44,
  "virtual_op": 0
}
2018/03/03 12:38:27
idfollow
json["follow",{"follower":"roxy19","following":"yougotresteemed","what":["blog"]}]
required auths[]
required posting auths["roxy19"]
Transaction InfoBlock #20351755/Trx a068a0e1b6e7f0e84ed1aff2eeff870f74a4ae07
View Raw JSON Data
{
  "block": 20351755,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"roxy19\",\"following\":\"yougotresteemed\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "roxy19"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-03T12:38:27",
  "trx_id": "a068a0e1b6e7f0e84ed1aff2eeff870f74a4ae07",
  "trx_in_block": 39,
  "virtual_op": 0
}
2018/03/03 12:38:21
idfollow
json["follow",{"follower":"roxy19","following":"yougotresteemed","what":["blog"]}]
required auths[]
required posting auths["roxy19"]
Transaction InfoBlock #20351753/Trx efa82a97d702aa3eb76565f51c84605958467d08
View Raw JSON Data
{
  "block": 20351753,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"roxy19\",\"following\":\"yougotresteemed\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "roxy19"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-03T12:38:21",
  "trx_id": "efa82a97d702aa3eb76565f51c84605958467d08",
  "trx_in_block": 27,
  "virtual_op": 0
}
2018/03/03 12:37:36
idfollow
json["follow",{"follower":"roxy19","following":"yougotresteemed","what":[]}]
required auths[]
required posting auths["roxy19"]
Transaction InfoBlock #20351738/Trx 11ee252b855f269fea488bed6d6742a377f53539
View Raw JSON Data
{
  "block": 20351738,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"roxy19\",\"following\":\"yougotresteemed\",\"what\":[]}]",
      "required_auths": [],
      "required_posting_auths": [
        "roxy19"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-03T12:37:36",
  "trx_id": "11ee252b855f269fea488bed6d6742a377f53539",
  "trx_in_block": 34,
  "virtual_op": 0
}
2018/03/03 12:36:09
idfollow
json["follow",{"follower":"roxy19","following":"yougotresteemed","what":["blog"]}]
required auths[]
required posting auths["roxy19"]
Transaction InfoBlock #20351709/Trx 33a776574cd0efc30b531dc33ede6f55723c9484
View Raw JSON Data
{
  "block": 20351709,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"roxy19\",\"following\":\"yougotresteemed\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "roxy19"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-03T12:36:09",
  "trx_id": "33a776574cd0efc30b531dc33ede6f55723c9484",
  "trx_in_block": 26,
  "virtual_op": 0
}
2018/03/03 12:36:03
idfollow
json["follow",{"follower":"roxy19","following":"yougotresteemed","what":["blog"]}]
required auths[]
required posting auths["roxy19"]
Transaction InfoBlock #20351707/Trx ef678c3427aa0454b879f61e9d73ab8e03205269
View Raw JSON Data
{
  "block": 20351707,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"roxy19\",\"following\":\"yougotresteemed\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "roxy19"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-03T12:36:03",
  "trx_id": "ef678c3427aa0454b879f61e9d73ab8e03205269",
  "trx_in_block": 99,
  "virtual_op": 0
}
2018/03/03 12:32:42
authorroxy19
permlinkre-skyme-re-roxy19-hello-everyone-20180303t114239921z
voterroxy19
weight10000 (100.00%)
Transaction InfoBlock #20351640/Trx 415cc7df6d96919f77798d738773582430787c9b
View Raw JSON Data
{
  "block": 20351640,
  "op": [
    "vote",
    {
      "author": "roxy19",
      "permlink": "re-skyme-re-roxy19-hello-everyone-20180303t114239921z",
      "voter": "roxy19",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-03T12:32:42",
  "trx_id": "415cc7df6d96919f77798d738773582430787c9b",
  "trx_in_block": 25,
  "virtual_op": 0
}
roxy19updated their account properties
2018/03/03 12:23:54
accountroxy19
json metadata{"profile":{"cover_image":"","profile_image":"https://img.esteem.ws/ig3e385504.jpg"}}
memo keySTM6HPNcMb1MNkFfDwm8XEAqh3wYwTdwh8uZU2nF8aajVZC9yjPAr
Transaction InfoBlock #20351464/Trx 4ab0e2e0d6bbff0faf8ee5086ef3fc7872be19d5
View Raw JSON Data
{
  "block": 20351464,
  "op": [
    "account_update",
    {
      "account": "roxy19",
      "json_metadata": "{\"profile\":{\"cover_image\":\"\",\"profile_image\":\"https://img.esteem.ws/ig3e385504.jpg\"}}",
      "memo_key": "STM6HPNcMb1MNkFfDwm8XEAqh3wYwTdwh8uZU2nF8aajVZC9yjPAr"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-03T12:23:54",
  "trx_id": "4ab0e2e0d6bbff0faf8ee5086ef3fc7872be19d5",
  "trx_in_block": 17,
  "virtual_op": 0
}
jasulyupvoted (100.00%) @roxy19 / hello-everyone
2018/03/03 12:12:00
authorroxy19
permlinkhello-everyone
voterjasuly
weight10000 (100.00%)
Transaction InfoBlock #20351226/Trx 786d81f0a01928861d2c5f3073bd05dc8e586b23
View Raw JSON Data
{
  "block": 20351226,
  "op": [
    "vote",
    {
      "author": "roxy19",
      "permlink": "hello-everyone",
      "voter": "jasuly",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-03T12:12:00",
  "trx_id": "786d81f0a01928861d2c5f3073bd05dc8e586b23",
  "trx_in_block": 1,
  "virtual_op": 0
}
hr1upvoted (0.02%) @roxy19 / hello-everyone
2018/03/03 11:53:18
authorroxy19
permlinkhello-everyone
voterhr1
weight2 (0.02%)
Transaction InfoBlock #20350852/Trx bf80252f0ee08c067c66acfa65b0c2d14b76fa09
View Raw JSON Data
{
  "block": 20350852,
  "op": [
    "vote",
    {
      "author": "roxy19",
      "permlink": "hello-everyone",
      "voter": "hr1",
      "weight": 2
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-03T11:53:18",
  "trx_id": "bf80252f0ee08c067c66acfa65b0c2d14b76fa09",
  "trx_in_block": 30,
  "virtual_op": 0
}
2018/03/03 11:42:54
authorjonathanxvi
permlinkre-roxy19-hello-everyone-20180303t120831881z
voterroxy19
weight10000 (100.00%)
Transaction InfoBlock #20350644/Trx fecfc9bd18bb125333266959b1f9aa198549636c
View Raw JSON Data
{
  "block": 20350644,
  "op": [
    "vote",
    {
      "author": "jonathanxvi",
      "permlink": "re-roxy19-hello-everyone-20180303t120831881z",
      "voter": "roxy19",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-03T11:42:54",
  "trx_id": "fecfc9bd18bb125333266959b1f9aa198549636c",
  "trx_in_block": 53,
  "virtual_op": 0
}
2018/03/03 11:42:39
authorroxy19
bodyThanks!
json metadata{"tags":["introduceyourself"],"app":"steemit/0.1"}
parent authorskyme
parent permlinkre-roxy19-hello-everyone-20180303t112603668z
permlinkre-skyme-re-roxy19-hello-everyone-20180303t114239921z
title
Transaction InfoBlock #20350639/Trx fd50cd08ca2c19869bfdbac62b86e818b1d505dc
View Raw JSON Data
{
  "block": 20350639,
  "op": [
    "comment",
    {
      "author": "roxy19",
      "body": "Thanks!",
      "json_metadata": "{\"tags\":[\"introduceyourself\"],\"app\":\"steemit/0.1\"}",
      "parent_author": "skyme",
      "parent_permlink": "re-roxy19-hello-everyone-20180303t112603668z",
      "permlink": "re-skyme-re-roxy19-hello-everyone-20180303t114239921z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-03T11:42:39",
  "trx_id": "fd50cd08ca2c19869bfdbac62b86e818b1d505dc",
  "trx_in_block": 74,
  "virtual_op": 0
}
2018/03/03 11:40:39
idfollow
json["follow",{"follower":"roxy19","following":"karachi","what":["blog"]}]
required auths[]
required posting auths["roxy19"]
Transaction InfoBlock #20350599/Trx 931165b9cc0aa99d03b75780a29ab6a86da85807
View Raw JSON Data
{
  "block": 20350599,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"roxy19\",\"following\":\"karachi\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "roxy19"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-03T11:40:39",
  "trx_id": "931165b9cc0aa99d03b75780a29ab6a86da85807",
  "trx_in_block": 32,
  "virtual_op": 0
}
2018/03/03 11:39:54
authorroxy19
permlinkhello-everyone
voterjonathanxvi
weight2000 (20.00%)
Transaction InfoBlock #20350584/Trx 3c00da609bf50818ab2bb595ec0a192b65eaebf6
View Raw JSON Data
{
  "block": 20350584,
  "op": [
    "vote",
    {
      "author": "roxy19",
      "permlink": "hello-everyone",
      "voter": "jonathanxvi",
      "weight": 2000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-03T11:39:54",
  "trx_id": "3c00da609bf50818ab2bb595ec0a192b65eaebf6",
  "trx_in_block": 3,
  "virtual_op": 0
}
roxy19followed @phreq
2018/03/03 11:39:18
idfollow
json["follow",{"follower":"roxy19","following":"phreq","what":["blog"]}]
required auths[]
required posting auths["roxy19"]
Transaction InfoBlock #20350572/Trx 5c2817fd0a1c45b855fdfabc690416781cc1db4b
View Raw JSON Data
{
  "block": 20350572,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"roxy19\",\"following\":\"phreq\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "roxy19"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-03T11:39:18",
  "trx_id": "5c2817fd0a1c45b855fdfabc690416781cc1db4b",
  "trx_in_block": 0,
  "virtual_op": 0
}
2018/03/03 11:39:06
authorjonathanxvi
bodywelcome to steemit @roxy19 upvote :)
json metadata{"tags":["introduceyourself"],"users":["roxy19"],"app":"steemit/0.1"}
parent authorroxy19
parent permlinkhello-everyone
permlinkre-roxy19-hello-everyone-20180303t120831881z
title
Transaction InfoBlock #20350568/Trx 29d5e6496c51fe44f171a7b321ffe5b511830c49
View Raw JSON Data
{
  "block": 20350568,
  "op": [
    "comment",
    {
      "author": "jonathanxvi",
      "body": "welcome to steemit @roxy19 upvote :)",
      "json_metadata": "{\"tags\":[\"introduceyourself\"],\"users\":[\"roxy19\"],\"app\":\"steemit/0.1\"}",
      "parent_author": "roxy19",
      "parent_permlink": "hello-everyone",
      "permlink": "re-roxy19-hello-everyone-20180303t120831881z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-03T11:39:06",
  "trx_id": "29d5e6496c51fe44f171a7b321ffe5b511830c49",
  "trx_in_block": 13,
  "virtual_op": 0
}
2018/03/03 11:36:39
authorstewsak
bodyHello and welcome to Steemit. I'm Steward, but everyone calls me Stew and it's a pleasure to meet you. You'll find the Steemit community is very warm and welcoming and here's a post to help answer some of your questions: [The Ultra Beginner's Guide to Steemit- What to do 1st](https://steemit.com/introduceyourself/@stewsak/the-ultra-beginner-s-guide-to-steemit-what-to-do-1st) Also, if you'd like to know more about me: [My Steemit Intro](https://steemit.com/introduceyourself/@stewsak/dear-steemit-community-re-introduction-so-please-give-me-a-2nd-chance-to-make-a-great-1st-impression) I look forward to reading your posts, pleasure meeting you and hope you stay in touch. Welcome to Steemit! [![follow stewsak!](https://img1.steemit.com/0x0/https://i.imgsafe.org/b87bb98157.gif)](https://steemit.com/@stewsak)
json metadata{"tags":["introduceyourself"],"image":["https://img1.steemit.com/0x0/https://i.imgsafe.org/b87bb98157.gif"],"links":["https://steemit.com/introduceyourself/@stewsak/the-ultra-beginner-s-guide-to-steemit-what-to-do-1st","https://steemit.com/introduceyourself/@stewsak/dear-steemit-community-re-introduction-so-please-give-me-a-2nd-chance-to-make-a-great-1st-impression","https://steemit.com/@stewsak"],"app":"steemit/0.1"}
parent authorroxy19
parent permlinkhello-everyone
permlinkre-roxy19-hello-everyone-20180303t113638828z
title
Transaction InfoBlock #20350519/Trx ca3125695819e13c5a51ccbdbab927c3a9dd1aeb
View Raw JSON Data
{
  "block": 20350519,
  "op": [
    "comment",
    {
      "author": "stewsak",
      "body": "Hello and welcome to Steemit.  I'm Steward, but everyone calls me Stew and it's a pleasure to meet you.  You'll find the Steemit community is very warm and welcoming and here's a post to help answer some of your questions:\n\n[The Ultra Beginner's Guide to Steemit- What to do 1st](https://steemit.com/introduceyourself/@stewsak/the-ultra-beginner-s-guide-to-steemit-what-to-do-1st)\n\nAlso, if you'd like to know more about me:  [My Steemit Intro](https://steemit.com/introduceyourself/@stewsak/dear-steemit-community-re-introduction-so-please-give-me-a-2nd-chance-to-make-a-great-1st-impression)\nI look forward to reading your posts, pleasure meeting you and hope you stay in touch.  Welcome to Steemit!  \n[![follow stewsak!](https://img1.steemit.com/0x0/https://i.imgsafe.org/b87bb98157.gif)](https://steemit.com/@stewsak)",
      "json_metadata": "{\"tags\":[\"introduceyourself\"],\"image\":[\"https://img1.steemit.com/0x0/https://i.imgsafe.org/b87bb98157.gif\"],\"links\":[\"https://steemit.com/introduceyourself/@stewsak/the-ultra-beginner-s-guide-to-steemit-what-to-do-1st\",\"https://steemit.com/introduceyourself/@stewsak/dear-steemit-community-re-introduction-so-please-give-me-a-2nd-chance-to-make-a-great-1st-impression\",\"https://steemit.com/@stewsak\"],\"app\":\"steemit/0.1\"}",
      "parent_author": "roxy19",
      "parent_permlink": "hello-everyone",
      "permlink": "re-roxy19-hello-everyone-20180303t113638828z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-03T11:36:39",
  "trx_id": "ca3125695819e13c5a51ccbdbab927c3a9dd1aeb",
  "trx_in_block": 38,
  "virtual_op": 0
}
karachiupvoted (100.00%) @roxy19 / hello-everyone
2018/03/03 11:28:39
authorroxy19
permlinkhello-everyone
voterkarachi
weight10000 (100.00%)
Transaction InfoBlock #20350359/Trx 158574de0b39a4eef2a22d1caacc9d307c020878
View Raw JSON Data
{
  "block": 20350359,
  "op": [
    "vote",
    {
      "author": "roxy19",
      "permlink": "hello-everyone",
      "voter": "karachi",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-03T11:28:39",
  "trx_id": "158574de0b39a4eef2a22d1caacc9d307c020878",
  "trx_in_block": 44,
  "virtual_op": 0
}
2018/03/03 11:28:36
authorkarachi
bodyWelcome to Steem..... There u go with 1st Upvote. Do Follow Me for More Upvotes.
json metadata{"tags":["introduceyourself"],"app":"steemit/0.1"}
parent authorroxy19
parent permlinkhello-everyone
permlinkre-roxy19-hello-everyone-20180303t112846861z
title
Transaction InfoBlock #20350358/Trx 51ca088712c9fd8f8b6101431a85fdf2eddaeb71
View Raw JSON Data
{
  "block": 20350358,
  "op": [
    "comment",
    {
      "author": "karachi",
      "body": "Welcome to Steem.....  There u go with 1st Upvote. \nDo Follow Me for More Upvotes.",
      "json_metadata": "{\"tags\":[\"introduceyourself\"],\"app\":\"steemit/0.1\"}",
      "parent_author": "roxy19",
      "parent_permlink": "hello-everyone",
      "permlink": "re-roxy19-hello-everyone-20180303t112846861z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-03T11:28:36",
  "trx_id": "51ca088712c9fd8f8b6101431a85fdf2eddaeb71",
  "trx_in_block": 58,
  "virtual_op": 0
}
2018/03/03 11:26:06
authorskyme
bodywelcome to steemit. I hope you will have good achievements on the steemit platform. Good Luck!!
json metadata{"tags":["introduceyourself"],"community":"busy","app":"busy/2.4.0"}
parent authorroxy19
parent permlinkhello-everyone
permlinkre-roxy19-hello-everyone-20180303t112603668z
title
Transaction InfoBlock #20350308/Trx c3144e807443e76c94ed4b5affa377aa3faca291
View Raw JSON Data
{
  "block": 20350308,
  "op": [
    "comment",
    {
      "author": "skyme",
      "body": "welcome to steemit. I hope you will have good achievements on the steemit platform. Good Luck!!",
      "json_metadata": "{\"tags\":[\"introduceyourself\"],\"community\":\"busy\",\"app\":\"busy/2.4.0\"}",
      "parent_author": "roxy19",
      "parent_permlink": "hello-everyone",
      "permlink": "re-roxy19-hello-everyone-20180303t112603668z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-03T11:26:06",
  "trx_id": "c3144e807443e76c94ed4b5affa377aa3faca291",
  "trx_in_block": 17,
  "virtual_op": 0
}
ximetaupvoted (100.00%) @roxy19 / hello-everyone
2018/03/03 11:24:00
authorroxy19
permlinkhello-everyone
voterximeta
weight10000 (100.00%)
Transaction InfoBlock #20350266/Trx 4f2b1daefc0a276d6783aa374a506887f6f3c3c1
View Raw JSON Data
{
  "block": 20350266,
  "op": [
    "vote",
    {
      "author": "roxy19",
      "permlink": "hello-everyone",
      "voter": "ximeta",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-03T11:24:00",
  "trx_id": "4f2b1daefc0a276d6783aa374a506887f6f3c3c1",
  "trx_in_block": 55,
  "virtual_op": 0
}
roxy19published a new post: hello-everyone
2018/03/03 11:23:21
authorroxy19
body![16649458_1545001958846527_3552374172710227284_n.jpg](https://steemitimages.com/DQmVEQ7V1njsrgcFhjuTm4n1cZGhpHLRda8JbvwEgZ4D9hc/16649458_1545001958846527_3552374172710227284_n.jpg) Hello steemit community! This is my first time in this community and I am very excited of what are those experiences will I gain in this social platform. I'm Roxan M. Icoy, I live in Philippines, Cebu. I'm 23 years old. Nature is my habitat because it gives shine in my life every morning I wake up. I am living in a peaceful place with the scent of nature. I am also here to share everyone a great posts, articles and stories. I know there are lot of amazing people here. I hope this community will help me to develop my personal characteristics. It's the beginning feel free to comment.
json metadata{"tags":["introduceyourself","steemgigs","steemph","life","philippines"],"image":["https://steemitimages.com/DQmVEQ7V1njsrgcFhjuTm4n1cZGhpHLRda8JbvwEgZ4D9hc/16649458_1545001958846527_3552374172710227284_n.jpg"],"app":"steemit/0.1","format":"markdown"}
parent author
parent permlinkintroduceyourself
permlinkhello-everyone
titleHello everyone!
Transaction InfoBlock #20350253/Trx 16a87f399576b9cc212a55b3b9b2410470137e03
View Raw JSON Data
{
  "block": 20350253,
  "op": [
    "comment",
    {
      "author": "roxy19",
      "body": "![16649458_1545001958846527_3552374172710227284_n.jpg](https://steemitimages.com/DQmVEQ7V1njsrgcFhjuTm4n1cZGhpHLRda8JbvwEgZ4D9hc/16649458_1545001958846527_3552374172710227284_n.jpg)\n\nHello steemit community! This is my first time in this community and I am very excited of what are those experiences will I gain in this social platform.\n\nI'm Roxan M. Icoy, I live in Philippines, Cebu. I'm 23 years old. Nature is my habitat because it gives shine in my life every morning I wake up. I am living in a peaceful place with the scent of nature. I am also here to share everyone a great posts, articles and stories. I know there are lot of amazing people here. I hope this community will help me to develop my personal characteristics.\n\nIt's the beginning feel free to comment.",
      "json_metadata": "{\"tags\":[\"introduceyourself\",\"steemgigs\",\"steemph\",\"life\",\"philippines\"],\"image\":[\"https://steemitimages.com/DQmVEQ7V1njsrgcFhjuTm4n1cZGhpHLRda8JbvwEgZ4D9hc/16649458_1545001958846527_3552374172710227284_n.jpg\"],\"app\":\"steemit/0.1\",\"format\":\"markdown\"}",
      "parent_author": "",
      "parent_permlink": "introduceyourself",
      "permlink": "hello-everyone",
      "title": "Hello everyone!"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-03T11:23:21",
  "trx_id": "16a87f399576b9cc212a55b3b9b2410470137e03",
  "trx_in_block": 43,
  "virtual_op": 0
}
2018/03/03 10:21:30
idfollow
json["follow",{"follower":"roxy19","following":"cryptoriddler","what":["blog"]}]
required auths[]
required posting auths["roxy19"]
Transaction InfoBlock #20349016/Trx 60d369079cd448be3ee485c7bbd98ce311e90e0b
View Raw JSON Data
{
  "block": 20349016,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"roxy19\",\"following\":\"cryptoriddler\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "roxy19"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-03T10:21:30",
  "trx_id": "60d369079cd448be3ee485c7bbd98ce311e90e0b",
  "trx_in_block": 25,
  "virtual_op": 0
}
steemdelegated 18.716 SP to @roxy19
2018/03/02 16:23:09
delegateeroxy19
delegatorsteem
vesting shares30438.632814 VESTS
Transaction InfoBlock #20327456/Trx 2d213c03e0591e7d21a4b47a1b45d5049d29d2a0
View Raw JSON Data
{
  "block": 20327456,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "roxy19",
      "delegator": "steem",
      "vesting_shares": "30438.632814 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-02T16:23:09",
  "trx_id": "2d213c03e0591e7d21a4b47a1b45d5049d29d2a0",
  "trx_in_block": 34,
  "virtual_op": 0
}
steemcreated a new account: @roxy19
2018/03/02 15:02:33
active{"account_auths":[],"key_auths":[["STM7outcY3dBjhR1KfZitgXPnugjRhCAbtjqAqsMgJCqLTsTLpPmo",1]],"weight_threshold":1}
creatorsteem
delegation30690.000000 VESTS
extensions[]
fee0.100 STEEM
json metadata{}
memo keySTM6HPNcMb1MNkFfDwm8XEAqh3wYwTdwh8uZU2nF8aajVZC9yjPAr
new account nameroxy19
owner{"account_auths":[],"key_auths":[["STM8jQJVBnqh49LqzQbr476wcJPKUAUREqdHKFXiJ5gk7fwtWUVWj",1]],"weight_threshold":1}
posting{"account_auths":[],"key_auths":[["STM7pitPpw1MtbU4WYHF94vWSjypbmojmvJRNFMTHrVGhXuebPUCH",1]],"weight_threshold":1}
Transaction InfoBlock #20325844/Trx dd29616775a1464ba76ee040f5d23673074925af
View Raw JSON Data
{
  "block": 20325844,
  "op": [
    "account_create_with_delegation",
    {
      "active": {
        "account_auths": [],
        "key_auths": [
          [
            "STM7outcY3dBjhR1KfZitgXPnugjRhCAbtjqAqsMgJCqLTsTLpPmo",
            1
          ]
        ],
        "weight_threshold": 1
      },
      "creator": "steem",
      "delegation": "30690.000000 VESTS",
      "extensions": [],
      "fee": "0.100 STEEM",
      "json_metadata": "{}",
      "memo_key": "STM6HPNcMb1MNkFfDwm8XEAqh3wYwTdwh8uZU2nF8aajVZC9yjPAr",
      "new_account_name": "roxy19",
      "owner": {
        "account_auths": [],
        "key_auths": [
          [
            "STM8jQJVBnqh49LqzQbr476wcJPKUAUREqdHKFXiJ5gk7fwtWUVWj",
            1
          ]
        ],
        "weight_threshold": 1
      },
      "posting": {
        "account_auths": [],
        "key_auths": [
          [
            "STM7pitPpw1MtbU4WYHF94vWSjypbmojmvJRNFMTHrVGhXuebPUCH",
            1
          ]
        ],
        "weight_threshold": 1
      }
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-03-02T15:02:33",
  "trx_id": "dd29616775a1464ba76ee040f5d23673074925af",
  "trx_in_block": 49,
  "virtual_op": 0
}

Account Metadata

POSTING JSON METADATA
profile{"cover_image":"","profile_image":"https://img.esteem.ws/ig3e385504.jpg"}
JSON METADATA
profile{"cover_image":"","profile_image":"https://img.esteem.ws/ig3e385504.jpg"}
{
  "posting_json_metadata": {
    "profile": {
      "cover_image": "",
      "profile_image": "https://img.esteem.ws/ig3e385504.jpg"
    }
  },
  "json_metadata": {
    "profile": {
      "cover_image": "",
      "profile_image": "https://img.esteem.ws/ig3e385504.jpg"
    }
  }
}

Auth Keys

Owner
Single Signature
Public Keys
STM8jQJVBnqh49LqzQbr476wcJPKUAUREqdHKFXiJ5gk7fwtWUVWj1/1
Active
Single Signature
Public Keys
STM7outcY3dBjhR1KfZitgXPnugjRhCAbtjqAqsMgJCqLTsTLpPmo1/1
Posting
Single Signature
Public Keys
STM7pitPpw1MtbU4WYHF94vWSjypbmojmvJRNFMTHrVGhXuebPUCH1/1
App Permissions
Memo
STM6HPNcMb1MNkFfDwm8XEAqh3wYwTdwh8uZU2nF8aajVZC9yjPAr
{
  "owner": {
    "account_auths": [],
    "key_auths": [
      [
        "STM8jQJVBnqh49LqzQbr476wcJPKUAUREqdHKFXiJ5gk7fwtWUVWj",
        1
      ]
    ],
    "weight_threshold": 1
  },
  "active": {
    "account_auths": [],
    "key_auths": [
      [
        "STM7outcY3dBjhR1KfZitgXPnugjRhCAbtjqAqsMgJCqLTsTLpPmo",
        1
      ]
    ],
    "weight_threshold": 1
  },
  "posting": {
    "account_auths": [
      [
        "utopian.app",
        1
      ]
    ],
    "key_auths": [
      [
        "STM7pitPpw1MtbU4WYHF94vWSjypbmojmvJRNFMTHrVGhXuebPUCH",
        1
      ]
    ],
    "weight_threshold": 1
  },
  "memo": "STM6HPNcMb1MNkFfDwm8XEAqh3wYwTdwh8uZU2nF8aajVZC9yjPAr"
}

Witness Votes

0 / 30
No active witness votes.
[]