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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Exporting data that is in wrong code page in SQL Server

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :Sql Server
 

Hi,

I have problem, when tryin to export data from SQL Server 2005 using Integration Services.

Sql Server has collation SQL_Latin1_General_CP1_CI_AS (code page 1252), but the actual data is encoded using code page 1257 (SQL_Latin1_General_CP1257_CI_AS). When I look the data using Management Studio, it is displayed wrongly, but when I convert the string to binary, I can see that bytes are encoded using code page 1257. I'm trying to read this data using SSIS 2005, but extended characters are always handled wrongly.

How should I read this data using SSIS?

My first assumption was changing DefaultCodePage to 1257 in my OLE DB Source component (also AlwaysUseDefaultCodePage to true). But without luck.

Also tried to convert data in my SQL Server query using COLLATE, but didn't work.

Is there something I could do to get it working?

 

Thanks




View Complete Post


More Related Resource Links

Data from text files, What's wrong with my code?

  
Hi all, I have uploaded some tab-delimited .txt files on my web site (actually run on my computer, ie localhost, for now), and now I try to retrieve the data from those files. I do this by calling a vb file containg the sub below. Everything works great, except that the sub won't recognise unicode characters. I can split the resulting string using vbnewline and vbtab, but already in the sub in question, the string doesn't understand the Swedish letters åäö, apostrophes and more. Any help would be greatly appreciated! /Pettrer       Shared Function getTextfile(ByVal FullPath As String, Optional ByRef ErrInfo As String = "") As String Dim strContents As String = "" Dim objReader As StreamReader Try objReader =New StreamReader(FullPath) 'UTF8Encoding? strContents = objReader.ReadToEnd() objReader.Close() ErrInfo = Ex.MessageCatch Ex As Exception End Try Return strContents End Function  

Automatically inserting server-side page events into C# when using code separation

  
I know this is a really basic question and I have spent the last half hour trying to find an answer so please forgive me if this has been asked before (it probably has)....When I create a web page with the C# code placed in a separate file I can't seem to easily add page events (apart from Page_Load). When I open the C# class code for the page all I see in the two drop-down boxes above the code is "Default" (with no other options in the drop-down) in the left-hand box and "ApplicationInstance,form1,Page_Load(object sender,EventArgs e),Profile" in the right hand box. I can't see a way to create the code for the other page events from either of these drop-downs.If I keep the C# code in the same file (i.e., not use code separation) everything works fine - I see "Server Objects & Events, Page, Form1, etc..." in the left hand drop-down and I can create new events in the right drop-down when either Page or Form1 are selected in the left box.Am I missing something really obvious?Many thanks for any suggestions

How to submit data to a SQL Server database table from a custom page ?

  
Using SPD, I have created a custom page. It has a form with ASP.NET controls textbox, radio buttons, dropdown, submit button etc., Also, I created a Database connection (to the SQLServer database table) under Database Connections. But not sure how to connect this form to the database connection so that when form data is submitted, the data will be inserted into the table.

Exporting Data from SQL Server to Excel; From Excel to SQL Server

  
I read some documentation on the web today about exporting data from SQL Server to Excel, and doing the reverse, exporting data from Excel to SQL Server.  Actually, this link was pretty good:

http://support.microsoft.com/kb/321686

 

For one thing, what is Excel linked server "EXCELLINK"?

 

This is pretty good too:

http://bytes.com/topic/sql-server/answers/486783-updating-sql-server-Table-using-excel

 

This is very good; gets pretty complicated though:

http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

 

 

I’m still pretty confused about how it all works.  It’s very easy to turn on the Macro Recorder in Excel, connect to SQL Server, choose a Table, and import date from that Table, but I would like to know if there is a more eloquent way of retrieving data, rather than doing something like:

"ODBC;DRIVER=SQL Server;SERVER=EXCEL-4J2W8KYNP\SQLEXPRESS;UID=;APP=2007 Microsoft Office system;WSID=EXCEL-4J2W8KYNP;Trusted_Connecti" _

HELP with Code passing data to new page

  

Hi all

Not sure which section of forum this should gi in. I have a gridview in one page and if the user wants to edit a row, I open a new page with a detailsview for editing.

On the new page I have a text box to display the primary key of the record selected from the prior page called Log Number. Then on the new page I have a where clause on the detailview to display the record with the primary key.

 

The problem I need help with is the code for the findcontrol. I copied from the MSDN site and it does not bring back the selected log number. Please keep in mind I do not do much coding. Thanks in advance.

 

Here is the code:

