Share your Knowledge

SQL Interview Questions

2010-06-22T23:49:00.000-07:00

1. SQL Injection: SQL injection is an attack in which malicious code is inserted into strings that are later passed to an instance of SQL Server for parsing and execution.
The following script shows a simple SQL injection. The script builds an SQL query by concatenating hard-coded strings together with a string entered by the user:
var Shipcity;
ShipCity = Request.form ("ShipCity");
var sql = "select * from OrdersTable where ShipCity = '" + ShipCity + "'";
The user is prompted to enter the name of a city. If she enters Redmond, the query assembled by the script looks similar to the following:
SELECT * FROM OrdersTable WHERE ShipCity = 'Redmond'
However, assume that the user enters the following:
Redmond'; drop table OrdersTable--
In this case, the following query is assembled by the script:
SELECT * FROM OrdersTable WHERE ShipCity = 'Redmond';drop table OrdersTable--'
The semicolon (;) denotes the end of one query and the start of another. The double hyphen (--) indicates that the rest of the current line is a comment and should be ignored. If the modified code is syntactically correct, it will be executed by the server. When SQL Server processes this statement, SQL Server will first select all records in OrdersTable where ShipCity is Redmond. Then, SQL Server will drop OrdersTable.

2.How we can avoid SQL Injection:Always validate user input by testing type, length, format, and range. When you are implementing precautions against malicious input, consider the architecture and deployment scenarios of your application.
Example:
SqlDataAdapter myCommand = new SqlDataAdapter("AuthorLogin", conn);
myCommand.SelectCommand.CommandType = CommandType.StoredProcedure;
SqlParameter parm = myCommand.SelectCommand.Parameters.Add("@au_id", SqlDbType.VarChar, 11);
parm.Value = Login.Text;In this example, the @au_id parameter is treated as a literal value instead of as executable code. This value is checked for type and length. If the value of @au_id does not comply with the specified type and length constraints, an exception will be thrown.
Stored procedures may be susceptible to SQL injection if they use unfiltered input.

3.What's the difference between a primary key and a unique key?
Both primary key and unique enforce uniqueness of the column on which they are defined. But by default primary key creates a clustered index on the column, where are unique creates a nonclustered index by default. Another major difference is that, primary key doesn't allow NULLs, but unique key allows one NULL only.

4. What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
DELETE TABLE is a logged operation, so the deletion of each row gets
logged in the transaction log, which makes it slow. TRUNCATE TABLE
also deletes all the rows in a table, but it won't log the deletion of each row, instead it logs the deallocation of the data pages of the table, which makes it faster. Of course, TRUNCATE TABLE can be rolled back.

Sharepoint Interview Questions

2010-06-14T23:22:00.000-07:00

1. Content Database: When the site collection or sites are created Window Sharepoint Services does not create any files or folders on the file system, everything is created in the content database. Each site collection is stored in a SQL Server database called the content database. This content database contains all the files, lists, and data for all sites in the site collection.

2. Virtualized File System: SharePoint sites consist of numerous Web pages, just like any ASP.NET 2.0 application. When a site is created, these pages are created as instances in the content database. The instances refer to the actual file on the file system. This is known as a virtualized file system.

3.Why did Microsoft decide to use a virtualized file system rather than the traditional ASP.NET 2.0 Web site approach that keeps everything on the server's hard disk?

There are a few reasons for this approach.

Windows SharePoint Services is a site-provisioning engine, which makes it very easy for those with appropriate permissions to create new sites. In addition, the architecture is set up to support hundreds, thousands, tens of thousands, even hundreds of thousands of sites. If each site that was created resulted in a new Web root created on the file system, an organization of any size would quickly accumulate a large number of unmanageable Web roots on the server.
consider a load-balanced environment. In a load-balanced environment, each SharePoint front-end Web server is essentially a mirror of other front-end Web servers. This means if an organization has hundreds of sites, they also have hundreds of Web roots, not to mention all the supporting files and assemblies for the site, on each server. This type of implementation would be very vulnerable to becoming out of sync with other servers or experiencing file corruption.

4. How many types of pages are in Sharepoint?

