How do I extract sql Avg result to vb.net?

[animeonegai2]

can someone help me on getting the average result out from this sql statement? thanks!!

sql = "select AVG(Height * Length * Width) from Bar"
da = oledbdataadapter(sql, dbconnection)
dt = new datatable
da.fill(dt)


not sure if the above statement is correct or not

 

[.paul.]

dt.fill(da) isn't it?

 

[animeonegai2]

I'm too newbie to know whats wrong with my sentence, I just follow one of the codes in the net.

 

[cjard]

can someone help me on getting the average result out from this sql statement? thanks!!

sql = "select AVG(Height * Length * Width) from Bar"
da = oledbdataadapter(sql, dbconnection)
dt = new datatable
da.fill(dt)


not sure if the above statement is correct or not

The above statement will calculate the average volume of all the entries in Bar. Is that what you want?

 

[cjard]

dt.fill(da) isn't it?

I'm afraid not

 

[.paul.]

it was just a wild guess.
i don't use datatables or dataadapters myself