与sql server 2008在c＃windows窗体中具有Ms访问权限的vb6 adodb的recordset.find相当于什么 [英] what is equivalent of recordset.find of vb6 adodb with Ms access in c# windows forms with sql server 2008

问题描述

您好我的名字是vishal我正在翻译/解释一个vb6代码adodb，其中Ms访问c＃code with sql server 2008.

下面给出的是vb6代码：

Hi my name is vishal i am translating/interpreting a vb6 code adodb with Ms access into c# code with sql server 2008.
Given below is vb6 code:

Dim sItemData As String
Dim strData As String
Dim strOutData As String
Dim strConnect As String
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\Prices.mdb;Persist Security Info=False"
    Dim strPath As String
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
      "Persist Security Info=False;Data Source=" & strPath & _
      "; Mode=Read|Write"
    Dim rs As New ADODB.Recordset
strData = "Item = '" & sItemData & "'"
   rs.Open "select * from prices", strConnect, adOpenKeyset, adLockOptimistic
    rs.Find strData
    strOutData = rs.Fields("Price")

以下是我的c＃代码翻译/解释上述vb6代码：

Given below is my c# code translation/interpretation of above vb6 code:

string sItemData="";
        string strOutData;
string strData;
            strData = "Item = '" + sItemData + "'";
 SqlConnection conn = new SqlConnection("Data Source=NPD-4\\SQLEXPRESS;Initial Catalog=Winsock;Integrated Security=true");
            if (conn.State != ConnectionState.Open)
            {
                conn.Open();
            }
            string root = ("Select * from Prices");
            SqlCommand cmd = new SqlCommand(root);
            cmd.Connection = conn;
            cmd.CommandType = CommandType.Text;
            SqlDataReader dr = cmd.ExecuteReader();
            while (dr.Read())
            {
                
                strOutData = dr[1].ToString();
            }

一切顺利，除非我无法翻译/解释给定的vb6代码行：

every thing goes okay except i am unable to translate/interpret given vb6 code line:

rs.Find strData

使用sql server 2008进入c＃代码。

任何人都可以帮助我！在使用sql server将vb6代码转换为c＃代码时，我正在朝着正确的方向前进吗？用cql server 2008告诉我c＃中的rs.Find相当于什么？告诉我必须在sql server 2008的c＃代码中做什么修改。非常感谢解决这个问题的任何帮助/指导！任何人都可以帮助我！

into c# code with sql server 2008.
Can anyone help me please! Am going in right direction in translating above vb6 code into c# code with sql server? Tell me what is equivalent of rs.Find in c# with sql server 2008? Tell me what modifications must i do in my c# code with sql server 2008. Any help/guidance in solving of this problem would be greatly appreciated! Can anyone help me !

推荐答案

Find方法正在转移到与strData中的条件匹配的记录 - 参考 [ ^ ]



就个人而言，我会添加 where 子句到sql查询...

The Find method is moving to a record that matches the criteria in strData - Reference[^]

Personally I would add a where clause to the sql query ...

"Select * from Prices where item = @itemdata"

并将参数添加到 cmd



是的，你正朝着正确的方向远离VB6！ ！如果它符合您的需求，C＃是一个不错的选择。你没有有同时离开Access，但它也是一个好动作

and add a parameter to cmd

And yes you are going in the right direction moving away from VB6!! C# is a good choice if it fits your needs. You didn't have to move away from Access at the same time, but it's is also a Good Move

那么有很多方法可以做到这一点，包括我认为最好的，包括select子句中的搜索表达式，使用参数。但是使用你的代码，我会尝试这样的事情：

Well there's a lot of ways of doing it,including the best in my opinion that would be including the search expression in the select clause,using parameters. But using your code,i'll try something like this:

while (dr.Read())
            {
                if (dr[1].ToString()==strData)
                {
                    strOutData = dr[1].ToString();
                {
            }

这篇关于与sql server 2008在c＃windows窗体中具有Ms访问权限的vb6 adodb的recordset.find相当于什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！