Category Archives: Database

This is all about database related Issues and Querys

Accessing controls of the Master Page from the Content Page

Accessing controls of the Master Page from the Content Page In my master page, i have a Label1 control. In the Page_Load event and if the page is not gone for postback event, in that situation, this Label1 is initialized with the day of the week. In this … Continue reading

Posted in Articles, Coding, Database, Programming | Tagged , , | Leave a comment

How to Add Colors to Alternative rows in GridView

We can add colors to alternative rows by doing like this suppose there exists 10 rows in a grid view  so we can do it in c# like this for (int i = 0; i <= 9; i++) { ActGridView.Rows(i).BackColor … Continue reading

Posted in Database, Interview Questions, Uncategorized | Tagged , , , | Leave a comment

Getting all checked checkboxes from Treeview in asp.net using c#

if i have a Treeview like this image and if i want to track all the lable names of check boxes which are checked into textbox like this then i have to write my code like this ArrayList al = … Continue reading

Posted in Articles, Database, Programming | Tagged , , | 2 Comments

Creating Sequence Numberin sql server 2008

if we have a Query to generate one auto number to one coulmn(Ack__no) when ever one row data is inserted we do it like this make the column as int data type in sql serevr 2008 then go to its … Continue reading

Posted in Articles, Database | Tagged , | Leave a comment

SQL SERVER – ACID

SQL SERVER – ACID ACID Followed When we r designing the databases and application architectures. Atomicity is an all -or-none Operations are performed in Transaction Consistency guarantees that a transaction never leaves your database in a half-finished state. Isolation keeps … Continue reading

Aside | Posted on by | Tagged , , | Leave a comment

auto paging in DataGrid visual studio 2003

hi friends you may have experienced that the datagrid is not showing you next set of records in a datagrid when u press “>” button so in order to make it work for you you have to write small set … Continue reading

Posted in Articles, Database, Programming | Leave a comment

creating user in asp.net sample

Please Note: Here iam writing description of code in comments // creating user into database sample using Vb.net Public Function Do_InsertUsrs(ByVal strConn As String, ByVal strDid As String, _ ByVal strUid As String, ByVal strPwd As String) As Integer Try … Continue reading

Posted in Database, Programming | 1 Comment