There are two types of pages are site pages (also known as content pages) and application pages. Site pages are the ones stored as instances in the site collection's content database. These pages fall into one of two categories: customized files or uncustomized files.

5.Uncustomized Files: When you create a new SharePoint site in a site collection, anywhere in a site collection, Windows SharePoint Services provisions instances of files into the content database that resides on the file system. The files on the file system are called templates. On their own they are not very useful because they cannot be accessed by using a browser. This is because they are not mapped to any specific URL. The instance of the file in the content database merely adds it to the site. When ASP.NET receives a request for the file, it first finds the file in the content database. This entry in the content database tells ASP.NET that the file is actually based on a file on the file system and therefore, ASP.NET retrieves the source of the file on the file system when it constructs the page.
This is how most files start in a SharePoint site. They are called uncustomized files. In the earlier version of SharePoint products and technologies (Windows SharePoint Services 2.0 and SharePoint Portal Server 2003) these files were called ghosted files, a term which has been deprecated. An uncustomized file is one in which the source of the file lives on the file system and not in the content database. The only thing that lives in the content database is the uncustomized instance that registers the file in the site.
One thing to note is that there can be multiple instances of a file in a site collection's content database, or content databases, all referencing the same file. This is how the out-of-the-box master page, default.master, is implemented. Every SharePoint site starts with an uncustomized instance of the default.master page. If an environment contained 100 SharePoint sites created with the Blank Site template, and no customizations had been made, there will be 100 uncustomized instances of the default.master page in the various content databases, yet there would be only a single default.master page on the file system.

6.Customized: A customized file is one in which the source of the file lives exclusively in the site collection's content database. In earlier versions (Windows SharePoint Services 2.0 and SharePoint Portal Server 2003) these files were called unghosted files, a term which has been deprecated. How can a file become customized? If you modify the file in any way through the SharePoint API, the source of the new page is saved in the content database. This includes SharePoint Designer 2007, which uses the SharePoint API via RPC and Web service calls to change files in sites. When the file is requested, ASP.NET first finds the file in the content database. The entry in the database tells ASP.NET whether the file is customized or uncustomized. If it is customized, it contains the source of the file, which is used by ASP.NET in the page contraction phase.
A file can start as an uncustomized instance and become customized. For example, after a site has been created, someone can open the site in SharePoint Designer 2007 and make a few changes to the default.master page for the site. When the file is saved, it has changed from being uncustomized to being customized. This enables Windows SharePoint Services to store only one instance of a file template on the file system regardless of how many sites implement it, while at the same time providing for site-by-site customizations of the file. Even if the file is customized, you can delete the customizations and put the file back into an uncustomized state by either right-clicking it in SharePoint Designer and selecting "Reset to Site Definition" .

7.Site Pages:Site pages are the ASP.NET 2.0 pages.These are the pages that support customization in the sense that they can be themed and they can host Web Parts.site owners and designers can customize these Site pages by using tools such as SharePoint Designer 2007. Site pages are virtualized in the site collection's content database.

