If InStr(sTotalRows, "TOP 100 PERCENT *", CompareMethod.Text) > 0 And Trim(sCondition = "") Then 'If db.Tables.Item(sTableName).Rows > 0 Then db.Tables.Item(sTableName).ExportData(objBCPExport) 'End If Else Dim sSelectCommand As String = "select " + sTotalRows + " from " + sDatabaseName + ".." + sTableName If Trim(sCondition) <> "" Then sSelectCommand += " WHERE " + sCondition End If 'Create a temporary view to hold data Try db.ExecuteImmediate("drop view Temp_View_For_Backup_001", SQLDMO.SQLDMO_EXEC_TYPE.SQLDMOExec_Default) Catch End Try db.ExecuteImmediate("create view Temp_View_For_Backup_001 as " + sSelectCommand, SQLDMO.SQLDMO_EXEC_TYPE.SQLDMOExec_Default) db.Views.Refresh() 'db.Views.Item("Temp_View_For_Backup_001").ExportData(objBCP) 'Export data to a file db.Views.Item("Temp_View_For_Backup_001").ExportData(objBCPExport) Try db.ExecuteImmediate("drop view Temp_View_For_Backup_001", SQLDMO.SQLDMO_EXEC_TYPE.SQLDMOExec_Default) Catch End Try End If

I had tried it with session and cookie, but still page is displaying... If I click any link in that page then exception will occure, it is not entering into the page load event when I type the page name in the address bar...

hi all How can I validate the Pages by using the base class, means... If Once I loged as an administrator then the page is 'admin.aspx', and after loging out if I loged as a user to page 'userpage.aspx' and in the address bar I enter the page as admin.aspx' instead of 'user.aspx' then browser is redirecting to admin page... I want to validate this to restrict access the admin page.... there I am using sessions for both pages from login pages seperately. how can I check the credentials in page load pls help me pls help me...... with the code regards Naushad

modified on Saturday, April 19, 2008 6:31 AM

can you help me?? How can I do it pls...

Anybody can help me, How can I get password from cookie while giving the user name.. (remember Password) pls send me the code also.. thank you Naushad