Answer Questions

• pnp How to get the max length of text field in a DataSet?

  I have a DataSet bound to an Access database. Is it possible to get the maximum length of a text field of a table in the DataSet Many fields in the database tables have maximum length values set in the design view in Access. When I examine the loaded DataSet in the VS 2005 debugger, I can't find any maximum length information anywhere in the DataSet or the "DataTable.Columns" objects. I wrote the schema of the DataTable to a file (using WriteXmlSchema) and I see that the XML schema does not contain maximum length information for any fields. I want the maximum length to validate user input on a form. Currently, if a user enters too much text for a field and trys to update the database, an exception is thrown stating: "T ...Show All

• SimonOng XSLT - Getting the first N elements.

  I'm new at XSLT and I have a problem: I'm trying to create a stylesheet with, as input: <Events> <Event datetime=" 2006-10-13T11:20:00 "> <Title>blabla</Title> <Text>blabla</Text> </Event> <Event .... </Events> as parameters: $date ; $num as output: an XHTML showing the first $num elements whose date is > than $date In my mind the approach will be to order the elements and do a foreach with a if statement to query the elements with a suitable date ... but I need a variable to store the num of elements selected and exit the cycle... It isn't the case, I know. Can anyone tell me a more clever approach Thank you. .utaal ...Show All

• StuartGM VB.NET without .NET?

  I realize that VB.Net programs don't work without .NET, so dont bother reminding me. Is it possible to install all the DLL files required by a VB.NET program onto removable media alongside the EXE, so the EXE can be run without a formal install of .NET A yes/no answer will suffice. If no, then don't worry I'll make an installer. If yes, can someone point me towards a tutorial no its not possible. the .NET Framework only installs on the same drive as the OS is installed on and you cannot rip away the files/copy the files onto some other media as not only would it not work but also would violiate the EULA. with Windows Vista, .NET 3.0 is shipped with it as standard so you can be sure that everyone who runs Vista will not ...Show All

• V.E problem with TCPClient

  hi, I work on a computer that is part of a network and uses proxy to connect to net. I cant connect to servers outside my proxy with simple ConnectTo code. I need to know how to make my requests go through proxy. eg, serverTcpConnection = new TcpClient(popServer, port); does not work. Thanx. What type of proxy are we talking about - socks or . If this is a socks proxy, System.Net does not suport such proxies. How can i know the type of proxy ...Show All

• KC416 Files inside dotnetfx3.exe

  Hi, I'm creating a .NET Framework 3.0 installation report and trying to figure out the impact it's going to have on our current environment. So far I've unzipped "dotnetfx3.exe" and tried to demystify the content of the installation package: 1. What is the vs_setup.msi file for Does it have anything to do with Visual Studio .NET 2. Does the .NET Framework 2.0 installation package contain the hot fixes Is there a difference between the .NET Framework 2.0 that is supplied by this package and the previous standalone version of the framework Thanks, Reza The .NET Framework 2.0 package included in .NET Framework 3.0 setup does not contain any extra hotfixes. It is the same .NET Fr ...Show All

• gafferuk prompt SerialiazationException

  Hi all, I CodeCompileUnit object serializing MemoryStream,Obtains the binary character to reduce expenses to save to a XML document text node.The code is as follows: MemoryStream ms = new MemoryStream(); BinaryFormatter formatter = new BinaryFormatter(); formatter.Serialize(ms, codeCompileUnit); ms.Seek(0, SeekOrigin.Begin); byte[] bytes = ms.ToArray(); And I obtain the binary system to flow the counter-serializing code to be as follows: byte[] bytes = Encoding.UTF8.GetBytes(codeFileNode.ChildNodes[0].Value); ms.Write(bytes, 0, bytes.Length); ms.Position = 0; BinaryFormatter formatter = new BinaryFormatter(); codeCompileUnit = formatter.Deserialize(ms) as CodeCompileUnit; Th ...Show All

• Stupidav SerialPort DataReceived Timeout?

  I'd like to get better control over when DataReceived are generated while using System.IO.Ports.SerialPort. In particular, I want to be able to control the timeout behavior. This can be done using SetCommTimeouts() when writing to the Win32 API but so far I have not found anything equivalent under .NET Anyone know how this might be done I was thinking I might be able to control it using IOCTL_SERIAL_SET_TIMEOUT but have not been able to find a way to access the underlying filehandle. Is there a way Hi, thanks for the reply. I agree that ReadTimeout applies to Read*() and not the DataReceived event. However what I want to be able to do is utilize the SetCommTimeouts functionality to control when DataRe ...Show All

• hrubesh Unmanaged dll hell and AppDomains

  Hi all, I've been struggling with an assembly loading problem for some time now, and I figured it was finally about time to ask someone about it. I'm building an application that integrates data between two different versions of an accounting application. Both versions of the accounting application are managed/unmanaged hybrids with the high-level interfaces implemented in .Net, the deep internals implemented in C++, and an interop layer in managed C++. My integration application loads some of the managed dlls from each application and uses some common interfaces to transfer data between them. Within my integration application, each version of the accounting application is loaded in its own AppDomain. This allows me to load diffe ...Show All

