IN windows 7

-------------------------------------------------------
-------------------------------------------------------
1. open cmd
2. type: cd\
3. type: Del *.log /a /s /q /f

/a : singifies all.
/s : delete from all sub folders.
/q : bars from any prompts to ask for yes or no question.
/f : forcibly remove the files.
-------------------------------------------------------
-------------------------------------------------------

how to Replace null value with 0 Using C#

//here we suppose that objDataTable have data collection as table now access this //datatable object.

decimal j = 0;

 j = objDataTable.Rows[0]["Qty"] == DBNull.Value ? 0 : Convert.ToDecimal(objDataTable.Rows[0]["Qty"]);




NOTE :-
//if  DBNull.value is null then  "0 " else  "your code here") 
// ? = then
// : = else




Thank You
[Sumit Singh Shekhawat]

solution : ISNULL ( check_expression , replacement_value )

declare @a float;

set @a  = ISNULL((select SUM(CONVERT(FLOAT,quentity)) as qty  from Cutting 

                   WHERE jobno = '1' and contractorname = 'submit'),0)

-- here when quentity is null then it is return "0" else your calculate value;

Thank You

[Sumit Singh Shekhawat]

step by step explain how to add bak file into your sql server 2008


1- Click Start, select All Programs, click Microsoft SQL Server 2008 and select SQL Server Management Studio. This will bring up the Connect to Server dialog box. Ensure that the Server name YourServerName and that Authentication is set to Windows Authentication. Click Connect.

2- On the right, right-click Databases and select Restore Database. This will bring up the Restore Database window.

3- On the Restore Database screen, select the From Device radio button and click the … box. This will bring up the Specify Backup screen.

4- On the Specify Backup screen, click Add. This will bring up the Locate Backup File.

5- Select the DBBackup folder and chose your BackUp File.

6- On the Restore Database screen, under Select the backup sets to restore: place a check in the Restore box, next to your data and in the drop-down next to To database: select DbName.

7- Ok your done.