Dot net variables in NAV 2013 R2

(0) Share

Report

Posted on by Senthil Kumar Varat...

205

Using Dot Net variable I am Selecting record from External SQL table (Separate DB), To read a data I used SQLREADER. Once I read the data from SQL I want to update the Boolean field true which is available in External table. How to Achieve " Update Query " Using Data Adapter, and how to initialize data adapter using CAL code.

*This post is locked for comments

All responses (2)

Answers (0)

Rashed 3,765 on at

Like (0)

Report

RE: Dot net variables in NAV 2013 R2

here is a link with example in cal.

mibuso.com/.../using-ado-on-rtc-in-nav
Suggested answer

keoma 32,675 on at

Like (0)

Report

RE: Dot net variables in NAV 2013 R2

hi

to update the value you do not need the sqldatareader.

you need sqlconnection and sqlcommand.

in c# the code it's like that:

using (SqlConnection connection = new SqlConnection(

connectionString))

{

SqlCommand command = new SqlCommand(queryString, connection);

command.Connection.Open();

command.ExecuteNonQuery();

}

queryString is a string/text variable, e.g. queryString = "update table1 set boolVar=true where id=@id";

not a big thing to adopt it to c/al.

you'll find tons of infos and tutorials about that topic.