percent20net's Q&A profile

• Windows Forms How can i create a xml file from typed dataset - Need Help

  HI, Give me some idea to create a xml file from typed dataset. Let me explain my problem.. I have the xmlschema with multiple parent and two child ). see ex: below < xml version="1.0" encoding="utf-8" > <xs:schema id="XSDSchema2" targetNamespace=" http://tempuri.org/XSDSchema2.xsd " elementFormDefault="qualified" xmlns=" http://tempuri.org/XSDSchema2.xsd " xmlns:mstns=" http://tempuri.org/XSDSchema2.xsd " xmlns:xs=" http://www.w3.org/2001/XMLSchema "> <xs:element name="Information"> <xs:complexType> <xs:sequence> <xs:element name="Name" type="xs:string" /> < ...Show All

• .NET Development Different ways of using xpath query within C#

  I havent used xpath in months (years ) and I was looking at a few examples Uses XPathNavigator and XPathNodeIterator http://www.codeproject.com/soap/myXPath.asp Using SelectSingleNode http://www.mastercsharp.com/article.aspx ArticleID=69&&TopicID=9 Is the 2nd listing the old way of doing it under the 1.1 framework No, XPathNavigator can be implemented over different stores, .NET 1.x and .NET 2.0 have it over XPathDocument, XmlDocument and XmlDataDocument and allow it to be implemented over other stores if someone wants to do it. MSDN has some examples I think e.g. XPathNavigator over .NET objects structures. In .NET 1.x SelectSingleNode is a method around in the .NET DOM implementation (System.Xml.XmlDoc ...Show All

• SQL Server Using OPENROWSET for csv files

  I have 2 instances of SQL2005 running on the same server. I'm trying to use openRowset to get data from a csv file. This is the query. SELECT * FROM OPENROWSET ( 'MSDASQL' , 'Driver={Microsoft Text Driver (*.txt; *.csv)}' , 'SELECT * FROM \\share\file.csv' ) The query works fine on one instance, but not the other. On the other instance I get this error. OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Text Driver] System resource exceeded.". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)". Any help would be greatly appreciated. ...Show All

• SQL Server Autorefresh in Microsoft Excel 2003 Cubeanalysis

  Hi, I play around with the Cubeanalysis Addin for Excel 2003. My Question: Every time, I drag a dimension, measure, etc. to an excelsheet, all data will be refreshed. This refreshment lasts often up to 1-2 minutes. I didn't need an refreshment at design-time. Is it possible to deactivate it for report design, and activate it when the report is ready for use Thanks Hans Hello Edward, Thanks for your Information, but I didn't find any Office Forum here at MSDN Forums ( ). And Cubanalysis is one of the Analysis Services 2005 Frontends, so I thought, thats the right forum. Hans ...Show All

• SQL Server Reporting services configuration Killed several Summary Report functions

  I installed 2K5 developer on my box. I was impressed with the Summary tab report functions and the reports available there. Then I ran the "Reporting services configuration" tool to get RS running, but now several of the summary reports are broken. There are several different error messages given in the summary window, depending on the report selected. For example, the "server dashboard" now displays Summary Unavailable The information needed to display a summary page for the selected object is not available. Error: "sql_handle" is ...Show All

• SQL Server SYSAdmin users do not have permission to see records in a view?

  We have a third party application and wish to create a report based upon a view. The strange thing is logged in to the server as a SQL SYSAdmin account, we cannot view the data via the view. SQL Admin accounts are setup correctly and there is nothing different on this particular server. No errors are returned just a blank view with no records. Could this be a permissions problem or orphaned schemas in that particular database I thought SYSAdmin could view and do just about anything and the people who use this particular database would not have the know how on denying permission to the SYSAdmin role. Thanks N Thank you, I can see the logic in that. Nice way of denying sysadmin read permiss ...Show All

• Visual Basic Graphics Disappear After Minimizing Window

  I have a VB 2005 windows apps with a picture box on a form. I created a graphic to draw stuff on the picture box: Dim g as System.Drawing.Graphic g = picBox.CreateGraphics Then I draw stuff ... but when I minimize the form's window and then restore it the stuff I've drawn does not appear. I don't know how to cause the program to redraw the graphic when the window is restored ... i.e. how to "anchor" the graphic to the window. If the answer involves using the paint event I would appreciate a bit of detail ... I cannot figure out how to do it. Thanks. Oh, your replly is really close to answering my question but I need to ask one other thing. The app creates the graphics obj ...Show All

