Answer Questions

• Trevor Iwaszuk Passinga null value to a com+ variant from c#

  I have a VB com object with the code below Public Function GetValue(value As Long, _ value As Long, _ value As Long, _ value As Integer, _ inDate As Variant, _ value As Integer, _ value As String, _ value As Integer, _ value As Date, _ value As String, _ ByRef value As Variant, _ ByRef value As Variant) As Boolean On Error GoTo err_handler : : unrelated code : : If IsDate(inDate) Then : :Do something : End If I am calling this com+ object from a c# .net2.X platform to calculate a return value. However I wish to have the IsDate(inDate) assertion fail, however no matter what value i pa ...Show All

• Chris.Stewart My database doesn't update !!!???

  I wrote a simple program with ASP .NET that modify data in a table and I'm using SQL server 2005 Express edition as my database engine. But when I modify data in a table (in the webpage) and then when I try to update the database, nothing happends, it even doesn't give me any error, and when i try to see the table again nothing is updated in the table. These are the things that I have done: 1- I gave permission to ASPNET and NETWORK SERVICE so they can Select, Update, Delete,... on that table. 2- I gave permission to ASPNET and NETWORK SERVICE to the table itself. 3- I evern assign the ASPNET and NETWORK SERVICE as the db_datareader and db_datawriter and db_owner. What else should I do Is there anything that i missed ...Show All

• beesol Backup and Restore a sql database using vb.net

  i'm trying to create a windows application with two buttons one to backup a database and the other is to restore it, can so me one assist me with this Thanks, Rama Thanks Hayerm, i will give a try now. Hi, The best and easiest way to backup/restore database is sql. So you have ust to execute Backup/restore sql commands on the server. Backup command : "Backup database YourDataBaseName to disk = YourFilePath" Restore Command "Restore database YourDataBaseName from disk = YourFilePath" You must notice here that the YourFilePath is a path of a file on the database server. You cannot do Backup/restore to/from files that are physically n ...Show All

• khamlon Generating tree hierarchy from adjacency list

   I have an XML representation of an adjacency list where each <row> element has 0 or 1 parent element where the ParentID element points to the ID element of the parent.  I am trying to use xsl:key to generate an XML output tree.  Could anybody help with this please Thanks, Tad input: < xml version="1.0" encoding="utf-8" > <root>   <row>     <ID>1</ID>     <Name>One</Name>   </row>   <row>     <ID>2</ID>     <ParentID>1</ParentID>     <Name>Two</Name>   </row>   <row>     <ID>3</ID> &nb ...Show All

• Pete Nelson Procedure or function has too many arguments specified

  Hi everybody I am a beginner and facing the problem in calling a Stored Procedure from within my VB.NET 2005, as below: MY Stored Procedure goes like ; ALTER PROCEDURE ByRoyalty @percentage int, @avgprice float Output AS SELECT @avgprice= AVG(price) FROM titles SELECT au_id FROM titleauthor WHERE titleauthor.royaltyper = @percentage DECLARE @numtitles Int SELECT @numtitles=COUNT(*) FROM titles RETURN @numtitles My VB code is as below : Dim cmd As New SqlCommand("ByRoyalty", Conxn) With cmd .CommandType = CommandType.StoredProcedure .Parameters.Add("@numtitles", SqlDbType.Int) .Parameters(0).Direction = ParameterDirection.ReturnValue .Parameters.AddWithValue("@percentage", 100) .Parameters(1).Direction ...Show All

• Georgyporgy Intermittent webservice issue...

  I have a webservice that pulls data from an AS400 backend across an ODBC connection. On initial load of a page, it pulls the data without issue. If I refresh the page, any subsequent calls to one of the functions in the webservice fail, and I get the error: "SoapException: Input string not in correct format" There are only 2 calls to the service that generate this error. I had thought it was an issue with the data being returned from the AS400 (some of the data items were packed), but adding a "cast" call within the SQL doesnt help. Again, initial load works fine but any refresh fails. The functions in question return a dataset, and if I debug I get the error right when I go to fill the dataset. I also tried loading a d ...Show All

• AlexBB Lost my Data

  I'm working on a small Windows Forms app (using VS 2005) where I use a single dataset reading multiple tables from a SQL Server (2000). Using the "My Project" interface, I changed the value of the datasource to point to a new database (dev to prod) and now my application is generating the following error message. Error Message: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken = b77a5c561934e089' failed. I made certain to keep the same Name, Type, & Scope on the dataset... I simply changed the Catalog Name and User Id. Any ideas where I went wrong This is a before and after example of my datasource string: Before: Data Sour ...Show All

