Answer Questions

• Bill Menees Unable to Update/Insert a new row into the database...

  I am working on a windows project. I created a data base "EAE.mdf" from MS VC# EE, one of the tables of this DataBase is "XmlData". i have created a dataset "EAEDataSet" with the tableadapter "XmlDataTableAdapter" to access the contents of this table. In the project I wanted to insert a few rows from the an XML file. So I have created a data row "xmlDataRow" filled all the columns of this row with the the required data. then added the row to the dataTable "XmlData" using this .DataSet.XmlData.Rows.Add(xmlDataRow); Then called on the update method on the table adapter "XmlDataTableAdapter" table. rowUpdates = this.XmlDataTableAdapter.Update(this.DataSet.XmlData); The above row updates return the exact number of rows added to t ...Show All

• GT_MSDN Internal vs. Public

  Sorry if this is simplistic, but is it a viable design choice to restrict visibility of as many type members as possible in a Windows application exe to internal, rather than public This client will necessarily never be consumed by any other class or application. It also suppresses various VS warnings about uncommented members, which are irrelevant anyway in many cases. Thoughts, comments Obfuscator I see no request for obfuscation mentioned anywhere in this thread. However, obfuscators can rename public classes too . Hello All. huysmans: That's what internal scope is meant for. Visibility throughout the assembly, but not outside of it. HTH. Oh, okay, thanks. I just managed t ...Show All

• Musafir Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'

  I did a quick search around this forum and around the web but I can't find any helpful information regarding this problem.  Currently, I am running a site on asp.net 2.0 within a shared hosting location.  Their SQL backend is 2000.  I managed to create the db via aspnet_regsql, and then upload the aspnetdb and set provider stuff to the correct bits of information, however when I try any query, like logging in, it doesnt work, and get the error could not find stored procedure...  I checked, and the procedure does exist.  Everything is set up as it should be, schema and all.  Any ideas   I used Scott Guthries blog on how to use asp.net authentication on SQL 2000, and that worked without any problems. ...Show All

• Quilnux Filter a dataset on the month of the date column

  Hi, I have two data grids. First one is showing data of all Invoices for a year. There will be one text box in that user will enter a month. I want to show all Invoices for that month from First data grid to the second data grid. ( I have InvoiceDate column of DateTime datatype and i want to show all records for a specified month in the second grid. Basically I want to use Month(InvoiceDate) = 2 this kind of filter query on dataset) How should i do it Mangesh I would recommend filling the second datagrid from the database when you want to filter by the month. This way you can use Transact SQL and the DatePart function. As an alternative you could also calculate the first and last date of the selected month and filter ...Show All

• Crispy Rice timeout expired failed to start instance

  I have a C# windows app created with vs2005 on windows xp pro with sql 2005 server express installed ( it uses a database ) I create a deployment project then install the app on the machine Every so often - quite rarely but enough to worry about - usually just after a restart - when I start the application I get a timeout expired - something about failing to connect to an instance - I am assuming it is because the database engine has to start up and then it has to creat an instance and all this just exceeds so time limit - I tried putting "Connection Timeout=300" in the connection string in the app.config file - it did change the sqlcmd.connection.connectiontimeout to 300 but it did not get rid of this intermitant probl ...Show All

• KrazyMGA DS HELP

  I currently have this error when I delete a record and then save it. My code is at the bottom of this post, im a newb to this though wish to learn. Though i've tryed to google this many a times and still come up blank with out knowing how to fix this problem. Can anyone help much thanks and please keep the answer with simple instructions. --------------------------------------------------------------------- ERROR: Update requires a valid DeleteCommand when passed DataRow collection with deleted rows. {"Update requires a valid DeleteCommand when passed DataRow collection with deleted rows."} System.InvalidOperationException was unhandled Message="Update requires a valid DeleteCommand when passed DataRow col ...Show All

• csLearner Importing Namespace

  Hi I'm developing windows application. I want to use Appsettings in my application. For that i've included the following line in the begining of the class file. imports Imports System.Configuration .......but i'm getting warning that i should include System.Configuration.ConfigurationManager. But i couldn't include ConfigurationManager. So please help me Thanks and Regards Jackuline S Try using namespace System::Configuration; Hi Thank u. i got the answer ...Show All

• luckymaheshwari Connection Pooling Issues

  I've been getting an error that goes something like 'Cannot obtain a connection from the pool, maximum pool size has been reached' I had been using a max pool size of 300, and now i've increased to 10,000. Is this the right thing to do Is there a limit to the pool size that i can set So far i haven't had that error, but I would like to know if there is a better way to handle the issue Thanks Emeka Awagu Note this error is quite common and it indicates that somewhere in your code you are not closing a connection. Finding out where is the tricky part! Yes i believe my application is closing the connection - all my data access codes are enclosed within a try..catch..finally block. and i always ...Show All

