|
|
Hi Sylvester,
Thanks for your reply.
That link is interesting. But what I am trying to do is find all the logged into user to the Windows Domain/Active Directory - then display them as a wall board type web page. I have been searching for a while now and can't seem to find anything.
Regards,
Simon
|
|
|
|
|
Ref and Sample file download ~
Michael Sync's Blog ~ Getting All Users Information from Domain in ASP.NET
Step #1: Disable "Anonymous Access" of Virtual Directory
- Open Internet Information Service (IIS)
- Go to "Properties of your Virtual Directiory"
- Go to "Directory Security" tab
- Click "Edit" button of "Anonymous access and autherntication control"
- Uncheck "Anonymous access"
Step #2: Enabled impersonating in Web.Config
Add the tag below under in Web.config.
<p><identity impersonate="true"/></p>
Step #3: Adding "System.Directory.Services" dll as reference
<p>System.Directory.Services</p>
Open ASP.NET Web project. And add this dll to your project.
Step #4: Put the following code in PageLoad
Code for getting all users from domain
try
{
DirectorySearcher searcher=new DirectorySearcher();
string rootDSE=searcher.SearchRoot.Path;
DirectoryEntry entry = new DirectoryEntry(rootDSE);
DirectorySearcher dirSearcher = new DirectorySearcher(entry);
dirSearcher.Filter = "(&(objectClass=user))";
dirSearcher.SearchScope=SearchScope.Subtree;
dirSearcher.Sort.Direction=System.DirectoryServices.SortDirection.Ascending;
dirSearcher.Sort.PropertyName="cn";
ArrayList domainMembers = new ArrayList();
foreach(SearchResult result in dirSearcher.FindAll())
{
try
{
string strUserInfo = string.Empty;
DirectoryEntry de=result.GetDirectoryEntry();
if(de.Properties.Contains("sAMAccountName"))
strUserInfo = de.Properties["sAMAccountName"].Value.ToString();
domainMembers.Add(strUserInfo);
}
catch(Exception ex)
{
Console.WriteLine(ex.Message);
}
}
DataGrid1.DataSource = domainMembers;
DataGrid1.DataBind();
}
catch(Exception ex)
{
Console.WriteLine(ex.Message);
}
You might get the following errors.
- An operations error occurred
- The specified domain either does not exist or could not be contacted
If you are getting these errors above, please make sure that you have permission to access your domain.
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Thank you.
|
|
|
|
|
Hi All,
I got an issue with my application. My application has a datagrid with filter option
So placed dropdownlist in header template of datagrid and made data bound to dropdownlist. But i cant access the selectedIndexchange property of drop down list
In-line coding
~~~~~~~~~~~~~~
<asp:datagrid id="DataGrid1" runat="server" autogeneratecolumns="False"
-----some="" lines
within="" headertemplate
asp:dropdownlist="" autopostback="True"
onselectedindexchanged="DropDown_SelectedIndexChanged"
within="" headertemplate
---some="" lines
<="" asp:datagrid="">
Code Behind
~~~~~~~~~~~~~
Protected Sub DropDown_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)
'some code will run here
End Sub
Pls help me
Kannapiran
|
|
|
|
|
Please check ur posted code here.
pathan
|
|
|
|
|
hi
convert ur columns to template columns
like
<asp:templatecolumn headertext="Color Pattern" headerstyle-width="70px">
<headertemplate>
<asp:radiobutton id="clr0" runat="server" width="70px" text="Pattern" groupname="Color" font-name="Arial"
="" font-size="X-Small">
<itemtemplate>
<asp:label runat="server" text="<%# DataBinder.Eval(Container, "DataItem.ColorPattern") %>" width="70px">
<edititemtemplate>
<asp:textbox runat="server" text="<%# DataBinder.Eval(Container, "DataItem.ColorPattern") %>" width="70px">
|
|
|
|
|
<headertemplate>
<asp:dropdownlist id="ddl" runat="server">
|
|
|
|
|
Hi
Is it possible to manipulate data in MS Access using javascript.
(We can access excel using javascript)
If yes then please help me with the code
Regards
Karan
|
|
|
|
|
JavaScript - Working with Database
After reading this coding, you will know the following facts.
How to connect the database in JavaScript
How to use the ADODB.Recordset in JavaScript
As I already put the details comments in coding, I hope you will find it useful.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<script type="text/javascript">
<!–
var adOpenDynamic = 2;
var adLockOptimistic = 3;
/* Path of database.
If you put the database "Inventory.mdb" in different location,
you need to specify the correct path to this variable.
But When you are running the webpage from Browsers only,
you should use this keyword "window.location.pathname" for getting
the current location. But If you are using FrontPage,
you hav to specity the static path.
*/
var strDbPath = "C:\\JavaScript Database\\Inventory.mdb";
/*
Here is the ConnectionString for Microsoft Access.
If you wanna use SQL or other databases, you hav
to change the connection string..
eg: SQL => var conn_str = "Provider=sqloledb; Data Source=itdev;" +
"Initial Catalog=pubs; User ID=sa;Password=yourpassword";
*/
var conn_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strDbPath;
function getAdoDb(strAdoType){
if (window.ActiveXObject){
return new ActiveXObject(strAdoType);
}
else{
return new ActiveXObject(strAdoType);
}
}
function showReports(){
try{
var strHtml ="";
strHtml += "<table cellpadding=0 cellspacing=0 border=1 width=500px align=center>";
strHtml += "<tr ><td align=center colspan=4><b>Stock List</b></td></tr>";
//Database Connection
var conn = getAdoDb("ADODB.Connection");
conn.open(conn_str, "", "");
//Recordset
var rs = getAdoDb("ADODB.Recordset");
strQuery = "SELECT StockID,StockName,ReOrderLevel,IsActive FROM Stocks";
rs.open(strQuery, conn, adOpenDynamic, adLockOptimistic);
if(!rs.bof){
rs.MoveFirst();
while(!rs.eof) {
strHtml += "<tr>";
strHtml += " <td width=\"10px\">" + rs.fields(0).value + "</td>";
strHtml += " <td width=\"50px\">" + rs.fields(1).value + "</td>";
strHtml += " <td width=\"10px\">" + rs.fields(2).value + "</td>";
strHtml += " <td width=\"5px\">" + rs.fields(3).value + "</td>";
strHtml += "</tr>";
rs.MoveNext();
}
}
else{
//No Records.
strHtml += "<tr colspan=4><td align=center><font color=red>No Records.</font></td></tr>";
}
conn.close();
strHtml += "</table>";
document.write(strHtml);
}catch(ex){
alert(ex.message);
}
}
//–>
</script>
<title>Stock List</title>
</head>
<!–<body onload="show_menu()">
<div id="main" />–>
<body>
<script language="JavaScript">
showReports();
</script>
</body>
</html>
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
|
|
|
|
|
And if the user isn't running IE?
|
|
|
|
|
these are the objects you can use to connect database.
=====================================================
this supports both IE and NNav
DbPool Constructors
Name MSIE NNav Notes
DbPool() - -
DbPool Methods
Name MSIE NNav Notes
connect() - -
connected() - -
connection() - -
disconnect() - -
majorErrorCode() - -
majorErrorMessage() - -
minorErrorCode() - -
minorErrorMessage() - -
storedProcArgs() - -
toString() - -
DbPool Properties
Name MSIE NNav Notes
prototype - -
this link will help you
=======================
http://docs.sun.com/source/816-6410-10/dbpool.htm[^]
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
|
|
|
|
|
|
Thanks for adding my link. Scott.
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Thank you.
|
|
|
|
|
You're welcome. Just trying to be helpful.
|
|
|
|
|
Hai to all,
I am using crystalreports Version7 in my VS2003(which supports crystalreports version9 ),But lower version can be used in the upper version.
Here i am getting problem when i am using report's Design part from the crystal report and the rest(like dataset and sqlquery for the report)are in .net/vbnet itself.
Here when i am debugging this,it si giving an error like "Logon Failed",I have checked the DBConnection also.
In my view there is no problem with the crystal report's Version. I am using SqlServer as backend.
Why it is giving error,For some reports it is working.
Can anybody give me the reason???
Thanks in advance
Regards,
kissy
kissy
|
|
|
|
|
Welcome to developing with Crystal Reports, the worst reporting application ever!
nothing
|
|
|
|
|
provide your database info
//set the database loggon information.
//**Note that the third parameter is the DSN name
// and not the Database or System name
reportDocument.SetDatabaseLogon("pchitriv", "Windows2000",
"TestDB_DSN", "testDB", false);
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
|
|
|
|
|
I need the help for printing the web page without clicking any button
|
|
|
|
|
you need an event to call the print function.
Thomas
|
|
|
|
|
|
You can call the Print() Function by declaring it, in the onLoad attribute of the Body Tag .
Regards,
Suresh Dayma
Everything Is Possible!
|
|
|
|
|
Hi,
need help with the following code, the intention is for my server-side web app to open a doc held on the server's drive using a clients external native program (ie. notepad for a .text doc).
my code so far:
(previous page redirects to here after setting the file path as the session 'FullFilePath')
FileStream theFile = File.Open(Session["FullFilePath"].ToString(), FileMode.Open);
Response.AppendHeader("content-disposition", "attachment;filename="+Session["FullFilePath"].ToString());
Response.Write(Session["FullFilePath"].ToString());
long filesize = theFile.Length;
byte[] getContent = new byte[filesize];
Response.BinaryWrite(getContent);
Response.Flush();
Response.Close();
theFile.Close();
theFile.Dispose();
compiled my site which was all fine
but then get server error in my app when i browse to it after its set live.
'Specified argument was out of the range of valid values.
Paramater name: offset'?
but I can't see that anythings wrong?
any thoughts at all?
|
|
|
|
|
What line does the code on. The other response.write of the filename might also be giving you a problem...
|
|
|
|
|
it seems to be on the filestream line, which made me think that the file path was bad, but then i response.write displays the path as ok, though the system may think otherwise
|
|
|
|
|
ok, with lots of playing I've narrowed it down to the
'Response.BinaryWrite(getContent);'
It took me a while to get that bit to what I thought was right, and taking it out lets the page work, but it just tries to open a new IE window with the redirected page in it rather than the file that I'm trying to open, I'm a little stumped as this is al new to me.
|
|
|
|