Monday, August 20, 2007

NFL Picks for office 2007 asp.net C#

http://nfl.aspnet.googlepages.com/nflasp.net2.0code

Thursday, August 9, 2007

Excel Transpose Data

Excel Transpose Data


Excel: Transpose Data
If you have data in columns and you wish that data were in rows (or if you have data in rows that you wish were in columns), you do not need to retype it.
Simply select the data and hit the Copy button.
Next, select the cell that you want to become the upper left corner of the new range of data.
Go to the menu bar and choose Edit Paste Special. In the Paste Special dialog box, choose Transpose.

or
=TRANSPOSE(A1:A3)


www.svdeals.com super value deals

Thursday, August 2, 2007

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'xxxxxxx\ASPNET' in C#, VB.NET, ASP.NET

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'SANTOSH_LAPTOP\ASPNET' in C#, VB.NET, ASP.NET: "Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'xxxxxx\ASPNET'"



Open SQL Enterprise Manager
Locate Server
Open Security Folder => Logins
Now right-click and select “New Login…”
1) Create user with Name : ASPNET
2) Select Domain : “ServerName” to connect
3) Grant permissions to access database with “Server Roles” tab
4) Also permit database access with “Database Access” tab.



www.svdeals.com access database deals