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
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
Using Percentage-of-Completion and Completed Contract Methods
Halsey Building Company signed a contract to build an office building for $40,000,000. The scheduled construction costs follow.
| Year | Cost |
|---|---|
| 2016 | $9,000,000 |
| 2017 | 15,000,000 |
| 2018 | 6,000,000 |
| Total | $30,000,000 |
The building is completed in 2018.
For each year, compute the revenue, expense, and gross profit
reported for this construction project using each of the following
methods.
a. Percentage-of-completion method
| 2016 | 2017 | 2018 | |
|---|---|---|---|
| Revenue | Answer | Answer | Answer |
| Expense | Answer | Answer | Answer |
| Gross Profit | Answer | Answer | Answer |
b. Completed contract method
| 2016 | 2017 | 2018 | |
|---|---|---|---|
| Revenue | Answer | Answer | Answer |
| Expense | Answer | Answer | Answer |
| Gross Profit | Answer | Answer | Answer |
In: Accounting
On December 31, 2017, Dow Steel Corporation had 790,000 shares
of common stock and 49,000 shares of 7%, noncumulative,
nonconvertible preferred stock issued and outstanding. Dow issued a
4% common stock dividend on May 15 and paid cash dividends of
$590,000 and $88,000 to common and preferred shareholders,
respectively, on December 15, 2018.
On February 28, 2018, Dow sold 72,000 common shares. In keeping
with its long-term share repurchase plan, 6,000 shares were retired
on July 1. Dow's net income for the year ended December 31, 2018,
was $3,050,000. The income tax rate is 40%.
Required:
Compute Dow's earnings per share for the year ended December 31,
2018
In: Accounting
At the end of 2017, Payne Industries had a deferred tax asset
account with a balance of $30 million attributable to a temporary
book–tax difference of $75 million in a liability for estimated
expenses. At the end of 2018, the temporary difference is $60
million. Payne has no other temporary differences and no valuation
allowance for the deferred tax asset. Taxable income for 2018 is
$235 million and the tax rate is 40%.
Required:
1. Prepare the journal entry(s) to record Payne’s
income taxes for 2018, assuming it is more likely than not that the
deferred tax asset will be realized.
2. Prepare the journal entry(s) to record Payne’s
income taxes for 2018, assuming it is more likely than not that
one-fourth of the deferred tax asset will ultimately be
realized.
In: Accounting