Microsoft Developer Network > 포럼 홈 > SharePoint - InfoPath Forms Services > how to add checkbox in repeating table?
질문하기질문하기
 

질문how to add checkbox in repeating table?

  • 2009년 7월 3일 금요일 오전 3:43barrydd 사용자 메달사용자 메달사용자 메달사용자 메달사용자 메달
     
    I need add checkbox or radio option control in repeating table, every row has one check box,I already added a field with checkbox type in repeating group, but if I binding the repeating table to a sql table, the checkbox disappear automatically, so how to implement this ?? binding a table in sql server onto repeating table and also reserve the check box in every row

모든 응답

  • 2009년 7월 3일 금요일 오전 4:12Clayton Cobb 사용자 메달사용자 메달사용자 메달사용자 메달사용자 메달
     
    After making your data connection to the SQL table, just drag that repeating group from the secondary data source onto your canvas, and it will make its own repeating table with the appropriate controls.
    SharePoint Architect || My Blog
  • 2009년 7월 3일 금요일 오전 4:29Shobhit Bhatnagar 사용자 메달사용자 메달사용자 메달사용자 메달사용자 메달
     
    Hi, Can u explain wat exactly your requirement is...you can display checkboxes based on some choice field from Database, or u can create an independent check box on the infopath form too...??
  • 2009년 7월 3일 금요일 오전 5:09barrydd 사용자 메달사용자 메달사용자 메달사용자 메달사용자 메달
     
    I need to create an independent check box in every row of repeating table which binding to a sql table.
  • 2009년 7월 3일 금요일 오전 5:29Clayton Cobb 사용자 메달사용자 메달사용자 메달사용자 메달사용자 메달
     
    I need to create an independent check box in every row of repeating table which binding to a sql table.

    Did you try what I said?  You shouldn't have to create any checkboxes.  The data element from the SQL data connection should automatically create a checkbox unless the data type is not boolen, but you can still change the control to a checkbox but will have to translate the SQL data into some sort of Checked and Cleared values.
    SharePoint Architect || My Blog
  • 2009년 7월 3일 금요일 오전 6:46barrydd 사용자 메달사용자 메달사용자 메달사용자 메달사용자 메달
     
    I need to create an independent check box in every row of repeating table which binding to a sql table.

    Did you try what I said?  You shouldn't have to create any checkboxes.  The data element from the SQL data connection should automatically create a checkbox unless the data type is not boolen, but you can still change the control to a checkbox but will have to translate the SQL data into some sort of Checked and Cleared values.
    SharePoint Architect || My Blog

    Yes, Cobb, I already try what you said, but actually I don't want to change any control type to checkbox which binded to any column in SQL table, I want to add a additional repeating checkbox in every row
  • 2009년 7월 3일 금요일 오전 8:49Clayton Cobb 사용자 메달사용자 메달사용자 메달사용자 메달사용자 메달
     
    You have stated twice, "binding to a sql table."  This is the first time you clearly specified that your table ONLY is bound to the SQL table and that you want to add your own extra checkbox in the main data source.  It's not easy to combine both ine one repeating table.

    What makes you and some others address me as Cobb when that's my last name?  Is that customary in some cultures? 
    SharePoint Architect || My Blog
  • 2009년 7월 3일 금요일 오전 9:21Shobhit Bhatnagar 사용자 메달사용자 메달사용자 메달사용자 메달사용자 메달
     
    Hi,

    When u add a checkbox control in your repeating table, then for each row that displayed on the  form when the data is loaded...the checkbox is repeated for each row....i dont knw whether this answers your question or not....but that is wat i think u want to knw...just add a checkbox to a column of a table n u r through....

    Regards
    Shobhit Bhatnagar