Creating and accessing a database in C #

  • Thread starter Thread starter Roy Gourgi
  • Start date Start date
R

Roy Gourgi

Hi,

I am new to C#.

I am trying to create a database and then to add records to it but to no
avail.
I have tried a lot of online examples but they all do not seem to work!!!!
It is very frustrating because I am used to Visual Foxpro where it is very
easy.

Please do not assume that I know anything so you really have to do all the
coding. :)

TIA
 
Roy said:
I am new to C#.

I am trying to create a database and then to add records to it but to no
avail.
I have tried a lot of online examples but they all do not seem to work!!!!
Click to expand...

What database software are you using ?
It is very frustrating because I am used to Visual Foxpro where it is very
easy.

Please do not assume that I know anything so you really have to do all the
coding. :)
Click to expand...

No point.

The examples we can create are not better than the online
examples you have already found.

So post some code and the error message you get and will
see if we can get it working for you.

Arne
 
--
RG


Arne Vajhøj said:
What database software are you using ?


No point.

The examples we can create are not better than the online
examples you have already found.

So post some code and the error message you get and will
see if we can get it working for you.

Arne
Click to expand...



Hi,

Here is one that I tried:

public class TestDB
{


public static void TryCreateTable()
{

using (SqlConnection con = new
SqlConnection(ConsoleApplication354.Properties.Settings.Default.masterConnectionString))
{
con.Open();
try
{
using (SqlCommand command = new SqlCommand("CREATE TABLE
Dogs1 (Weight INT, Name TEXT, Breed TEXT)", con))
{
command.ExecuteNonQuery();
}
}
catch
{
Console.WriteLine("Table couldn't be created.");
}
}
}


}
 
--
RG


Arne Vajhøj said:
What database software are you using ?


No point.

The examples we can create are not better than the online
examples you have already found.

So post some code and the error message you get and will
see if we can get it working for you.

Arne
Click to expand...

Hi,


public class TestDB
{


public static void TryCreateTable()
{

using (SqlConnection con = new
SqlConnection(ConsoleApplication354.Properties.Settings.Default.masterConnectionString))
{
con.Open();
try
{
using (SqlCommand command = new SqlCommand("CREATE TABLE
Dogs1 (Weight INT, Name TEXT, Breed TEXT)", con))
{
command.ExecuteNonQuery();
}
}
catch
{
Console.WriteLine("Table couldn't be created.");
}
}
}


}
 
Hi Mark,

Yes that is the problem in that I am totally confused. :)
1) You say that you want to create a database but the SQL you are using is
to create a table
Click to expand...

Well I was trying to create a database first and then a table as I assumed
that first you have to create a database and then the tables that make up
that database.
2) You are using the SQL Server native data provider objects - do you
already have an instance of SQL Server running?
Click to expand...

I do not know what you mean by an instance of SQL Server running
unfortunately.
3) Are you actually trying to create a database or a table?
Click to expand...

As I said I would like to create a database and then the tables. Is that not
the way it should be?
I thought that I already created the database when I "Add a New Source" and
I chose "Database". Is that not how it is done?
Then I tried to create the table to go into the database I think.

Can you tell me what I should be doing?

Thanks
 
Roy Gourgi said:
Hi Mark,

Yes that is the problem in that I am totally confused. :)


Well I was trying to create a database first and then a table as I assumed
that first you have to create a database and then the tables that make up
that database.


I do not know what you mean by an instance of SQL Server running
unfortunately.


As I said I would like to create a database and then the tables. Is that
not
the way it should be?
I thought that I already created the database when I "Add a New Source"
and
I chose "Database". Is that not how it is done?
Then I tried to create the table to go into the database I think.

Can you tell me what I should be doing?

Thanks
Click to expand...
We need to clarify a few things:
* Do you have SQL Server (or SQL Server Express) installed on the relevant
machine?
* Is it running? (Check services for MSSQL and similar)
* Can you find the database you need to create the table in (using either
SQL Server Management Studio or Visual Studio Server Explorer)?

If these are all true then the code you showed looks okay, it maybe that the
user running the code doesn't have permission to create new tables. Instead
of trapping the error and then writing "Table could not be created" show the
output from:
catch (Exception e)
{
Console.WriteLine(e.Message);
Console.WriteLine(e.ToString());
}
 
Hi Mark,

I just thought of something. I do not have to create the tables
programatically either so maybe I should create the tables after I create the
database?
Is that how I should do it maybe?

Thanks
 
SQL Server, unlike FoxPro, is a server-based relational database management
system. It needs to be installed like any other application and then
started - most people accept the default option of having SQL Server start
automatically when the server boots up. So, as Joe says...
Click to expand...

How do I get SQL Server to start automatically when the server boots up?

I think that I have installed it because I see it when I click Start and
then All Programs I see Microsoft SQL Server 2008.
Though I am not sure that it starts automatically when I open C#.

Ok I see, I just opened Database Explorer I see the Data Connections and I
just created a database named TestDB and I just created a table called
customer and added the fields Name, Address, TelNum.

I guess if I am able to do that it means that I am running SQL Server right?

Ok now that I have created the database TestDB and the table called customer
how do I add records and select them when I want to?

Thanks
 
--
RG


Mark Rae said:
Start, Programs, Microsoft SQL Server 2008, Configuration Tools, SQL Server
Configuration Manager
Select SQL Server Services in the left pane and then make sure that SQL
Server (.........) is set to start automatically
Click to expand...

Yes it is as I see it is set to Automatic.

Thanks Mark I appreciate it. It has been a very frustrating experience.
It looks like there are many ways to skin the cat. :)

Thanks again
Roy
 
A cheap trick is to provide a "virgin" database (an mdb file). Just the
tables/queries and such, no data.
Then filecopy it to make a "new" database.

A suggestion:
Move away from JET database(s) and move toward Sql Server Express or even
Sql Server CE.

...........

You can see a basic SqlServerCE database here:
http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!176.entry
Follow the read me's as well about CE, especially the "johnnycantcode" ones.
 
Back
Top