update the tables sql,asp.net c#

Question

hi, i have two table t1,t2 and one target table t3
 
t1 have 3 columns
t2 have 3 columns (different columns)

i inserted t1,t2 tables and stored successfully
  now i want to copy(column values) the all t1,t2 values in t3 table based on (t1.id=t2.id )

and next i want to fetch all  t3 column values in a gridview
 plz help

Answer 1

Ok Nithin ... carry on...

Answer 2

thanks for your reply

 i have solved it just now .

thanks 

Answer 3

I tried the same in my project ... It is working

 

Check the data type of date field .Write the show alert code in the form_load function 

post your code for further steps...

-------------------------------------------------------------------

If you find anything useful please accept my answer

 

Answer 4

already try this not working

Answer 5

Hi Nithin,

Use two tables

1. contain followupdate

2. customer information

update the followupdate by some form

on form load of your resultant from use this query and update your fields or Datagrid.

"Select A.name ,A.mobile,A.address,A.order from customer A ,followup B Where B.folloDate=CURDATE() "

-------------------------------------------------------------------

If you find anything useful please accept my answer