Code

Re: How display data in drop-down

Greg Collins — Wed, 19 Dec 2007 17:37:01 GMT

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.

Re: How display data in drop-down

assaxi — Wed, 19 Dec 2007 08:26:11 GMT

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

Do you have code example

Re: How display data in drop-down

Greg Collins — Tue, 18 Dec 2007 19:08:21 GMT

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.

How display data in drop-down

assaxi — Tue, 18 Dec 2007 14:24:13 GMT

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

public void FormEvents_Loading(object sender, LoadingEventArgs e)

{

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;

}