-
April 29th, 2012, 11:09 AM
#1
Counter in SQL and Database help!
Hey all!
I'm a bit of a 'Newbie' and I'm practising SQL and Databases. I've got a windows form in VS2010 which takes a word from a text box and on a button click, that a word is stored in the database.
I have my database called 'Setup' my table called 'tblpeople' and 2 columns called 'people' and 'occur'
So right now my data values from textbox1 are going into 'people' like it should, but what I want to add is that if a persons name is all ready in 'people' then I want it to NOT add it in again but add a count to the 'occur' column beside it.
so in my data base table it should look like this once i've updated it:
people occur
john 1
James 5
That's only an example since it could be any name i've entered.
Here's my code so far:
Code:
private void database()
{
{
SqlConnection conn = new SqlConnection();
connection.ConnectionString = (@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\John\Desktop\db\db\db\Setup.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO tblpeople (people) VALUES (@ppl)", conn;
try
{
string[] splin = textbox1.Text.Split(' ');
foreach (string pstring in splin)
{
if (pstring.StartsWith("*"))
{
cmd.Parameters.AddWithValue("@ppl",pstring);
int rowsAffected = cmd.ExecuteNonQuery();
}
}
}
finally
{
conn.Close();
}
}
}
note: I've got the string split because it's only names starting with * to get stored.
So any help guys? would be much appreciated.
-
April 29th, 2012, 11:51 AM
#2
Re: Counter in SQL and Database help!
-
April 30th, 2012, 06:37 AM
#3
Re: Counter in SQL and Database help!
Change your sql request to something like that
IF EXISTS (SELECT * FROM Table1 WHERE Column1='SomeValue')
UPDATE Table1 SET (...) WHERE Column1='SomeValue'
ELSE
INSERT INTO Table1 VALUES (...)
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|