Need help impersonating a user - ASP.NET Discussion Boards

Hi Everyone,

I need help on my asp:menu which is bind to hierarchichal data source. It has no error but it's not displaying anything. This is my first time to use asp.net and I have spent a lot of time on this task. I know there are glitches in my classes and interfaces but just don't know what code I should write on it. Please help me. See discussion below.

Thanks,
Neil

I have a class called menuClass and class collection called menuCollection. menuCollection is populated correctly through a stored procedure. I could bind this to a datalist for testing purposes and it would display its content. The menuclass has String members menuid, parentid and title. The fourth member is a list type IList. Am not sure of the last member if it's necessary but based on my research it will be used for the GetChildren function.

To bind my menu item, I used the logic as follows:
dsView = New SQLDataSourceControlView(mnuTempItems)
mnuItems.DataSource = dsView.Select()
mnuItems.DataBind()

where mnuTempItems is an instance of class menuCollection.

See my other classes and interfaces needed for HierarchicalDataSource:

Imports System
Imports System.Collections
Imports System.IO
Imports System.Runtime.InteropServices
Imports System.Security.Permissions
Imports System.Web
Imports System.Web.UI
Imports System.Web.UI.WebControls

Namespace DrinksWebSite.Menu

<aspnethostingpermission(securityaction.demand,
level:=aspnethostingpermissionlevel.minimal)> _
Public MustInherit Class SQLDataSourceControl
Inherits HierarchicalDataSourceControl

Public Sub New()
End Sub

' Return a strongly typed view for the current data source control.

Private view As SQLDataSourceControlView = Nothing

Protected Overloads Function GetHierarchicalView(ByVal viewPath
As Menu.MenuCollection) As HierarchicalDataSourceView
If view Is Nothing Then
view = New SQLDataSourceControlView(viewPath)
End If
Return view
End Function 'GetHierarchicalView

Protected Overrides Function CreateControlCollection() As ControlCollection
Return (New ControlCollection(Me))
End Function 'CreateControlCollection

End Class 'SQLDataSourceControl

' The SQLDataSourceControlView class encapsulates the
' capabilities of the FileSystemDataSource data source control.

Public Class SQLDataSourceControlView
Inherits HierarchicalDataSourceView

Private _sqlCollection As MenuCollection

Public Sub New(ByVal viewPath As MenuCollection)
_sqlCollection = viewPath
End Sub 'New

Public Overrides Function [Select]() As IHierarchicalEnumerable
Dim fshe As New HierarchicalData(_sqlCollection)
Dim fsi As menuClass

For Each fsi In fshe
fshe.Add(New HierarchicalDataElement(fsi))
Next fsi
Return fshe

End Function 'Select
End Class 'FileSystemDataSourceView

Public Class HierarchicalData
Inherits ArrayList
Implements IHierarchicalEnumerable

Private data As MenuCollection

Public Sub New(ByVal values As MenuCollection)
data = New MenuCollection
For Each value As menuClass In values
data.Add(New HierarchicalDataElement(value))
Next
End Sub

Public Overridable Function GetHierarchyData(ByVal
enumeratedItem As
Object) As IHierarchyData _
Implements IHierarchicalEnumerable.GetHierarchyData
Return CType(enumeratedItem, IHierarchyData)
End Function 'GetHierarchyData

End Class 'HierarchicalData

Public Class HierarchicalDataElement
Implements IHierarchyData
Public _data As menuClass = Nothing

Public Sub New(ByVal obj As menuClass)
_data = obj
End Sub 'New

Public Overrides Function ToString() As String
Return _data.title
End Function 'ToString

' IHierarchyData implementation.
Public Overridable ReadOnly Property HasChildren() As Boolean _
Implements IHierarchyData.HasChildren
Get
Dim children As Menu.MenuCollection
children = GetChildren()
Return children.Count > 0
End Get
End Property

' returns the title of the menu

