Hi

   I have a table called Version and its attributes are Version_ID, Project_ID , Hospital_ ID , Date_Created and comments. I want to select the data by Version_ID,Project_ID and  Hospital_ID and the selected data is inserted in the same table(Version) as new row .

Table: Version (Version_ID(Primary_key), Project_ID(Foreign_Key),Hospital_ID(Foreign_Key),Date_Created,Comments). 

Iam using Visual Web Developer Express and SQL Server 2005. Iam doing on asp.net 2.0.

Could anyone please send me the code asp.net 2.0 for the above problem.

Where are you selecting the data from? Do you simply want to add a new row to a data set and then perform a database update? This would be the easiest approach.


 

Gcalderon thanks a lot for reply

Actually i want to select a row from the version table for example Version_ID (1004) and i want to insert that selected row into the same table(Version) as new row for example Version_ID (1007).

Table: Version (Version_ID(Primary_key), Project_ID(Foreign_Key),Hospital_ID(Foreign_Key),Date_Created,Comments). 

If you don't mind could you please give me the solution in detail.I'll wait for your reply .

I'm having difficulty understanding what your trying to accomplish from a user point of view.  Are you dealing with a gridview? Do you want the user to click on a row to get the data or do they simply type it in somewhere and then add it to the database. Explain from a user point of view, what are the steps?

Hi gcalderon

                  My webpage contain three dropdown box and one button. One dropdown to choose hospital_id, second dropdown to choose project_id and third dropdown to choose version_no .After choosing these three and when the button is clicked i want to run this sql query

INSERT INTO  version(project_id,hospital_id,date_created,comments) SELECT project_id,hospital_id,date_created,comments FROM version where version_no=@version_no and project_id=@project_id and hospital_id=@hospital_id.

Just i need the code in asp.net 2.0 , VB , when the button is clicked the above query should run and the parameters (values) should take from dropdown box.

Please send the solution for the above problem. I'll wait 4 ur mail.

The easiest way would be to put your insert query into a datasource. Then on the button OnClick event put

sqldatasource.insertparameters["@version_no"].defaultvalue = dropdownlistVersion_no.selectedvalue;

sqldatasource.insertparameters["@project_id"].defaultvalue = dropdownlistProject_id.selectedvalue;

sqldatasource.insertparameters["@hospital_id"].defaultvalue = dropdownlistHospital_id.selectedvalue;

sqldatasource.insert();

The syntax might be a little bit different as I use C#, but that is what you need to do.