Weixiao Fan's Q&A profile

• .NET Development DateTime Issue of Two Timezone!

  Frist, I will introduce my trouble. I deploy the WS in one Timezone, and UI in another Timezone. UI gets the datetime info by WS, but UI can't get the right Time that equals to database. For example the WS Timezone is UTC+1, and UI Timezone is UTC+6, the Time received by UI is always add 5 hours. Is anyone can help me out Thanks! Return all your server-side time data as UTC at all times. The client can then adjust to its local time as needed. The DateTime class gives you all the necessary functionality to map from (client) and to (server) UTC. ...Show All

• Microsoft ISV Community Center Forums Problem with Connection Strings

  Hi All, I have an excel spreadsheet, which I want to use like a database table and access using ADO from another spreadsheet, but whenever I attempt to assign my connection string to the ActiveConnection property of my ADODB Recordset, I get the following error: Could not find installable ISAM. Below is the connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\Le09\kpl_biskra\personal_biskra\ksmith\Reporting\Weekly\Christmas Analysis\DataFile.xls;Extended Properties=Excel 8.0;HDR=Yes; Can anyone help Many thanks! Keith Keith, I ran into this exact issue a couple weeks ago. Unfortunately I don't remember off the top of my head what I did to fix it. Let me dig through some ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Will run from debugger, won't run from .EXE on same machine

  Ok, I've got my project building and running on the 360. A friend of mine wanted to see what I was up to, so I moved the source over to an PC hosted XNA project, and got it running there too. Before I sent the .EXE to him, I double clicked on it, and I just get a message box that says "Application generated an exception that could not be handled." This works fine under GSE, but doesn't seem to work when clicking directly through Windows. What am I missing You could also get the .NET Framework 2.0 SDK from the MSDN site and use the CLR Debugger tool (or a non-express copy of VS.NET). Next time it complains about some random exception (and you're trying to run a debug version of your ...Show All

• Visual FoxPro the no server server?

  ok my client now wants the application i made to run on multiple computers. i am not a network wiz but i know a few things. will this work: 1. right click mynetwork places and do map network drive. ill make drive Z:\ and find a folder.... ok now i have drive Z:\.... now i do the same thing with the 2 other computers. So i now have 3 computers with drive z:\. on drive z:\ im going to have all the files. my questions are is this a good setup will it work out what i do is i have a text file on all the computers and inside the text file is the path.. "z:\" so before my application starts i just create a temp cursor and append the csv value from that text file. i ...Show All

• SQL Server Unexpected error occurred during model generation

  I am working with a client who has installed SQL Server 2005 Enterprise on a Itanium 2 64-bit, 8 Gb ram. Normally when we install Reporting Service their is no problem but when we did it on a Itanium we can’t get it to work properly. When we are trying to generate a model we get this error: An error occurred while generating model. (rsModelGenerationError) Get Online Help An error occurred during the generation of semantic model : [Create roles from measure group dimensions]Unexpected error occurred during model generation.. [Create roles from measure group dimensions]Unexpected error occurred during model generation. Unexpected error occurred during model generation. "Get Online Help" link: http://www.microsoft.com /products/ee ...Show All

• SQL Server Error in SQL startup

  Hi guys, I have an SQL Server 2000 installed on a Windows server 2003. Yesterday, i restart my server and before login to the server the following message poped-up: "Your SQL Server installation is either corrupt or has been tampered with (unable to load SQLBOOT.DLL). Please uninstall, then re-run setup to correct this problem" Any ideas what this error is or why occurred Any help will be appreciated. have u checked the sqllog and application log.. post the error from Log. its looks like the REGISTRY/system drive got corrupted/ or master file corrupted... what all are the backup u have. Do u have system dbs backups ... Madhu ...Show All

• Windows Forms SQL with VB 2005

  hi all i linked my VB 2005 project to a small database which i created. I have a listbox and 2 textboxes. In the list box i see the surname of the customer and in the two textboxes the name and surname. When you click on the listbox (any customer name) the 1st and surname appear in the 2 textboxes as they are linked. My question is when i try to change the name of any customer then stop my application and run it again, the name of the customer does not change. I followed the steps shown in the video for that on this website but no luck. Stopping my application doesnt save the changes :(..any suggestion will be appreciated. thnx You'll probably want to put it in the same form where you're filling the da ...Show All

• Microsoft ISV Community Center Forums macro for automatically creating data labels in excel chart

  Hi all, I'd like to write a macro in for excel to create automatically a chart, i have no experience in this field. I use the following code: Sub Macro1() ' ' Macro1 Macro ' Macro recorded 8-6-2006 by CTW ' ' Keyboard Shortcut: Ctrl+m ' ActiveSheet.ChartObjects("Chart 1").Activate ActiveChart.ChartArea.Select ActiveChart.SeriesCollection(1).XValues = "=Sheet1!R1C1:R2C1" ActiveChart.SeriesCollection(1).Values = "=Sheet1!R1C2:R2C2" End Sub This code works well, but i want the following to do: every time pressing Ctrl+m I want the used data for the chart move 2 rows below, so I can visually scroll through the data. for example: Ctrl+m gives chart of: x value: Sheet1!R1C1:R2C1" ...Show All

• Visual Studio 2008 (Pre-release) Code-Generated Base Entity Class

  Hey team, Is there a way to specify the base-class that the generated entities inherit when the code is generated I'm thinking of creating a base-class that contains common functionality, and want to have the generated classes derrive from that instead of System.Data.Objects.Entity. My base-class will of course extend System.Data.Objects.Entity. :) Thanks! Technically we don't support abstract base classes, but it is possible to do something like this. In your CSDL file you can create an entity type which all of your other entity types inherit from. That type can contain properties which exist on all of your other entities, in which case when you write your map file you will need to map not only the added properties on each ...Show All

• Visual Studio An unknown error occured while copying files to your temporary folder. Setup will now exit.

  VB Studio 2005 Pro I have made sure my Temp folder is empty and good to go....writeable, etc etc. I have 3 PCs and on the 2 main ones I get this error no matter what I try while attempting to install from a CD. On the 3rd PC which I do not use (my son's) it will open up and install. I cannot figure out the problem. I tried movnig all files to a folder on the HD and installing from there, but no use. There has to be a fix for this. Help Merid wrote: Here is what I did for a fix: I have ISO Buster, and had tried it 3-4 times with no luck. The program is a 2-disc setup...so, on a hunch I extracted all files and then the contents of s ...Show All

• SharePoint Products and Technologies how to get the current web when my class inherits from SPFieldText

  Hi, I am writing a custom field control that inherits from SPFieldText. I need to access the current web as an SPWeb in the FieldRenderingControl method that i override. When I try: SPWeb spw = SPContext.GetContext(Context).Web; That doesn t work. iT SAYS: Error : The name 'Context' does not exist in the current context Any idea how I can do that PLS That SPWeb  spw = SPContext .Current.Web;  worked perfectly|: SPContext .GetContext( HttpContext .Current).Web; also works but yours is much simpler Thank you   ...Show All

• Visual C++ Getting pointer to edit box in MFC

  Hi, I'm learning to use MFC and I have encountered a problem... I have a main dialog window, with an edit box (which is used for displaying information), and when a button on the main dialog is pressed, function from another c++ file is called to load data from some txt files and processes it, and I wish to display any errors from processing the txt file to the edit box in my main dialog... say my main dialog's class is called StepDlg, I tried to do this in my other c++ file: StepDlg dialog; dialog.send_data(data); Where "data" is the data I want to display in the edit box... I got an assertion error for this and after a bit of digging and searching I found that the problem is because I have created another dialog by doing " ...Show All

• Visual Studio Report with linked subreport not showing data on the subreport

  I've a main report ("rptFichaProducaoColagem") with a subreport ("rptFichaProducaoColagemOcorrencias"). I want to link both by the field "Data". The main report is bound to table "Numeros_Dia" by the following code: Private Sub frmVisualizarCrystalReports_Load( ByVal sender As Object , ByVal e As System.EventArgs) Handles Me .Load Dim relatorio As New rptFichaProducaoColagem conexao() sSQL = "SELECT * FROM Numeros_Dia WHERE [Data] LIKE '" & DataRelatorio & "'" da = New OleDb.OleDbDataAdapter(sSQL, con) ds.Clear() da.Fill(ds, "Numeros_Dia" ) relatorio.SetDataSource(ds) CrystalReportViewer1.ReportSource = relatorio con.Close() ...Show All

• Visual C++ MSVCRT.dll: Daylight Saving Time BUG when TZ variable is set.

  Does anyone knows status of it Senate change Daylight saving time from April to March and from October to November. Now code, working in multi timezone screwed if TZ variable used. MSVCRT.dll from 2004 on my XP has April and October date hard coded. Proposed by Microsoft Fix (Unset TZ) will not work since We set it from program for current instance when needed to calculate Time for the person other then user of current PC when person is in different time zone. We're in Medical software business and very often User of the system (tech) works in PC time but Patient/Doctors are in different time zones (Big independent Lab for example). Specimen will be processed and "Tech" time used but in reports and query time for resulting should ...Show All

• Visual Studio Tools for Office VSTO Without Office Installation

  Hi All, Is it possible to use VSTO without office installation in the production machine. Office can be installed in the machine during developement. but when deployed there is not office installation in the server for some security reasons, so is there a way to use VSTO without office installation. thanks sathya Read the information on MSDN concerning the ServerDocument technology and see if this meets your needs. Start here and work your way through http://msdn2.microsoft.com/en-us/library/h7eb01hx(VS.80).aspx ...Show All