Answer Questions
The Developer-X Where to set the timeout for a SqlTransaction.Commit?
It happens quite often in my application that I get a "Timeout expired" SQlException when I do a SqlTransaction.Commit. where do I have the ability to adjust the Commit Timout value Grtnx, Adri Was this problem solved by setting the Connection Timeout value In the connectionstring of your connection object. Visit www.connectionstring.net Your connection, not the transactio ...Show All
jledgard CType vs. Parse
If I had a form where I wanted to add together two numbers entered as text by the user -- so it becomes necessary to convert the text properties of the textboxes to decimal values -- which approach is better 1: Total = CType(Me.TextOne.Text, Decimal) + CType(Me.TextTwo.Text, Decimal) OR 2: Total = Decimal.Parse(Me.TextOne.Text) + Decimal.Parse(Me.TextTwo.Text) Thoughts ...Show All
amit_toney Where does the assemblies loaded?
Hi all, I've the following doubts., Say I've a assembly Myassembly.exe and when i run it it is loaded into a AppDomain.Where does the referred assemblies gets loaded For ex:My assembly refers mscorlib by default and say it refers another user-defined assembly MyLibrary.dll.Now ,where both mscorlib and MyLibrary will be loaded Will it be in the same Appdomain as MyAssembly or If not ,if it it gets loaded in another AppDomain then Remoting w ...Show All
StringMon Simple TSQL called by ADO fails
(SQL 2005) I have a program using ADO that sends a line of text to SQL Server to be executed. the line is essentially: if exists(select 1) DELETE C_Codes WHERE category=13; I can't get the DELETE clause to execute in ADO even when the if exists clause is clearly true (works fine when manually executed in Management Studio). Can someone explain why this doesn't work, and what I need to do to make it work Thanks. ...Show All
Jose A. M. card layout in .NET
I want to create a GUI which consist of three different pages. Only one page should be visible at the same time. In Java there is a special layout manager handling this case (CardLayout), is there something similar in .NET, or how should I go about solving this For traditional apps you should probably use the TabControl and create a tab for each of the pages. This is similar to either VS's project proper ...Show All
Ron31416 Dataset serialization
I have an issue with the Dataset serialization. I have a class, say BaseDataSet which inherits from the Dataset. More classes inherit from BaseDataSet. I would like to pass on the object inherited from the BaseDataSet back to the client via a web service. Before passing on I cast the derived object to BaseDataSet type. On the client, I am not able to down cast the dataset back to the specific class which is the type of dataset passed across. ...Show All
GregXTZ How to get field value in attribute constructor?
There is a StringValueAttribute attribute. The user can use it to associate string values with an enumeration field. In the first constructor of StringValueAttribute, two string arguments are passed and can be used to explicitly assigned to _databaseValue and _resourceKey. This is illustrated in MyEnum.EnumValue1. My question is in the second constructor with only one string argument. Since the resource key string is not pass ...Show All
Robert Darwin Data drops when reserializing XSD.exe-generated classes using 2.0 framework.
I gen my XSD /classes with no reported errors, then deserialize my sample data using XmlSerializer. The data structure looks exactly as expected in the debugger. Then I reserialize with XmlSerializer and, again, no reported errors. The output is valid by the schema. I can reserialize it if I like using the XmlSerializer objects, for example. The output just happens to be missing a bunch of elements (it's a lax schema, minoccurs of everythin ...Show All
JayScott Inserting a New Record with FormView in ASP.NET 2.0
In the insert mode of form view, the primary key is hidden from the user. In the underlying access database, the primary key is autonumber. Clicking the autogenerated insert button causes the error: "You tried to assign the Null value to a variable that is not a Variant data type." Do you have to programmatically set the unique ID key, and if so how would you do that in Visual Web Developer The form view is linked to an access datasource with ...Show All
PainDeer Connecting to a database through a webservice
Ilya Tumanov wrote: Yes, but it makes no sense. To accomplish that you would have to purchase SQL 2000/2005 and pay CALs per device (or per CPU license). If that’s acceptable, simply get rid of Access and use much more powerful SQL you've paid for. Alternative solution is to use Web Service to talk to Access database. Create couple WEB methods to talk to access and call them from device. Something like this should do: ...Show All
Brian_Kramer Autonumbers and currency
I was wondering if currency only applies when you are editing a record as opposed to adding or deleting a record. For example, say there are 2 users that are using some disconnected database software. Each of them starts to add records to their respective datasets at the same time. When they run an update to push the values back to the server, will the autonumbers collide I'm still learning the basics, so any information will help out grea ...Show All
Sean F Can a WebService call a client apps
Hallo, can a webservice installed on a webserver call up e.p. winpad.exe on a client, if the webservice knows the client IP and the physical way to winpad thx Jeff Chang wrote: No, not with the current one. HTTP call is one request from the client to server, then the server return a response, it's always the client initiating a call. Indigo (Windows Communication Foundation) may optional ...Show All
J/-\Y How can I know that a driver is unavailable?
When I launch the sentence below string[] a1=Directory.GetDirectories("A:\") I get a error because I don't put a floppy disk in driver A: How can I know that a driver is unavailable Do I need to write the sentences below Is there a better way try { string[] a1=Directory.GetDirectories("A:\") } catch { MessageBox.Show("A driver is unavailable!"); } Hello CUE WEI, I recommend catching the most limited set of exceptions possible (e.g. onl ...Show All
wrightti isDate issue
Hi, I have the following problem: MyString = aDate.ToString("MM/dd/yyyy") IsDate(MyString) ---> returnsFALSE MyString = aDate.ToString("dd/MM/yyyy") IsDate(MyString) ---> returnsTRUE And I would like it to return TRUE regardless the position of Month and Day. How can I bypass the regional settings Regards What are you exactly trying to accomplish graphics, yo ...Show All
VB Technical Support Webservice partial class error
Hey guys, here goes: Version: Visual Studio 2005 final release I created a Web Service and generated the proxy class, however once I use the Web Service method I get this error: CS0260: Missing partial modifier on declaration of type 'TACCGlobalWebMethods'; another partial declaration of this type exists. "TACCGlobalWebMethods" being the name of my class. According to MSDN this error is because another file contains the same ...Show All
