value save in database only one time

Question

0.00/5 (No votes)

See more:

Dear All,

i have two textboxes. both of have some integer value. i want when the user click on the save button then first time its saves in the database next time if the user pass some value then it does't save in the database.

Posted 2-Sep-13 3:54am

Manish Arya

Add a Solution

Comments

Marvin Ma 2-Sep-13 10:08am

Could you post your code please?

abbaspirmoradi 2-Sep-13 10:11am

unclear.explain more.. you have two textboxes.what the means of its?are you want just one time your data save into database?

Manish Arya 2-Sep-13 10:17am

yes i want just one time data save into database

i am using for insert above code:

private void btnSavePrice_Click(object sender, EventArgs e)
{
string connstr = @"Server=.\SQLEXPRESS ;Initial Catalog=RPSJDB;Integrated Security=True; Max Pool Size=100";
string query = "insert into PriceTable values('" + txtPriceGold.Text + "','" + txtPriceSilver.Text + "')";
SqlConnection conn = new SqlConnection(connstr);

if (txtPriceGold.Text != "" & txtPriceSilver.Text != "")
{
conn.Open();
SqlCommand cmd = new SqlCommand(query, conn);
cmd.ExecuteNonQuery();

txtPriceGold.Clear();
txtPriceSilver.Clear();

MessageBox.Show("Values Save in DataBase");
conn.Close();
}
else
{
MessageBox.Show("Enter some value in the box");
}
}

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2013-09-02T04:09:00

So check if it is in the table before you do the insert, by using SELECT to eitehr return matching records or return the count of the records and check it for zero:

SQL

SELECT COUNT(*) FROM MyTable WHERE myColumn=MyValu

You could cretae a stored procedure to check and then insert if it doesn't exist, but I'd rather do it expicitly and report a problem to the user sensibly instead.