Updating column values at once in sqlserver

Leave a comment


Here the query looks like:

Update Tablename set[column name]=value;

example : Update employee_details set[salary]=20000;

Advertisements

Place vb and cs files together in App_Code folder

5 Comments


Sometimes while using class files in asp.net we will face the situation where we want to place both Vb and Cs class files.The simple solution is:

1) First make two folders in App_code with foldernames as 1)CSCode 2)VBCode

2) Modify the Web.conig with following code:

    <compilation debug="false">
    <codeSubDirectories>
        <add directoryName="VBCode" />
        <add directoryName="CSCode" />
    </codeSubDirectories>
</compilation>

Thats all.....

Get the recent row entered in SQL

Leave a comment


We can select the recent row enrtered by using the query below.
suppose the table name is employee;
then.

select * from employee where rowid=(select max(rowid) from employee).

This works fine because rowid is assigned for each and every record and in accending order. So the recent record’s rowid is the man (rowid). Please send feedback with any concern
or

You can check it with the help ofSCOPE_IDENTITY( ) function in SQL server 2000 or 2005.

Gridview with fixed header

Leave a comment


Skin:

1 <asp:GridView SkinID=“skinGridView” runat=“server” BackColor=“White” BorderColor=“#DEDFDE” BorderStyle=“Solid” BorderWidth=“1px” CellPadding=“4” ForeColor=“Black” GridLines=“Vertical”>
2 <HeaderStyle BackColor=“#D7D4D4” Font-Bold=“True” ForeColor=“#316AC5”/>
3 <RowStyle BackColor=“#FFFFFF” ForeColor=“#333333”/>
4 <AlternatingRowStyle BackColor=“#F7F7F7” ForeColor=“#333333” />
5 <HeaderStyle CssClass=gridHeader />
6 </asp:GridView>

CSS:

1    .gridHeader
2    {
3         position:relative;
4         top:auto;     
5    }

%d bloggers like this: