vino

Google Chart Tools

2010-09-14T13:48:00.003+05:30

http://code.google.com/apis/ajax/playground/?type=visualization#line_chart

Loading

The google.load package name is "corechart"

google.load("visualization", "1", {packages: ["corechart"]});

The visualization's class name is google.visualization.LineChart

var visualization = new google.visualization.LineChart(container);

Fun with VB 2010

2010-08-22T12:52:00.000+05:30

Google Search Tips .......

2010-08-03T12:10:00.001+05:30

Explicit Phrase:
Lets say you are looking for content about internet marketing. Instead of just typing internet marketing into the Google search box, you will likely be better off searching explicitly for the phrase. To do this, simply enclose the search phrase within double quotes.

Example: "internet marketing"

Exclude Words:
Lets say you want to search for content about internet marketing, but you want to exclude any results that contain the term advertising. To do this, simply use the "-" sign in front of the word you want to exclude.

Example Search: internet marketing –advertising

Site Specific Search:
Often, you want to search a specific website for content that matches a certain phrase. Even if the site doesn’t support a built-in search feature, you can use Google to search the site for your term. Simply use the "site:somesite.com" modifier.

Example: "Chennai" site:www.irctc.co.in

Similar Words and Synonyms:
Let’s say you are want to include a word in your search, but want to include results that contain similar words or synonyms. To do this, use the "~" in front of the word.

Example: "internet marketing" ~professional

Specific Document Types:
If you’re looking to find results that are of a specific type, you can use the modifier "filetype:". For example, you might want to find only PowerPoint presentations related to internet marketing.

Example: "internet marketing" filetype:ppt

This OR That:
By default, when you do a search, Google will include all the terms specified in the search. If you are looking for any one of one or more terms to match, then you can use the OR operator. (Note: The OR has to be capitalized).

Example: internet marketing OR advertising

Phone Listing:
Let’s say someone calls you on your mobile number and you don’t know how it is. If all you have is a phone number, you can look it up on Google using the phonebook feature.

Example: phonebook:617-555-1212 (note: the provided number does not work – you’ll have to use a real number to get any results).

Area Code Lookup:
If all you need to do is to look-up the area code for a phone number, just enter the 3-digit area code and Google will tell you where it’s from.

Example: 617