• PaulCzy Connecting to a Sybase db

  When running my program I get this error, I installed the Sybase client in my local machine and I can access the tables using the SQL Advantage utility in Sybase. Do I have to do anything else Message "The 'Sybase.ASEOLEDBProvider.2' provider is not registered on the local machine." String Thank you JM Thank you Paul. I already installed the Sybase client, do I still need to install Sql Anywhere JM Hi, I think you should install Sql Anywhere to be able to use the Sybase provider in .Net. Try searching for it in the sybase homepage. www.sybase.com cheers, Paul June A. Domag I moved this question to the .Net Data access forum. This forum is related to Team Suite only, ...Show All

• TheViewMaster VS 2003 debugger haults

  Hi All, I am working to generate the correct stacktraces whenever my application fails. So, i have been testing the stacktracing code by making my application crash at different points. But when i am trying to debug the crash in my application through VS .NET 2003. The debugger displays a message box saying "Unhandled exception in exe......... Access Violation writing location" and gives three options. 1) Break 2) Continue 3) Help Even after clicking "Continue" the debugger doesn't allow to proceed with the debugging and displays the same message box again. The debugger basically haults and does not allow to do anything futher. Any suggestions or workarounds would be of great help. Thanks, - Navin ...Show All

• SONAL N. SATPUTE Is there a command to print the members of an assembly ?

  I need a way to generate a simple list of each method of each class in an assembly. The Visual Studio object browser doesnt give me a way to export the list of print its display. Try something like this: Assembly asm = Assembly.GetExecutingAssembly(); Type[] types = asm.GetTypes(); BindingFlags[] kinds = new BindingFlags[] { BindingFlags.DeclaredOnly | BindingFlags.Instance | BindingFlags.Public, BindingFlags.DeclaredOnly | BindingFlags.Instance | BindingFlags.NonPublic, BindingFlags.DeclaredOnly | BindingFlags.Static | BindingFlags.Public, BindingFlags.DeclaredOnly | BindingFlags.Static | BindingFlags.NonPublic }; foreach (Type t in types) foreach (BindingFlags kind in kinds) foreach ...Show All

• zdrae Question about WSDL.EXE /SHARETYPE

  Hi,   I have two .ASMX web services and I need to share a typed DataSet – called AdminDataSet -between them.   I used wsdl.exe /sharetype to have one type shared between them, but the result proxy.cs file contains two definitions for AdminDataSet! So I have compile time error.   I checked both wsdl definitions for ASMXs, they both refer to the same definition for AdminDataSet.XSD.   Why WSDL.EXE /SHARETYPE doesn’t work properly with my case   Any help would be appreciated, Alan         Here is the first wsdl:   - < wsdl:types > - < s:schema elementFormDefault =" qualified " targetNamespace =" http://Company.com/Trans ...Show All

• Nick Gravelyn running another process

  I run an exe using Process.Start("myexe.exe"); how can i check if the process is running so i dont run it twice Thank You there ar a couple of ways. get a list of processes by name and see if the collection is returned... Process [] theProcesses = Process.GetProcessesByName("processName"); if (theProcesses.Length > 1) {    //more than 1 process is running }   you could also get the process by ID which is returned by the Process.Start() method, returns a process object. could check to see if the process has exited via the HasExited Property Process theProc = Process.Start("filename.exe"); ... ... if (!theProc.HasExited) { &n ...Show All

• Jamie Thomson How to get the error message from Login Provider Validate() method?

  Hi, I am trying to use Login control (framework 2.0) with a custom provider for authenticating user. As the custom provider inherits abstract class MembershipProvider, it implements method ValidateUser(). The method just returns a bool and if there is any exception it goes as page error; an unhandled exception. I would like to handle this exception in Login control, but do not find any way or place where I would get this exception. Could you please tell me how do I handle this exception and have a custom message to be displayed to end user instead Thanks in advance, Maithili. Login control has a LoginError event you can suscribe to handle the exception.. have you tri ...Show All

• tone-loc Simple Update from a VS 2005 vb project to an mdb?

  Hi all, New to Visual Studio, and only have experience with asp and access. The problem I have is this. I can call nearly anything out of my database that I want, but for the life of me, I can't update even a single field. Now the worst part is this. The little program I'm working on to do the data access is just a simple console app, which passes the data on to clients. All is well except, how do I code an update to a field. For example, to update the field Email in the Clients table with a variable passed through dimmed as a simple string This is an example of the code I am using for my general select querries: Dim conn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Delirium.mdb" Dim cmd A ...Show All