how to check record exists,update and insert

Question

1.00/5 (1 vote)

See more:

In run mode as follows

From date calendar1

In Table record as follows

Schdate   course   Staff   Active
28 Aug 14   MFA    BJR       A
29 Aug 14   EFA    RPK       A

When i click the From date i want to check for selected date record is there in the database.

suppose user select the 28 aug 14 in the calendar1, check whehter for selected 28 aug 14 record is there in the database.

if there shows the message for the selected date records is there.

suppose for selected date record is there want to Active 'A' in to 'D' want to upate

Then after inserting the record.

for that how can i validate in asp.net using c#

Regards,
Narasiman P.

Posted 1-Sep-14 21:14pm

narasiman1

Updated 1-Sep-14 23:15pm

Nelek

v2

Add a Solution

Comments

OriginalGriff 2-Sep-14 3:16am

And?
What have you tried?
Where are you stuck?

[no name] 2-Sep-14 3:20am

Update your question so that any one can help you

2 solutions

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)

MukeshSagar · Answer 1 · 2014-09-01T22:35:00

In Table record as follows

Schdate   course Staff Active
28 Aug 14   MFA   BJR   A
29 Aug 14   EFA   RPK   A

When i click the From date i want to check for selected date record is there in the database.

To check the existence of the record use the query:

C#

SqlCommand cmd;
SqldataAdapter adpt = new SqlDatAdapter("select count(*) from tablename where Schdate='28-Aug-14'",cn);
DataSet ds = new DataSet();
adpt.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
   Response.Write("Record Exists");
   for (int i=0;i<ds.tables[0].rows.count;i++)>
   {
      cmd = new SqlCommand("update tablename set Active='D' where Staff = '" + ds.Tables[0].Rows[i][2].ToString() + "'",cn);
      cn.Open();
      cmd.ExeceuteNonQuery();
      cn.Close();
      cmd.Dispose();
   }
}
else
{
   Response.Write("Record Not Exists");
}

_Maxxx_ · Answer 2 · 2014-09-01T22:31:00

Solution 2

To check if a record exists in the Db you can use a simple 'if exists' SQL

To insert or update records you can do a simple Update ..Where or a simple Insert (you've already checked if it exists)

Posted 1-Sep-14 22:31pm

_Maxxx_