I have excel file which has got mixed of Japanese & English written in it. I need to read it using stream reader, I changed it's extension as .CSV and now I am trying to read all the content.
While reading, I am getting random numbers/alphabets/and hexa blocks.
Can anyone please have a look and let me know what is the best way to read out Japanese from a excel changed CSV file?
Here is my code:
...
Manikrag
Last Activity: Nov 29 '10, 02:44 PM
Joined: Jun 3 '09
Location: Bangalore
-
Issue in deleting session ID from Dictionary object
Please help as this issue is driving us crazy...
Any idea would be of great help..
Application is running over IIS and I am getting error "
Index was outside the bounds of the array." on the Session_Start on line
Code:AllSessions[Session.SessionID] = GetSession.GetNewSession(Context);
When I tried to catch the error I got random values for AllSessions.Cou nt. It touched 77 and after a day it... -
thank you!!
My connection string is as given below and working for other forms..but end of the day I would say tht instead of connecting from below string it is trying from domain\server user which I am not sure why is happening
"data source=ServerNa me;Database=Dat abaseName;User ID=user;Passwor d=password;Mult ipleActiveResul tSets=True;"; -
thanks Frinavale..hope you are doing good.
The user Domain\Server$ coming into error is not at all into picture. I checked the connection string and its correct.Leave a comment:
-
Login failed for user domain\servername
Hi Team,
I am facing a strange issue, I have an application on a sever with SQL. I shifted it from one server to other. Configured all the connection strings. Now, when I am trying to access login page..it is showing below error
Error authenticating user. Cannot open database "DBAPP" requested by the login. The login failed.Login failed for user Domain\Server$' .
Strange thing is I am... -
you guys are right
install ajax msi file on server - in my case it was ASPAJAXExtSetup .msi and copy AjaxControlTool kit.dll under your bin directoryLeave a comment:
-
got a better way, sharing it for others who might be OR will be in the same situation where I was..
System.Data.Sql Client has a class - SqlBulkCopy (http://msdn.microsoft.com/en-us/libr...lbulkcopy.aspx) - this can copy tables as per the select command over servers like a charm..try u will love it :)
SqlCommand cmd = new SqlCommand("SEL ECT QUERY", dbConn_source);
dbConn_target.O pen();...Leave a comment:
-
Sorry about that - I was desperate and was looking for reaction on the issue which i did not get..Point taken anyway!!Leave a comment:
-
Urgent dataset question
Hi
I did not find any solution on internet so pretty basic question here:
I am trying to copy a dataset to a new dataset by
ds1 = ds.Copy(); // ds has one row
After that I am trying to update the SqlDataAdapter by using below statement
adptr.Update(ds 1.Tables["table name"]);
I am not facing any issue but the...Leave a comment:
-
Question on DataSet
Hi
I did not find any solution on internet so pretty basic question here:
I am trying to copy a dataset to a new dataset by
ds1 = ds.Copy(); // ds has one row
After that I am trying to update the SqlDataAdapter by using below statement
adptr.Update(ds 1.Tables["table name"]);
I am not facing any issue but the SqlDataAdapter is not adding the new... -
just poasting for ppl looking ard the same solution - what really worked for me was -
EXEC sp_addlinkedsrv login @rmtsrvname = 'RemoteServerNa me'
, @useself = 'false'
, @locallogin = 'LocalSqlUSER'
, @rmtuser = 'SeverSqlUser'
, @rmtpassword = 'SeverSqlPasswo rd'
Thanks,
ManikLeave a comment:
-
it linked after mapping a local sql user to a server sql user..but as per our dbAdmin it's not a secure way and it will have a ongoing dedicated connection both the database..which should not be the case.
Can anyone confirm that link server build a dedicated connection with the linked server?Leave a comment:
-
sp_linkedservers did not help in linking server
Hi Team,
I am trying to run a query on my local system and trying to access a table from a remote server..here is the query:
select * from SERVER.DATABASE .DBO.TABLE
This query is working fine but when I am trying to access the same from db server I am getting error as given below:
TCP Provider: An existing connection was forcibly closed by the remote host. Login failed for user 'USER'.... -
great - thanks man, I am searching on it hope I will get smthing.Leave a comment:
-
:) great idea - I will go thru it and refresh myself.
But I would like to know about the standard approach for such cases. I have following options
1. how about linking the servers. What are the +ves and -ves.
2. Updating the tables using dataset or datareader.
It would be quick if I can run it thru a single query as written below.
INSERT INTO table2 SELECT * FROM Server1.Databas e.dbo.table1...Leave a comment:
-
thanks you very much! It would be great if you can direct me what exactly I should look for in above tutorials!
Thanks again!!Leave a comment:
-
INSERT SELECT from different server
Hi Team,
I have 2 tables on two database servers and I want table1 to feed table 2.
I have a database user "WEB" on both the databases with diff passwords.
I open a SqlConnection connection for database2 and execute following thru ExecuteNonQuery .
Query = "INSERT INTO table2 SELECT * FROM Server1.Databas e.dbo.table1
On running this query, I am getting below error
... -
Manikrag started a topic No connection could be made because target machine actively refused it 127.0.0.1:xxxxin .NETNo connection could be made because target machine actively refused it 127.0.0.1:xxxx
Hi Team,
I am facing an issue which is driving me crazy: I am trying to use a API for injecting some DB info. to an external system. I can call one of the function which is directing to a URL after all processingsand its working all fine. Issue is with other functions whcih are updating/deleting information to the external system. I am pasting the error below, please have a look and let me know the nature of the issue. I did google... -
Nop Debasis, it will return PREFERRED_NAME in alphabetical. For exmple, out put will be like this:
Ashar
Bishar
Sharath
Sharma
Zashar
I need to have Sharrath & Sharma on the top.Leave a comment:
-
thanks Biswas for your response.
Actully I am looking for smthing like this
select top 10 PREFERRED_NAME from PS_ARIBA_PHONE_ LIST_TBL where
Lower(PREFERRED _NAME) like '%krishna%'
order by
CASE PREFERRED_NAME
when 'krishna%' THEN 1
when '%krishna%' THEN 2
ELSE 100
END
That means: First it should give name starting from krishna...Leave a comment:
No activity results to display
Leave a comment: