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 : 2401 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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 ?

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	hi Please mark as answer if it helpful to you. Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Pcjoshi, if this helps please login to Mark As Answer. \| Alert Moderator

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

0	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 Kumaraspcode2009@gmail.com Pcjoshi, if this helps please login to Mark As Answer. \| Alert Moderator

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

0	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

0	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 Kumaraspcode2009@gmail.com Pcjoshi, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts