How can i get a Web Host for my ASP.NET application

Question

Hi,

I'm just about to finish a web application that i developed in ASP.NET. Can anyone help/explain to me how can i make my application run on the server(how to turn my application into a website). How do i get things like domain name,do i need filezilla,to name a few.
I'd also appreciate if u could give me any helpful links.


I'd also like to take this opportunity to thank all the c-sharpcorner memembers for replying to my question and helping me, i wouldn't have finished it if it weren't for u. THANK YOU ALL FROM THE BOTTOM OF MY HEART!!!...

Yours in Code
Choko,AD;

Answer 1

Gaurav,

Would like to understand few things.

Whether you want to delete the records in a table based on the count of rows (parameter)? irrespective of which 10 or 40 records to be deleted.

Below link has the sample stored procedure to delete the records (result of search query) from the table.

https://technet.microsoft.com/en-us/library/ms189634(v=sql.105).aspx

Hope it will solve your issue.

Answer 2

Another approach you can take is schedule the deletion of rows during a time when database is not used.

Example during Night.

Then you would not need to implement any extra logic.

But use this, only if deletion can be done later.

Answer 3

CREATE PROCEDURE spDeleteRecord
@DeleteBatchSize INT,
@DelayTime DATETIME
AS
BEGIN
SET NOCOUNT ON;
DECLARE @DeleteRowCount INT
SET @DeleteRowCount = 1

WHILE (@DeleteRowCount > 0)
BEGIN
BEGIN TRANSACTION
DELETE TOP(@DeleteBatchSize) SchemaTableName;
SET @DeleteRowCount = @@ROWCOUNT;
PRINT @DeleteRowCount;
COMMIT
WAITFOR DELAY @DelayTime
END
END
GO

Answer 4

https://sqlperformance.com/2013/03/io-subsystem/chunk-deletes