vb.net - Is it possible to add a T-SQL function/query to an adapter whos table is build in the datasetdesigner -

vb.net - Is it possible to add a T-SQL function/query to an adapter whos table is build in the datasetdesigner -

i want add together t-sql query existing datatable adapter datasetdesigner.xsd . possible in designer? if not, can utilize existing adapter designer when hardcode query?

cheers steven

@tim did already. right clicked , added sql query : here query

declare @start integer declare @currentkey varchar(20) set @rowcount = (select max(id) z_skm) set @start =1 while @start <= @rowcount begin set @currentkey= (select branche_firma_key z_skm id = @start ) if(@currentkey = null or @currentkey ='') begin end else begin update [sysdba].[z_skm] set branche_firma_val = (select text zdefproperty bring together zsysproperty on zdefproperty.zdefpropertyid=zsysproperty.zdefpropertyid @currentkey= zsysproperty.syspropertyid , valuetype ='branch' , text not '% eh' , text not '% gh' , text not '% alt' ) id = @start end set @start = @start + 1 end

it works in mssql - servermanager doesnt work in visual studio rightclicking adapter, add together query , insert it.. there syntax use? or need hardcode it?

cheers steven

i made function work saving procedure in sql server. after able phone call procedure in visual studio dataset designer rightclik on adapter , click "add query" -> "saved procedure"

vb.net tsql visual-studio-2013