Answer Questions

• Ke Sun arrays to sql server table

  Using vb8, I would like to be able to programmatically save data in arrays to an existing sql server 2005 table. I've found tons of info on how to load db data into arrays but not the reverse. Can anybody offer some clues It looks like you are reading the array data correctly and putting it into the datatable correctly.... DO NOT call AcceptChanges until you have called the tables update method! Table.Rows.Add(row) TableAdapter.Update() Table.AcceptChanges Remeber you always have the ability to utilize SQl command objects to do your updating Since the .Update() function provided the updates to the dataset, then it sounds like you were somehow still adding rows to a table out ...Show All

• loopool Authorization by domain/computername role

  Is it possible to have a clients computername equal to the domainname to authenticate to I have for example the following snippet of my .Net remoting server configuration: <channel ref="tcp" port="20061" secure="true" impersonate="true" > And I set security actions by using declarative security. For example: [PrincipalPermission(SecurityAction.Demand, Authenticated = true, Role = @"oDomain\oRole")] public void DoSomething() { .. } My question now, is the following. Is it possible to have a client connecting to this remote object, having his computername as oDomain and a group on that machine named oRole. And would this client have access to DoSomething() Regards tj. It's either a group in your do ...Show All

• Jourdan Will the object be disposed if an unhandled exception is thrown in using block?

  For example, within a piece of code like this:- ... using(ExpensiveObject expensive1 = new ExpensiveObject()) { this.DoTask1() ; this.DoTask2() ; } ... what if an exception is thrown from this.DoTask1 Will the dispose() method in ExpensiveObject be called I was wrong, the answer is no -- objects will not be completely disposed when exceptions occur and you don't explicitly dispose them with the using{} block. This is true even for .NET objects (unmanaged wrappers) like SqlConnect and SqlCommand. I did a test where I created 70 and 140 exceptions in unmanaged code by doing connects to a database and then doing commands against a table that does not exist. Test 1 - Exceptions where the unmanaged object ...Show All

• peterng Exposing a Shared Assembly in the Add Reference Dialog in .Net

  Hi I have created a sample shared assembly and installed it in the GAc using the following command GACUTIL /i SharedDemo.dll After this, when I browse to <windir>\Assembly, the Above assembly is viewable but if I try to view it in the Add Reference Dialog in C# or Vb.Net, I can't. Please assist. Thanks in advance Devesh http://support.microsoft.com/default.aspx scid=kb;en-us;306149 Do you see your assembly when you run the gacutil as follows: gacutil /l sharedemo.dll Thanks for your help :-) Hi I have created a sample shared assembly and installed it in the GAc using the following command GACUTIL /i FA.dll After this, when I browse to <windir>\Assembly, the Above assembly i ...Show All

