Provisioning AD users

//Provisioning AD Users from C#
Include directory services from ADD reference

protected void Button1_Click(object sender, EventArgs e)
{
string ldapPath = "LDAP://OU=PMPMIIS,OU=Fabrikam,DC=fabrikam,dc=com";
string status = ProvisonADUser(TextBox1.Text, TextBox2.Text, ldappath);
}


string ProvisonADUser(string username, string password, string ldapPath)
{
try
{
string oGUID = string.Empty;
DirectoryEntry dirEntry = new DirectoryEntry(ldapPath);
DirectoryEntry newUser = dirEntry.Children.Add("CN=" + username, "User");
newUser.Properties["samAccountName"].Value = username;
newUser.CommitChanges();
oGUID = newUser.Guid.ToString();
newUser.Invoke("SetPassword", new object[] { password });
newUser.CommitChanges();
dirEntry.Close();
newUser.Close();
string Success = "User Provisioned Successfully";
return Success;
}
catch (System.DirectoryServices.DirectoryServicesCOMException E)
{
string Error = E.Message;
return Error;
}
}

Script to excute Javascripts Alert function in ASP.NET with C#

//Script to excute Javascripts Alert function in ASP.NET with C#
// button_CLick(objects sender,Eventargs e)
// {
// string val=Textbox.text;
// if(val=="Navyanth")
// {
// alert("Navyanth")
// }
// else
// {
// alert("Others")
// }
//
// public void alert(string msg)
// {
// string str = "write script1 langauge equal java script1 " "+" " write alert(' " + msg+" ');";
// RegisterStartupScript("ds",str);
// }

ps: Remove write

Populating data into DataGridview of Windows Forms in .NET 2.0

Populating data into DataGridview of Windows Forms in .NET 2.0
////string select = "select Meaning,Examples from "+tablename+" where Word="+"'"+Searchword+"'";
////SqlConnection conn = new SqlConnection(ConnString);
////conn.Open();
////SqlCommand cmd1 = new SqlCommand(select,conn);

//SqlDataAdapter adap = new SqlDataAdapter(cmd1);
//DataTable dt = new DataTable();
//dt.Locale = System.Globalization.CultureInfo.InvariantCulture;
//adap.Fill(dt);
//bndSource.DataSource = dt;
//dgvSrchWord.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
//dgvSrchWord.ReadOnly = true;
//dgvSrchWord.DataSource = bndSource;

//conn.Close();

Usage of Sql Reader in C#

Connection string is been added n the App setting of app.config file
//string select = "select Meaning,Examples from "+tablename+" where Word="+"'"+Searchword+"'";
//SqlConnection conn = new SqlConnection(ConnString);
//conn.Open();
//SqlCommand cmd1 = new SqlCommand(select,conn);
////SqlDataReader dr = cmd1.ExecuteReader();
////while (dr.Read())
////{
//// string value = dr[0].ToString();
//// //txtMeaning.Text = dr[1].ToString();
//// MessageBox.Show(value);

////}

To get single character from String in C#

//To get single character from String in C#
// byte[] m = Encoding.Unicode.GetBytes("chetan@123");
//
// string n = Encoding.Unicode.GetString(m, 0,2);
// Console.WriteLine(n);

Use of Streamwriter/Reader and Arraylist in C#

"//Use of Streamwriter/Reader and Arraylist in C#
StreamWriter exportfile = new StreamWriter("C:\\temp\\ExportFile.txt");
//
//
ArrayList mylist = new ArrayList();

StreamReader sr = new StreamReader("C:\\temp\\shadow");
string line;
while((line=sr.ReadLine())!= null)
{
mylist.Add(line);
}


int count = mylist.Count;

string[] userarray;
ArrayList username = new ArrayList();


