Forum Discussion

hoaphan's avatar
hoaphan
New Contributor III
3 years ago

Saving data released on a gridview directely to a shared folder

Dear OneStream community, I'm trying to save the data on this gridview on a shared folder, does anyone know how i can do it ?  Once i will save it on a shared folder, i will put a busines...
Data Management
Mustafa_A's avatar
Mustafa_A
Contributor II

Hi hoaphan 

 

Were you able to implement this BR? I'm trying to figure how did you setup the source target? 

ChristianW's avatar
ChristianW
Valued Contributor
3 years ago

Something like this, gives you the datatable object:

'Define the SQL Statement
Dim sql As New Text.StringBuilder					
sql.Append("Select * ")
sql.Append("From <Your Table> ")
sql.Append("Where <your Restrictions> ")
				
Dim dt as datatable 
Using dbConnApp As DBConnInfo = BRAPi.Database.CreateApplicationDbConnInfo(si)
	dt = BRAPi.Database.ExecuteSql(dbConnApp, sql.ToString, False)			
End Using