用C#做一个对象返回的问题

Question

using System;
using System.Collections;
using System.Collections.Specialized;
using System.Configuration;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace mns
{
/////////////////////////////////////////////
/// Data类主要包括数据库连接，数据存取
/////////////////////////////////////////////
public class Data
{
public object connect()
{
string StrConSet="user id=";
StrConSet+=ConfigurationSettings.AppSettings["UserName"];
StrConSet+=";password=";
StrConSet+=ConfigurationSettings.AppSettings["PassWord"];
StrConSet+=";initial catalog=";
StrConSet+=ConfigurationSettings.AppSettings["DataBase"];
StrConSet+=";data source=";
StrConSet+=ConfigurationSettings.AppSettings["DataSource"];
StrConSet+=";Connect Timeout=";
StrConSet+=ConfigurationSettings.AppSettings["DataTimeout"];
SqlConnection objConnection = new SqlConnection(StrConSet);
return objConnection;
}
}
/////////////////////////////////////////////
/// Check类主要包括用户验证、IP验证等验证机制
/// /////////////////////////////////////////
public class Check
{
public string[] UserCheck(int CheckID,string CheckUsername,string CheckPassword,string CheckType,string[] CheckPower)
{
string Con_Open;
object objConnection; objConnection=mns.Data.connect(); try
{
objConnection.Open();
Con_Open="connect ok!";
objConnection.Close();
}
catch(Exception e)
{
Con_Open="connect fail!<br>";
Con_Open+=e.ToString();
} //bool[] UserCheck=new bool[]{InfoInput[0],InfoInput[1],true};
string[] UserCheck={Con_Open};
return UserCheck;
}
}
}

Answer 1

objConnection=mns.Data.connect();-〉
objConnection=(SqlConnection )mns.Data.connect();

Answer 2

补充：
object objConnection;
是不是也应该变为：
SqlConnection objConnection ;

Answer 3

SqlConnection objConnection = new SqlConnection改成
static SqlConnection objConnection = new SqlConnection

Answer 4

还是错误，不知道为什么？！
下面是修改后的代码using System;
using System.Collections;
using System.Collections.Specialized;
using System.Configuration;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace mns
{
/////////////////////////////////////////////
/// Data类主要包括数据库连接，数据存取
/////////////////////////////////////////////
public class Data
{
public object connect()
{
string StrConSet="user id=";
StrConSet+=ConfigurationSettings.AppSettings["UserName"];
StrConSet+=";password=";
StrConSet+=ConfigurationSettings.AppSettings["PassWord"];
StrConSet+=";initial catalog=";
StrConSet+=ConfigurationSettings.AppSettings["DataBase"];
StrConSet+=";data source=";
StrConSet+=ConfigurationSettings.AppSettings["DataSource"];
StrConSet+=";Connect Timeout=";
StrConSet+=ConfigurationSettings.AppSettings["DataTimeout"];
SqlConnection objConnection = new SqlConnection(StrConSet);
return objConnection;
}
}
/////////////////////////////////////////////
/// Check类主要包括用户验证、IP验证等验证机制
/// /////////////////////////////////////////
public class Check
{
public string[] UserCheck(int CheckID,string CheckUsername,string CheckPassword,string CheckType,string[] CheckPower)
{
string Con_Open;
SqlConnection objConnection=(SqlConnection)mns.Data.connect(); try
{
objConnection.Open();
Con_Open="connect ok!";
objConnection.Close();
}
catch(Exception e)
{
Con_Open="connect fail!<br>";
Con_Open+=e.ToString();
} //bool[] UserCheck=new bool[]{InfoInput[0],InfoInput[1],true};
string[] UserCheck={Con_Open};
return UserCheck;
}
}
}