protected void Page_Load(object sender, EventArgs e)
    {
  if (PreviousPage != null)
    {
    Control gridview =
          PreviousPage.Controls[0].FindControl("gvCustomers");
     TextBox source_text =
       (TextBox) gridview.FindControl("log_nbr");
           if (source_text != null)
              {
           Te

Make a C# WinForm Call a JS code in a Data server??!!

  
Hi... 
I have a situation as follows:
My company has its Customers Data stored in a server, and we as employees use Internet Explorer to find the data needed through a page that contains some textboxes to supply info to the server and some other textboxes that shows Data retrieved from server. So fro example I put the customerID in a textbox, press the search button near this textbox, and I get the customerName and customerAge and so on in another textboxes in the same webpage. I konw this is done via JavaScripts.

I hope the scene is clear, Now when I need to print a report about certain customer I have to copy/paste every single textbox content to Word individually.

So I know how to export from C# to Word or at least to Excel .., But is it possible to make a C# WinForms App that can read the contents of these textboxes OR call the JS function that is executed when I press the (Search) button shown in the IE WebPage.

I dont know if my question is clear enough but I hope you can help me. Any help would be appreciated.
Thanks in advance

How to use a custom server control that is defined in inline code in the same page?

  

Hi,

 

I have to use inline code for an aspx page and I need to use a custom server control that is defined in the same aspx page but the control does not get processed as a server control. it gets  returned as is as static html tag.

 

does anyone know how to do that?

 

Thanks,

 

Alaeddin


Suggestion about exporting data into Access database from sql server 2008 without Linked Server

  

Hello,

    We have a website that was using Sql server 2005. There was a option in Website where when a user clicks a button, Some tables data will be exported to an access database. To achieve this, we have setup a linked server to Access database. We have moved from sql server 2005 to 2008 (64bit). We did not want to use that option of having a linked server now. I am looking for different ways to achieve the task. We also donot want to use OPENROWSET and OPENDATASOURCE .

 

Can someone  give some insight about this?

 

Thanks,

Nag


How to Shift My Data From one page to another In sharepoint server 2010

  

Hai,

Am just uploaded some files into  Book Folder under Meterials in share point server 2010.

Now my boss ordered to change the location of all files  to Libraries.How can i change the Files location .Is  there any chance to shift/export the data.please help me urgent.

Thanks & Regards

Naresh.D

 9291500737


exporting data from table on sql server 2008 to Ms access 2007

  

Greetings


i wana know how can i export data from a table  to access through a sql job

i am using sql server 2008 and office 2007

 

thnx

 


How to import SQL Server Reporting Services Report Viewer Webpart on web part Page using code in Sha

  

Hi Every One,

I have use SQL Server Reporting Service in SharePoint integrated mode. I have deployed all reports and data source in SharePoint Document Library using CODE. I need to show those report in “SQL Server Reporting Services Report Viewer” Web Part on Web Part Page, I have created Web Part page by code. But I cannot import this Web Part on Page using Code.

How I can do this by code.

 


Navaratan Sharma

Unable to access Site page having data from web part after restoring it to another server

  

Hi,

I am trying to restore site backup to another server using following powershell cmdlet:

  • import-spweb -identity siteurl -path abc.cmp

Before starting restore I have created the site with template same as present on source server. After executing the command it did not displayed any error in the Management shell window. When I checked the log file it displayed 127 warnings and 1 error as follows:

  • Error: List Images could not be imported because it uses the DocumentLibrary base template and the destination uses the 851 base template.
  • Warning: User or group 18080 cannot be resolved.

When I am trying to access the page of the page library it is navigating to error page. This page contains Data form web part which is referencing the lists in the site. In the ULS logs I found following error:

  • PermissionMask check failed. asking for 0x00000005, have 0x400000300C231061

I tried follwoing resolution steps:

  • Provided the Full permission to the current user through which am accessing the site.

Still I am not able to fix the issues. Can anybody please guide me what would be the cause of these errors and what could be the resolution.

Thanks,


call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

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.

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

Accessing SharePoint 2010 Data with Server-Side APIs

  
Accessing SharePoint data in server-side solutions is one of the most common tasks that you will perform as a SharePoint developer. SharePoint 2010 provides powerful server-side APIs that enable you to retrieve, add, edit, and delete SharePoint data programmatically. SharePoint 2010 also includes the new LINQ to SharePoint technology that enables you to work with SharePoint data efficiently and easily.

Sorting Data in a GridView Web Server Control

  
The GridView control provides built-in sorting functionality without requiring any coding. You can further customize the sort functionality of the GridView control by using custom SortExpression property values for columns as well as by using the Sorting and Sorted events
Categories: 
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