• .NET Development The process cannot access the file because it is being used by another process

  Hey all This is annoying, I want to perform a copy or move or read operation on a file but the file is already open in word or notepad, whatever. No when I try for example to rename the file that is open in word the system tells me that I can't do it since word holds it. How can I do the same in C#, meaning checking if the file is open and alert which application holds it. Itzik Hi there, Have a question. l want to disable system file protection on my xp sp2, so l downloaded the the sfc_os.dll (2600.1106) and created a backup sfc_os.bak opened it with hexeditor and changed the values, everything like is mentioned here in this link http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp ID=51 ...Show All

• .NET Development Socket SendFile prb

  I want to transfer an image file On the client side I use this code, after creating all the connections all: client.SendFile(img); On the server side I use this: byte [] btt = new byte [1000000]; client.Receive(btt); FileStream fs = new FileStream ( "C:\\img.jpg" , FileMode .Create); fs.Write(btt,0,1000000); fs.Flush(); fs.Close(); Now, the file img.jpg is created however it only contains a part of the original image, however the image int eh Windows explorer thumbnail view is complete, and one thing is that that in the SendFile method I can not specify the buffersize, so I just use 1MB,at the server side. How do I get complete picture You need to ...Show All

• Visual Studio Express Editions making it count

  hi trying to make a label count upwards. what have I forgot Dim tries As Integer = +1 Label10.Text = tries.ToString thank you whoisit, that worked how I wanted sorry I havent got my thinking hat on today, I know how basic that is lol thanks for your replies ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Will Game Creator Club be Region Locked?

  OK.. bad way to put it.. and it's probably a stupid question but someone's gotta ask it. Since we have a concept of regions to our Live memberships, and the creator club goes ontop of our Live memberships can you answer if Creator Club membership will be open to ALL live subscribers regardles of country Since... some of us are grey... and there're plenty of us out there who don't have US accounts and just dreads it when Major Nelson says "This content is not available in XXXXXX" :P Regionalization is a tough cookie, because it involves things like copyright laws, international commerce laws, etc. That being said, our intention is to make content as broadly available as possible, and we ...Show All

• SQL Server Cannot shut down VS after using report designer

  Routinely when I use BIDS to work on a report design, I cannot close BIDS because I get a message box that says: Microsoft Visual Studio cannot shut down because a modal dialog is active. Close the active dialog and try again. Of course, there is no visible dialog open. I actually have to terminate the process from task manager. I do not get this problem when using SSIS or SSAS. Only SSRS. Any Ideas Thanks! BobP FYI... I encountered this problem today for the first time. I was creating a new report in a project by selecting an existing report, right-clicking on it and selected COPY. I then did a CTRL-V to paste it into my project. The new report name was "Copy of...". I renamed the report and then ...Show All

• .NET Development Reading any file format with FileStream

  I want to be able to send ANY type of file (Text, .Doc, .Zip,. Etc.) with sockets. Everything seems to be going as planned, except when I read the file, the bytes are little bit different. How can I correctly read (ANY) file, for transferring over sockets Real Line 1 of File: +o[C€‥46( § cgZ C)E xn[y"QO Cp After reading with code below: +o[C (46( ,' cgZ6C)K xn["QS Cp It seems I am reading the file wrong. Only a few characters are not being read correctly. Here is the basic code for reading the file: fs = File.OpenRead(@"c:\mailroot\MENU.pdf"); br = new BinaryReader(fs); byte [] currentBuffer = new byte [1019]; currentBuffer = br.ReadBytes(currentBuffer.Length-5); Logger.Log(Encoding.ASCII.GetS ...Show All

• SQL Server Server does not exist messages.. ?!

  We have recently upgraded our SQL Express 2005 server, to SQL Server Standard 2005. It refused to install a new default instance during install, so i upgraded the SQLEXPRESS instance instead. Im now trying to install Microsoft CRM but when it tries to connect to the SQL server get the following error: "Setup was unable to verify that the SQL Server Agent (SQLSERVERAGENT) was running." "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied." "Microsoft SQL Server Reporting Services [DBNETLIB][ConnectionOpen (Connect ()).]SQL Server does not exist or access denied." As far as i can tell, the problem is that when we upgraded, the pipe( ) or sql service name( ) (im not ...Show All

• .NET Development Binary stream '0' does not contain a valid BinaryHeader Exception

  Hi, I'm having trouble using the BinaryFormatter class. When I call Deserialize (see below for code sample), I get this exception: System.Runtime.Serialization.SerializationException: Binary stream '0' does not contain a valid BinaryHeader. Possible causes are invalid stream or object version change between serialization and deserialization.     Public Overrides Sub WriteXml( ByVal writer As System.Xml.XmlWriter)         writer.WriteStartElement(XmlConstants.NamespaceQualifier, XmlConstants.ObjectElementName, XmlConstants.XmlNamespace)                 If m_Formatter Is Nothing Then      & ...Show All