.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

insert Arabic text to sql express 2005 (windows application)

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :



I need your help guys. Am devolving a windows application by c#. I have problem of insert Arabic text to sql express 2005. I always get ???? instead of the Arabic letters. I change the collation of the database field to windows collation and choose Arabic but still I get the same problem.


Your help is appreciated



View Complete Post

More Related Resource Links

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

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

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

How to insert Data into Sharepoint using windows application?

Hi, I Have sharepoint account. I have to daily insert the some profile (Name,id,address,desgination) in sharepoint. For this I have a form in sharepoint. Now I want to insert that records using windows application. I want code for how to insert the records from windows application without browse the corresponding page. Please help me ASAP and let me know if you need further clarification. Thanks, KK  Thanks, Karikalan N

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

How should an SQL statement refer to a Text field value on a Windows Form Application?


In a WindowsFormApplication, I have a form that contains an MS Office Spreadsheet (an Office Web component).  The data source of the spreadsheet is  an Oracle table which is referenced in an SQL statement  - for example, the following works fine: 


I've now added a Text field (TextBox1) to the form and would like to have the SQL statement refer to the value of this field.  I've tried various syntaxes, including the following::


This generates an error (ORA00904: "HOST: invalid identifier)

I've also tried the following: 


This generates an error (ORA00904: "FORM1"."TEXTBOX1"."VALUE": invalid identifier)

I'd appreciate any ideas on what the correct syntax should be in referring to the Text field or whether or not this is even possible.


Pagination and Data buffering in Windows Application using C# 2005


.NET Windows application using C# interacts with Oracle DB for retrieving and saving data

With huge volume of data, the performance is slow and the memory usage is high, the application displays the entire data in the screen. Response time is high due to database call and client side data processing

Proposed Solution
Using pagination (from Oracle DB) to display partial data in the screen, response time of the application will be faster; however, it will make DB calls for each page. We are looking at a solution to get the 1st page data from DB and start the application, after which there will be a background job to get the rest of the data from DB to a local XML DB. So, in case of next page, the data will be loaded from XML instead of making a DB call.

Is this design possible?
Is synchronization possible between local XML DB and the Oracle DB?

Why does SQL Server 2005 Express SP3 prompt to insert next disk when run from CD?



Why does SQL Server 2005 Express SP3 prompt to insert next disk when run from CD?


Replication Steps:


1. Download SQL Server 2005 Express with SP3 (SQLEXPR.EXE)



2. Extract the SQLEXPR.EXE using the "/X" cmd line parameter to c:\DBEngine\SQLSP3\


3. Burn to CD c:\DBEngine\SQLSP3\


4. Install a XP 32bit test machine with SQL Server 2005 Express with SP1 as the default instance with this command





5. Attempt to upgrade the XP 32 bit test machine with the SP3 CD made above with the following command




During the upgrade the installat

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

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

How to upload files to remote machine using FTP or other method in VB.Net 2005 (Windows Application)



I have to create an application to upload and download files using FTP.
Are there any classes, methods in VB.Net 2005(Windows Application) to do this?

I have created a small GUI for this.

It contains 4 text boxes - Path of Local file to be uploaded, IP address of remote machine, User name and password of remote machine At last there is one Transfer button when I click on this transfer button that file should get copied to the remote machine.


I tried this using FTPWebRequest class by reading example in msdn.

But to connect to remote machine it requires URI format of FTP and I only have IP address of that remote machine. I think there is no web server on that remote machine.

Should I need to install web server on that remote machine.

Or is there any other method to do upload files to remote machine ?


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.



SQL Server 2005 random login failures for windows forms application


One of our VS .NET 2008 windows forms applications runs from multiple client machines. The application randomly has login failures from random machines and from random places in the code. The login works almost every time but about once every fifteen minutes an error shows up in SQL Server error logs from a random user. We are running a clustered SQL Server 2005 system and the database is in 2005 (90) mode.

The following error appears in the SQL Server error logs:

Login failed for 'App_Login'. [CLIENT: XXX.XXX.X.XXX] Error: 18456, Severity: 14, State: 16.

The following error is what the client sees:

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