I've created a C# Windows form application in Visual stuidos it allows the user to enter information, save that information to a database, then show that information in a datagridview. Everything works fine but the datgridview. It shows that rows have been added but not the text. I can see in my database the reports that have been added so I know its alteast saving the information. I don't know what I'm doing wrong. Please help!
My code:
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.SqlClient;
using System.Globalization;
namespace Reports
{
public partial class ReportsForm : Form
{
public ReportsForm()
{
InitializeComponent();
}
SqlConnection con = new SqlConnection("Data Source=Blu;Initial
Catalog=Reports;Integrated Security=True");
SqlCommand cmd;
private void Submitbtn_Click(object sender, EventArgs e)
{
String query = ("INSERT INTO Reports_tbl (EntryDate, ReportText)
VALUES ('" + DateTime.Now + "','" + ReportsrichTextBox.Text +
"')");
con.Open();
cmd = new SqlCommand(query, con);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Report Successfully Added");
ReportsrichTextBox.Text = "";
}
private void Form1_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=Blu;Initial Catalog=Reports;Integrated Security=True");
con.Open();
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Reports_tbl", con);
DataSet ds = new DataSet();
da.Fill(ds,"Reports_tbl");
ReportsdataGridView.DataSource =
ds.Tables["Reports_tbl"].DefaultView;
con.Close();
}
}
}
In: Computer Science
Justin Stone was an employee of DataCare Services, Inc. His salary was $45,000 through November 10, 2018, when he was laid off. DataCare Services provided medical insurance for Justin and his family during his employment and agreed to continue this coverage through the end of 2018. He received $7,000 of unemployment compensation from November 11, 2018, through December 31, 2018. FICA withholdings were as follows: Social Security of $2,790 ($45,000 x 6.2%) and Medicare of $653 ($45,000 x 1.45%). Justin lives at 112 Green Road, Crown City, OH 45623. His Social Security number is 111-11-1112.
Justin owned an apartment building until November 22, 2018 when he sold it for $200,000 (the apartment building's address is 4826 Orange Street, Crown City, OH 45623). For 2018, he had rent revenue of $33,000. He incurred and paid expenses as follows: $4,568 of repairs, $12,000 of mortgage interest, $10,000 of real estate taxes, and $1,000 of miscellaneous expenses. He purchased the building on January 2, 2012, for $125,000. The building generated an operating profit each year that Justin owned it. Justin received $13,000 in cash as a gift from his mother to help “tide him over” while he was unemployed. He also withdrew $10,000 from his checking account. He “invested” $300 in lottery tickets during the year but had no winnings.
Other information follows:
Required:
Compute Justin's 2018 net tax payable or refund due by providing
the information requested for Form 1040 and Schedules A, B, D, and
E and Forms 4562, 4797, and 8582.
In: Finance
Vaughn Corporation was formed 5 years ago through a public
subscription of common stock. Daniel Brown, who owns 15% of the
common stock, was one of the organizers of Vaughn and is its
current president. The company has been successful, but it
currently is experiencing a shortage of funds. On June 10, 2018,
Daniel Brown approached the Topeka National Bank, asking for a
24-month extension on two $35,180 notes, which are due on June 30,
2018, and September 30, 2018. Another note of $5,970 is due on
March 31, 2019, but he expects no difficulty in paying this note on
its due date. Brown explained that Vaughn’s cash flow problems are
due primarily to the company’s desire to finance a $299,820 plant
expansion over the next 2 fiscal years through internally generated
funds.
The commercial loan officer of Topeka National Bank requested the
following financial reports for the last 2 fiscal years.
|
VAUGHN CORPORATION |
||||
|---|---|---|---|---|
| Assets |
2018 |
2017 |
||
| Cash | $18,140 | $12,490 | ||
| Notes receivable | 147,030 | 131,070 | ||
| Accounts receivable (net) | 132,730 | 124,830 | ||
| Inventories (at cost) | 104,550 | 49,700 | ||
| Plant & equipment (net of depreciation) | 1,462,750 | 1,417,080 | ||
| Total assets | $1,865,200 | $1,735,170 | ||
| Liabilities and Owners’ Equity | ||||
| Accounts payable | $79,140 | $91,380 | ||
| Notes payable | 75,500 | 61,560 | ||
| Accrued liabilities | 22,780 | 11,570 | ||
| Common stock (130,000 shares, $10 par) | 1,301,670 | 1,288,340 | ||
| Retained earningsa | 386,110 | 282,320 | ||
| Total liabilities and stockholders’ equity | $1,865,200 | $1,735,170 | ||
| aCash dividends were paid at the rate of $1 per share in fiscal year 2017 and $2 per share in fiscal year 2018. | ||||
|
VAUGHN CORPORATION |
||||
|---|---|---|---|---|
|
2018 |
2017 |
|||
| Sales revenue | $3,017,370 | $2,675,520 | ||
| Cost of goods solda | 1,534,450 | 1,434,800 | ||
| Gross margin | 1,482,920 | 1,240,720 | ||
| Operating expenses | 859,730 | 778,290 | ||
| Income before income taxes | 623,190 | 462,430 | ||
| Income taxes (40%) | 249,276 | 184,972 | ||
| Net income | $373,914 | $277,458 | ||
| aDepreciation charges on the plant and equipment of $100,410 and $102,940 for fiscal years ended March 31, 2017 and 2018, respectively, are included in cost of goods sold. | ||||
(a) Compute the following items for Vaughn
Corporation. (Round answer to 2 decimal places, e.g.
2.25 or 2.25%.)
| (1) | Current ratio for fiscal years 2017 and 2018. | |
|---|---|---|
| (2) | Acid-test (quick) ratio for fiscal years 2017 and 2018. | |
| (3) | Inventory turnover for fiscal year 2018. | |
| (4) | Return on assets for fiscal years 2017 and 2018. (Assume total assets were $1,676,750 at 3/31/16.) | |
| (5) | Percentage change in sales, cost of goods sold, gross margin, and net income after taxes from fiscal year 2017 to 2018. |
|
2017 |
2018 |
|||||||
|---|---|---|---|---|---|---|---|---|
| (1) | Current ratio | :1 | :1 | |||||
| (2) | Acid-test (quick) ratio | :1 | :1 | |||||
| (3) | Inventory turnover | times | ||||||
| (4) | Return on assets | % |
|
% | ||||
| (5) |
Percent Changes |
Percent Increase |
|||
|---|---|---|---|---|---|
| Sales revenue | % | ||||
| Cost of goods sold | % | ||||
| Gross margin | % | ||||
| Net income after taxes |
|
% | |||
In: Accounting
The unadjusted trial balance of the Manufacturing Equitable at December 31, 2018, the end of its fiscal year, included the following account balances. Manufacturings 2018 financial statements were issued on April 1, 2019
Accounts receivable $ 95250
Accounts payable 42800
Bank notes payable 601000
Mortgage note payable 1,490,00
Other information
a. The bank notes, issued August 1, 2018, are due on July 31, 2019, and pay interest at a rate of 12%, payable at maturity.
b.The mortgage note is due on March 1, 2019. Interest at 11% has been paid up to December 31 (assume 11% is a realistic rate). Manufacturing intended at December 31, 2018, to refinance the note on its due date with a new 10-year mortgage note. In fact, on March 1, Manufacturing paid $480,000 in cash on the principal balance and refinanced the remaining $1,010,000.
c.Included in the accounts receivable balance at December 31, 2018, were two subsidiary accounts that had been overpaid and had credit balances totaling $19350 The accounts were of two major customers who were expected to order more merchandise from Manufacturing and apply the overpayments to those future purchases.
d.On November 1, 2018, Manufacturing rented a portion of its factory to a tenant for $25200 per year, payable in advance. The payment for the 12 months ended October 31, 2019, was received as required and was credited to rent revenue.
Required:
(1) Prepare any necessary adjusting journal entries at December 31, 2018, pertaining to each item of other information (a–d). (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.) Journal entry worksheet: a. Record the bank notes, issued August 1, 2018, are due on July 31, 2019, and pay interest at a rate of 12%, payable at maturity. b. Record the mortgage note is due on March 1, 2019. Interest at 11% has been paid up to December 31 (assume 11% is a realistic rate). Manufacturing intended at December 31, 2018, to refinance the note on its due date with a new 10-year mortgage note. In fact, on March 1, Manufacturing paid $480,000 c. Record included in the accounts receivable balance at December 31, 2018, were two subsidiary accounts that had been overpaid and had credit balances totaling $19,350. The accounts were of two major customers who were expected to order more merchandise from Manufacturing and apply the overpayments to those future purchases. d. Record on November 1, 2018, Manufacturing rented a portion of its factory to a tenant for $25,200 per year, payable in advance. The payment for the 12 months ended October 31, 2019, was received as required and was credited to rent revenue.
(2) Prepare the current and long-term liability sections of the December 31, 2018, balance sheet.
Balance Sheet (partial)
At December 31, 2018
Current liabilities:
Total current liabilities
Long-term liabilities:
In: Accounting
In: Accounting
1.Describe Economic policy of the Czech Republic and fulfillment of the main goals at present time
3. Describe norminal GDP in the Czech republic in 2018
4. Describe consumption and saving household in the Czech Republic in 2018
In: Economics
Condensed balance sheet and income statement data for Landwehr Corporation appear below.


Additional information:
1. The market price of Landwehr’s common stock was $4.00, $5.00, and $8.00 for 2016, 2017, and 2018, respectively.
2. All dividends were paid in cash.
Instructions
(a) Compute the following ratios for 2017 and 2018.
(1) Profit margin.
(2) Asset turnover.
(3) Earnings per share. (Weighted-average common shares in 2018 were 32,000 and in 2017 were 31,000.)
(4) Price-earnings ratio.
(5) Payout ratio.
(6) Debt to assets ratio.
(b) Based on the ratios calculated, discuss briefly the improvement or lack thereof in financial position and operating results from 2017 to 2018 of Landwehr Corporation.
In: Finance
Explain and illustrate the impacts that the COVID-19 pandemic and horrendous bushfires of 2019/2020 have had on the Australian economy. You will do so by comparing the three main macro-economic indicators –GDP growth, inflation and unemployment – in June 2020 to a point in time prior to the pandemic and bushfires (pre-July 2019), then you will illustrate and explain the impacts using the AD-AS model. Provide references that support your work and submit your slides and a link to your video for marking.
|
Comparison: July 2018 and June 2020 GDP growth: September 2018 (2.6%) June 2020 (-6.3%) Inflation: September 2018 (1.9%) June 2020 (-0.3%) Unemployment rate: July 2018 (5.3%) June 2020 (7.4%) |
In: Economics
Data pertaining to the postretirement health care benefit plan
of Sterling Properties include the following for 2018:
|
($ in 000s) |
|||
|
Service cost |
$ |
146 |
|
|
Accumulated postretirement benefit obligation, January 1 |
1,200 |
||
|
Plan assets (fair value), January 1 |
80 |
||
|
Prior service cost–AOCI |
none |
||
|
Net gain–AOCI (2018 amortization, $1) |
105 |
||
|
Retiree benefits paid (end of year) |
93 |
||
|
Contribution to health care benefit fund (end of year) |
225 |
||
|
Discount rate, 7% |
|||
|
Return on plan assets (actual and expected), 10% |
|||
Required:
1. Determine the postretirement benefit expense
for 2018.
2. Prepare the appropriate journal entries to
record the postretirement benefit expense, funding, and retiree
benefits for 2018.
In: Accounting
3. The following data show the average Home Price Index over asix-quarter period.
Quarter Price
Q1 2017 185.9
Q2 2017 190.1
Q3 2017 196.1
Q4 2017 196.1
Q1 2018 198.3
Q2 2018 203.7
a. Forecast the price index for Q3 2018 using a two-period simple moving average. (Round to two decimal places asneeded.)
b. Calculate the MAD for the forecast in part a. (Round to two decimal places as needed.)
c. Forecast the price index for Q3 2018 using a three-period simple moving average. (Round to two decimal places asneeded.)
d. Calculate the MAD for the forecast in part c. (Round to two decimal places as needed.)
In: Statistics and Probability