BlakeMc's Q&A profile

• Visual Studio How to Add Untyped DataSet or DataTable to Report as a Report Data Source

  Please help me to solve following 3 points 1) How to add DataTable as a Report Data Source in RDLC file I don’t want to make XSD, My Database contains 300 Tables, 2400 Stored Procedure and I have to develop 600 different reports. So Creating XSD for each report is not possible. I want plain dynamically initialized DataTable or DataSet, I mean untyped. 2) How to add fields to the Report I mean is there any thing like dragging and dropping textbox or so 3) I reviewed all examples of GotReportViewer.com, Example of SubReport is exactly what I want but I cant find that how to build that report visually in Visual Studio. Its Urgent, Please ...Show All

• SQL Server datetime and timezone

  Hi All, I just wanted to confirm what I've found: A datetime field is not stored independent of timezone In otherwords, I have a java app that accesses MSSQL via JDBC. In java, the 'Timestamp' object is internally represented as GMT, but when printed, it looks at the timezone of the OS to determine how to display it. I thought that MSSQL would be the same in this respect but it seems not to be... I set a datetime field to, for example, 10:30 am. I then changed my OS's (win xp) timezone from eastern to central, then opened up sql server management studio. The datetime field still showed as 10:30 am. Does this sound right or am I doing something wrong Thanks, Martin No, you are right. ...Show All

• .NET Development Releasing dBase (OleDB) resources

  Hello all. I've digged Inted and found no answer for problem I found. When I connect the dBase files, the directory where dbf files are stored cannot be removed anymore untill the process (application) is closed completly. Closing datareader, connection etc doesn't help. a bit of code: OleDbConnection conn_batch = null; OleDbCommand cmd = null; OleDbDataReader dr_batch = null; conn_batch = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + data_dir + ";Extended Properties=DBASE IV;"); conn_batch.Open(); // here the data_dir directory can be still deleted cmd = new System.Data.OleDb.OleDbCommand(); cmd.Connection = conn_batch; cmd.CommandText = "SELECT * FROM BATCH" ...Show All

• Visual Studio Create a Solution Explorer link to a class in a different project

  In Charles Petzold's latest book, he creates a "link" to a class file in a different project. The class's icon in Solution Explorer is displayed with an embedded shortcut symbol (the tiny shortcut arrow) that implies that it is a shortcut to a class and its filename in the property window is not editable as it would be for a class created in the project itself. How is this link created in Visual Studio Right click on the project, select Add, Existing Item, navigate to the item you want to add, select it, and then instead of clicking the Add button, click the down arrow next to it and select Add as Link. Eric ...Show All

• .NET Development xml documents path (...\Microsoft Visual Studio 8\Common7\IDE)

  I am doing a website project. I would like to use xml files from the directory (My project)\Bin\Debug instead of ...\Microsoft Visual Studio 8\Common7\IDE where i need currently to place my xml files. Are they options that i could modify in MVS or how can i set a different relative path Thanks I get the same problem when I run my application locally. When I publish it to a web server, I get the error message " Could not find a part of the path c:\windows\system32\inetsrv\App_Data" Zhiwen Li, I cannot find project>property in my MS Visual Studio 2005 toolbar. ...Show All

