Bulelani Botman
Bulelani Botman
Explore posts from servers
CC#KPCKevin Powell - Community
PostsComments
CC#
Created by Bulelani Botman on 12/2/2024 in #help
How To Properly Catch An SMTPException & IOException
use linq queires, i'll do that thank you! but any code suggestions / examples i should include in the meantime?
33 replies
CC#
Created by Bulelani Botman on 12/2/2024 in #help
How To Properly Catch An SMTPException & IOException
i was thinking of doing that, updating my db whenever an email is sent. pretty rudimentary
33 replies
CC#
Created by Bulelani Botman on 12/2/2024 in #help
How To Properly Catch An SMTPException & IOException
that's why i need a proper internship / graduate programme
33 replies
CC#
Created by Bulelani Botman on 12/2/2024 in #help
How To Properly Catch An SMTPException & IOException
😭 , this is the best i could come up with, just basic stuff
33 replies
CC#
Created by Bulelani Botman on 12/2/2024 in #help
How To Properly Catch An SMTPException & IOException
yeah! it's some sort of notices for clients & the company doesn't have a senior nor a intermediate software who knows all the rights & wrongs of design patterns so the tasks are handled by interns & juniors who were also interns
33 replies
CC#
Created by Bulelani Botman on 12/2/2024 in #help
How To Properly Catch An SMTPException & IOException
the database is hosted on the server as well
33 replies
CC#
Created by Bulelani Botman on 12/2/2024 in #help
How To Properly Catch An SMTPException & IOException
to answer this question, i just want to purely handle the exceptions that may occur. if for instance it doesn't send, does my code with the retrying loop work for handling this error because you might find that the exception has to do with internet connection & it that case it doesn't send anything. if the exception is IO related, maybe the saved copy file doesn't get renamed, i don't mind but it should just save it & continue running. i just don't want to have an Error 500 pop out telling me it crashed
33 replies
CC#
Created by Bulelani Botman on 12/2/2024 in #help
How To Properly Catch An SMTPException & IOException
jesus! i'm not much of a senior dev or anything of that sort & where i'm interning, i'm pretty sure that they don't adhere to dev standards that the whole world does
33 replies
CC#
Created by Bulelani Botman on 12/2/2024 in #help
How To Properly Catch An SMTPException & IOException
😭 , good or bad?
33 replies
CC#
Created by Bulelani Botman on 12/2/2024 in #help
How To Properly Catch An SMTPException & IOException
I'm sorry. It makes sense when you know the business & all its rules
33 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
yes, i can do but with a limited number of records, 20K records max
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
okay, let me run & see what the error name is again so i can confirm
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
i am lost with this one, what does do?
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
i did implement the search feature but on another page it's just not suitable. i need to pull all those records whether i like it or not and the user just can't search because he doesn't know the information / doesn't have the info because this table is just filled with properties that are about 900K
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
yes, i was just telling him that the datatables plugin does pagination for me but my problem is just the connection timeout!
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
the datatable plugin has the pagination feature, if you are pulling lets say 10k records it will automatically do it for you but my issue is behind the scenes which is my SQL code. I am using 
SELECT * FROM LIS
SELECT * FROM LIS
which pulls all the columns and the records from this table and I get the connection timeout from MSSQL Server because pulling a lot of data at once & trying to display it
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
well, thank you for explaining this scenario. it absolutely helped me
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
ohhhh! i will try to use it. so, i assume when you press the next button in the view it will go back to the sql script and laod the next batch?
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
no, i think i will revert back to just searching for the specific data that a user wants & display that record rather than requesting all 900k records
59 replies
CC#
Created by Bulelani Botman on 3/19/2024 in #help
How Can I Pull 900K Records From My Database & Not Have The Page Slow Down When Rendering The Record
is there a sql script for using pagination?
59 replies