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

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

How to find students positions Based on their marks in Microsoft Sql Server Compact?

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

hi everybody! i have the following table in Microsoft Sql server Compact

1  aaa        90
2  bbb        90

3  ccc        80

4  ddd       75

5  eee      75

6  fff        70

7  ggg      68

I need to obtain the following results

ID  NAME    MARKS Position
1    aaa       90         1
2    bbb       90         1

3    ccc       80         2

4    ddd      75          3  

5   eee  

View Complete Post

More Related Resource Links

Failed to find SharePoint server when using Microsoft Transporter Suite

When attempting to migrate a Lotus Domino application into MOSS 2007 using the Microsoft Transporter Suite 2007, I get the error: "Failed to find SharePoint server for URL: http://shp7/resimport".  I have installed the Transporter Suite on the SharePoint server (Windows 2003), and am running it under an account with full SharePoint admin rights.  I fill out the Target SharePoint site and Target SharePoint list boxes as directed in the Transporter console's help.  I know the site is running, as I can see it when I use http://shp7/resimport in IE from the server.  Anybody else experience this problem?

Microsoft SQL Server Compact Edition & CE6


I have an issue on a Janam barcode scanner (wifi) with an App I have written, it appears the realtime SQL login screen intermittently puts a call onto the network when we run it on CE6. When we run the same app on a Psion scanner with CE5 it works every time. I get the feeling its an SQL timing issue / lockout on the local client as no network traffic happens when it occurs, we restart the app and it sometimes works ??

The app is written in VS2008, the framework is v3.5, the cab on the terminal is sqlce.wce5.armv4i.CAB. there is currently no wce600 build but reading up the wce500 should be OK with ce6 ???

Anyone know of any SQL issues like this or what stops the connection to the SQL Server on the network?

Microsoft SQL Server Compact 3.5 Not Listed as a Connection in VB.NET 2008


SSCERuntime-ENU.msi is installed in "C:\ProgramFiles\Microsoft SQL Server Compact Edition" (confirmed). When trying to add a connection in VS.Net 2008 (Server Explorer> Data Connection > Add Connection > Data source)SQL Server Compact SQL Editionis not listed.

When trying to "Add Existing Item" (XXX.sdf) this message is displayed.

"The data provider requires to connect to the local data file could not be found. The file will be added to the project but the typed DataSet associated with the file will not be generated."

I've never used a local instance of SQL.

What am I missing

Thanks for any help.



Requests to Microsoft after using SQL Server Compact

Visual Studio 2008 really places a lot of emphasis on SQL Server Compact.  I recently tried it out for a course project in Information Visualization.  I had some existing data I needed to visualize that was in Access Jet (MDB) format, which I wanted to copy into a new SDF file.  This should have been extremely straightforward to do, but it actually turned out to be a nightmare.

For comparison, I also have SQL Server Express 2008 installed, as well as Microsoft Access 2007.  To transfer a database from an MDB file to SQL Server Express 2008, I could do any of the following:
  • Start Access 2007.  Open the MDB file.  Click the "External Data" ribbon.  In the "Export" group, click "More", and click "ODBC database".  Select the DSN for SQL Server Express 2008.  Continue following the wizard.
  • Start Access 2007.  Open the MDB file.  Click the "Database Tools" ribbon.  In the "Move Data" group, click "SQL Server".  Follow the wizard.
  • Start the SQL Server Import and Export Wizard (a.k.a. DTS).  For "Data Source", choose "Microsoft Access" and select the file.  For "Destination", select from any of these three choices and choose the appropriate options:
    • .Net Framework Data Provider for SQL Server
    • Microsoft OLE DB Provider f

CLR Integration With Microsoft SQL Server

Transact-SQL provides as much flexibility as possible but, because it is not a real programming language, it has some shortcomings about many issues (memory management, exception handling, debugging, file processing (or streaming), object-orientation (classes), or thread management). Transact-SQL also lacks features of normal libraries (arrays, collections, serialization, expressions, or string manipulations, etc).

User Defined Functions in Microsoft SQL Server

User Defined Functions are compact pieces of Transact SQL code, which can accept parameters, and return either a value, or a table. They are saved as individual work units, and are created using standard SQL commands. Data transformation and reference value retrieval are common uses for functions. LEFT, the built in function for getting the left part of a string, and GETDATE, used for obtaining the current date and time, are two examples of function use. User Defined Functions enable the developer or DBA to create functions of their own, and save them inside SQL Server.

dynamically adding sql server columns based on number of files in fileuploader


I want to create a new table to sql database at runtime.  The column names would be "Name", "Date", "Event".  I would also like to have one more column name "Image" but the problem is that since the amount of images will vary, I want the application to count the amount of files in the Multiple fileuploader and then add a image column to the table for the respected amount of files. 

For example if i am uploading 3 files in the multiple fileuploader, the names should be "Name", "Date", "Event", "Image1", "image2", Image3"

I also would like that table name to be name dynamically from the textbox Name when the user enters the information.


