.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

Windows Mobile 5 , SQLSERVER/EXPRESS VB.Net 2005 Datareader NullException

Posted By:      Posted Date: August 29, 2010    Points: 0   Category :Sql Server
Hi all, Recently I have started learning developing Smart Device Applications using .Net.Am using WM 5.0 SQLServer 2005 Express and VS 2005 (VB). In my application, I made a form with some comboboxes and other fields.In the form load am calling a function in my classfile.This function intends to fill the combobox.Please refer the codes below. 1 . The Form Load event in the Form Imports ShoppingList.DB Public Class frmMain Dim objDB As New DB Private Sub frmMain_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load objDB.FillComboBox(cmbCat, "SELECT * FROM TABLE ORDER BY ID_PK") End Sub End Class 2 .Now the DB cls file Imports System Imports System.Data Imports System.Data.SqlClient Public Class DB Dim strCon As String = "Data Source=,1010;Initial Catalog=DB_Shopping;User ID=***;Password=****" Public Sub FillComboBox(ByVal cmbTarget As ComboBox, ByVal Sql_SP As String) Dim dbConn As New SqlConnection(strCon) Dim sqlCMD As New SqlCommand(Sql_SP, dbConn) Try dbConn.Open() Dim dr As SqlClient.SqlDataReader dr = sqlCMD.ExecuteReader() 'dr = sqlCMD.ExecuteReader(CommandBehavior.SequentialAccess) While dr.Read() cmbTarget.Items.Add(dr(0)) End While

View Complete Post

More Related Resource Links

Management Studio sql 2005 Express on Windows Server 2008 r2

Hi , i have install a application that use sql server express 2005 on a server with OS windows server 2008 r2. My question is how to make automatic backup of my database , because i cant install SQL Server 2005 Management Console on my server .   Please help me Thanks

Installing SQL Server 2005 management studio express with Windows 7

I have bought a new laptop with windows 7 premium and i cannot install sql server management studio express. I have downloaded sp3 and i still reveive an error message that it is not compatible with the os. please help

Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706) windows update install error 0xD

I have tried several times to use Windows Update to install the SQL Server 2005 Express Edition Service Pack 3 (KB955706) but it keeps failing.  When I check the install history all I get is error code 0xD59

I have Windows XP SP2 on a Core 2 Duo Dell Vostro 1500

Silent installation of SQL Express 2005 SP3 (English) on localized European Windows Systems fails wi


Dear Colleagues,  

We deliver C++ med. application with several prerequisites, including SQL Express 2005 SP3. All installations are flawless but!

The problematic installation is on German\French systems (this far it was Windows 7 32-bit, but I would expect it to fail on all flavors of supported Windows, including 64-bit, Vista etc).


SQL Express 2005 SP3 fails to recognize localized parameter [German or French] 

SQL Server Express 2005 on localized Windows



SQL Express 2005 SP3 silently installs - by using command line options and switches - well on all English editions of Windows.

However, when it comes to German (localized) Windows 7 (I suspect that other German OS editions as well), SQL Express fails to recognize recommended SQLACCOUNT="NT-AUTORITÄT\SYSTEM"; simple removal of this option from command line - and silent install goes through but sets default account to Network Service, and we really need LocalSystem instead. Oh, manual installation goes fine with all configurations, including LocalSystem; unfortunately we have to use silent install for all our customers.

Similar problem detected while installing SQL Express 2005 on French Windows 7 - SQLACCOUNT="AUTORITE NT\SYSTEM" is not taken well by installer.

Please kindly recommend a solution for this issue

Alex S

Unable to install Sqlserver 2005 SP2 on a Virtual Server - Unable to install windows install MSI fil


Okay this is making me crazy...I am on a virtual server and this will not install...anyone have the solution.



Can this be any harder? SQL Express 2005 needed on a 64bit Windows 7 upgraded machine


I run a program, WinPakSE, that controls a card access system for our building. I just upgraded the computer it ran on from XP to Windows 7 Prof 64 bit. I checked with Honeywell and they said the program will only work in 64 bit environment if I installed SQL Express 2005 and ran WinPak in XP Mode. They sent me some instructions and the following link to download SQL Express 2005:http://www.microsoft.com/downloads/details.aspx?familyid=220549b5-0b07-4448-8848-dcc397514b41&displaylang=en

So I did that and followed their directions. First thing I get a message that their are known compatibility issues and need to upgrade to Service Pack 3. Ok- I can do that. Next problem is it gives me this a warning message under ASP.Net Version Registration Requirement that says:
- ASP.Net Version Reg

