how can save valid and invalid email id in database at a time [Resolved]

Posted by Pcjoshi under ASP.NET on 9/22/2012 | Points: 10 | Views : 1445 | Status : [Member] | Replies : 4
hi
In my application i want to pick all email id from database table it contains valid and invalid email ids. I have another table where i want to insert
data if valid email id status will be true or invalid email id status will be false .
in try block i wrote query for insert valid email id ? where i wrote query for invalid email id ?




Responses

Posted by: Jayakumars on: 9/22/2012 [Member] [MVP] Bronze | Points: 50

Up
0
Down

Resolved
hi

Please mark as answer if it helpful to you.

Mark as Answer if its helpful to you

Pcjoshi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jayakumars on: 9/22/2012 [Member] [MVP] Bronze | Points: 25

Up
0
Down
hi
Pcjoshi

check this url

http://www.dotnetfunda.com/codes/code3247-how-to-save-valid-and-invalid-email-id-using-stored-procedure.aspx

Mark as Answer if its helpful to you

Pcjoshi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Pcjoshi on: 9/22/2012 [Member] Starter | Points: 25

Up
0
Down
Actually your answer is correct but my query is that when it picks id from table, id will be valid and invalid now how it will check which is valid or invalid ids if valid then execute query which i wrote and insert data in sent details table with status true if invalid its update status false.

Pcjoshi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jayakumars on: 9/22/2012 [Member] [MVP] Bronze | Points: 25

Up
0
Down
hi

check this datatable method FetData here return the datatble if u need customized here i have write the sql put count(*) like if u need
select * from etc then return your all email id then you will achieve this.

Mark as Answer if its helpful to you

Pcjoshi, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response