InfoPath Dev

Hi there,

I am new to InfoPath and trying to write a code. I tried something simple:

root.SelectSingleNode("/dfs:myFields/dfs:dataFields/d:AOLObservation/d:AOL_Development/@Comments", NamespaceManager).SetValue("Meera Patel");

 The code you've posted looks fine the way it is.  Is there possibly some other code you're not showing us?

Could you also make sure that your form is set to use C# code and not Visual Basic?

The form is set to use C# (Under Tools, Options, Design Tab)

This is the code I have

Namespace AOL2 Public Class FormCode

AddHandler EventManager.XmlEvents("/dfs:myFields/dfs:dataFields/d:AOLObservation/@ID").Changed, AddressOf AOLObservation_ID_attr_Changed

AddHandler EventManager.FormEvents.Submit, AddressOf FormEvents_Submit

End Sub

' Write your code here to change the main data source.

End Sub

' Ensure that the constraint you are enforcing is compatible

' with the default value you set for this XML node.

' Write your code here.

' If the submit operation is successful, set

' e.CancelableArgs.Cancel = False

' Write your code here.

End Sub

' Write your code here.

End Sub

End Sub

End Namespace

hi,

code seems to be good, could you attach the template so that we can have a look at it.

Thanks for helping me out.

I tried to attach the file but it is 148KB so couldn't.

Any other option?

 That's Visual Basic code, not C#.  Please change the form's programming language to C# in Tools->Form Options->Programming, and add your C# code again.

Thanks jimmy

It is working fine now. I also need some help writing code to add new record to sql table.

I am not sure where to start from.

I have managed to write some code.

public void Button_Clicked(object sender, ClickedEventArgs e)
        {
            // Write your code here.
            string Id = MainDataSource.CreateNavigator().SelectSingleNode("/dfs:myFields/dfs:dataFields/d:AOLObservation/@ID", NamespaceManager).Value;
            string Key = MainDataSource.CreateNavigator().SelectSingleNode("/dfs:myFields/dfs:dataFields/d:AOLObservation/d:AOL_Development/@Key", NamespaceManager).Value;
            string Comments = MainDataSource.CreateNavigator().SelectSingleNode("/dfs:myFields/dfs:dataFields/d:AOLObservation/d:AOL_Development/@Comments", NamespaceManager).Value;
           

            SqlConnection MyConnection = new SqlConnection("server=vs-skunk;database=StaffDetails;UID=ework;PWD=ew0rk;");
            SqlCommand command = new SqlCommand(@"INSERT INTO [AOL Development]" + "([AOLID],[Key],[Comments])" + "Values(@Id, @Key, @Comments)",MyConnection);
            try
            {
                MyConnection.Open();
                command.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());

            }

}

But I am getting an error message saying "Must declare the scalar variable "@Id"

Can you help?????

 You need to set values for your three parameters.  Please have a look at this:

http://www.csharp-station.com/Tutorials/AdoDotNet/lesson06.aspx

That tutorial adds parameters like this:

SqlParameter param = new SqlParameter();
param.ParameterName = "@City";
param.Value = inputCity;

cmd.Parameters.Add(param);

But this whole process can be done with a single command like this:

cmd.Parameters.AddWithValue("@City", inputCity);

Thanks for this Jimmy

I have managed to add a button now. When user clicks on this button the values get added to the database. User can add maximum of 5 records.

Now my problem is I need to display these values on the form. Any idea how to go around this problem??