8. Application Pages:application pages are much more like traditional ASP.NET 2.0 pages. These pages reside in a special virtual directory (http://www.localhost.com/_layouts/*.*) that all sites have access to. This virtual directory points to the [..]\12\TEMPLATE\LAYOUTS folder on the file system. All Windows SharePoint Services sites on a front-end Web server use the same pages. These pages are not provisioned as instances in the site collection's content database. Instead, they act just like traditional ASP.NET 2.0 pages. Each is coded to analyze the current context of the HTTP request such as which site collection, site, and user to determine what it should and should not do. These pages do not appear in SharePoint Designer 2007 when you browse a site because they exist only on the file system. Therefore you cannot customize them.

Jquery Basic Knowledge

2010-03-05T12:11:00.000-08:00

1. Give me an example of ready function in Jquery?

      $(document).ready(function() {
      $('p').addClass('highlight');
      });
      ready function is declared as "$(document).ready()".

2. How ready function works in Jquery?

   "$(document).ready()" This method executes the function call when the DOM is loaded and ready.
Example:
$(document).ready(function() {
$('p').addClass('highlight');
});

We use the function keyword (without the function name) and define the body of the function to use when the DOM has loaded. The function body is used as an argument to the method for the simple reason that we want the function to be executed immediately, but once only. We don’t want it to be reused again. In other words, $(document).ready() registers a ready event for the document.
The $('p') in the preceding solution is a selector that accesses the paragraph elements of the HTML. file, and to those elements the addClass() method will apply the specified CSS class.

3.How we select the nodes using $()?

     • $('p')—Accesses all the paragraph elements in the HTML file
     • $('div')—Accesses all the div elements in the HTML file
     • $('#A')—Accesses all the HTML elements with id=A
     • $('.b')—Accesses all the HTML elements with class=b
     Example:
     $(document).ready(function() {
     $('p').addClass('highlight'); //'highlight' is the css class
     });
4.How you count the number of nodes in the DOM and display its text?

Solution

Jquery

$(document).ready(function() {

var $nodes = $('#root').children();
alert('Number of nodes is '+$nodes.length);
var str="";
$('#root').children().each( function() {
str+=$(this).text();
});
alert(str);
});

5. How we use ".each()", ".text()", ".childeren()" in jquery methods?

children(): The children() method is a tree-traversal method that searches for the immediate children of the specified element and returns a new jQuery object. This method travels only a single level down in the DOM tree.
each():each() is a method that is used to iterate over each element in the wrapped collection.
text(): text() is a method of the jQuery object that accesses the text contents of the selected element(s). Exanple: alert($('p').text());
parent(): The parent() method is a tree-traversal method that searches for the immediate parent of each of the selected elements and returns a new jQuery object. This method travels only a single level up in the DOM tree. Example:

alert($('span').parent().text());

6. COMMING SOON.

Published Links

2008-10-17T03:28:00.000-07:00

Hi Guys,
Thanks for using this blog. Please find the published contents below.
Published Contents in this blog :
1. MOSS 2007 Important Questions
2. Create New site in moss 2007
3. Web part code for change password
4. MOSS 2007 vs WSS

Thanks

Badri Nath

MOSS 2007

2008-10-06T02:12:00.001-07:00

1. What is sharepoint 2007 or MOSS 2007 ?
A: Sharepoint is an extensibale and sacalable web - based platform consisting of tools and technologies which help to build bussiness application. Which helps us to better store, share and manage digital information in our organization.
These are sharepoint primary features:

Web content management.
Monitor key business activities.
Simplify Collaboration.

2. Comparing MOSS 2007 and WSS.
A: WSS contains the core functionality needed for document Management and collaboration, such as document libraries and list where MOSS 2007 offers the same feature of WSS in addition to the functionality required for Enterprise content management as well as Excel and forms services, Business data catalog and Business intelligences.

3. What is the Enterprise feature?

A. Enterprise features named because they often represent the functionality that large enterprises require and demand from their collaborative applications.

Form Services: InfoPath is a forms creation and completion application that is in an important part of the Microsoft Office system.
Search: This connects you with the information, people, and processes you need to make informed business decisions. Users’ complaints concerning SharePoint 2003’s inability to locate information resulted in a greatly improved search engine in the 2007 release, which includes search highlighting.
Web Content Management: With the integration of Microsoft Content Management Server 2002, SharePoint now supports web content creation and publishing. Publishing features ranging from content approval workflow to page layouts and content types which means you can create and publish branded web content without knowing code. You can then host these websites on an intranet environment or an extranet so partners or clients can access information.
Excel Services: Excel Services lets you work with important data in real time using only the browser. You can publish interactive pivot tables, charts, and spreadsheets to a large audience while protecting your formulas and calculations. Users are given “view-only” rights, which only allows them to see the browser-based version of a report.
Business Data Catalog: Business Data catalog is newly introduced shared services which enable MOSS 2007 to surface business data from back-end server applications with minimal coding effort. It provides built-in support for displaying data from database and Web services.
Audiences/Profiles: SharePoint 2007 can collect user profile information and store it in a centralized database so that various elements in SharePoint can access it and personalize it. Personalization targets relevant content to users based on properties of their profiles.

4. What is SSO?

A. Single Sign on (SSO) functionality enables users to authenticate only once when they access portal site based application that need to obtain information from other business applications and systems. Configuring single sign-on consists of five tasks:

Configuring the Microsoft Single Sign -On Services service.
Managing Server settings for single sign-on.
Managing the encryprion key.
Managing enterprise application definitions.
Managing account settings for enterprise applications definitions.

5.define Business Data Catalog?

A. Business Data catalog is newly introduced shared services which enable MOSS 2007 to surface business data from back-end server applications with minimal coding effort. It provides built-in support for displaying data from database and Web services. There are five in built BDC web part:

Business data web-parts.
Business data in links.
Business data actions.
Business data search.
Business data in user profiles.

6. How to Personalizing Your Portal?

A. There are three main features in MOSS 2007 personalization Model.
a. User profiles: User profile allow us to search for and connect with people in our organization based on information published about them. In MOSS 2007 we can import user profile information from : 1. Active Directory 2. LDAP Server or 3. From apllication registered in BDC.
b.Audiences : Office SharePoint Server 2007 allows you to target content to people according to their membership in a particular audience. Office SharePoint Server 2007 supports targeting to rules-based audiences, distribution lists, and Windows SharePoint Services groups. Except for Windows SharePoint Services groups, these audiences can span one or more portal sites in a deployment.
c.My Site :My Site is a collection of Profile pages, personal sites, and personalization sites created in the Office SharePoint Server 2007 site.

7.What is content types?

A. A content type is a reusable collection of settings which enable us to manage the metadata and behaviors of a document or item type in a centralized manner.

You create a content type at the site level. This site content type acts as a template that is independent of any specific list or library. That site content type is then available on any child site. For example, if you create a site content type at the root site of a site collection, that site content type becomes available on any site in that site collection, so that you can add it to any list in the site collection.

8. Types of contents types.

A. Following are the base content types:

Business Intelligence Content Types
Document Content Types
Folder Content Types
List Content Types
Page Layout Content Types
Publishing Content Types
Special Content Types

9.Describe the difference between a lookup column and a choice column.

A.A choice column features a value list from which you can select that a site manager has manually entered into the column. A lookup column displays a value list based on the contents of an existing column from another list on the site.

10.Describe how you would send a report of information stored in a list to a partner outside your organization that did not have access to your SharePoint list.

A. You can export SharePoint list views to an Excel spreadsheet from the Actions menu. This means you can take information from the SharePoint site, customize it, and send it to team members or partners that do not have direct access to the SharePoint list.

11.What are the differences between a tasks list and a projects tasks list?

A. A projects tasks list is created with a Gantt chart view by default. Also, you can associate a tasks list with a workflow activity template whereas you can’t do this with a projects task.

Create New Site in MOSS 2007

2008-09-25T11:56:00.000-07:00

Follows these steps to create a top level Sites in MOSS 2007:

Open central administration site

Click on Application Management
Application Management site open
Click on create or extended web application
Create or extend web application Open
Click on Create on new Web Application
Create on new Web Application open

Now follow the steps to create your new site :

a. Give proper name for your site in Description Text box

b. Give proper port number
c. Give admin userid and passowrd
d. Give Database name and
e. Choose database authentication
6. Click on Ok

7. Operation in Progress

8. Site Created
9. Click on Create Site Collection

10. Give user name and click on OK

11. Tope leve site created

12. Top level site

Date in oracle

2008-07-03T00:33:00.000-07:00

How to update the date column of the table?
If column is date type
UPDATE TableName SET Updateable_Col =to_date('yourDate’,'MM/DD/YYYY') WHERE ColumnName ='Paramenter'.

or if column is string type
UPDATE TableName SET Updateable_Col =to_char('yourDate’,'MM/DD/YYYY') WHERE ColumnName ='Paramenter'.

Note:
1. To_date(‘Column Parameter’, ‘Date Format’) function converts a string to a Date.
2. To_Char(‘Column Parameter’, ‘Date Format’) function converts a Date to a String.

Sno	Field Name	Used for
1	TableName	Table name, which table you want to update.
2	Updateable_Col	Column Name, which column you want to update
3	YourDate	Date as 06/25/2008
3	ColumnName	In respect to which column you want to update

Business Data Catalog (BDC) overview

2008-07-01T03:49:00.000-07:00

Business data Catalog is newly introduced in the MOSS 2007. It is a shared service which enables to connect the business data from back-end –server application without any coding or minimal coding. It bridges the gap between the portal site and our business application and enables to bring key data from various business application to office SharePoint 2007 lists, Webparts, search, user profiles, and custom application.

We can use Business Data Catalog to display data from your SAP, Siebel, or other line-of-business (LOB) application via Web services or databases.

There are five default Business Data Web Parts in MOSS 2007:

Business Data List.
Business Data Item.
Business Data Item Builder.
Business Data Related List.
Business Data Actions.

Business Data catalog support two authentication Models:

Trusted Subsystem
Impersonation and delegation.

each authentication Models have four Authentication Modes:

Pass through
RevertToSelf
WindowsCredentials
Rdbcredentials

What is the diffrence between WSS and MOSS

2008-01-15T08:10:00.000-08:00

To install the MOSS we have to install the WSS first.

So question is what is diffrence between MOSS and WSS?

Just I am trying to explain you individualy:

WSS ( Windows Sharepoint Services 3.0)

It is a web based application.
All information are stored in the MS sql database.
It is using to display the information by the help of webparts.
There are more then one list type which is use to store all type of information.
It is ideal for collaboration on project data.
It has its own index and search engine.
It contains the site templates which helps to create Wiki and Blog sites.

WSS doesn't support

Indexing and searching information is not supported by the wss
No advanced intranet features such, as targated information and content management.
No advance document management fatures, such as policies.
Infopath form cnnot display in the web browser.
Limited no of webparts (less then 10)
Unable to read and write the external database.

MS Office Sharepoint Server 2007

add more features to the wss 3.0.

Use Global search functionality which helps to find any type of information such as type and location.
You can create one user or you can create a group of user in a diffrent group.
Import user data into Active directory.
Advance content management.
Able to use infopath Forms, using forms service.
MS Excel Spredsheets and charts in a webpart , using Excel services.
Search, dispaly and edit content in external daabses, such as SAP, using BUssiness Data Catalog.
Give each sharepoint a perosonal website , for both private and public use.

To change password through webparts

2008-01-13T06:56:00.000-08:00

using System;
using System.Runtime.InteropServices;
using System.Web.UI;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Serialization;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using Microsoft.SharePoint;
using Microsoft.SharePoint.WebControls;
using Microsoft.SharePoint.WebPartPages;
using System.ComponentModel;
using System.Collections.Generic;
using System.Web.UI.WebControls;

namespace changepasswordwebpart
{
[Guid("713bc165-73a4-4a65-8651-adf5d5da8a50")]
public class changepasswordwebpart : System.Web.UI.WebControls.WebParts.WebPart,IWebEditable
{
System.Web.UI.WebControls.Label oldlb = new System.Web.UI.WebControls.Label();
System.Web.UI.WebControls.Label userid_lb = new System.Web.UI.WebControls.Label();
System.Web.UI.WebControls.Panel panel = new System.Web.UI.WebControls.Panel();
System.Web.UI.WebControls.TextBox oldpasswordtb = new System.Web.UI.WebControls.TextBox();
System.Web.UI.WebControls.TextBox userid_txt = new System.Web.UI.WebControls.TextBox();
System.Web.UI.WebControls.TextBox newpasswordtb = new System.Web.UI.WebControls.TextBox();
System.Web.UI.WebControls.TextBox Confirmpasswordtb = new System.Web.UI.WebControls.TextBox();
System.Web.UI.WebControls.Button Checkpasswordbttn = new System.Web.UI.WebControls.Button();
System.Web.UI.WebControls.Button cancelbttn = new System.Web.UI.WebControls.Button();
System.Web.UI.WebControls.Label statuslb = new System.Web.UI.WebControls.Label();
System.Web.UI.WebControls.Label Info_lb = new System.Web.UI.WebControls.Label();
public changepasswordwebpart()
{
this.ExportMode = WebPartExportMode.All;
}
protected override void Render(HtmlTextWriter writer)
{
// TODO: add custom rendering code here.
// writer.Write("Output HTML");
}
protected override void CreateChildControls()
{
try
{
SPWeb thisWeb = SPControl.GetContextWeb(this.Context);
SPUser currentUser = thisWeb.CurrentUser;
String username = currentUser.Name;
//base.CreateChildControls();
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl("

"));
Info_lb.Text = "All fields are manadatory!";
Info_lb.Width = 300;
Info_lb.Height = 20;
panel.Controls.Add(Info_lb);
panel.Controls.Add(new LiteralControl("

"));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl(""));
panel.Controls.Add(new LiteralControl("

")); userid_lb.Text = "UserID:"; userid_lb.Width = 150; userid_lb.Height = 20; panel.Controls.Add(userid_lb); panel.Controls.Add(new LiteralControl("	")); userid_txt.Text = username; userid_txt.ID = "usernametb"; userid_txt.Width = 150; userid_txt.Height = 20; userid_txt.ReadOnly = true; panel.Controls.Add(userid_txt); panel.Controls.Add(new LiteralControl("
")); panel.Controls.Add(new LiteralControl("
")); oldlb.Text = "Old Password"; oldlb.Width = 150; oldlb.Height = 20; panel.Controls.Add(oldlb); panel.Controls.Add(new LiteralControl("	")); oldpasswordtb.Text = ""; //oldpasswordtb.ID = "oldtb"; oldpasswordtb.Width = 150; oldpasswordtb.Height = 20; oldpasswordtb.TextMode = TextBoxMode.Password; panel.Controls.Add(oldpasswordtb); panel.Controls.Add(new LiteralControl("
")); System.Web.UI.WebControls.Label newlb = new System.Web.UI.WebControls.Label(); newlb.Text = "New Password"; newlb.Width = 150; newlb.Height = 20; panel.Controls.Add(newlb); panel.Controls.Add(new LiteralControl("	")); newpasswordtb.Text = ""; //newpasswordtb.ID = "newpwdtb"; newpasswordtb.Width = 150; newpasswordtb.Height = 20; newpasswordtb.TextMode = TextBoxMode.Password; panel.Controls.Add(newpasswordtb); panel.Controls.Add(new LiteralControl("
")); System.Web.UI.WebControls.Label confirmlb = new System.Web.UI.WebControls.Label(); confirmlb.Text = "Confirm Password"; confirmlb.Width = 150; confirmlb.Height = 20; panel.Controls.Add(confirmlb); panel.Controls.Add(new LiteralControl("	")); Confirmpasswordtb.Text = ""; //Confirmpasswordtb.ID = "Confirmtb"; Confirmpasswordtb.Width = 150; Confirmpasswordtb.Height = 20; Confirmpasswordtb.TextMode = TextBoxMode.Password; panel.Controls.Add(Confirmpasswordtb); panel.Controls.Add(new LiteralControl("
")); panel.Controls.Add(new LiteralControl("	")); Checkpasswordbttn.Text = "Ok"; Checkpasswordbttn.Width = 100; //Checkpasswordbttn.ID = "okbttn"; Checkpasswordbttn.Click += new EventHandler(Checkpasswordbttn_Click); panel.Controls.Add(Checkpasswordbttn); cancelbttn.Text = "Cancel"; cancelbttn.Visible = false; Controls.Add(cancelbttn); panel.Controls.Add(new LiteralControl("

"));

panel.Controls.Add(new LiteralControl("

"));
panel.Controls.Add(new LiteralControl("

"));
statuslb.Text = "";
statuslb.ForeColor = System.Drawing.Color.Red;
statuslb.Width = 400;
statuslb.Height = 20;
statuslb.Visible = true;
panel.Controls.Add(statuslb);
//cancelbttn.Click += new EventHandler(cancelbttn_Click);
this.Controls.Add(panel);
}
catch (Exception ex)
{
statuslb.Text = "Contact with Administrator!";
}
}
public override void RenderControl(HtmlTextWriter writer)
{
panel.RenderControl(writer);
EnsureChildControls();
//create a table
//base.RenderControl(writer);
}
string str1;
public static string err;
void Checkpasswordbttn_Click(object sender, EventArgs e)
{
statuslb.Text = "";
if (userid_txt.Text != "" && oldpasswordtb.Text != "" && newpasswordtb.Text != "" && Confirmpasswordtb.Text != "")
{
////throw new Exception("The method or operation is not implemented.");
if (newpasswordtb.Text == Confirmpasswordtb.Text)
{
str1 = updatePassword(newpasswordtb.Text, oldpasswordtb.Text);
//if(Convert.ToInt64(str1) > 0)
if(str1=="1")
{
statuslb.Text = "your password has changed successfully!";
}
else
{
statuslb.Text = "Please check your oldpassword!";
}
}
else
{
statuslb.Text = "Newpassword and confrim password must be same!";
}
}
else
{
statuslb.Text = "All fields are manadatory!";
}
if(userid_txt.Text!="" && oldpasswordtb.Text!="")
{
bool verified = AuthenticateUser(userid_txt.Text, oldpasswordtb.Text);
if (verified)
statuslb.Text = "Verified";
else
statuslb.Text = "Not Verified" + err;
}
}
//public SqlConnection conn = new SqlConnection("Data Source=server name;Initial Catalog=databasename;Integrated Security=True");
public SqlConnection conn = new SqlConnection("Data Source=server name;Initial Catalog=databasename;Integrated Security=True");
public string updatePassword(string password, string oldpassword)
{
try
{
SPWeb thisWeb = SPControl.GetContextWeb(this.Context);
SPUser currentUser = thisWeb.CurrentUser;
String username = currentUser.Name;
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Update statement")";
return cmd.ExecuteNonQuery().ToString();
}
catch (Exception ex)
{
return ex.Message;
}

}
private string connectionstring;
// Property to Assign Site URL from ToolPart
[WebBrowsable(false)]
public string ConnString
{
get
{
return connectionstring;
}
set
{
connectionstring = value;
}
}
// Creating the ToolPart with the WebPart
#region IWebEditable Members
EditorPartCollection IWebEditable.CreateEditorParts()
{
List editors = new List();
editors.Add(new editchagepassword());
return new EditorPartCollection(editors);
}
object IWebEditable.WebBrowsableObject
{
get { return this; }
}

}
}

// Next Class
using System;
using System.Collections.Generic;
using System.Text;
using System.ComponentModel;
using System.Web;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
namespace changepasswordwebpart
{
class editchagepassword:EditorPart
{
TextBox constringtxt;
public editchagepassword()
{
this.ID = "PasswordEditorPart";
this.Title = "Change Your Password";
}
protected override void CreateChildControls()
{
base.CreateChildControls();
constringtxt = new TextBox();
// Create new panel for ToolPart
//Panel userSectionBody = new Panel();
//constringtxt = new TextBox();
//Label lblSiteURL = new Label();
//lblSiteURL.Text = "Connection string";

//// Adding Site URL TextBox to Panel
//userSectionBody.Controls.Add(lblSiteURL);
//userSectionBody.Controls.Add(new LiteralControl("
"));
//userSectionBody.Controls.Add(constringtxt);

Controls.Add(constringtxt);
}
// This Function will be Triggered When the Apply or OK button Clicked in ToolPart
public override bool ApplyChanges()
{
changepasswordwebpart webpart = WebPartToEdit as changepasswordwebpart;
if (webpart != null)
{
webpart.ConnString = constringtxt.Text;
return true;
}
return true;
}
// This Function will be Triggered when the Task Pane of the WebPart is Opened
public override void SyncChanges()
{
EnsureChildControls();
changepasswordwebpart webpart = WebPartToEdit as changepasswordwebpart;
if (webpart != null)
{
constringtxt.Text = webpart.ConnString;
}
}
protected override void RenderContents(HtmlTextWriter writer)
{
// Rendering Tool Part Pane
//writer.WriteLine("Document Library TreeView Editor Part");
base.RenderContents(writer);
}
}
}

Thanks to blogger.com

2008-01-13T06:07:00.000-08:00

Hi All,

I have created my own blog. First of all i thanks to blogger.com who help every one to create his own blog and helps to other to become a known person in the E wolrd market. which kepp touch with each othe.

I am Senior software engg in MNC company. I want to share my knowledge what i have gain through my exprince form last four year. Thanks to all who share his/her knowledge. I also want to become one of them. Thanks to Uday ethurajulu who inform me about this all.

Thanks & regards

Badri Nath