• Visual Studio 2008 (Pre-release) Resolving assembly dependencies in a Windows Service-hosted WCF service

  Hello, I have a WFC service hosted in a Windows Service. The WFC service depends on 2 external assemblies (one C#, one Interop) and some COM .dlls. The assemblies are local (in the same dir) to the service .exe; the COM .dlls are registered. The flow is WFC->C# Assembly->Interop->COM When the WFC service is called, it fails load the assemblies claiming it can't find a file. Using the fusion log viewer, the last pertinent log (in the "native" section) says: LOG: Start binding of native image Interop.QBXMLRP2ELib, Version=1.0.0.0, Culture=neutral, PublicKeyToken=6e0be22769c60cc7. WRN: No matching native image found. Adding the assemblies to the GAC fixes this. My question is how can I configure my WFC ser ...Show All

• .NET Development cannot use xmlSerializer with FileSystemInfo

  I am having difficulty getting FileSystemInfo to work with the xmlSerializer. The snippet is pasted below. At runtime an error occurs stating 'System.IO.DirectoryInfo cannot be serialized because it does not have a parameterless constructor.' I have tried working around this in several ways: explicit casting of DirectoryInfo; a wrapper object (snippet shown below line) that is set to fsi. The object won't cast to FileSystemInfo. Any help or suggestions would be much appreciated. I can be contacted at bedocs@gdls.com. Stream stream = new FileStream(fileName,FileMode.Create,FileAccess.Write,FileShare.None); FileSystemInfo fsi = new DirectoryInfo(path); try { xmlSerialize = new XmlSerializer(fsi.G ...Show All

• SQL Server Extracting Data from lotusNotes into SQL SERVER

  I have a form in Notes that is huge. I need to extract a part/field from that form into SQL SERVER. If I use NotesSQL Thru SQL DTSPackages, I am afraid it will run very long. Is there any other option on that Any help is appreciated. you need the right connector to be able to deal with the Notes as a source/destination. Please check our Data Sources matrix in our connectivity wiki to see possible alternatives for Lotus Notes integration: http://ssis.wik.is/Data_Sources ...Show All

• Visual Studio Express Editions Reading/processing Hex ASCII text file

  Hello, I have a need to read/process Motorola s-record file which contains HEX ASCII characters. The format of the file is as follows: Motorola S-Record File Format. The S-Record file format is designed to contain data intended for programming into various types of PROM (Programmable Read Only Memory). Each S-Record is a self contained memory segment and as such data fragments may come out of sequence. An S-Record looks like: S<type><length><address><data><checksum><cr/lf> where: type The type of S-Record. S0, S1, S2, S3, S5, S7, S8, S9 length The remaining count byte-pairs. Includes the address, data and checksum fields. ...Show All

• Visual C# HOW TO: Spilt Text File After Specified Line

  Hi All, How can I split a big text file (e.g. 4525 lines of data) into pieces of smaller text file after a specified number of lines (e.g. it will gives us 10 smaller file if the smaller file has maximum 500 lines of data; the last piece will have only remainder 25 lines of data.) Thanks in advance. Leonard, In the sample below, I put the code to retrieve the 'fileheaders' in a seperate method. The method takes 2 arguments: the filename to retrieve the headers from, and the number of lines to return. The method to parse the file (ParseFile) uses this method to get the headers before parsing the file. Remember that if the file that contains the headers is the same file as the one that needs to be par ...Show All

• Windows Live Developer Forums Hide the scalebar in V3?

  I am working on upgrading from V2 to V3 and notice that I can no longer hide the scalebar I tried guessing around with the MapControl.Features to figure it out, but no dice. Any ideas In the virtual earth SDK they have a code to add a Hidhe and Show button. If that is what you want here is the code <html> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <script src="http://dev.virtualearth.net/mapcontrol/v3/mapcontrol.js"></script> <script> var map = null; function GetMap() { map = new VEMap('myMap'); map.LoadMap(); } functio ...Show All

• SQL Server Cluster 2005 need help please

  quick overview 2 nodes-cluster setup from node 1 I setup a cluster, created 4 groups 1.cluster 2.msdtc 3.sqlinstance1 4.sqlinstance2 I want to create an active\passive on both nodes. (onenode will be the active node for on sql install while the other is passive. I want to repeat this fo rthe second node, the second node being active and node 1 passive. I logged into node 1 and I installed sql 2005 in failover cluster into sqlinstance 1., everyhting was fine, failover etc. Now I logged into node 2 and ran sql 2005 setup to create a failover cluster. I chose to install into sql instance 2. Database unable to install with error "failed to set registry settings for server network libraries. acition is setdefault ...Show All

• SQL Server Newbie Question - Automatically update

  Maybe my question is not at the right place but I'm totally new to this. So I have the following scenario: I have a DB with one table with five records. I create a cube on this. Based on the cube I have to show some KPIs. Everyday I have one more record in my table. If someone clicks on this site it has to show the current uptodate KPIs every day. How can I do this If I understand right I have to process the cubes manually to show the actual datas from the DB. Is there a way to automate this somehow thanks for any your help Create an integration services package that processes the cube and then create a job with the Sql Server Agent that consists of running this package. Schedule the job to r ...Show All

• Visual Studio SandCastle, Msbuild, and H2Reg

  I have updated to the Oct 17 version of sandcastle and update msbuild scripts for the changes in this version. I am successfully building an hxs and can view it correctly with h2 viewer. However, when I register the collection to integrate it with Vs 2005 only the index items appear but nothing shows in the content window. I have search the fourm and can't find anything similar to this issue. Anyone have any clues why the collection looks fine in the viewer but not content in content window in vs2005 thanks, Don Eddleman Thanks Don - two more questions: 1) are you installing this on the same system you are building the .hxs files on, and 2) do you have an .hxt file defined for your collection an ...Show All

• SQL Server Problem with sp_xml_preparedocument

  Hi All, Follwing are the 2 code snippets of XOPEN 1. declare @idoc int declare @doc varchar(1000) set @doc =' <b> <a> <s>aaa</s> </a> <a> <s>bbb</s> </a> </b>' exec sp_xml_preparedocument @idoc OUTPUT, @doc SELECT * FROM OPENXML (@idoc,'/b/a',2) WITH (s varchar(100) '@s') 2. create table newtemp ( s varchar(100) ) declare @idoc int declare @doc varchar(1000) set @doc =' <b> <a> <s>aaa</s> </a> <a> <s>bbb</s> </a> </b>' exec sp_xml_preparedocument @idoc OUTPUT, @doc SELECT * FROM OPENXML (@idoc,'/b/a',2) WITH newtemp Code snippet 2 works but 1 doesnot. Can some one me the reason why Thanks & Reg ...Show All