retrieving data ffrom database

[mauj]

i've two tables trans-mstr having columns as acc_no_from,dat e,particular,wd _dt,amt,balance and third_party_tra nsfer(table2) having columns as acc_no_frm,acc_ no_to,date,amt.
now i wnt to retreive date ,particular,wd_ dt,acc_no_to,am t,balance where the acc_no_from in third_party_tra nsfer is equal to the no.entered in the textbox of the webpage.
i've used datagrid view to show all this.

i'm using c# n sql server2005 in this

i'm a beginer



plzz help me out as soon as possible.!!!!!! !!!!!

[Frinavale]

You need to translate everything that you just stated that you need to do into a SQL statement.

When you execute the SQL statement the database will return you what you told it to return you.

Bind you GridView to the table returned to you and it will display the data.

-Frinny