I have the following code to make a new table, but I dont know how to name the fields at runtime like previously asked please help!!!


Dim objConn As New SqlConnection("Server=<servername>;uid=<userid>;pwd=<password>;database=master")


LDAP - Can't find server


Hey people,

I would like to get a persons name from their username - a common query on forums i know, but i haven't managed to get mine working yet and any help would be appreciated.

I currently have this code that I found here: http://www.vbforums.com/showthread.php?t=612655 (Thanks Chris128)

I have adapted it from VB into VB.net. The page renders but when i enter my username into the Username textBox and hit the submit button (Which calls IsUser) I just get "The specified domain either does not exist or could not be contacted." I have tried lots of other code but I always get this response...

If anyone can help by posting links to a tutorial or another post for code that they know works, i will give it a go.


Imports System.DirectoryServices

Partial Class UserInfo
    Inherits System.Web.UI.Page

    Private Function GetRealNameFromAd(ByVal UsernameToFind As String) As String
        Using searcher As New DirectorySearcher(New DirectoryEntry())
            searcher.PageSize = 1000
            searcher.SearchScope = SearchScope.Subtree
            searcher.Filter = "(&(samAccountType=805306368)(sAMAccountName=" & UsernameToFind & "))"
            Using Results A

Security Briefs: Add a Security Bug Bar to Microsoft Team Foundation Server 2010


Take a peek inside Microsoft's strict development security structure as Bryan Sullivan describes the objective security bug classification system?the "bug bar"?used by internal product and online services teams. He will show you how to incorporate this classification system into your own development environment using Microsoft Team Foundation Server 2010.

Bryan Sullivan

MSDN Magazine March 2010

ISA Server 2004: Developing an Application Filter for Microsoft Internet Security and Acceleration S


The beta version of Internet Security and Acceleration (ISA) Server 2004 is now publicly available. It includes a rich SDK with several extensibility mechanisms that allow third parties to integrate their specialized solutions on top of the ISA platform. In this article, the author explores the application filter extensibility mechanism, which enables you to add high-level application layer filtering capabilities to ISA Server and to provide rich content filtering solutions. He also highlights the new features of the ISA Server 2004 SDK, then moves on to describe how to develop a basic application filter that monitors all data going through the ISA Server, and how to integrate a filter into the ISA Server management console to create a seamless interface experience for your users.

Yigal Edery

MSDN Magazine March 2004

Go Mobile: Create Compact, Robust Mobile Apps with SQL Server CE 2.0 and the .NET Compact Framework


Developers have myriad options when it comes to creating solutions for mobile devices. One of the greatest challenges facing mobile developers is finding a compact yet robust local storage solution. SQL Server CE 2.0 promises to deliver on both fronts. This new release represents a tremendous leap in terms of features and performance over its predecessor. This article will review some of the platform and tools choices developers have today. The authors will compare and contrast the significant new features in SQL Server CE 2.0 with the previous release. Following that, they will build a sample app for illustration.

Mark Brown and David Meunier

MSDN Magazine January 2003

.NET Interop: Get Ready for Microsoft .NET by Using Wrappers to Interact with COM-based Applications


Very soon, the development of Microsoft .NET applications will require interaction between those apps and existing COM components on both the client and the server. The .NET Framework has made provisions for this interaction by implementing various wrappers for COM objects to allow exposure of their properties and methods to .NET components. These wrappers will make it easy to make the connection between COM and .NET. After discussing wrappers, this article discusses other ways for .NET components to take part in COM+ transactions. To top off the tutorial on the interoperation of COM and .NET, the article discusses how ActiveX containers can host .NET controls, and how .NET containers can host ActiveX controls.

David S. Platt

MSDN Magazine August 2001

Upsize Your Database: Convert Your Microsoft Access Application to Take Advantage of SQL Server 7.0


What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0. Using some concrete code examples, this article takes you step by step through converting the native Jet queries in your Access application into stored procedures and pass-through queries that SQL Server can use. You'll also learn how to pass on parameters when your client-server app calls these SQL Server stored procedures and queries.

Michael McManus

MSDN Magazine June 2000

Getting Started with SQL Server Compact 4.0 and ASP.NET 4

The article Getting Started with SQL Server Compact 4.0 and ASP.NET 4 was added by tmorton on Monday, August 09, 2010.

While professional developers are waiting for the Visual Studio Tools and Designers for SQL Server Compact 4.0, I will show how impatient developers can include SQL Server Compact with ASP.NET applications, and use it from ASP.NET pages. Previously, you

"This server is not supported. Only servers up to Microsoft SQL Server 2005 are supported"



I am getting the following error when i want to add a remote connection in the Server explorer:

'This server is not supported. Only servers up to Microsoft SQL Server 2005 are supported'

what can be the problem. On Microsoft site i saw, you need to install following update: 'Microsoft Visual Studio 2005 Service Pack 1 Update for Microsoft SQL Server 2008 Support'

But i have a Microsft SQL Express Server 2005 SP3...

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