Numeric Ranges:
This is a rarely used, but highly useful tip. Let’s say you want to find results that contain any of a range of numbers. You can do this by using the X..Y modifier (in case this is hard to read, what’s between the X and Y are two periods. This type of search is useful for years (as shown below), prices or anywhere where you want to provide a series of numbers.

Example: president 1940..1950

Stock (Ticker Symbol):
Just enter a valid ticker symbol as your search term and Google will give you the current financials and a quick thumb-nail chart for the stock.

Example: GOOG

Calculator:
The next time you need to do a quick calculation, instead of bringing up the Calculator applet, you can just type your expression in to Google.

Example: 48512 * 1.02

Word Definitions:
If you need to quickly look up the definition of a word or phrase, simply use the "define:" command.

Example: define:plethora

Hope this list of Google search tips proves useful in your future Google searches.

From http://blog.hubspot.com

Microsoft Humorous Quotes

2010-07-20T16:20:00.001+05:30

"640 K ought to be enough for anybody."
-- Bill Gates, 1981
"I believe OS/2 is destined to be the most important operating system, and possibly program, of all time. As the successor to DOS, which has over 10,000,000 systems in use, it creates incredible opportunities for everyone involved with PCs."
-- Bill Gates - OS/2 Programmer's Guide
"The best way to prepare [to be a programmer] is to write programs, and to study great programs that other people have written. In my case, I went to the garbage cans at the Computer Science Center and I fished out listings of their operating systems." -- Bill Gates, OS/2 Notebook, Microsoft Press, 1990, p. 614
"The Internet? We are not interested in it"
-- Bill Gates, 1993
"Sometimes we do get taken by surprise. For example, when the Internet came along, we had it as a fifth or sixth priority."
-- Bill Gates, Jul, 1998
http://www.news.com/News/Item/0%2C4%2C23808%2C00.html?dd.ne.tx.fs
"We had planned to integrate a Web browser with our operating system as far back as 1993"
Microsoft (27 Jul 1998, filing its first court responses to federal antitrust)
In response to Java: "Anybody who thinks a little 9,000-line program that's distributed free and can be cloned by anyone is going to affect anything we do at Microsoft has his head screwed on wrong."
-- Bill Gates
"Microsoft Products are Generally Bug Free"
-- Bill Gates
"There are people who don't like capitalism, and there are people who don't like PCs, but there's no one who likes the PC who doesn't like Microsoft."
-- Bill Gates
"Like medieval peasants, computer manufacturers and millions of users are locked in a seemingly eternal lease with their evil landlord, who comes around every two years to collect billions of dollars of taxes in return for mediocre services"
-- Mark Harris, Electronics Times
"Microsoft does not innovate. It buys, imitates, or steals. It makes things difficult for software developers, and thus eventually for users."
-- Richard Brandshaft, San Jose Mercury-New
"There is a fantasy in Redmond that Microsoft products are innovative, but this is based entirely on a peculiar confusion of the words "innovative" and "successful." Microsoft products are successful -- they make a lot of money -- but that doesn't make them innovative, or even particularly good."
-- Robert X. Cringley
"A few weeks ago, a member of the audience at a [Bill] Gates speech in San Francisco asked simply this of the world's richest businessman: ''Can you make a list of things you won't be doing? ... I just want a little piece of something to pass on to my kids 20 years from now.''"
-- San Jose Mercury News, 26 Oct 97
"We have no intention of shipping another bloated OS and shoving it down the throats of our users."
-- Paul Maritz, Microsoft group vice president
"Microsoft has gotten so big that it can put out a Preview that will install itself without checking first to see if it has expired. The message here is that Microsoft's time is worth more than yours.... no start-up company could get away with being that arrogant."
-- Jerry Pournelle, Byte Magazine
"Appeasement, said Winston Churchill, consists of being nice to a crocodile in the hope that he will eat you last. At the moment, the biggest crocodile in the world is Microsoft, and everybody is busy sucking up to it."
-- John Naughton, the London Observer
"Every time you turn on your new car, you're turning on 20 microprocessors. Every time you use an ATM, you're using a computer. Every time I use a settop box or game machine, I'm using a computer. The only computer you don't know how to work is your Microsoft computer, right?"
-- Scott McNealy, CEO, Sun Microsystems, Inc.
"Microsoft's biggest and most dangerous contribution to the software industry may be the degree to which it has lowered user expectations."
-- Esther Schindler, OS/2 Magazine
"Microsoft - Which end of the stick do you want today?"
-- Unknown
http://www.slothmud.org/~hayward/mic_humor/mic_quotes.html

What is silverlight ?

2010-07-14T14:42:00.002+05:30

Silverlight is a web based technology, launched by Microsoft in April 2007. Silverlight is considered as a competitor to Adobes Flash.

Silverlight applications are delivered to browsers in a text-based markup language called XAML. One important difference between Flash and XAML is, Flash is a compiled application where as XAML is text based. Search engines can analyze and index such content, which is a huge benefit for webmasters.

For regular internet users, Silverlight is a browser plug-in that supports video, audio and animations.

For web developers, Silverlight offers much more. Silverlight supports video and audio files without need of much programming. It allows them to handle events from web pages (like handle start/end of video playing etc)

Demo Links:

http://demos.telerik.com/silverlight/#Controls

http://www.componentgo.com/projectservice/#/Views/Resolutions
Here are the steps to Install silverlight :
1. Open http://silverlight.net/Default.aspx

2. Open GET STARTED Page by clicking it.

3. Find out Download Silverlight Link (If already Silverlight is installed in your machine this link will not be appeared to you).

4 If you click on Download Silverlight Link, It opens Microsoft Silverlight Install Pagehttp://www.microsoft.com/silverlight/install.aspx.

5. Click on Install Now Option then you can download the Silverlight Plug-in.

5. Then Install Silverlight By using downloaded silverlight plug-in installable setup software.

6. While Installing Silverlight you can see the progress screen as bellow.

7. Restart all of your browsers

Mouseless - an invisible computer mouse

2010-07-09T10:28:00.001+05:30

The perpetual changes in computer technology & web has seen many evolutions, right from large room size CPUs to miroprogrammed slim netbooks, heavy bulky monitors to thin LCDs, few MBs capacity hard disks to trillion capacity HDs but in all these what remained nearly unchanged and un-evolved is mouse – moving it around to help us interact computer.

Mouseless is an invisible computer mouse project done in in MIT Fluid Interfaces Group headed by Pranav Mistry, this invisible mouse provides the familiarity of interaction of a physical mouse without actually needing a real hardware mouse, hence removes the requirement of having a physical mouse altogether but still provides the intuitive interaction of a physical mouse that everyone is familiar with.

New Features in the Visual Studio 2010 IDE and .NET Framework 4.0

2010-07-06T13:30:00.000+05:30

New Features in the Visual Studio 2010 IDE

Call Hierarchy of methods
A New Quick Search
Multi-targeting more accurate
Parallel Programming and Debugging
XSLT Profiling and Debugging
The XSD Designer

New ASP.NET features

Static IDs for ASP.NET Controls
The Chart control
Web.config transformation

New VB.NET features

Auto Implemented Properties for VB.NET
Collection Initializers
Implicit Line Continuations
Statements in Lambda Expressions

New C# features

Dynamic Types
Optional parameters
Named and Optional Arguments

For More http://www.microsoft.com/visualstudio/en-us/products/2010/default.mspx

Obtaining information about the queries by average CPU time.

2010-06-30T10:38:00.001+05:30

1. SQL Exection CUP Times

It’s very use full one for optimizing and fine turning the SQL, and also to compare the SQL

CREATE PROC mySqlTime as

SELECT total_worker_time/execution_count AS [Avg CPU Time],

SUBSTRING(st.text, (qs.statement_start_offset/2)+1,

((CASE qs.statement_end_offset

WHEN -1 THEN DATALENGTH(st.text)

ELSE qs.statement_end_offset

END - qs.statement_start_offset)/2) + 1) AS statement_text

FROM sys.dm_exec_query_stats AS qs

CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st

ORDER BY total_worker_time/execution_count DESC;

exec mySqlTime

2. SQL Time with details (mySqlTimeDetails)

The text of SQL queries that are being executed in batches and provides statistical information about them.

CREATE PROC mySqlTimeDetails as

SELECT s2.dbid,

s1.sql_handle,

(SELECT TOP 1 SUBSTRING(s2.text,statement_start_offset / 2+1 ,

( (CASE WHEN statement_end_offset = -1

THEN (LEN(CONVERT(nvarchar(max),s2.text)) * 2)

ELSE statement_end_offset END) - statement_start_offset) / 2+1)) AS sql_statement,

execution_count,

plan_generation_num,

last_execution_time,

total_worker_time,

last_worker_time,

min_worker_time,

max_worker_time,

total_physical_reads,

last_physical_reads,

min_physical_reads,

max_physical_reads,

total_logical_writes,

last_logical_writes,

min_logical_writes,

max_logical_writes

FROM sys.dm_exec_query_stats AS s1

CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS s2

WHERE s2.objectid is null

ORDER BY s1.sql_handle, s1.statement_start_offset, s1.statement_end_offset;

--Run The SQL

exec mySqlTimeDetails

Ref :MSDN

Passing a own class back to the server

2010-06-29T10:51:00.000+05:30

Class Examples

The first example will return an own class that has some public fields to be used on the client-side JavaScript.

public class MyClass

{

public string FirstName = "";

public string FamilyName = "";

public int Age = 0;

}

It is also working if you inherit from a class and add your own properties to the new class.

public class MyInheritedClass : MyClass

{

public double SizeInMeters = 0.0;

public Guid ID = Guid.Empty;

}

Passing a own class back to the server

Next we want to pass the MyClass object back to the server. The first call will get an MyClass object from the server like we have done above. Then we want to modify the .FirstName property on the client, submit the object to the server, modify the .FamilyName there and see the results.

function doTest3() {

// synchronous call to the server-side method to get an MyClass object

var p = AJAXDemo.Examples.Classes.Demo.GetMyClass().value;

p.FirstName = "CLIENT-SIDE CHANGE"; // change one property

AJAXDemo.Examples.Classes.Demo.PutMyClass(p, doTest3_callback);

p = null;

}

[AjaxMethod]

public MyClass PutMyClass(MyClass c)

{

c.FamilyName = "SERVER-SIDE CHANGE"; // change one property

return c;

}

Create converters for your classes

One new feature is the use of converters to serialize a .NET object or deserialize a JSON string. In this example I am using a custom IJavaScriptConverter. This converter will return a new class on the client-side JavaScript that may have more properties or methods that are not returned using the built-in custom object converter (which will only return public fields and properties).

function doTest4() {

var p = AJAXDemo.Examples.Classes.Demo.GetPerson().value; // synchronous call to the server-side method

// access the properties of the Person object here

alert(p.FirstName);

// Now, we want to save it, we call the save method of the instance

// and get a boolean if succeded.

var b = p.save();

}

Ref :http://www.ajaxpro.info/Examples/Classes/default.aspx

List the COLUMN_NAME in MS SQL Tables

2010-06-20T16:05:00.004+05:30

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = 'mpidallergy'

For all Tables

====================================================

SELECT table_name=sysobjects.name,

column_name=syscolumns.name,

datatype=systypes.name,

length=syscolumns.length

FROM sysobjects

JOIN syscolumns ON sysobjects.id = syscolumns.id

JOIN systypes ON syscolumns.xtype=systypes.xtype

WHERE sysobjects.xtype='U'

ORDER BY sysobjects.name,syscolumns.colid

Random Data Sampling Queries in SQL Server 2005

2010-05-31T16:26:00.001+05:30

The following query will return a random sampling of data:

SELECT * FROM PHTTEMPORDERSHEET TABLESAMPLE SYSTEM (1 PERCENT);
SELECT * FROM PHTTEMPORDERSHEET TABLESAMPLE SYSTEM (100 PERCENT);

SELECT * FROM PHTTEMPORDERSHEET TABLESAMPLE SYSTEM (20 ROWS)
SELECT * FROM PHTTEMPORDERSHEET TABLESAMPLE SYSTEM (200 ROWS)

Not only will the records returned be random, but so will the number of rows.

Understanding "login failed" (Error 18456) error messages in SQL Server 2005

2010-05-28T09:24:00.001+05:30

In continuing with the theme of understanding error messages I'll discuss the "login failed" messages that are surfaced by the client and written to the server's error log (if the auditlevel is set to log failures on login which is the default) in the event of an error during the login process.

If the server encounters an error that prevents a login from succeeding, the client will display the following error mesage.

Msg 18456, Level 14, State 1, Server , Line 1
Login failed for user ''

Note that the message is kept fairly nondescript to prevent information disclosure to unauthenticated clients. In particular, the 'State' will always be shown to be '1' regardless of the nature of the problem. To determine the true reason for the failure, the administrator can look in the server's error log where a corresponding entry will be written. An example of an entry is:

2006-02-27 00:02:00.34 Logon Error: 18456, Severity: 14, State: 8.

2006-02-27 00:02:00.34 Logon Login failed for user ''. [CLIENT: ]

The key to the message is the 'State' which the server will accurately set to reflect the source of the problem. In the example above, State 8 indicates that the authentication failed because the user provided an incorrect password. The common error states and their descriptions are provided in the following table:

ERROR STATE	ERROR DESCRIPTION
2 and 5	Invalid userid
6	Attempt to use a Windows login name with SQL Authentication
7	Login disabled and password mismatch
8	Password mismatch
9	Invalid password
11 and 12	Valid login but server access failure
13	SQL Server service paused
18	Change password required

Other error states indicate an internal error and may require assistance from CSS.

Ref Link :http://blogs.msdn.com/

MS SQL Stored procedure with XML

2010-05-27T17:17:00.000+05:30

I find that it's easiest to visualize if you start with a very simple XML document. Here is an example XML snippet:

Here is how that stored procedure would be written:

alter procedure usp_InsertManyRows

@XMLDOC varchar(8000)

declare @xml_hndl int

--prepare the XML Document by executing a system stored procedure

exec sp_xml_preparedocument @xml_hndl OUTPUT, @XMLDOC

--insert into table

Insert Into testtable

(

InsertedID

)

Select

IDToInsert

From

OPENXML(@xml_hndl, '/items/item', 1)

With

(

IDToInsert int '@id'

)

Now follows a comparison of how each performs. The following tests were run with simple ASP.NET pages using a local SQL Server database. The results are quite dramatic, and would only be more dramatic if the hits had to go over the network.

XML files from SQL Database

2009-03-28T12:50:00.000+05:30

Sub Page_Load(Source as Object, E as EventArgs)

Dim strCon as string = "Server=127.0.0.1;uid=sa;pwd=;Database=Northwind;"
Dim strSQL as string = "Select EmployeeID, FirstName, LastName, Address, City, PostalCode, Country from Employees
order by EmployeeID desc"
Dim objDataSet as New DataSet()
Dim objCon as SQLConnection
Dim objAdapter as SQLDataAdapter

objCon = New SQLConnection(strCon)
objAdapter = New SQLDataAdapter(strSQL, objCon)

objAdapter.Fill(objDataSet, "Empls")

objDataSet.WriteXml(Server.MapPath("emp_xml_file.xml"))
message.text = "Check your XML file"

end sub

ASP.NET

2009-03-18T15:36:00.000+05:30

1. Describe the role of inetinfo.exe, aspnet_isapi.dll andaspnet_wp.exe in the page loading process.
inetinfo.exe is theMicrosoft IIS server running, handling ASP.NET requests among other things.When an ASP.NET request is received (usually a file with .aspx extension), the ISAPI filter aspnet_isapi.dll takes care of it by passing the request tothe actual worker process aspnet_wp.exe.

2. What’s the difference between Response.Write() andResponse.Output.Write()?
Response.Output.Write() allows you to write formatted output.

3. What methods are fired during the page load?
Init() - when the page is instantiated
Load() - when the page is loaded into server memory
PreRender() - the brief moment before the page is displayed to the user as HTML
Unload() - when page finishes loading.

4. When during the page processing cycle is ViewState available?
After the Init() and before the Page_Load(), or OnLoad() for a control.

5. What namespace does the Web page belong in the .NET Framework class hierarchy?
System.Web.UI.Page

6. Where do you store the information about the user’s locale?
System.Web.UI.Page.Culture

7. What’s the difference between Codebehind="MyCode.aspx.cs" andSrc="MyCode.aspx.cs"?
CodeBehind is relevant to Visual Studio.NET only.

8. What’s a bubbled event?
When you have a complex control, like DataGrid, writing an event processing routine for each object (cell, button, row, etc.) is quite tedious. The controls can bubble up their eventhandlers, allowing the main DataGrid event handler to take care of its constituents.

9. Suppose you want a certain ASP.NET function executed on MouseOver for a certain button. Where do you add an event handler?
Add an OnMouseOver attribute to the button. Example: btnSubmit.Attributes.Add("onmouseover","someClientCodeHere();");

10. What data types do the RangeValidator control support?
Integer, String, and Date.

11. Explain the differences between Server-side and Client-side code?
Server-side code executes on the server. Client-side code executes in the client's browser.

12. What type of code (server or client) is found in a Code-Behind class?
The answer is server-side code since code-behind is executed on the server. However, during the code-behind's execution on the server, it can render client-side code such as JavaScript to be processed in the clients browser. But just to be clear, code-behind executes on the server, thus making it server-side code.

13. Should user input data validation occur server-side or client-side? Why?
All user input data validation should occur on the server at a minimum. Additionally, client-side validation can be performed where deemed appropriate and feasable to provide a richer, more responsive experience for the user.

14. What is the difference between Server.Transfer and Response.Redirect? Why would I choose one over the other?
Server.Transfer transfers page processing from one page directly to the next page without making a round-trip back to the client's browser. This provides a faster response with a little less overhead on the server. Server.Transfer does not update the clients url history list or current url. Response.Redirect is used to redirect the user's browser to another page or site. This performas a trip back to the client where the client's browser is redirected to the new page. The user's browser history list is updated to reflect the new address.

15. Can you explain the difference between an ADO.NET Dataset and an ADO Recordset?
Valid answers are:
• A DataSet can represent an entire relational database in memory, complete with tables, relations, and views.
• A DataSet is designed to work without any continuing connection to the original data source.
• Data in a DataSet is bulk-loaded, rather than being loaded on demand.
• There's no concept of cursor types in a DataSet.
• DataSets have no current record pointer You can use For Each loops to move through the data.
• You can store many edits in a DataSet, and write them to the original data source in a single operation.
• Though the DataSet is universal, other objects in ADO.NET come in different versions for different data sources.

16. What is the Global.asax used for?
The Global.asax (including the Global.asax.cs file) is used to implement application and session level events.

17. What are the Application_Start and Session_Start subroutines used for?
This is where you can set the specific variables for the Application and Session objects.

18. Can you explain what inheritance is and an example of when you might use it?
When you want to inherit (use the functionality of) another class. Example: With a base class named Employee, a Manager class could be derived from the Employee base class.

19. Whats an assembly?
Assemblies are the building blocks of the .NET framework. Overview of assemblies from MSDN

20. Describe the difference between inline and code behind.
Inline code written along side the html in a page. Code-behind is code written in a separate file and referenced by the .aspx page.

21. Explain what a diffgram is, and a good use for one?
The DiffGram is one of the two XML formats that you can use to render DataSet object contents to XML. A good use is reading database data to an XML file to be sent to a Web Service.

22. Whats MSIL, and why should my developers need an appreciation of it if at all?
MSIL is the Microsoft Intermediate Language. All .NET compatible languages will get converted to MSIL. MSIL also allows the .NET Framework to JIT compile the assembly on the installed computer.

23. Which method do you invoke on the DataAdapter control to load your generated dataset with data?
The Fill() method.

24. Can you edit data in the Repeater control?
No, it just reads the information from its data source.

25. Which template must you provide, in order to display data in a Repeater control?
ItemTemplate.

26. How can you provide an alternating color scheme in a Repeater control?
Use the AlternatingItemTemplate.

27. What property must you set, and what method must you call in your code, in order to bind the data from a data source to the Repeater control?
You must set the DataSource property and call the DataBind method.

28. What base class do all Web Forms inherit from?
The Page class.

29. Name two properties common in every validation control?
ControlToValidate property and Text property.

30. Which property on a Combo Box do you set with a column name, prior to setting the DataSource, to display data in the combo box?
DataTextField property.

31. Which control would you use if you needed to make sure the values in two different controls matched?
CompareValidator control.

32. How many classes can a single .NET DLL contain?
It can contain many classes.

Drop all Database Connections

2009-03-06T11:30:00.000+05:30

Although this could be a very dangerous script to run, it is very useful when you need to do some maintenance on a database and there are some rouge connections open stopping you from doing so. The script will run through all users currently connection to the specified database and kill their connection.

Use Master
Go
Declare @dbname sysname
Set @dbname = 'name of database you want to drop connections from'
Declare @spid int
Select @spid = min(spid) from master.dbo.sysprocesses
where dbid = db_id(@dbname)
While @spid Is Not Null
Begin
Execute ('Kill ' + @spid)
Select @spid = min(spid) from master.dbo.sysprocesses
where dbid = db_id(@dbname) and spid > @spid
End

If you know of any more tips or tricks please share them with me...

SQL Server connection strings

2009-03-06T11:13:00.000+05:30

SQL Server connection strings
Standard Security:
"Driver={SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Uid=Your_Username;Pwd=Your_Password;"

Trusted connection:
"Driver={SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=yes;"

SQL OLE DB connection strings

Standard Security:

"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;"

Trusted connection:

"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;"

SQL OleDbConnection .NET strings

Standard Security:

"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;"

Trusted connection:

"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;"

SQL SqlConnection .NET strings
Standard Security:

1. "Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;"
2. "Server=Your_Server_Name;Database=Your_Database_Name;UserID=Your_Username;Password=Your_Password;Trusted_Connection=False"

Trusted connection:
1. "Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;"
2."Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=True;"

ASP.NET 2.0 Nested GridView

2009-03-03T14:24:00.000+05:30

Confirmation before the event fire

2009-02-21T10:39:00.000+05:30

The purpose of Attributes

In asp.net one of the main control is command Button. My scenario is display the confirmation before the event fire. Let we see

It’s simple

Use JavaScript function “confirm”.

Syntax:

[controls]. Attributes.Add(strkeys as string , values as string)

Code :

btnExit.Attributes.Add("OnClick","return confirm('Exit from this Page')");

btnExit – Command Button
Attributes- basic control Attributes( HTML controls or Client controls)
So when you add an Attributes its fire on the Client side without server requst
OnClick- Event Name . Not only the events css also
Confirm- JavaAcript

Example or Events:

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// set the Attributes at the time of form loading

btnExit.Attributes..Add("OnClick","return confirm('Exit from this Page')");
}
}

