.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

!!! Internal MSSQL product teams, employees & MVPs blogs list !!!

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :Sql Server

Microsoft SQL Server Team Blogs List:

·          SQL Server Storage Engine Team blog: http://blogs.msdn.com/sqlserverstorageengine/

·          PSS SQL Server Engineers blog: http://blogs.msdn.com/psssql/

·          SQL Server Security:

View Complete Post

More Related Resource Links

How to list existing blogs in a section the portal of blogs in sharepoint

I need to know how to list the existing blogs on my blog portal for users to access to read, in sharepoint 2007.

internal hyperlink is not showing in main web site hyperlink list

Hi, I am using sharepoint designer 2007. I move data from 32 bit to 64 bit architecture. some of the hyperlinkslinks are not showing in my website hyperlink list hence site is not working correctly. what should I do? How can I show internal hyperlink?  

How to create a list filter like: get all list elements from the current user and all employees from

Hello, is it possible to filter elements by the condition mentioned in the title? Tobias

list of employees - custom list or managed metadata term set ?

Hi all, I am working on a intranet site for a small company with 25 employees. They want to create a site for tracking employee training. Most of the items on this site are going to be associated with an employee entity. What is the best way to manage the employee entity ? should I create a custom list called employee or should I create a term set called employee containing the names of all 25 employees ? In a related question is it possible to add a "people picker" field to a custom list ? ( e.g. Training schedule list ) I note that for 'assign to' columns SharePoint provides a dialog which enables you to browse and select users from active directory. Is there a way to add similar lookup functionality to a custom list in SharePoint ? thanks and regards, Counie  

Report Parameter type for a list of Employees to prompt like AJAX Textbox intellisence when the user


Hi All,

I have around 300 employees report to run for a specific employee, I cannot have a Dropdown as it would be too long for the report user to choose from. Is it possible in SSRS 2008 to have a text box that would provide intellisence like AJAX textbox and provides user with Employee name to choose from database or is there any other better way to select the right mployee name to run this kind of report. being a newbie to SSRS I am unable to go furthur on this. All help is great help. Thanks in advance for responding.

Opening SharePoint List Attachments - HTTP 500 Internal Server Error


We are getting "HTTP 500 - internal server error" upon opening list attachments. The list attachments are added programmatically to the list item.

This doesn't happen for all the items in the list, but only for few items.

There is no error in the SharePoint logs and the event viewer.

Has anyone encountered this issue/error?

Opening SharePoint List Attachments - HTTP 500 Internal Server Error

Hi All,


We are programmatically attaching documents/attachments to the list item through a web-part.

I'm using the below code to accomplish this. (Fileupload control is rendered in the webpart)

Stream inputStream = this.fileUploadCtrl.PostedFile.InputStream;

byte[] buffer = new byte[inputStream.Length];

inputStream.Read(buffer, 0, (int)inputStream.Length);



spListItem.Attachments.Add(this.fileUploadCtrl.PostedFile.FileName, buffer);



The attachments are getting added fine. But in some cases, only the file is attached but not the contents. when we click on the attached file name, we get the following error:


Has anyone encountered this issue? Any help is highly appreciated.



Call web service and list product list from jquery or javascript




How can i Call web service and list product list to web page. I want do it from jquery or javascript. I want create peace of html code to paste any site to dsiplay some product. Like google adsense.

Through javascript and html codei want call to web service and get product and display site




Gmail internal chat like message box

This article provides you with the multi-functional message box window through which the usability of the web-site or any web application increases.

.Configurable MessageBox window with AJAX Support
.can set maximum number of message boxes to be visible
.can define the auto reload time, for single message, for all messages or no reload
.can create messages through a single function call
.can define auto hide time for each messages

Ready made List Types provided by SharePoint

SharePoint provides some out of the box List Types. Some of the most used ready made list types that SharePoint provides currently are listed below:

Export SharePoint List to Excel Spreadsheet Programmatically using C#

In SharePoint applications, Custom Lists are used to store business data and Document Libraries to store the documents. But for data manupulation and analysis, Microsoft Excel provides very rich features as compared to SharePoint Lists. That's why people still loves to work on Microsoft Excel Sheets.

Dropdown list in ASP.NET - How to get value selected

am sure this must be very simple, but unforunately I can't figure it out.
I have the following code which populates the dropdown lists from the database. This works fine. Now, when the user selects a particular employee name from the list, I want to get the Employee Id of the selected employee. i.e. I need to get the "Eid" value. I can do this if the EId is loaded in the dropdown list, but in this case only the employee name is displayed. Please let me know howI can get the Eid value even though it is not loaded in the dropdown list.
I would really appreciate your help

Creating Sites/Lists/List Items under Current User Context in SharePoint By Using SPUserToken

Usually we do this by performing the action under RunWithElevatedPrivileges method and updating the listitem using SPListItem.SystemUpdate() method (see here). but this approach has its own flaws like (RunWithElevatedPrivileges will run under system account, we cannot use SystemUpdate for SPSite,SPWeb,SPList, since it runs under system we will "CreatedBy" by as SystemAccount).

Editable Gridview with Textbox, CheckBox, Radio Button and DropDown List

This is an example of an editable gridview containing different ASP.NET controls. When user wants to edit values in gridview, she/he can use these controls to edit existing values in Gridview Edit Mode.

Using the Code

Get pixel format, raw format, property id list and property items image in VB.net - C#.net.

n this simple article you will learn that how we can get pixel format, raw format, property id list and property items image in VB and C#.net.

Get Pixel Format:

Image consists of pixels to get the format of the pixel we have a property named pixel format. This property returns an enumeration of pixel format. This enumeration tells the pixel format.

To demonstrate make a window application. Drag one button and a picture box on form.

Now write the following code on Button click event:

Binding an array to dropdown list


I have the following string which is a list of urls. How do I get this to work so the url shows for the selection and also is the value?      


allLinks = newAllLinks
        Me.DropDownList1.DataTextField = "Link"
        Me.DropDownList1.DataValueField = "LinkURL"
        Me.DropDownList1.Items.Insert(0, New ListItem(" - Select - ", 0))
        Me.DropDownList1.DataSource = allLinks


 ArgumentNullException: Value cannot be null.
Parameter name: container]
   System.Web.UI.DataBinder.GetPropertyValue(Object container, String propName) +121
   System.Web.UI.DataBinder.GetPropertyValue(Object container, String propName, String format) +8

Compare List


i have got two list<string> containing datas

i would like to compare the both list and the result to new list whch does not contains the same data.(basically unique data)

eg shown below..

list A       list b          list c

a             a                 d

b           d                    c

c            f                   e

f            e

plz let me knw..

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend