發表文章

目前顯示的是 2022的文章

從Excel輸入資料到Sql Server裡的Line break問題; Insert data from excel to Sql server may encounter line break replace problem.

 Excel : ctrl+J  press ctrl+f to open the find an replace box, press ctrl+J, you will see a dot at find what field. If  Ctrl + J  does not work, press the  Alt key, and type 0010  on the number keypad (do not use the numbers above the letters) SQL Server : CHAR ( 13 ) + CHAR ( 10 ) repace by this character. End

ASP Validation avoid postback

 I f you like to validate your fields on click of radiobutton or Checkboxes you need to manually add "CausesValidation="true" as by default it is disabled. <asp:RadioButtonList ID="rblNineteen1" CausesValidation="true" runat="server" AutoPostBack="true" OnSelectedIndexChanged="rblNineteen1_SelectedIndexChanged" RepeatDirection="Horizontal">