c# – “无法将类型IDbConnection隐式转换为SqlConnection”

我尝试将INSERT插入我的SQL数据库,但我不能,因为在此代码行中给出了一个错误：

commandoSQL.Connection = dbcon;

我收到此错误：

Assets/NGUI/Scripts/Interaction/ChamarVariavel.cs(43,29): error CS0266: Cannot implicitly convert type System.Data.IDbConnection' toSystem.Data.SqlClient.SqlConnection’. An explicit conversion exists (are you missing a cast?)”

我希望有人可以帮助我.

谢谢

我的代码：

public class ChamarVariavel : MonoBehaviour {

    public UISlider slider;

    // Use this for initialization
    void Start () {
    }

    // Update is called once per frame
    void Update () {
    }

    void OnGUI(){
        // Connection DB
        string connectionString = "Data Source=(local);Initial Catalog=Test;User ID=******;Password=*******";

        IDbConnection dbcon;

        dbcon= new SqlConnection(connectionString);

        dbcon.Open();
        //DB Online

        float x = slider.value * 100;
        GUI.Label(new Rect( 570,238,70,30 ),"(" + x.ToString("f2") + ")");

        string qInsert = string.Format(@"INSERT INTO Fuel (fuel) VALUES ('{0}')",x);

        SqlCommand commandoSQL = new SqlCommand(qInsert);

        commandoSQL.Connection = dbcon;

        try
        {
            commandoSQL.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            GUI.Label(new Rect( 300,40,300,300 ),ex.ToString());
        }

        dbcon.Close();
        //DB offline
    }
}