.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

i can not make query for any information in arabic language

Posted By:      Posted Date: September 05, 2010    Points: 0   Category :ASP.Net
HI,   i work on Sql Developer Edition when i select for any Company name in arabic it does not get any data ,why? although my data are inserted by arabic language,please help me asap,thank youand my code like this use   todayselect CatID from dbo.tbl_Categories where CatName like '%???????%' 

View Complete Post

More Related Resource Links

How to send an email with information in query string


First I will say I googled (Binged to make Bill happy) for this but could not find anything, perhaps I am not stating what I need correctly;

I have a website that a customer creates orders (for a printing company) and after the order, I would like to email the customer a link to view the status of their order;

I need to send the CustomerID in the link so on the returning page if a CustomerID is detected in the querystring, I "auto login" the client and open the "Dashboard" for the order page for that customer.

Can anyone point me in the right direction as to how to send the link and how to parse the querystring to get the values from the link;

Thank you if you can point me in the right direction.

Sql Server 2005 ( remove header information from query output file "Job 'bustd_Daily_Query_Output_1

Dear All,I have scheduled job for querying output & asve it into particuler folder....but in the top of file i getting the message like "Job 'bustd_Daily_Query_Output_13July09' : Step 1, 'Query1' : Began Executing 2009-07-13 16:32:06"I want to remove this & want output in txt file format without above header....RegardsRavendra Cindia

Arabic Language Support in SQL Server 2005

ummary: Microsoft SQL Server 2005 supports Arabic data in Unicode and non-Unicode formats. Get information about the Arabic language code page, collations, components, and functions, as well as feature-specific information concerning set up, administration, replication, data transformation, and more.

Make a T-SQL Query Sleep for a certain amount of time

At times, in test scenarios, you may want to emulate that a transaction or a T-SQL query takes 'x' amount of time. Well that is possible (although not with precision) in SQL Server (2005/2008) using the WAITFOR command.

Can't make parameterized query work in data flow task


I have an OLE DB source in a data flow task.  The connection is pointing to a SQL Server 2008 instance.  My SQL works fine when I click the preview button.  Now I need to make it parameterized by adding a question mark in my where clause.  After doing so & clicking the Parameters button, I get the error described in this post .  When I try to do what's described therein to correct the problem (click the "build query" button), I get the error "The PIVOT SQL construct or statement is not supported."

I can't make this query an expression; it's simply too complex to maintain that way (besides, just pasting it into an expression builder window and trying to evaluate as is doesn't work - can't evaluate).

So the question is, how do I parameterize a query?  And why does SQL here work so radically differently from SQL in an execute SQL task?

Install Sharepoint 2010 Arabic Language Pack on windows 7 x64


Dear Team,

I have installed sharepoint server on windows 7 x64, and after that when i tried to install

arabic language on my enviroment i got the following message that means "language pack need to be installed on windows server 2008 service pack 2"

I don't know what i have to do now,  i need to install language pack but at the same time i don't want to install windows server 2008

So please advise


Get information about collation of a column of a resultant select query using oledb



I have executed a select query from a table using OLEDB (IID_ICommandText) . Now I want the information about collation(Case Sensitivity,Accent Sensitivity, Kana Sensetivity, Width Sensetivity, LCID) of all the eligible columns of a select query. Can anyone please help me with a way to retrieve all of them.



asking for information about query situation


Hi all engineers.

I have an important trigger in my data base. It effects many many records so it need many much time for 4 or 5 minutes.

I want to show it's situation into bottom of my web page. for example every 10 seconds, it say how many records is affected?

or I want to show situation of every query. what is way?

Fast Query Language questions



I have some table in MS SQL Table (Id, title, body, creationDate). 

On Fast Search server side after crawling this table with JDBC connector I've mapped 'creationDate' column (as crawled property) to 'Created' managed property.

Now I want to query search web service with FQL query text syntax like this:


   <QueryText type='FQL'>near(cat, dog, N=3) AND... ?


Now, how I can add an expression for querying Created/creationDate values ?

I've been tried 'created:range(.., ..)' , 'Created &gt;= date1 AND Created &lt;= date2', but it always returns SoapException, with details that my query is malformed.


How to make sql query run faster??



Below is my query:

SELECT [FieldValue2] = case isdate(FieldValue2) When '1' then
    case isdate(FieldValue4) When '0' then
     dbo.GetCountagingDay(FieldValue2, getdate(), '') -1
FROM  test

Unable to connect to database. Check database connection information and make sure the database ser



I am using MOSS2007. My MOSS site was working fine for last 1 month and today suddenly it started to show me below message

"Unable to connect to database.  Check database connection information and make sure the database server is running."


On my server, SahrePoint admin site is working. Other port site is also working. Only my MOSS site is showing me above message.  Can anyone helkp me to resolve this issue.

How to let the user switch between English and Arabic language SharePoint sites?


I have installed MOSS 2007 Arabic Language Pack and now have SharePoint 2007 sites in both English and Arabic languages.

I have a custom UserControl in my MasterPage which is a dropdown box having the options:English and Arabic.

I want the user to select the language of his/her choice and depending on the choice,the site will be displayed in the selected language.

I have created a custom team site definition using the SharePoint 2007 WSPBuilder Project template which has custom document libraries,lists,web parts,features,usercontrols,workflows,etc.
I am deploying this WSP using STSADM commands on the WFE server.

I want to have this site language switching functionality in this custom team site definition.
The same thing which is found in the Microsoft SharePoint 2010 site at: http://sharepoint.microsoft.com/en-us/Pages/default.aspx

My current custom team site definition(WSP) uses the default English Resource file(core.en-US.resx).
How can I use the Arabic language Resource file(core.ar-SA.resx) in the same WSP Solution?

Also,suppose I create a custom publishing site definition(WSP),then I want that if the content publisher/owner/administrator publishes the content in the English language site,then the same thing must be reflected in the Arabic language site as well.

That is,any content ch

How to make a Bangla language based database and software ?


I want to create a software using C#.NET which is a Spell Checker for Bangla Language. For this, I need to build a database which will store the 'Bangla' words and by programming, it will check the spelling.
I also asked the same question in Codeproject.com .Anyone replied me "Make sure your database is Unicode capable and aware".So which which are Unicode Capable database.Is SQL Server?

So how can I do it?

Microsoft's Collaborative Application Markup Language (CAML) Loop

discovered an interesting error recently while working with Microsoft's Collaborative Application Markup Language (CAML) that, surprisingly, had received no ink. Partly what surprises me about this is that the error may require you to rewrite large sections of your code if you haven't previously considered this SharePoint limitation. I'll start with some context, but first of all the error is:

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

New Language features in .NET4.0

The site explains the new features and enhancement to VB.NET and C# in .NET framework 4.0. The new enhancements are described in detail with examples and code snippets. One can easily understand the new features from this site. This is a must visit site for every .NET professional.

How to Encrypt Query String Parameters in ASP.NET

Encrypt Query String Parameters in ASP.NET.u can send secure data one page another page u can also use query string to encrypt
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