Public Overridable ReadOnly Property Path() As String _
Implements IHierarchyData.Path
Get
Return ToString()
End Get
End Property

Public Overridable ReadOnly Property Item() As Object _
Implements IHierarchyData.Item
Get
Return _data
End Get
End Property

Public Overridable ReadOnly Property Type() As String _
Implements IHierarchyData.Type
Get
Return _data.GetType().ToString()
End Get
End Property

Public Overridable Function GetChildren() As
IHierarchicalEnumerable_
Implements IHierarchyData.GetChildren
Dim parentContainer As New HierarchicalData(_data.List)
Dim children As New MenuCollection
Dim objMenu As menuClass
For Each objMenu In parentContainer
children.Add(objMenu)
Next objMenu

Return children
End Function 'GetChildren

Public Overridable Function GetParent() As IHierarchyData _
Implements IHierarchyData.GetParent
Return New HierarchicalDataElement(_data)
End Function 'GetParent
End Class 'HierarchicalDataElement

End Namespace

Cheers,
Neil

hi.
how can I encrypt my password? what type must I select in sqlserver?
how can I encrypt & decrypt QuesryString ?
some times I see a QuesryString like this : zHtkKwwebwYoekpwner43

mehran asghari

Check: Keeping Passwords in a Database Secure[^]

Hesham A. Amin
My blog

mohandesmehran wrote:
how can I encrypt & decrypt QuesryString ?

Encryption password and "encrypt & decrypt QuesryString" are two different questions. As the first question is already answered, I will tell you about second question.. You can use URL-rewriting with encryption class for encrypting /decrypting the querystring...

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."

Encrypt and Decrypt Query String[^]

- Regards -
JON

Life is not measured by the amount of breaths we take, but by the moments that take our breath away.

Hello,

I made a Calculator usercontrol and a Time custom control and added them to a DeclarativeCatalogPart.When I run the application if I try to switch to the Catalog display mode using the web part manager I get an Argument Exception:
"The specified display mode is currently disabled on this page. Make sure personalization is enabled for the current user.
Parameter name: value".

Every thing looks correct to me Confused | :confused:

.Could any one help me to solve this problem?.

I am too late but i will never give up

Please help!!
I saw the C# code on your page for
pagebreakrender. I'd like to
redisplay the header row of my gridview on
the top of each page when I print.
How do I do this in VB?

I am developing a web application of which I am scanning all computers in our intranet. During the scan of each computer, I am attempting to determine if they have certain services installed or running so I will need to execute these as an administrator. I am trying to impersonate the domain administrator in the web.config and not having much luck. Here is what I put in the web.config file:

<system.web>
<identity impersonate ="true" userName ="DOMAIN\Admin" password ="password"/>

during my initialization of the web app, I am connecting to a SQL Server 2005 express database file and deleting records in case there were any left from the previous run. My code is as follows:

Dim conn As New System.Data.SqlClient.SqlConnection
Dim cmd As New System.Data.SqlClient.SqlCommand
Dim strDate As String = Now.AddHours(-3).ToString
With conn
.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings("NetworkConnectionString").ConnectionString
.Open() 'Failed Line
End With

When I have the line in the web config shown above, I get an error on the failed line in code that says:

Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.

Based on this message, I would assume that I need to have a profile for the domain admin on the machine running the web server, which it has. Right now, the web server is on my local machine but will be eventually installed on our company's web server but I want to get this working before copying it up. All code in the web app is written in VB.NET.

If anyone has any suggestions, I would appreciate it very much. This is my first attempt at impersonation and the code I've tried to implement was from web sites specific in ASP.NET/VB.NET.

Thanks for any help!

David

Just for clarification, the code above:

Dim conn As New System.Data.SqlClient.SqlConnection
Dim cmd As New System.Data.SqlClient.SqlCommand
Dim strDate As String = Now.AddHours(-3).ToString
With conn
.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings("NetworkConnectionString").ConnectionString
.Open() 'Failed Line
End With