Another one Example with CSS :

protected void grdRackingmaster_RowDataBound(object sender, GridViewRowEventArgs e)
{

// set the row background color of the gridview at the time of DataBound event

if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes.Add("onmousemove", "this.style.backgroundColor='#D1D9E5'");

e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=''");

}

}

- when the mouse moves on the gridview control row color changed

Result :

----

MS SQL Troubleshooting

2009-02-20T13:25:00.000+05:30

Sp_who & Sp_who 2

My friends! How to know your MS SQL, Doing what? , Way the system slow? , How may progress currently going on!. Here is the answer.

In SQL so many System stored procedures available. Let we see two stored procedures one is sp_who and sp_who2. This two are useful.

1.Sp_who (Show the Information about current users and processes)

Syntax :
---------
sp_who [[@login_name =] 'login']

Result:

Spid—The system process ID.
status—The status of the process (e.g., RUNNABLE, SLEEPING).
loginame—Login name of the user.
hostname—Machine name of the user.
blk—If the process is getting blocked, this value is the SPID of the blocking process.
dbname—Name of database the process is using.
Cmd—The command currently being executed (e.g., SELECT, INSERT)

2.Sp_who2

Show some additional information

Syntax :
---------
sp_who2 [[@login_name =] 'login']

Result:

CPUTime—Total CPU time the process has taken.
DiskIO—Total amount of disk reads for the process.
LastBatch—Last time a client called a procedure or executed a query.
ProgramName—Application that has initiated the connection (e.g., Visual Basic, MS SQL Query Analyzer)

