Standard ADO.Net components works with ES?


Author
Message
Luiz Lima
Luiz Lima
StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)
Group: Forum Members
Posts: 66, Visits: 724
Hi,



I´d like to know if the code below works when I using a ES connection.



Tks



con = New SqlConnection(sConnectionString)

con.Open()

ds = New DataSet()

sSql = "select cli_campo01, cli_campo02, cli_classe, cli_nome from tb_cliente "

dap = New SqlDataAdapter(sSql, con)

Dim dt = New DataTable()

dap.Fill(dt)

If dt.Rows.Count > 0 Then

dim campo1 as string = dt.Rows(0).Item("server_cliente")

dim campo2 as string = dt.Rows(0).Item("db_cliente")

classe_cliente = dt.Rows(0).Item("cli_classe")

nome_cliente = dt.Rows(0).Item("cli_nome")

end if


Replies
Luiz Lima
Luiz Lima
StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)
Group: Forum Members
Posts: 66, Visits: 724
Greg,

Sorry by late.
I tested the code but I´ve got an error about override TableName, how can I do that?

See the screen shot


tks

Luiz

Greg McGuffey
Greg McGuffey
Strategic Support Team Member (4.8K reputation)
Group: Forum Members
Posts: 2K, Visits: 6.6K
Oops. I haven't done this in a while. You have actually build a BO using the BO mapper so all the required override properties are handled. I guess a better way of expressing this is to say that you can use any BO to generically retrieve data. I'm working on an example which should be done tomorrow.
Greg McGuffey
Greg McGuffey
Strategic Support Team Member (4.8K reputation)
Group: Forum Members
Posts: 2K, Visits: 6.6K
I just posted a sample demonstrating how you might do this.



http://forum.strataframe.net/FindPost26800.aspx
Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
Great job, Greg. Thanks for the samples! Smile
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search