InfoPath Dev

How data display in drop-down (field1) in infopath

        {

            SqlConnection con;

            SqlCommand cmd = new SqlCommand();

            SqlDataAdapter da;

            DataSet ds = new DataSet();

            con = new SqlConnection("Data Source = 111.111.111.111; Initial catalog = database; Integrated Security = True");

            cmd.CommandText = "SELECT Pracownicy FROM Karta WHERE Day >= 10 AND Pracownicy.[Login] = 'zorro'";

            cmd.Connection = con;

            con.Open();

            DataSources[0].QueryConnection.Execute();

            string result = Connection.SelectSingleNode("/my:mojePola/my:field1", NamespaceManager).Value;

        }

Create a secondary data source to your SQL. You can always update the SQL command in code.

Configure your drop-down control (in the view) to populate its values from the secondary data source DOM.

Then you can requery all you want in code, and the drop-down will repopulate based on the returned results.

OK bat I dont now haw display this data in drop down.

Do you have code example

There is no code. You simply right-click the drop-down list box control in the view, choose Properties, and then set it up to pull its options from your secondary data source. That's it.