for(int i=0; i {
string users = mylist[i].ToString();
userarray= users.Split(Convert.ToChar(":"));
username.Add(userarray[0].ToString());

}
for(int j=0; j {
exportfile.WriteLine("objType:person");
exportfile.WriteLine("givenName:" + username[j].ToString());
exportfile.WriteLine("name:" + username[j].ToString());
exportfile.WriteLine("userid:" + username[j].ToString());
exportfile.WriteLine("displayName:" + username[j].ToString());
exportfile.WriteLine();

}
// Console.ReadLine();
exportfile.Close(); "

Creating Ascii text file from C#

//Creating Ascii text file from C#
// byte[] messagebyte = Encoding.ASCII.GetBytes("naviputti@321");
// FileStream fwrite = new FileStream("C:\\temp\\na.txt",FileMode.Create);
//
// //fwrite.WriteByte((byte)messagebyte.Length);
// fwrite.Write(messagebyte,0,messagebyte.Length);
// fwrite.Close();

To get windows authenticated username

imports System.Security

Dim authUserName As String
Dim aspUserName As String
'authUserName = User.Identity.Name
'aspUserName = Principal.WindowsIdentity.GetCurrent.Name
'authUserPrincipalLabel.Text = "You are: " & authUserName
'aspPrincipalLabel.Text = "This page runs as: " & aspUserName
authUserName = User.Identity.Name
aspUserName = Principal.WindowsIdentity.GetCurrent.Name
authLbl.Text = "You are: " & authUserName
aspLbl.Text = "This page runs as: " & aspUserName

to build dynamic tree view in asp.net 2.0

Dim treeview2 As New TreeView
treeview2.EnableClientScript = True
treeview2.PopulateNodesFromClient = True
Dim i, j As Integer
Dim ds1 As New DataSet
ds1 = objtest05.fnLoadempdetails(strconn)
i = ds1.Tables(0).Rows.Count

Dim root1(i) As TreeNode
Dim child(i) As TreeNode

j = 0
While j < i
root1(j) = New TreeNode
'root1(j).PopulateOnDemand = True
child(j) = New TreeNode
' child(j).PopulateOnDemand = True
Dim s, s1 As String
s = CStr(ds1.Tables(0).Rows(j).Item(0))
s1 = CStr(ds1.Tables(0).Rows(j).Item(1))
root1(j).Text = s
child(j).Text = s1
root1(j).ChildNodes.Add(child(j))
treeview2.Nodes.Add(root1(j))
PlaceHolder1.Controls.Add(treeview2)
j = j + 1
End While

FAQ's related Windows Forms in .NET

Hi All,

Here's a very useful list of technical FAQ's related to Windows Forms applications on .NET.

http://www.syncfusion.com/FAQ/WindowsForms/Default.aspx

This can be a great time saver for development teams while coding and for tech. experts for judging "Is it supported?" type of questions.

Extracting Data from a Text file to Label in ASP.Net

Private Sub lnkBut1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lnkBut1.Click
' Dim file_name As String

file_name = "News1.txt" \specify the text file[this is only for a text file]

Dim fs As New FileStream(Server.MapPath(file_name), FileMode.Open, FileAccess.Read)

Dim objreader As New StreamReader(fs)

lblText.Text = "" \pasting the test data to a Label
While (objreader.Peek() > -1)
lblText.Text += objreader.ReadLine
End While
fs.Close()
End Sub

Connection Strings on Various Databases

MS_Access
ODBC
Standard Security:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;"
Workgroup:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;SystemDB=C:\mydatabase.mdw;"
Exclusive:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;Uid=admin;Pwd="

OLE DB, OleDbConnection (.NET)
Standard security:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=admin;Password=;"

Workgroup (system database):
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:System Database=system.mdw;"

With password:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:Database Password=MyDbPassword;"

Oracle
ODBC
New version:
"Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=Username;Pwd=asdasd;"
Old version:
"Driver={Microsoft ODBC Driver for Oracle};ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword;"

OLE DB, OleDbConnection (.NET)
Standard security:
"Provider=msdaora;Data Source=MyOracleDB;User Id=UserName;Password=asdasd;"
This one's from Microsoft, the following are from Oracle
Standard Security:
"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=Username;Password=asdasd;"
Trusted Connection:
"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;"

OracleConnection (.NET)
Standard:
"Data Source=MyOracleDB;Integrated Security=yes;"
This one works only with Oracle 8i release 3 or later
Specifying username and password:
"Data Source=MyOracleDB;User Id=username;Password=passwd;Integrated Security=no;"
This one works only with Oracle 8i release 3 or later
Declare the OracleConnection:
C#: using System.Data.OracleClient;OracleConnection oOracleConn = new OracleConnection();oOracleConn.ConnectionString = "my connectionstring";oOracleConn.Open();

VB.NET:Imports System.Data.OracleClientDim oOracleConn As OracleConnection = New OracleConnection()oOracleConn.ConnectionString = "my connectionstring"oOracleConn.Open()
Missing the System.Data.OracleClient namespace? Download .NET Managed Provider for Oracle >>Great article! "Features of Oracle Data Provider for .NET" by Rama Mohan G. at C# Corner

Excel
ODBC
Standard:
"Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\MyExcel.xls;DefaultDir=c:\mypath;"
TIP! SQL syntax: "SELECT * FROM [sheet1$]" - i.e. worksheet name followed by a "$" and wrapped in "[" "]" brackets.

OLE DB
Standard:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
"HDR=Yes;" indicates that the first row contains columnnames, not data
"IMEX=1;" tells the driver to always read "intermixed" data columns as text
TIP! SQL syntax: "SELECT * FROM [sheet1$]" - i.e. worksheet name followed by a "$" and wrapped in "[" "]" brackets.

Text
ODBC
Standard:
"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\txtFilesFolder\;Extensions=asc,csv,tab,txt;"

OLE DB
Standard:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\txtFilesFolder\;Extended Properties=""text;HDR=Yes;FMT=Delimited"""
"HDR=Yes;" indicates that the first row contains columnnames, not data

DBF/FoxPro
ODBC
standard:
"Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\mydbpath;"

OLE DB, OleDbConnection (.NET)
standard:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=dBASE IV;User ID=Admin;Password="

Sybase
ODBC
Standard Sybase System 12 (or 12.5) Enterprise Open Client:
"Driver={SYBASE ASE ODBC Driver};Srvr=Aron1;Uid=username;Pwd=password"
Standard Sybase System 11:
"Driver={SYBASE SYSTEM 11};Srvr=Aron1;Uid=username;Pwd=password;"
Do you know a userguide for Sybase System 11, 12, 12.5? E-mail the URL to connectionstrings.com now!! >>
Intersolv 3.10:
"Driver={INTERSOLV 3.10 32-BIT Sybase};Srvr=Aron1;Uid=username;Pwd=password;"
Sybase SQL Anywhere (former Watcom SQL ODBC driver):
"ODBC; Driver=Sybase SQL Anywhere 5.0; DefaultDir=c:\dbfolder\;Dbf=c:\mydatabase.db;Uid=username;Pwd=password;Dsn="""""
Note! The two double quota following the DSN parameter at the end are escaped quotas (VB syntax), you may have to change this to your language specific escape syntax. The empty DSN parameter is indeed critical as not including it will result in error 7778. Read more in the Sybase SQL Anywhere User Guide >>

OLE DB
Adaptive Server Anywhere (ASA):
"Provider=ASAProv;Data source=myASA"
Read more in the ASA User Guide >>
Adaptive Server Enterprise (ASE) with Data Source .IDS file:
"Provider=Sybase ASE OLE DB Provider; Data source=myASE"
Note that you must create a Data Source .IDS file using the Sybase Data Administrator. These .IDS files resemble ODBC DSNs.
Adaptive Server Enterprise (ASE):
"Provider=Sybase.ASEOLEDBProvider;Srvr=myASEserver,5000;Catalog=myDBname;User Id=username;Password=password" - some reports on problem using the above one, try the following as an alternative -"Provider=Sybase.ASEOLEDBProvider;Server Name=myASEserver,5000;Initial Catalog=myDBname;User Id=username;Password=password"
This one works only from Open Client 12.5 where the server port number feature works, allowing fully qualified connection strings to be used without defining any .IDS Data Source files.

AseConnection (.NET)
Standard:
"Data Source='myASEserver';Port=5000;Database='myDBname';UID='username';PWD='password';"
Declare the AseConnection:
C#:using Sybase.Data.AseClient;AseConnection oCon = new AseConnection();oCon.ConnectionString="my connection string";oCon.Open();
VB.NET:Imports System.Data.AseClientDim oCon As AseConnection = New AseConnection()oCon.ConnectionString="my connection string"oCon.Open()

MYSQL
ODBC
ODBC 2.50 Local database:
"Driver={mySQL};Server=localhost;Option=16834;Database=mydatabase;"
ODBC 2.50 Remote database:
"Driver={mySQL};Server=data.domain.com;Port=3306;Option=131072;Stmt=;Database=my-database;Uid=username;Pwd=password;"
ODBC 3.51 Local database:
"DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=myDatabase;USER=myUsername;PASSWORD=myPassword;OPTION=3;"
ODBC 3.51 Remote database:
"DRIVER={MySQL ODBC 3.51 Driver};SERVER=data.domain.com;PORT=3306;DATABASE=myDatabase; USER=myUsername;PASSWORD=myPassword;OPTION=3;"

OLE DB, OleDbConnection (.NET)
Standard:
"Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;"
MySqlConnection (.NET)
eInfoDesigns.dbProvider:
"Data Source=server;Database=mydb;User ID=username;Password=pwd;Command Logging=false"
This one is used with eInfoDesigns dbProvider, an add-on to .NET
Declare the MySqlConnection:
C#:using eInfoDesigns.dbProvider.MySqlClient;MySqlConnection oMySqlConn = new MySqlConnection();oMySqlConn.ConnectionString = "my connectionstring";oMySqlConn.Open();

VB.NET:Imports eInfoDesigns.dbProvider.MySqlClientDim oMySqlConn As MySqlConnection = New MySqlConnection()oMySqlConn.ConnectionString = "my connectionstring"oMySqlConn.Open()

SQL SERVER
ODBC
Standard Security:
"Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"
Trusted connection:
"Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connection=yes;"
Prompt for username and password:
oConn.Properties("Prompt") = adPromptAlwaysoConn.Open "Driver={SQL Server};Server=Aron1;DataBase=pubs;"

OLE DB, OleDbConnection (.NET)
Standard Security:
"Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"
Trusted Connection:
"Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"
(use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)
Prompt for username and password:
oConn.Provider = "sqloledb"oConn.Properties("Prompt") = adPromptAlwaysoConn.Open "Data Source=Aron1;Initial Catalog=pubs;"
Connect via an IP address:
"Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"
(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))

SqlConnection (.NET)
Standard Security:
"Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;" - or -"Server=Aron1;Database=pubs;User ID=sa;Password=asdasd;Trusted_Connection=False" (both connection strings produces the same result)

Trusted Connection:
"Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;" - or -"Server=Aron1;Database=pubs;Trusted_Connection=True;" (both connection strings produces the same result)
(use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)
Connect via an IP address:
"Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"
(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))
Declare the SqlConnection:
C#:using System.Data.SqlClient;SqlConnection oSQLConn = new SqlConnection();oSQLConn.ConnectionString="my connectionstring";oSQLConn.Open();
VB.NET:Imports System.Data.SqlClientDim oSQLConn As SqlConnection = New SqlConnection()oSQLConn.ConnectionString="my connectionstring"oSQLConn.Open()

