file upload in windows form

Question

hi, how to upload a file(.txt, .doc) into database with full file path name. In my application i have a text box and a browse button and a save button. when i click the browse button i am showing OpenFileDialog box,their i select a file and it will show into the textbox. Now when i click the save button i want the full path name from the textbox to save on the database. I am using .net windows application with C#. regards, bjb

Answer 1

Select DeptName, sum(salaries)
from
T1
inner join T2 on T1.empid=T2.empid
group by DeptName

please mark it as answer if it addresses the issue.

Answer 2

Hi, bala krishna

 

you can write below query....

 

select T1.d_name, sum(T2.salaries) from T1,T2 where T1.id=T2.id group by T1.d_name 

 

NOTE : d_name is department name

 

Happy Coding...

 

Thank you,

(Ravi D. Sangtani)