• DMillerNCR Can I develop an application by having both asp and asp.net together

  I have already developed part of an application in asp , I have to complete remaining thing, whether can I develop remaining part in asp .net , If I do so Whether I will face many problem ,otherwise system will support both asp and asp.net in all scenario. Suresh The migration forum ( http://forums.asp.net/29/ShowForum.aspx ) at forums.asp.net will be better equipped to help you. Thanks. ...Show All

• Fradam Updating IBindingList from different thread

  I have a DataGridView which draws it's information from a BindingSource. This BindingSource gets it's data from a BindingList. Now, I need to update this BindingList from a different thread than the one that the DataGridView is implemented on. When I try to do this, I catch a thrown exception and the exception says that I cannot modify the control from a different thread (understandable). However, how can I work around this In my opinion, shouldn't the BindingSource or DataGridView controls ensure that the control is updated from the implementing thread Is this a bug Any suggestions would be welcomed - Thanks! ~ matt You're right, BindingList isn't set up to handle asynchronous situations, ...Show All

• John.Doe The code works properly!!

  I ran into a huge problem using TransactionScope. I've been using it inside some classes that manage persistence to a database. I intended to use System.Transactions so that calling classes can wrap my persistence manager classes in a transaction scope and thereby control whenther or not a transaction commits or not. The persistence manager is blissfully unaware that the transaction it uses internally is being controlled by an external transaction scope. Here's an example of my problem: public void Test() { string conString = "Data Source=localhost;" ; SqlConnection con = new SqlConnection (conString); con.Open(); this .DoDatabaseStuff(con); con.Close(); } public void DoDatabaseStuff( SqlC ...Show All

• delma use of filesystemwatcher along with backgroundworker

  hi all, I m creating an application that continuously monitors the file sytem using FileSystemWatcher in the background using the BackGroundWorker class, but i m not getting the event fired when the filename is renamed, plz any1 can help me inthis how to implement it...... i dnt knw anything abt using both 2gether. plz help needed. thanx in advance Why do you need to do it with Background worker It doesnot halt your GUI if you use it from the main Thread then why BackgoundWorker is needed Try to think and change your logic accrordingly. ;) thanx for the reply. Ya i have already did that, but event is not catched only. Can i knw how to implement filesystemwatcher along with the backgroun ...Show All

• Tryin2Bgood Detecting remove lock event on file

  I have the following problem: We have to write an application that acts on changes on files. For example editing a word - file. We achieve this using the FileSystemWatcher from .NET 2.0.  When the word-file is saved the events correctly trigger, but the files are locked, which causes our action to fail, but this is not the problem. But when the user closes the word-application. The application release the lock,but  we can't seem to catch this event so we could run our actions then.   Does anybody has as solution Thx, gert Windows doesn't provide any way to either detect a lock or be notified that a lock may have been released. To avoid a lot of threads, use just one ...Show All

• Michael1956 Running external application

  I have been exploring the options available to have my VB dot net application do "auto updating" when a new release is required, and all of the complexities in using the "ClickOnce" approach is too much to deal with. Mainly it's due to server restrictions, but there are other issues as well. Thanks to some suggestions from Indian Ocean, I've been able to determine when an update is available but now I'm "semi-stuck" with how to handle it. I could use the "downloadfile" side but I would rather close the application and point the users to a website address with information on the update and a link to download it from. The issue I have now is exactly how to "load" that website address in ...Show All

• AbErCrOmBiE12 data objects and their limitations

  I'm in need of a lightweight data object to get data from database and process data in the object. I have the following questions: Which dataobject will work fast in fetching large amount of data from DB Is the any limit on the amount of data (in terms of bytes) for datareader and dataview If so, whats the limit Is the dataprovider required to read data from datareader object Can data be read from xml obj and put into a datareader Is it possible to get row count without going thru the datareader object What is the structure of those 400MB in terms of number of columns and number of rows If it’s just one big BLOB, you might be better off spitting it out to a file on the server, and then copy it, a ...Show All

• JSweet Authenticating client using SSLStream

  I have seen the MSDN sample code for implementing SSL in a TCP client/server application (http://msdn2.microsoft.com/en-us/library/system.net.security.sslstream.aspx) I then wanted to add the 'optional' client authentication piece to this sample by changing the client to use: I Added: X509CertificateCollection X509Coll = new X509CertificateCollection(); I Added: X509Coll.Add(new X509Certificate(@"c:\Projects\SSLStreamClient.cer")); I Changed: sslStream.AuthenticateAsClient(serverName, X509Coll, SslProtocols.Tls, false); it originally was: s slStream.AuthenticateAsClient(serverName); I created SSLStreamClient.cer using makecert.exe and placed it in CurrentUser.Personal and in CurrentUser.Trusted Root Certi ...Show All

• Eissing Socket timeout not expired when the client socket shutdowns

  Hi, I have a socket communication in .NET 2.0, with a server socket that accepts many client sockets, creating a thread foreach client. I want to close the communications that don't send data within n minutes from the last communication; so I set timeout option in the client socket with this code: Socket socket = sListener.Accept(); socket.SetSocketOption(SocketOptionLevel.Socket, SocketOptionName.ReceiveTimeout, n * 60 * 1000 ); This timeout expires as expected when the client doesn't close his socket. But if the client closes his socket before the timeout expires, the timeout doesn' t expire and so the server can't close the communication. Are there other ways to do this I've tried with setting a KeepAlive, in hopes to get an excepti ...Show All

• KevinBurton Accessing/Editing SQL Server Database using VB.net program via TCP/IP

  Hey everyone, I have a SQL Server 2005 database up and running on a server and I have it set so that there can be remote connections using Windows Authentication (we share the server with some other accounts so this is the most convenient way for us to do it) and I also made sure that our XP Firewall allows connections to SQL Server. We have created  program using VB.net (Visual Studio 2005) that reads/writes/and deletes items from our database on the local machine.  What we want to do is now make it so that we can run the VB program from other computers around our building and remotely connect to the database via TCP/IP using Windows Authentication. I have tried altering our data source that writes to the database locally ...Show All

• NickNotYet ProtectionLevel of SSIS

  My SSIS works fine on my machine but other members of my team are not able to execute my packages. Is this because of the ProtectionLevel property Should I change it from the default value i.e. EncryptSensitiveWithUserKeys toEncryptSensitiveWithPassword ad provide a password for my package Set the PackagePassword property on the Application Object Hi, If we have to execute the SSIS package through C# code, then how to use this Protection Level:Encrypt sensitive data with password Regards,   The solution to this problem is While importing the package in SQL Server 2005(Integration Services) from ...Show All