• donWong only for server.transfer

  Hi, It is better not to make a control as public , instead create a read only property which returns the value of the control. This can be achieved only if you use server.transfer , In case of Response.redirect the thread will be closed so we can't get the data. The Code below is how to take the value. WebForm4 requestForm; requestForm = (WebForm4)(Context.Handler); Response.Write(requestForm.getName); ...Show All

• mwoodruff XSLT to Excel transfer slow when using large data files

  I am attempting to transfer an XML file to an Excel File using XSLT. I am using XmlDataDocument and it slows down greatly on large data sets. A workaround was found on MSDN: http://support.microsoft.com/kb/318580/EN-US/ , But I am not sure how to implement it. Below is what I am currently using: <% @ Page Language = "c#" %> <% @ Import Namespace = "System.Data" %> <% @ Import Namespace = "System.Xml" %> <% @ Import Namespace = "System.Xml.Xsl" %> < script language = "C#" runat = "server" > public void Page_Load ( Object sender , EventArgs E ) { string reportname = Request . QueryString [ "Name" ]; string xmlpath = "e:/Program Files/Apache Software Foundation/Tomcat 5 ...Show All

• RaphaelGray Troubleshooting information collection

  Hey all, I want to develop a Web application which gathers troubleshooting information from the client machine, compress it and uploads it to the website. The information may include Event Viewer logs, Log files and other client specific information. The question is which technology should I choose (If using .NET) Most of the code will be preformed at the client side and I want to interact with the client code in the site code (to be able to display progress and so...). I want to be able to do this using VS 2005 using the latest technologies. Much thanks. Regards Zeffy. ...Show All

• Ofir Epstein Can a Windows Service Return any value

  I am new to dotnet, but for our requirement we need Windows Service returns value. If possible send the details and example in C#. Windows Services do not 'return values' in the normal sense to a client application. However you could have that service pubish a remoting object for example whose method returns a value. Cheers, Micky You should use some method of Inter Process Communication between your client application and the windows service. .....following some IPC methods: -MSMQ -Named pipes -Sockets -File mapping -Even simple files may be an option sometimes -Registry -Memory mapped files -Database -Windows messages -Remoting(as Micky said in his post) You may consider using xml web serv ...Show All

• DrJim FtpWebrequest

  hello to all when iam uploading files to online webserver from local folder i have to create folder struture on online webserver before uploading files for that i am using WebRequestMethods . Ftp .MakeDirectory but what it is happening, it is throwing an exception if the folder already exists. can any body please help me. currently now i am working with localhost   regards, ramana kumar   This very bad solution, why we can't get error code "521 directory exist" hello this is the code i u sed to create folder directory structure on the server private static void FTPCreateDirectory(string sPath) { ...Show All

• bryanedds How to improve web connectivity?

  Hi,           We are working on ASP.NET application using VS.NET 2003. Application fails when more than 10 users are logged in same time. Is it because of network connectivity Please provide the solution.     ...Show All

• Larry Menard Question: Multi-tier Applications and SQL Server Application Roles

  Is there anyway to get around the need to turn off connection pooling if you want to be able to use SQL Server application roles Turning off application pooling on a application that has a data layer is going to lead to some nasty performance issues. I have seen replies saying that application roles shouldn't be used but there is no other way of making sure that users have to go through the application to get at the database. I don't really want to have to move the server into mixed authentication mode just so I can use a SQL Server login instead of an application role but I'm guessing that I may not have any other choice. Has anyone had any clever ideas Many thanks. I've run into the same problem. Did you ever get an a ...Show All

• NetPochi Get Datagrid...

  Hi, I currently have a populated datagrid within my c# .net application. Once the user selects a record within the datagrid, I would like to get the value within the columnX of the record they have selected. I have done multiple searches and am unable to find a solution. All help is appreciated. Hmm.. it could be because I am using .Net 1.1 I believe. Do you know how I would do this in 1.x you mean the entire column   if so...   DataColumnCollection theColumn = theDataSet.Tables[0].Columns; Then to go through the row of data: foreach (DataColumn curColumn in theColumn) {    object theData = theDataSet.Tables[0].Rows[ RowInd ...Show All