how to use foreach in updating a table in asp.net web application

Question

0.00/5 (No votes)

See more:

Hi i have table which has columns like TaskID,UserID,ReminderDate,Task,TaskType,EmailID.

Now when the value in ReminderDate column is equal to Today's Date then a new row has to be inserted with the same values.

Here TaskType is Daily,Weekly,Monthly,Yearly,None.

1) ReminderDate value should be replaced with a value based on TaskType value.

2) TaskID is automatically set to incremnet by 1.

pls guide me further..

Posted 23-Jul-13 0:00am

Harsha24

Add a Solution

Comments

Dholakiya Ankit 23-Jul-13 6:11am

what u have tried?

Harsha24 23-Jul-13 6:16am

i was successful in inserting a new row for single record..
But i want to loop it to all the records in the table

santosha epili 23-Jul-13 6:18am

i suggest, use triggers in database instead of foreach loop

3 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)

Maciej Los · Answer 1 · 2013-07-23T00:41:00

Solution 2

You don't need any loop ;)

Please, test it:

SQL

INSERT INTO TableName (TaskID, UserID, ReminderDate, Task, TaskType, EmailID)
SELECT  TaskID + 1 AS TaskID, UserID, ReminderDate, Task, TaskType, EmailID
FROM TableName
WHERE ReminderDate = GETDATE()

Posted 23-Jul-13 0:41am

Maciej Los

Updated 23-Jul-13 0:43am

v2

renish patel · Answer 2 · 2013-07-23T00:43:00

Hello Harsha,

Agree with santosha,I also suggest to make trigger for it.

Here I mention following post for your better references..

Overview of SQL Server database Triggers[^]

http://technet.microsoft.com/en-us/library/ms189799.aspx[^]

If you getting your solution then please mark this post as answered

Thanks

Renish Ankola

senthil kumar - 2185 · Answer 3 · 2013-07-23T01:25:00

SqlConnection con = new Sqlconnection("conn");
SqlCommand cmd 
foreach(GridViewRow rw in Gridview1.rows)
{
Textbox txtrmddate  = (Textbox) rw.FindControl("ReminderDate");
Dropdownlist ddltasktyp = (Dropdownlist) rw.FindControl("TaskType");
if (convert.Todatetime(txtrmddate) == Datetime.Now.tostring("dd/MM/yyyy") && ddltasktyp.selectedItem.Text == "Daily"  )
{
con.Open();
cmd = new Sqlcommand("Insert into tblnam (UserID,ReminderDate,Task,TaskType,EmailID) Values (1,'"+ txtrmddate .text  +"','Task','"+ddltasktyp.selectedItem.Text+"','EmailID')",con);


}
}

how to use foreach in updating a table in asp.net web application

3 solutions

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0