---------------

Ajax

2009-02-18T10:59:00.000+05:30

AJAX = Asynchronous JavaScript and XML
AJAX is not a new programming language, but a technique for creating better, faster, and more interactive web applications.
With AJAX, your JavaScript can communicate directly with the server, using the JavaScript XMLHttpRequest object. With this object, your JavaScript can trade data with a web server, without reloading the page.
AJAX uses asynchronous data transfer (HTTP requests) between the browser and the web server, allowing web pages to request small bits of information from the server instead of whole pages.
The AJAX technique makes Internet applications smaller, faster and more user-friendly.

2009-02-18T10:43:00.000+05:30

SQL Server

The final choice to save the session information is using the Sql Server 2000 database. To use Sql Server for storing session state you need to do the following:

1) Run the InstallSqlState.sql script on the Microsoft SQL Server where you intend to store the session.

You web.config settings will look something like this:

SQL Server lets you share session state among the processors in a Web garden or the servers in a Web farm. Apart from that you also get additional space to store the session. And after that you can take various actions on the session stored.

The downside is SQL Server is slow as compared to storing session in the state in process. And also SQL Server cost too much for a small company.

Asp .net Web.config Configuration

2009-02-18T10:31:00.000+05:30

1.What is Web.Config File?
Web.config file, as it sounds like is a configuration file for the Asp .net web application. An Asp .net application has one web.config file which keeps the configurations required for the corresponding application. Web.config file is written in XML with specific tags having specific meanings.

2.What is Machine.config File?

As web.config file is used to configure one asp .net web application, same way Machine.config file is used to configure the application according to a particular machine. That is, configuration done in machine.config file is affected on any application that runs on a particular machine. Usually, this file is not altered and only web.config is used which configuring applications.
3.What can be stored in Web.config file?
There are number of important settings that can be stored in the configuration file. Here are some of the most frequently used configurations, stored conveniently inside Web.config file..
Database connections
Session States
Error Handling
Security