Unable to Install SQL Server 2005 Express Edition on Windows 7



 i am trying to install SQL Server 2005 Express Edition on Windows 7. it requires to install Windows installer also. While installing Windows Installer it gives me error that " Do not have enough storage Space in Disk", however i have 150 GB free space in HD.

Please help.. Thanks in advance

install sql server 2005 express on 64 bit windows


I am trying to install sql server 2005 express on 64 bit windows but i get a error message saying SQLncli_x64.msi file is missing and asks me to download it.

How can i fix this problem to install the SQL server on my Windows XP x64 Edition?

SQL Server 2005 Express ODBC connection error with Windows Vista Business

I have a SQL Server 2005 Express Edition installed on a Windows Server 2003 domain machine. When I do a connection with a client running Windows XP through the SQL 2008 ODBC driver I have no problem.  The problem is when I try to establish a connection using a client running Windows Vista Business Edition which is a member of the domain. Please help me to solve this issue.

Thanks in advance
Danilo Bucheli Sánchez

Merge replication setup with SQL EXPRESS 2005 on Windows 7 Professional


Hi all,

I have a web app that runs on local and use merge replcation using sql server 2005 standard on the server and sql express 2005 on clients on XP. As you know, XP Pro laptops are getting hard to find. We are trying to change to Windows 7 Pro x64. I installed SQL Express 2005 and I don't see a subscription on "Sync Center" after I created local subscription using SSMS. I normally see the subscription in Synchronize in XP Pro right away. 

I googled about this issue and not really have a good solution. There is one link saying Windows 7 not supporting Express 2005 anymore. http://blogs.msdn.com/b/repltalk/archive/2010/03/24/using-windows-synchronization-manager-on-x64-to-synchronize-replication-revised.aspx 

If so, I would like to know what would be a solution such as can I use Sql Express 2008 R2 instead of Sql Express 2005 for client even if the server is still SQL Server 2005 Standard edition. We are planning to upgrade, but we need to hire 5 to 10 people now. My boss does not want us to keep using XP Pro. 

Any suggestion would be appreciated.



problem with windows authenticatoin while installing iis features for sqlserver 2005

while i was enabling iis and its related component for sql server 2005 on windows7 . i did not get windows authentication in security. please hepl me to get this.

Need the help while installing the MS SQL 2005 Express edition on windows 2008 server.



I want to install MS SQL 2005 Exp. edition in windows server. For that I had already downloaded the SP2 MS SQL 2005 exp. edition from Microsoft web site. I am geeting error while trying to install SQL: "The SQL service failed to strat . For more information see the SQL server books online topics, "How to view SQL server 2005 setup log files and starting SQL server manually." Our Server configuration is windows 2008 R2 with 32 bit prcessor.

Before that i had install the same but SQL Server Management Studio icon is not showing, so I unstalled SQL and then trying to fresh installation.

Please help me to resolve this issues.

Thanks in advance.


Problem with SQL Express 2005 installed on Windows 7


Hi All, I am facing problem with SQL Express 2005 ..i installed SQL Express ToolKit 2005 in my laptop having Windows 7 and when i opening SQL Express management studio....it did not give my PC name in "Server name" option..

could anyone advise what could be the problem...

Pls Advise


-- Regards Sandeep

how to install 32 bit sql server 2005 express in 64 bit windows 7 operating system?

how to install 32 bit sql server 2005 express in 64 bit windows 7 operating system?

Windows 2008R2 + MS SQL 2005 Express + "Synchronize" tool ? Where it is ...


Hello Everyone,

I just installed in a test setup a replication from SQL Server 2005 to SQL 2005 Express. Everything work fine. However, I like to schedule it to run ever hour. On the express machine, a Windows 2008R2, I cannot find the "Synchronize" tool (Normally in accessory folder). After looking online I ended up copying it from another machine. However, it does not work well.


Where is that tool in Windows 2008R2 ? I am doing something wrong ?



Windows 7 connection to SQL Server Express 2005 on Windows Server 2003


I have SQL Server Express 2005 running on Windows Server 2003 R2.

I have several remote machines running Windows XP that connect to the database engine with no problem.  I'm using an Access adp to connect.

Just connected a Windows 7 machine and installed SQL Server Express 2005 on it and cannot connect to the db engine on the server. 

Error is:

Test connection failed because of an error in initializing provider. Login failed for user ''. The user is not associated with a trusted SQL Server connection. 


I am on the network and connected fine and can access files on the server.  I am using the same connection protocols in the Data Link Properties that the XP machines use.

Any ideas are greatly appreciated.



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