string formattinf to round off 4 decimal values

double t="o.00005";
  string aa = String.Format("{0:0.#####}", t);

Display 4 decimal place in double.

double a = 23.22;
           string msg = string.Format("E format: {0:N4}", a);
           MessageBox.Show(msg);

printing in sql

  Print 'schedule Id value is : ' + convert(varchar(20), @test_id) +    
          ':   @task Id value is : ' + convert(varchar(20), @mycount)

creating Html table dynamically including header in (xhtml)

creating Html table dynamically including header in
(xhtml)

UI

  <asp:TableRow ID="tdrCTC_CTCDetails_GrossIncomeAmt" runat="server" Width="794px">
                    <asp:TableCell Font-Size="XX-Small">
                        <table id="tblCTC_Data" runat="server">
                            <tr id="tdrCTCData_Header">
                                <td runat="server">Description fo Class Shares
                                </td>
                                <td runat="server">(a) Immediately before 1 January 2011
                                </td>
                                <td runat="server">(b) Where the company became a resident since 1 January 2011
                              </td>
                            </tr>
                        </table>
                    </asp:TableCell>
                </asp:TableRow>


aspx page

 tblCTC_Data.Rows.Clear();
            HtmlTableRow headerRow = new HtmlTableRow();
            headerRow.Cells.Add(new HtmlTableCell() { InnerText = "Description fo Class Shares" });
            headerRow.Cells.Add(new HtmlTableCell() { InnerText = "(a) Immediately before 1 January 2011" });
            headerRow.Cells.Add(new HtmlTableCell() { InnerText = "(b) Where the company became a resident since 1 January 2011" });

            foreach (HtmlTableCell c in headerRow.Cells)
            {
                c.Style.Add("font-weight", "bold");
            }
 tblCTC_Data.Rows.Add(headerRow);


  if (_rootCustomer.ReturnDetail.CorporateIncomeTaxReturn.CompanyDetails.ContributedTaxCapitalDetails.Count > 0)
            {
//xData of type class //CorporateIncomeTaxReturnStructureCompanyDetailsContributedTaxCapitalDetail //variable
                foreach (CorporateIncomeTaxReturnStructureCompanyDetailsContributedTaxCapitalDetail xDataTable in
                _rootCustomer.ReturnDetail.CorporateIncomeTaxReturn.CompanyDetails.ContributedTaxCapitalDetails)
                {

                    HtmlTableRow newRow = new HtmlTableRow();
                    newRow.Cells.Add(new HtmlTableCell() { InnerText = xDataTable.ShareClassDescription.ToString() });
                    newRow.Cells.Add(new HtmlTableCell() { InnerText = xDataTable.Before1January2011Amt.ToString() });
                    newRow.Cells.Add(new HtmlTableCell() { InnerText = xDataTable.Since1JanuaryAmt.ToString() });
                }

            }

Find a specific column entry in an unknown table in a database

DECLARE
   @TotalRows   int,
   @Counter     int,
   @TableName   varchar(50),
   @ColumnName  varchar(50),
   @FieldValue  varchar(250),
   @SQLCommand  nvarchar(1000),
   @ValueToFind varchar(100)


-->
SET @ValueToFind = 'Test case'
-->


DECLARE @MyTable table
   (  RowID      int IDENTITY,
      TableName  varchar(50),
      ColumnName varchar(50)
   )


CREATE TABLE #FoundTable
   (  RowID      int IDENTITY,
      Tablename  varchar(50)
   )



INSERT INTO @MyTable
   SELECT
      TABLE_NAME,
      COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE DATA_TYPE IN ( 'char', 'varchar', 'nchar', 'nvarchar', 'text', 'ntext' )


SELECT
   @TotalRows = @@ROWCOUNT,
   @Counter   = 1


WHILE ( @Counter <= @TotalRows )

 
   BEGIN
  SELECT
         @TableName = TableName,
         @ColumnName = ColumnName
      FROM @MyTable
      WHERE RowID = @Counter

     
      SET @SQLCommand = 'IF EXISTS ( ' +
                        'SELECT 1 FROM [' + @TableName + '] WHERE [' + @ColumnName + '] LIKE ''%' + @ValueToFind + '%'' ' +
                        ' )' +
                        'INSERT INTO #FoundTable ' +
                        '   SELECT ''' + @TableName + '(' + @ColumnName + ')'''
EXECUTE sp_executesql @SQLCommand
     
      SET @Counter = ( @Counter + 1 )

 
   END


SELECT * FROM #FoundTable


DROP TABLE #FoundTable

Delete windows service

sc delete ServiceName