Data ind i datagrid

Hmm tilføjede følgende inden lukningen af db-forbindelsen:

"DataColumn colSecond = setVideos.Tables[0].Columns[
MessageBox.Show("Navnet på anden kolonne er: " + colSecond.ColumnName);"

Den burde vise en besked nu men den popper heller ikke op med en besked her.. ?

************* Exception Text **************
System.ArgumentException: Format of the initialization string does not conform to specification starting at index 0.
  at System.Data.Common.DbConnectionOptions.GetKeyValuePair(String connectionString, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, String& keyname, String& keyvalue)
  at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)
  at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules)
  at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
  at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
  at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
  at System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value)
  at System.Data.SqlClient.SqlDataAdapter..ctor(String selectCommandText, String selectConnectionString)
  at FDF.Members.fyldOp() in C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\FDF\FDF\Members.cs:line 34
  at FDF.Members.Members_Load(Object sender, EventArgs e) in C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\FDF\FDF\Members.cs:line 22
  at System.Windows.Forms.Form.OnLoad(EventArgs e)
  at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
  at System.Windows.Forms.Control.CreateControl()
  at System.Windows.Forms.Control.WmShowWindow(Message& m)
  at System.Windows.Forms.Control.WndProc(Message& m)
  at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
  at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Vist min  cnnVideos.ToString()); der er en dårlig ide :(

Error    1    The best overloaded method match for 'System.Data.SqlClient.SqlDataAdapter.SqlDataAdapter(System.Data.SqlClient.SqlCommand)' has some invalid arguments    C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\FDF\FDF\Members.cs    40    49    FDF

Error    2    Argument '1': cannot convert from 'MySql.Data.MySqlClient.MySqlCommand' to 'System.Data.SqlClient.SqlCommand'    C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\FDF\FDF\Members.cs    40    68    FDF

System.InvalidOperationException: The SelectCommand property has not been initialized before calling 'Fill'.
  at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
  at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
  at FDF.Members.fyldOp() in C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\FDF\FDF\Members.cs:line 43
  at FDF.Members.Members_Load(Object sender, EventArgs e) in C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\FDF\FDF\Members.cs:line 24
  at System.Windows.Forms.Form.OnLoad(EventArgs e)
  at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
  at System.Windows.Forms.Control.CreateControl()
  at System.Windows.Forms.Control.WmShowWindow(Message& m)
  at System.Windows.Forms.Control.WndProc(Message& m)
  at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
  at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

MySqlConnection cnnVideos = new MySqlConnection(
    "Data Source=localhost;" +
                                    "Persist Security Info=yes;" +
                                    "Database=funworld;" +
                                    "UserId=root; PWD=test;");

            string strVideos = "select name, adress from member;";
            MySqlCommand cmdVideos = new MySqlCommand(strVideos, cnnVideos);

           
            SqlDataAdapter dadVideoCollection = new SqlDataAdapter();

            DataSet setVideos = new DataSet("funworld");
            dadVideoCollection.Fill(setVideos);
            this.dataGrid1.DataSource = setVideos;
            this.dataGrid1.DataMember = setVideos.Tables[0].TableName;

            DataColumn colSecond = setVideos.Tables[0].Columns[1];
            MessageBox.Show("The name of the second column is " + colSecond.ColumnName);
            cnnVideos.Open();
            cnnVideos.Close();

Argh den sidste er fordi jeg fjernede cmdVideos som gav problemer før fra  SqlDataAdapter dadVideoCollection = new SqlDataAdapter(); .. hvordan løser jeg dette.. ?

System.NullReferenceException: Object reference not set to an instance of an object.
  at FDF.Members.fyldOp() in C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\FDF\FDF\Members.cs:line 43
  at FDF.Members.Members_Load(Object sender, EventArgs e) in C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\FDF\FDF\Members.cs:line 24
  at System.Windows.Forms.Form.OnLoad(EventArgs e)
  at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
  at System.Windows.Forms.Control.CreateControl()
  at System.Windows.Forms.Control.WmShowWindow(Message& m)
  at System.Windows.Forms.Control.WndProc(Message& m)
  at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
  at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
--------------------------------------
og ser sårn ud nu..


MySqlConnection cnnVideos = new MySqlConnection(
    "Data Source=localhost;" +
                                    "Persist Security Info=yes;" +
                                    "Database=tiebreak;" +
                                    "UserId=root; PWD=test;");

            string strVideos = "select name, adress from member;";
            MySqlCommand cmdVideos = new MySqlCommand(strVideos, cnnVideos);

            MySqlDataAdapter dadVideoCollection = new MySqlDataAdapter(cmdVideos);

            DataSet setVideos = new DataSet("tiebreak");
            dadVideoCollection.Fill(setVideos);
            this.dataGrid1.DataSource = setVideos;
            this.dataGrid1.DataMember = setVideos.Tables[0].TableName;

            DataColumn colSecond = setVideos.Tables[0].Columns[1];
            MessageBox.Show("The name of the second column is " + colSecond.ColumnName);
            cnnVideos.Open();
            cnnVideos.Close();