works when there is NO impersonation line in the web.config file. It only fails when I have the "identity" in the web config file.

David

You have remembered to switch off Enable anonymous logins on the website haven't you?

Deja View - the feeling that you've seen this post before.

My blog | My articles

i want to validate data first. if the data is valid then i want ConfirmButtonExtender message like ARE YOU SURE YOU WANT TO ADD?
HOW CAN I DO IT?
ANY HELP WILL BE GREATFUL

Sarfarj Ahmed

Hi Sarfarj

Try this.
If you are using Ajax, it will work for you.

ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "myScript", "alert(\"The record can not be deleted\");", true);

Write any Javascript you want in it.
I believe you need for Confirm, so use Confirm("Are you sure?") instead of Alert. Should work for you.

Cheers

Menon

Hi Menon
Thanks for your quick reply
what i want to do is, details is follows

1. I have a button name btnSubmit on my page
2. when you click btnSubmit then it will check Text, DropdownList etc value
3. if the values are right then it will ask me wheather i want to submit this value are not?
4. if i click ok button then it will add data into server
5. if i click no then it show me message which will tell me, data wasnt added

now could you please tell me the best solution of this
any help and example will be greatful

waiting for ur reply
thanks in advace

Sarfarj Ahmed

javascript function something like:

<br />
function validateAndSubmit()<br />
{<br />
// validate the dropdownlist // I am assuming first value in dropdown list is not valid value<br />
var validFalg = true;<br />
if(document.getElementById(dropdownlist).selectedIndex == -1 || document.getElementById(dropdownlist).selectedIndex == 0)<br />
{<br />
// no value selected so set the validflag to false;<br />
validFlag = false;<br />
}<br />
if(validFlag)// valid values<br />
{<br />
var con = confirm("Are you sure you want to...");<br />
if(con)// user clicked yes<br />
return true; // submit the form, on server side save the data and display message in any div<br />
else// user clicked no/cancel<br />
{<br />
alert('data not saved');<br />
return false;<br />
}<br />
else//invalid values<br />
{<br />
alert('please select valid values');<br />
return false;<br />
}<br />
}<br />
}<br />
<br />

call the above function on button's client click like
asp:button id="mybtn" runat="server" onCLientClick="javascript:return validateAndSubmit()"

-----

HI Bhatti
thank you very much for your reply
i have done my field checking after that inside btn event i put

Protected Sub ibtnAddNewBooks_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles ibtnAddNewBooks.Click<br />
        Dim _CheckingForm As Integer = CheckingFormForAddingBooks()<br />
<br />
        If Not _CheckingForm = 0 Then<br />
            ibtnAddNewBooks.Attributes.Add("OnClick", "javascript:return confirm('Are you sure you want to add this book informations?');")<br />
<br />
       // now i want to put the condition like<br />
       // if i click ok button then it will be added into database<br />
       // else data hasnt been added <br />
       // please help me here<br />
        <br />
        Else<br />
            lblmessage.text= "Please Check Your Input Value"        <br />
<br />
        End If<br />
    End Sub

but the problem is

Sarfarj Ahmed

Sarfraj you and I are not on same page. The code I suggested was to validate the form on the client using javascript, not on the server. From your code it seems that you are validating the form on the server side. If you want to do this way, I'll suggest the following:

Add a panel in the aspx page like this below lblmessage:

<asp:panel id="pnlYesNo" runat="Server" visible="false">
<asp:button runat="server" id="btnYes" text="Yes" />
<asp:button runat="server" id="btnNo" text="No" />
</asp:panel>

change your code as under:

If Not _CheckingForm = 0 Then
pnlYesNo.visible = true
lblmessage.text = "Are you sure you want add this book information?"
else
lblmessage.text= "Please Check Your Input Value"
pnlYesNo.visible = false
end if

Now in click event of No button, you will hide the panel like:

Protected Sub btnNo_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles btnNo.Click
pnlYesNo.visible = false;
lblmessage.text ="whatever you want"
End Sub

and in click event of Yes do this:

Protected Sub btnYes_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles btnYes.Click
// validate the form again in case user might have changed something
Dim _CheckingForm As Integer = CheckingFormForAddingBooks()

If Not _CheckingForm = 0 Then
// save the book info, display the message and clear the form
Else
// invalid values so display the message
lblmessage.text= "Please Check Your Input Value"
End If
End Sub

----- code for my previous solution

And, if you want to follow my previous code then you have to do this:

In pageload function do this:
<code>

ibtnAddNewBooks.Attributes.Add("OnClick", "javascript:return validateAndSubmit();")

</code>

now whatever you are doing in CheckingFormForAddingBooks function you will have to convert it to javascript and do it validateAndSubmit function. And on the server side in ibtnAddNewBooks_Click function you will save the books and display successful message.

-----

Hi all,

I am building a class where I have a sub calling my.settings like this:

Private Sub New()
oConn = New SqlConnection("Provider=" & My.settings.provider & ";" & "Datasource=" & _ My.settings.datasource & ";")
End sub

it has produced an error even though I am sure It shouldn't.
Does anyone have an idea as to how I can treat this.
Thanks

JMUREKEZI wrote:
Does anyone have an idea as to how I can treat this.

Ignore it, because without the showing the error you are getting there is nothing that can be done.

only two letters away from being an asset

Hi,

It is part of a class that is used to create connection to the database.
Anyway thanks I figured out how to do it using

Dim esetting As ConfigurationSettings
Dim appSet As NameValueCollection
appSet = settings.AppSettings()
connectionString = appSet.Item("ConnectionString")

Hi All,
I have need to execute a SSIS package from the button click event in the Repeater. I am sending the e.CommandArgument which will use in the SSIS package.

Thanks in advance.

Sri..

Execute SSIS project from ASP.NET page

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."

I tried using the Microsoft help, I am not really a decent programmer, the website we already have, is setup to function under an access database, we hired a SQL guy to bulid us the SQL tables we needed in SQL, trying to update the Webconfig to talk to the SQL server, I have failed at.

Is what I have tried to get my website to talk to the sql

<connectionStrings>
Line 17: <add name="DIMHRSDataCon" connectionString="Server=HOODNBOTC458827;Database=DIMHRS;Trusted_Connection=Yes;"/>
Line 18: </connectionStrings>

Here is our old webconfig file talking to the access database:

<appSettings>

<add key="DIMHRSDataCon" value='Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data Source=C:\Projects\DIMHRS\Database\DIMHRS.mdb;'/>
<add key="DIMHRSTreeviewCon" value='Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data Source=C:\Projects\DIMHRS\Database\PA.mdb;'/>

</appSettings>

Can anyone tell me how to setup my webconfig file? So I can work on the SQL server? Using Visual Studio 2003, .NET 1.1

Ibuprofen wrote:
Webconfig + SQL Server 2003

AFAIK, There is no SQL Server 2003.

Ibuprofen wrote:
<connectionstrings>
Line 17: <add name="DIMHRSDataCon" connectionstring="Server=HOODNBOTC458827;Database=DIMHRS;Trusted_Connection=Yes;">
Line 18:

If you are using .NET 1.1, there is no connectionstrings tag so you should probably use appSetting for connectionstring of SQL

Example :

<br />
<appSettings><br />
<add key="DIMHRSDataCon" value='Server=HOODNBOTC458827;Database=DIMHRS;Trusted_Connection=Yes;'/><br />
</appSettings>

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."

Sorry, I meant to type SQL Server 2000 and Visual Studio 2003. Thank you, that worked for me.

I am generating reports using the Report Viewer. I have 9 columns.
My problem is that the report is splitting into 3 when it is generated as a PDF,
it seems that only 4 columns is displayed on a page.

Anyone know how to fix this?
macca