做相反的操作我可以帮你,不过如果你是学csharp的做这些工作应该不是问题吧!

解决方案 »

  1.   

    Imports 被Using替换
    有End的地方被大括号替换,定义的语句要换比如Dim dsSet As DataSet换成Dataset dsSet;还有要注意加;
    :)
      

  2.   


    在c#中没有这个咚咚啊 ?   Public Sub New()        sqlConn = New SqlConnection(ConfigurationSettings.AppSettings("KeyConn"))    End Sub
      

  3.   

    using System;
    using System.Data;
    using System.Data.SqlClient;
    using System.Configuration;public class clsMain
    {
    //连接 SQL Server 数据库字符串
     SqlConnection sqlConn ; //%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
    //连接数据源
    //%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
    public clsMain()
    {
    sqlConn = new SqlConnection(ConfigurationSettings.AppSettings.Get("KeyConn"));
    } //%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
    //对 SQL Server 数据库进行查询操作
    //%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
    public DataView funShowData(string strSQL) 
    {
    DataSet dsSet;
    SqlDataAdapter sqlAdapter;
    dsSet = new DataSet();
    sqlAdapter = new SqlDataAdapter(strSQL, sqlConn);
    sqlAdapter.Fill(dsSet, "tTable");
    return dsSet.Tables["tTable"].DefaultView;
    } //%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
    //对 SQL Server 数据库进行添加、修改、删除操作
    //%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
    public void subExecute(string strSQL)
    {
    SqlCommand odcComm ;
    odcComm = new SqlCommand(strSQL, sqlConn);
    odcComm.Connection.Open();
    odcComm.ExecuteNonQuery();
    odcComm.Connection.Close();
    }
    }
      

  4.   

    找个VB.net to C#.net的程序,哈