Answer Questions
Tim Newsham List tables in SQL database
Previously (VB2003) with Access I've referenced the ADOX namespace and used something like follows to list all of the tables and indicate which were system tables; tTables = cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, Nothing ) In a similar manner I could list the fields in each table to include datatype. Can someone point me in the direction to accomplish this is SQLExpress and possibly indicate PK's also. Thanks ...Show All
r3n Excel interop - crash on dispose call
I'm hosting excel inside a .NET 2.0 winforms application. However, I'm having a problem when the container control is disposed and excel is quit and disposed. Everytime a call to dispose happens, Excel crashes, giving me a non-saying error window. I tried a lot of stuff already like: protected override void OnHandleDestroyed(EventArgs e) { &nb ...Show All
Scott518 How can i get the maximum path length?
I didn't find any enum type that gives me this platform constant. How could i get it I mean the maximum character number which i could use to identify a file path. Thx. Look at- http://www.pinvoke.net/default.aspx/Constants/MAX_PATH.html The answer is that MAX_PATH = 260 This is a restriction of the Windows OS - 2000.XP,2003 ...Show All
Morgan1339 NetworkStream with UDPClient
hi, is it possible to use a networkstream while using an udpclient to send and receive data. I have a thread wich constantly checks the Stream to see if new data has arrived, because i have to implement both a tcp connection and an udp connection i'd like to use the same thread to check for incoming data as well as sending data; by setting the UDPClient to work only with 1 remote host is it possible to use the networkstream for this pupose btw ...Show All
HдLΛвί SmtpMail::Send Works Once then fails
I am trying to send a list of reports to a list of ppl. I am using a simple managed C++ program, and SmtpMail::Send. This works fine for the first email I send, all calls there after to my SendMail function fail. I know "SmtpMail::Send" is considered obsolete, but we are currently still using VS:2003 with .net 1.1 (I think). I get this error on the second and all following calls: System.Web.HttpException: Could not access 'C ...Show All
RaghuramKr Killing a ThreadPool thread
How can I safely kill a thread from a ThreadPool That is, how can I kill/abort the thread resulting from queueing like this: ThreadPool.QueueUserWorkItem( new WaitCallback(someMethod), someObject); The problem is as follows: 1. Once in a while (much more often than we can afford for the critical production application!..) the Image.SelectActiveFrame(...) method hangs, consumes 98 to 99 % of CPU, and we have to reboot the server... ...Show All
Miguel Angel Zavala Vizcaya How could I know if I am running a NGEN'ed image?
After I NGEN'ed my program and run it, I found there is no change on memory cost and running speed. I doubt if I am still running the old version(not NGEN'ed) of my program. How can I run the NGEN'ed image directly Or how can I know if I am running a NGEN'ed image Thanks! BTW : where is the native image cache on my hard disk Thanks! The files are in \Windows\Assembly directory. There is no way to run it directly, I think, no ...Show All
ersheido Can I write Profile.UserID from SqlDataSource1?
Quick question. New guy here, appologies if this is incredibly simple but I can't figure this out. Visual Studio 2005, C#, Web form. I have SqlDataSoruce1 that grabs a login name and password from a DB, if a match on button click, you go to page 2. As I do this, I write the value from the username and password text box to Profile.UserName and Profile.Password for later use... I want to write the UserID from the DB to Profile.UserID but it doesn' ...Show All
huseyin_ Need some help with system.io.ports
HI there all, I am trying to get an output like this on a serial connection, but i never build something with serial communications! I know that the ouput(rs485) looks like this in hex without the datetime string: 11:31:58.281 : f5 f0 01 00 61 2e 2c 00 00 00 00 00 00 00 00 00 00 00 00 00 a1 02 00 f5 f6 01 ff ff ff ff ff ff ff ff 00 00 00 00 52 70 00 00 00 a6 0a 00 11:31:58.656 : f5 f0 01 00 61 2e 2c 00 00 00 00 00 00 00 00 00 00 ...Show All
Nightlinerdev Webservice problems.
Hello. I am desperately trying to send data from a client application to a webserver via a webservice. Apparently I cannot pass an object class as a parameter, so have decided to use a dataset. When I run the code, I get the following error at this line in Reference.vb: Dim results() As Object = Me .Invoke("SendSpecs", New Object () {serial}) An unhandled exception of type 'System.Web.Services.Protocols.SoapException' occurre ...Show All
misternet Query String
How can I pass an argument from one Web Page to another I now how to do it in C#, but I want the equivalent in VB. The API for C# and VB.NET are to same. The only difference is the syntaxe of the language. You can convert from one to the other easely with some online tools: http://www.developerfusion.co.uk/utilities/convertcsharptovb.aspx VB uses parentheses for array indexing instead of square braces, ...Show All
gzinger System.Net.NetworkInformation & Process Counters
Hi, I know currently it is possible to access process counters using the System.Diagnostics.PerformanceCounter but this can be expensive and wrong security setting can interfere. Is there any other base classes in Framework 2 that can do a similar task I've read that it possible to use System.Net.NetworkInformation class to access Network Information and device information on remote machines, but can it access Process Inform ...Show All
Lino How to compare input value with database value
hey guys, I have trouble with comparing the two values. One value is from the user, then once the user click the calculate button, it will take the input value compare with the value in the database and then select only that row of the data base. Below is my code: Imports System.Data Imports System.Data.OleDb Imports System.Data.OleDb.OleDbPermission Imports System.Data.OleDb.OleDbConnection Imports System.Data.OleDb.OleDb ...Show All
blewisjr Checking for Duplicate Records First
I am updating a tempory database table with a file. Once i have read it into the tempory table, i want to update the master table, but only for new records IE, each record has an account code, which is unique. The first time the master table is updated there will be no problems, as there won't be any data in it already. All future updates, will require that they check there isn't an existing record with the same account code. Ba ...Show All
Details Monster Convert VB.Net-application to Webpage
I downloaded VS2005 Express. Great, but I have to study again a lot because I was just happy to cope with WebMatrix. My question: I developed a navigation-aid/calculator in VB.NET using a trial-version of the old Visual Studio.NET. A not completely debugged usable version you can see on www.alswin.nl/navigate.exe (with .NET Framework!) Is there an easy way to convert this application to a new ASP.NET 2.0 web-page ...Show All
