Inserting new row of data into C# Windows Form using SQL Server
<p>Thanks to Nate M. I've got this running, using the second part of code, and some schooling in SQL Server (it's my first day)
So it's solved. Thank you everyone for the help.</p>

<p>I can't figure this out. I'm using Visual Studio 2015, SQL Server 2014, that works, but I can't figure out how to insert data on the click of a button. I've tried stuff on MSDN, nothing works, they have about 100 different ways. I'm confused. Here's what I've got.</p>

<pre><code>private void btnTheWorst_Click(object sender, EventArgs e)
{
    lblMood.Text = "The Worst :(";
    lblMood.ForeColor = System.Drawing.Color.Navy;

    SqlConnection cmood = new SqlConnection("my connection string"); {

    cmood.Rows.Add(new Object[] { 1, "Smith" });
}
</code></pre>

<p>This is where I get the error.</p>

<blockquote>
  <p>SqlConnection does not contain a definition for 'Rows' and no extension method 'Rows' accepting a first argument of type 'SqlConnection' could be found.</p>
</blockquote>