Poping new window and to pass variable value from one webform to another in ASP.NET

The code helps in poping new window and to pass variable value from one webform to another. Technology: ASP.NET Language: VB

'Response.Write("<'write script language= javascript here'>" & vbCrLf)' 'Response.Write("wndCht=window.open('http://blrkec32416d/naviwebpage/mainpage.aspx?arg='data' ','','width=650, height=400,toobar=no,addressbar=no,menubar=no,scrollbars=yes,resizable=yes');")' 'Response.Write("<" & "/" & "script" & ">" & vbCrLf)

'Dim str1 As String'
str1 = Request.QueryString("arg")'
TextBox1.Text = str1

Comments Please

Database Connectivity and Query commands to execute in ASP.NET

This is the conenction string for access stroed in a variable strconn. This variable is passed as argument to the function in the function call. Here it is GETHEADLINES.
Public strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("Database/naviwebpage.mdb")

The function returns a dataset of records of the query. the results should be stroed in the Dataset and can populated to any form.
Function fnGetHeadlines(ByVal strConn As String) As DataSet
Dim conn As New OleDbConnection(strConn)
conn.Open()
Dim cmd As New OleDbCommand("select Headlines,DetailNews from news", New OleDbConnection(strConn))
Dim myDataAdapter As New OleDbDataAdapter(cmd)
Dim myDataset As New DataSet
myDataAdapter.Fill(myDataset)
conn.Close()
Return myDataset
End Function

Comments Please

Link Button Event in a Datagrid in ASP.NET

This code gets the event of the Linkbutton placed in a Datagrid. make sure the datagrid is not autogenerates and the data should be bounded. In this code the linkbutton is placed in the first column of the Datagrrid using the datagrid properties.

Technology : ASP.NET
Language : VB
Code:

Private Sub DataGrid1_ItemCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.ItemCommand
TextBox1.Text = e.Item.Cells(1).Text
End Sub

The DataGrid1_itemcommand is the event handler for the Datagrid.

Comments Please.