如何访问我的SQL数据库以查找我需要的内容？ [英] How do I access my SQL database to find what I need?

问题描述

我正在尝试为直角三角形编写代码。我有一个从0到90度的正弦，余弦，正切和弧度的数据表。我写的表是在等待访问的数据集中。我想让代码在表中搜索度数的输入并搜索表并将Sine函数返回到文本框，以便我的程序的其余部分可以操作Sine函数并返回答案，以便查看者可以看到正确的内容三角形包括，即相邻，相反，斜边，角度A和角度B，使用正弦律和余弦定律。我感谢你们给予帮助的人们的帮助。我非常感谢你



我尝试过：



我查看过一些涉及VB 2005，VB 2010，VB.NET和搜索网络的书籍，但找不到任何有用的内容，也找不到有用的代码。

解决方案

Quote：

我正在尝试为直角三角形编写代码。我有一个关于正弦，余弦，正切和弧度的数据表，从0到90度。

整个想法适得其反，众所周知，trig函数是慢，但与SQL请求相比，它们非常快。

您正在使用正典杀死蚊子。



使用vb集成函数要快得多。

这样的东西：

 Dim result = myDataSet.myTable.Select（Degrees =&度）

I am trying to write code for a right triangle. I have a data table for the Sine, Cosine, Tangent, and Radians for the degrees from 0 to 90. The table I wrote is in a dataset waiting to be accessed. I want to have the code search the table with the input of a degree and search the table and return the Sine function to a textbox so the rest of my program can manipulate the Sine function and return an answer so the viewer can see what the right triangle consists of, i.e., Adjacent, Opposite, hypotenuse, Angle A and Angle B using the Law of Sines and Law of Cosines. I thank you for the help to anyone who does help. I appreciate you so very much

What I have tried:

I have looked in some of the books I have that deals with VB 2005, VB 2010, VB.NET, and search the web, but cannot find anything that will help, nor can I find the code that will help.

解决方案

Quote:

I am trying to write code for a right triangle. I have a data table for the Sine, Cosine, Tangent, and Radians for the degrees from 0 to 90.

The whole idea is counter productive, it is common knowledge that trig functions are slow, but compared to a SQL request, they are blazingly fast.
You are using a canon to kill a mosquito.

Using vb integrated functions is much faster.

Something like this:

Dim result = myDataSet.myTable.Select("Degrees = " & degree)

这篇关于如何访问我的SQL数据库以查找我需要的内容？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！