Exporting QTP runtime datatable to SQL server during

[SweetyChowdhury]

Hi Team,

I am importing datatable from sql server in the global sheet, then modifying few column data.
After modification, I want to write back the changes(runtime datatable) to the same datatable in the sql server database.

Is it possible to do? If yes, can you please suggest a sample code.

[sria123]

Its possible. given the Update access previlages to your DB.
i dont have sample code.
bt u can do this in similar way how you caonnect to the DB and query the DB


U can write a update query and execute it.

Thanks
Sonu

Code:

Function db_connect( strSQL ) Set o_CON =CreateObject("ADODB.Command") Set o_RS= CreateObject("ADODB.RecordSet") serverName = Left(Environment.Value("LocalHostName"), 4)&"svr"'Inputbox("Enter the DB server Name") If Trim( serverName) ="" Then 's_ConnectionString = "dsn=" & "yourDB" serverName ="yourdbserver" s_ConnectionString ="driver=sql server;server="& serverName &";database=yourDB;uid=yourdbuserid;pwd=yourpassword*" Else s_ConnectionString ="driver=sql server;server="& serverName &";database=yourDB;uid=yourdbuserid;pwd=yourpassword*" End If o_CON.ActiveConnection = s_ConnectionString o_CON.CommandText= strSQL Set o_RS =o_CON.Execute Set db_connect = o_RS End Function