• lachlanj OTP: running Asp.Net 2.0 on Windows 2000

  I tested very simple webform (have just one button) on my develope pc (windows xp) using asp.net 2.0. Its ok. But when I publishe it on our server (windows 2000) its failed. I recieve this message: Server Error in '/kamaei/DBD' Application. ... <!-- Web.Config Configuration File --> <configuration> <system.web> <customErrors mode="Off"/> </system.web> </configuration> But I did this settings. Is there any specific configuration base on win 2000 Tnx for any help I'm afraid that ASP.NET questions are off topic here, and should be directed to www.asp.net instead. ...Show All

• locoLindy Database transactions performance issue

  Hi everyone, Hope you all had a nice Christmas. This is my first post here, so be gentle, even if this is in the wrong forum, but since this forum mencioned performance, I thought I was in the right one. I'm currently building an app that basically will be a database client, being the database MySql, since it's cheaper. The database will represent a catalog of products, clients and such, but the main table will be the one refering products. My issue is, since the table has one field which is the picture of the product, and it will have somewhere between 500 and 1000 products (at least), and if each picture is around 100KB, we'll have a database with 50MB to 100MB (images alone), so my question is: if the user is browsing the produc ...Show All

• Zac Boyles .NET Assembly Structure ?

  I want to create an obfuscator (will be free). I have look some obfuscator (e.g spices, .net reactor, etc), I a little bit confused how they can make it. I have look at search engine how to make it but to minimum information I get. So I want to ask is where I can find information about .NET assembly structure so I can no on which byte is CLR header on .NET assembly. .NET Reactor do good work (I see only that) on preventing assembly to be opened on ILDASM. If anyone suggest a paid obfuscator, here is the reasons why I want to create obfuscator. 1. I don't have credit card, any obfuscator must buy online. 2. It to expensive, I can not buy one. If there any cheaper then back to reason 1. Thanks, Ariston. Th ...Show All

• hrubesh database binding cascade dropdown objects

  is there anyone who could comment error in this example: i have database with two tables. first table (table1) has two columns: worktitleid (int) and worktitle (string). second table (table2) has three columns: nameid (int),worktitleid (int),name (string). column worktitleid from table2 takes its values from column worktitleid of table1. in vb.net 2005 i create two comboboxes lists (cb1 and cb2). both comboboxes have dropdownstyle property set to dropdownlist (to force choosing from listed items). First combobox has to be filled with data from first table - display item is column worktitle, and value item is column worktitleid. Second column has to be filled with data from second table - display item is column name, an ...Show All

• iansbrainstorm Passing Values from a Windows Service to a Web Service

  Has anyone ever created a windows service that would query a SQL database and hold onto the results and then pass those results to a Web Service through HTTP Post Parameters: 1. Query SQL Database in own environement using windows service(C#). 2. Pass results from SQL query to client Web Service in external environment. It sounds very basic but I am new to Windows Services and Web Services. If anyone has any example code for download or an article on such a configuration, I would appreciate any advice. Thanks, Always Learning How to create a windows service: http://www.codeproject.com/dotnet/simplewindowsservice.asp How to work with DB (for beginners): http://www.codeproject.com/cs/database/DatabaseAcessWith ...Show All

• tczyp SslStream and AuthenticateAsServer

  I'm trying to create authenticated SslStreams, with a certificate created with OpenSSL (which is read from file). I can read the certificate without a problem from within C#. The problem is my code hangs whenever I call AuthenticateAsStream(). My question is, I'm creating (and signing) the x509 certificates myself. Will this cause problems with AuthenticateAsStream What exactly does AuthenticateAsServer do Thanks, Josh I realised that I wasn't matching the AuthenticateAsServer() on the server side with an AuthenticateAsClient() on the client side. The problem I get now is the following exception: System.NotSupportedException was caught Message="The server mode SSL must use a certificate with the a ...Show All

• parm12 Problem using LIKE and WILDCARDS - ASP.NET 2005 / SQL-SERVER 2000

  Hi all. Having a hard time figuring out what's going on here :-( Trying to grab a customer who's registered as: FirstName= "hans magne" and LastName = "pedersen" Following SQL returns a few records from a view AND the one I'm looking for: SELECT * FROM _VIEW__CUSTOMERS WHERE (FirstName LIKE N'ha%') AND (LastName LIKE N'p%') But when using 3 characters in the searchstring for FirstName like this: SELECT * FROM _VIEW__CUSTOMERS WHERE (FirstName LIKE N'han%') AND (LastName LIKE N'p%') .... the view won't return anything.. So searching for LIKE N'ha%' works perfect, but not LIKE N'han%' To make this even more complicated - if I use ONLY FirstName LIKE N'han%' like this: SELECT * FROM _VIEW__CUSTOMERS WHERE (FirstName LIKE ...Show All