I'm this type of newbie to c# I must request questions before I'm able to get began!

What I wish to do is enter a number number right into a text box, send it for an attached sql compact database, determine when the number is incorporated in the table, if true return the information towards the form. If false, I wish to run some code which get the data increase the table, increase table, send towards the form. Other then creating sql tables via C#, Could someone assist me to prototype this idea as they say in order to start reading through on the concepts to ensure that I'm able to begin to build this part of my project? Thanks.

I'd mind to the MS Development for Beginners site, which supports you receive began using the basic principles in addition to lead you onto greater levels.

The Tier 1 lessons will give you through Visual Studio Express, and enable you to get writing an easy application.

The Tier 2 lessons introduce a few of the core concepts underlying Home windows development, including reading through and inhabiting forms.

The Tier 3 lessons then introduce a few of the concepts around hooking up to Databases, including upgrading them.

The Aspiring Professional section then points you in direction of further assets including plenty of training materials.

Have some fun!

You will find a number of ways to complete what you're explaining. A fast and simple way additional scenario is always to use WPF for that interface and LINQ to SQL for that database access. You will find a lot of lessons on technologies, but listed here are the fundamental steps:

Step One: Produce a new WPF project in Visual Studio
Step Two: Give a LINQ to SQL class and map it for your Database
Step Three: Edit the MainWindow.xaml and add the input textbox, check button, and results textbox

Sample code for MainWindow.xaml (note this really is fast and dirty):

<Window x:Class="WPFPlayground.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    Title="MainWindow" Height="350" Width="525">
    <Grid>
        <StackPanel Orientation="Horizontal" Height="30">
            <TextBox Name="InputTextBox" Width="50"/>
            <Button Name="CheckButton" Content="Check DB" Click="CheckButton_Click"/> 
            <TextBox Name="ResultsTextBox" Width="100"/>
        </StackPanel>
    </Grid>
</Window>

Step Four: Edit the code behind of MainWindow.xaml.cs to handle button click event

Sample code for Click event in MainWindow.xaml.cs (again fast and dirty)

private void CheckButton_Click(object sender, RoutedEventArgs e)
{
    // Get instance of my LINQ to SQL datacontext
    var db = new MyDbDataContext();

    // Try to get the record that matches the text in the InputTextBox
    var data = db.TableName.FirstOrDefault(r => r.Id == InputTextBox.Text);

    // Was able to find a matching record so show results data
    if (data != null)
    {
        ResultsTextBox.Text = data.EventDesc;
    }
    else 
    {
        // do what ever you need to do when there is no match
    }
}

Step Five: Learn some guidelines and don't make use of this sample code :)

Have some fun.

I'd focus on fundamental SQL CRUD procedures and ADO.Internet (specially the SqlClient namespace). Individuals are the most crucial concepts for which you are explaining, and those which will go ahead and take most depth of understanding.

The key concepts here will be CRUD procedures, event based development, and merely the .Internet framework generally. That you can do many of these things in Visual Studio 2010 C# Express Edition (free), and you will find many lessons around around the internet. Need something more specific?