sproc to determine if query will produce Invalid SqlNotificationEventArgs event

.NET Framework Data Access and Storage

- Previous
  - 1
    - Problen Inserting Data into a Ms Database I can not seem to find the problem in the following snippet of code. I would like the code to insert data into the Ms Database. I get an error message as follows. System.Data.OleDb.OleDbException was unhandled ErrorCode=-2147217904 Message="No value given for one or more required parameters." Below is the code for the application Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click ' Create containers to contain Text Dim myLastName As String Dim myFirstName As String Dim myTELUSID As String Dim myWork As String Dim myCell As String Dim myEmailAddress As String 'Fill the new containers with data the user keys in myLastName = TextBox1.Text myFirstName = TextBox2.Text myTELUSID = TextBox3.Text myWork = TextBox4.Text myCell = TextBox5.Text myEmailAddress = TextBox6.Text 'Open database connection and prepare to add records 'Dim MyConn As New ADODB.Connection Dim strConn As String strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source= e:\GDPR-OPE.MDB;" 'MyConn.Open(strConn) 'opens database command 'now add the command to execute the database add Dim SQL As String = "INSERT INTO tblEmployees" SQL = SQL + "(LastName,FirstName,TELUSID,Work_Number,Cell_Number,EmailAddress)" SQL = SQL + "values(" SQL = SQL + "myLastName,myFirstName,myTELUSID,myWork,myCell,myEmailAddress)" Dim myconn As New OleDbCommand((SQL), New OleDbConnection(strConn)) myconn.Connection.Open() myconn.ExecuteNonQuery() myconn.Connection.Close() Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 2
    - UsernameToken with actor Is there a special way to set client credentials for a web service client that needs to specify client and service actors in its policy If I have actors on my usernameForCertificateSecurity or usernameOverTransportSecurity assertion specified in my policy file, then even if I call SetClientCredentials on the proxy, I get an error similar to "unable to determine client token to use". You can easily reproduce in the RoutingClient project in the SecureRouting WSE 3.0 sample. Just change the client's policy to use one of the "username" assertions. I've gotten a little farther by using proxy->RequestSoapContext->Credentials->SetCredentials to specify a "credential set", but it either doesn't like the actor value I use or for some reason doesn't send the password when connecting to the router. My ultimate goal is to implement a router service that validates a user with some token service and then passes on the user credentials along with a new token to an inner service. Does anyone know of a good sample to do this Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 3
    - .NET Runtime version 2.0.50727.42 - Fatal Execution Engine Error (7A05E2B3) (80131506) Hello, I got the following Error in my WXP Application Log after I tried to start a custom C# .net application .NET Runtime version 2.0.50727.42 - Fatal Execution Engine Error (7A05E2B3) (80131506) For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Source : .net Runtime Category : None Event Id : 1023 ---------- I think this problem started when I removed the trail version of a C# Profiler [ from a vendor that I can't name under NDA ] It seems that the profiler installed a hook somewhere to start itself whenever I start any C# / .net app. Does anyone know where the hook could be installed I would like to remove the hook without reimaging my laptop.... Thanks ! Benjamin Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 4
    - Mouse Related functions in Windows XP I would like to capture the mouse's left click event and convert it to a right-click. A few examples of utilities that implement this, are: DialKeys (for the UMPC), Fujitsu made a utility for the P1510D Notebook/Tablet PC, and Samsung also implemented this for the Q1 in their "TouchMon" utility. The reason I am looking for a solution like this is that in a UMPC there is no easy way to right-click. I am looking for a utility which I can run (.exe) which will then convert my next mouse click into a right-click. After performing the right-click, the mouse should function normally. I am familiar with programming and .net so if someone provides me with sample code I would be able to create this utility myself. Thank you very much. Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 5
    - Determining local or network environment within program Hey guys! I have a question about determining what kind of access a program has. This is the problem - there is an object whose data is populated via a web service (which gets data from the database) or via local access to the database. In the scenario where the application has no web access, I need the program to know that it should use the local access to populate the object. At this point, this is what is happening: if httpcontext object is null, then populate object using direct access to db. else populate object using web service. Is there any .NET function or whatnot that will allow me to determine what environment (local/network) the program is running in Thanks! David Pham Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 6
    - Calling 32-bit COM object fails 80040154 I have a .NET project that normally calls into 32-bit COM objects. I would like to port it to 64-bit but there is one COM object that must remain 32-bit. When the project runs, it gives an error "Retrieving the COM class factory for component with CLSID {...} failed due to the following error: 80040154." The error is 'Class not registered'. Having researched the issue, on 64-bit Windows my 32-bit COM dlls are registered in HKCR\Wow6432Node\CLSID instead of the normal HKCR\CLSID. When my .NET project runs in 32-bit, it looks to HKCR\Wow6432Node\CLSID and finds the correct object there. When it runs 64-bit, it looks to HKCR\CLSID and doesn't find it. I thought if I compiled my interop assembly to only target 32-bit, it might work. However, the 64-bit app did not like working with the 32-bit interop assembly at all. Does anyone know how to do this correctly Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 7
    - XML "Id" attribute Hi there, I tried to read an XML file by using Dataset.ReadXML() method. However, i cannot read some of the "Id" attribute for some elements. But when i checked the XML file, there are values inside. Anyone can be advised on this Thanks, JL Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 8
    - Smtp with c# through gmail. Hi guys, hope you can help. I have installed Visual Web Developed and started learning ASP.NET with c#. I am currently trying to build a website that sends email through gmail's smtp, here's the code: _______________________________________________________________________ using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Net.Mail; using System.Net; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { System.Net.Mail.MailMessage mail = new System.Net.Mail.MailMessage(); System.Net.NetworkCredential cred = new System.Net.NetworkCredential("xxx@gmail.com", "xxx"); mail.To.Add("xxx@xxx.com"); mail.Subject = "subject"; mail.From = new System.Net.Mail.MailAddress("xxx@gmail.com"); mail.IsBodyHtml = true; mail.Body = "message"; System.Net.Mail.SmtpClient smtp = new System.Net.Mail.SmtpClient("smtp.gmail.com"); smtp.UseDefaultCredentials = false; smtp.EnableSsl = true; smtp.Credentials = cred; smtp.Port = 587; smtp.Send(mail); } } _______________________________________________________________________ And I am getting this error message: Server Error in '/email' Application. A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond I am testing the app on the server that's integrated in Visual Web Developer, could that be the problem What else could it be Please help. Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 9
    - Help connection to a database. I'm workin on converting a C # program from VS2003 .NET 1.1 over to VS2005 .NET 2.0 . The program accesses an Access 97 database with a password. In the original program, the following connection string works: "Provider= Microsoft .Jet.OLEDB.4.0;Data Source=\" C :\\SLData\\Database\\SLDebit.mdb\";Jet OLEDB: Database Password=\"PaSsWoRd\";" The new program crashes at: connection.Open I'm fairly certain that the problem is that the Database Password property isn't getting set. If I pause runtime and add a Watch on my OLEDBconnection object , I can't even find where this property exists to check if it was set. In VS2005, I tried to add a new database through the Server Explorer and was able to verify that all of my above information is valid. Through the server explorer, I was able to view all the database columns and rows. When using the Connect to a Database wizard, I paused to view it's Advanced. settings before clicking Ok. This view of the properties resembles that of a Watch and I could see that the Database Password property indeed had to be set inorder to connect. I'm stumped. This all has to be accomplished programically. If anyone can offer any help, it would be greatly appreciated. Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 10
    - DataSet location Hi, ALL! I had added an sdf file to my project and created dataset on design time. While running the application on WM2003 the sdf must be located in application folder otherwise I get an error... I'd like to move the sdf to memory card, but can't find how to change connection string! Any help! Lev Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 11
    - 64-bit License Compiler issues I don't fully understand how x64 affects .NET, but I didn't think I would have to. I thought development should be 32/64 bit agnostic. Anyway, I've hit a snag after upgrading to Vista x64. Building one of our components produced the following error: C:\Program Files (x86)\Microsoft Visual Studio 8\SDK\v2.0\bin\LC.exe /target:Elsinore.ReportDesigner.dll /complist:licenses.licx /outdir bj\Debug\ .... licenses.licx(2): error LC0004: Exception occurred creating type 'DataDynamics.ActiveReports.Design.Designer, ActiveReports.Design2, Version=4.3.0.1261, Culture=neutral, PublicKeyToken=cc4967777c49a3ff' System.BadImageFormatException: is not a valid Win32 application. (Exception from HRESULT: 0x800700C1) I saw in some places to use LDR64 /setwow and LDR64 /set64 in pre/post build events to fix this. Well that fixed this particular licensed component, but now another licensed component (that was fine without the ldr64) is giving problems building the same assembly: C:\Program Files (x86)\Microsoft Visual Studio 8\SDK\v2.0\bin\LC.exe /target:Elsinore.ReportDesigner.dll /complist:licenses.licx /outdir bj\Debug\ .... licenses.licx(1): error LC0004: Exception occurred creating type 'Syncfusion.Core.Licensing.LicensedComponent, Syncfusion.Core, Version=4.402.0.51, Culture=neutral, PublicKeyToken=632609b4d040f6b4' System.ComponentModel.LicenseException: A valid license cannot be granted for the type Syncfusion.Core.Licensing.LicensedComponent. Contact the manufacturer of the component for more information. I have read the following article but it seems to be no help: http://support.microsoft.com/kb/913961 Am I screwed Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 12
    - schemaLocation problem with Serialization. I am using serialization in c# 3.0 (trying to serialize). I want to use the schemaLocation xml attribute as that is what is in an example i need to stick to. I cannot work out what c# attribute i need to use to do this. I have tried: Code Snippet public Class exampleClass { [System.Xml.Serialization.XmlAttributeAttribute("schemaLocation", Namespace = "http://www.rewerse.net/I1/2006/R2ML http://oxygen.informatik.tu-cottbus.de/R2ML/0.4/R2ML.xsd")] public string schemaLocation; } where "exampleClass" is the root node in the serialized document. The output should be like: Code Snippet <exampleClass schemaLocation="http://oxygen.informatik.tu-cottbus.de/R2ML/0.4/R2ML.xsd"> ... </exampleClass> what comes out is more like: Code Snippet <exampleClass xmlns="http://oxygen.informatik.tu-cottbus.de/R2ML/0.4/R2ML.xsd"> ... </exampleClass> Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 13
    - IPv6 Multicast Hi, I'm trying to find out how IPv6 Multicast works, from a C# application's viewpoint. How are multicast addresses assigned i.e. how would an application obtain a multicast address for use on the public internet. How does an application connect to a multicast address and recieve data. i.e. Computer A is multicasting how does computer Z register its interest in that multicast when the public internet (Computers B through Y) stand in the way. Cheers Colin Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 14
    - List<T> collection not getting disposed even after closing the form. Hi, Please find below a sample application which demonstrates the above problem.If we run this code from memory profiler we can see that List object live count is 1 even we close Form1. //This is my Test form code namespace ListTest { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { List<InfoClass> infoList = new List<InfoClass>(); //ArrayList infoList = new ArrayList(); InfoClass info1 = new InfoClass(); info1.Name = "John"; info1.Id = 1; infoList.Add(info1); InfoClass info2 = new InfoClass(); info2.Name = "John"; info2.Id = 1; infoList.Add(info2); ultraGrid1.DataSource = infoList; } } } //This is the infoclass code.Here i added IDisposible also but still the problem persists. namespace ListTest { class InfoClass :IDisposable { private string _name = string.Empty; private int _id = 0; public void Dispose() { Dispose(true); GC.SuppressFinalize(this); } protected virtual void Dispose(bool disposing) { } ~InfoClass() { // Simply call Dispose(false). Dispose (false); } public string Name { get { return _name; } set { _name = value; } } public int Id { get { return _id; } set { _id = value; } } } } Now from a mainform i am calling Form1 form = new Form1(); form.Show(); So when i close Form1 ,with mainform(MDIParent still open) in memory profiler still i see the live count of infoClass[] as 1. Here is the memory profiler results. Namespace Name Total(Live instances) New(Live instances) ListTest Form1 0 0 0 0 0 0 0 0 0.04 14.3 ListTest InfoClass 0 0 0 0 0 0 0 0 0.09 1.4 ListTest InfoClass[] 1 1 0 1 16 16 16 16 0.09 2.1 ListTest MDIParent 1 1 0 1 540 540 540 540 0.04 23.5 Please help me to fix this problem Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 15
    - Business layer passing results from a SQLDatareader Hi, I'm creating a business layer to access an SQL database cycle through the data for validation and pass the clean data onto an ASP form. I am currently retrieving the results into a SQLDatareader into my class file. I loop through the reader and validate the data. Should I place the results into an array Is that the best way to pass that data via code to my VB code for the ASP form. Can I transfer that into a datatable or something similar. I don't mind cycling through the records in the VB part of the ASP form but I don't want to persist any SQL connections. Thank you for your help Vear Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 16
    - How do you 'Join' a background worker thread? I am using a 'BackgroundWorker' object to impliment multithreadeding because it provides a really neat way of passing events into the main UI thread. My problems occur when it is time to halt the background worker thread. I can easily signal the thread to exit via synchronization objects and if desired I can service the 'RunWorkerCompleted' event later on but what I can NOT neatly do is wait for the thread to exit after I have signalled it to do so. If this was a thread I had instantiated myself I could call its 'Join' method but I can find no equivalent for the BackgroundWorker - nor can I see anyway to get hold of its thread to call join on it myself. I can bodge something up using synchronization objects so that the thread loop releases an object just before it exits and the terminating function 'Waits' on this object. But this approach causes problems during debug. Is there any way to perform a 'Join' or some equivalent operation on a background worker thread. Thanks in advance for any help or discussion on this subject. Ted.. Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
- Next
  - 1
    - WSE 3 and VS2008 Hi, Are there any plans to support WSE 3 in VS2008 I tried installing WSE 3 after VS2008 Beta 2, but does not integrate with the IDE. Thanks Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 2
    - Sending content of file over serial connection. Hi All. I have a quick question. I have a file that needs to be sent over a serial connection. I am not sure if it is a file or the content of the file that needs to be sent, this would be subject to test. I am sendin from a terminal to a printer and the printer recieves and prints. The file is here called Test1.LBL and it contains this: ! 0 200 200 240 1 LABEL CONTRAST 0 TONE 0 SPEED 5 PAGE-WIDTH 400 BAR-SENSE ;// PAGE 0000000004000240 BT 5 1 0 B I2OF5 2 1 30 23 115 999900001190507 BT OFF T90 0 2 136 59 Hello IL 124 14 280 14 50 LINE 71 90 334 90 1 FORM PRINT So I am looking for 2 ways of doing this. 1 to send the file over serial port and 2 to send the content of the file. I have the serial port open. What comes next Thanks in advance. Sune Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 3
    - Configuring Jet connection parameters using .NET OLEDB connection I use .NET 2.0 OLEDB provider to connect to a Access Database. I could not find a resource in MSDN library that enumerates & explains various connection parameters that can be set. I copied the following code from one of the connection string, generated by VS 2005, when I connected to a Access DB with server explorer, using OLEDB data provider: "Jet OLEDB:Global Partial Bulk Ops=2;" & _ "Jet OLEDB atabase Locking Mode=1;" & _ "Jet OLEDB FP=False;persist security info=False;" & _ "Mode=Share Deny None;Jet OLEDB:Encrypt Database=False;" & _ "Jet OLEDB:Create System Database=False;" & _ "Jet OLEDB on't Copy Locale on Compact=False;" & _ "Jet OLEDB:Compact Without Replica Repair=False;" & _ "Jet OLEDB:Global Bulk Transactions=1;" Can anyone explain this string I am not asking about the parameters, like what is Locking Mode. What I am asking is whether Locking Mode=1 locks the DB with Pessimistic or Optimistic Locking protocal Moreover, I need to tweak my application performance. So, can somebody point me to a resource that enumerates & explain all parameters that can be set in this string Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 4
    - How to save xml file in a client-server environment... I have used the doc.Save( Application .StartupPath + @ \..\config\\vb_alias.xml ); to save on my local machine & it works here. But when in a client-server environment i want to save some thing it gives error that Access to the path \\client57\myTest\product\config\vb_alias.xml is denied. Please help me. With regards Tapan Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 5
    - Difference between CreateInstance and CreateInstanceandUnwrap ? Hi, Can somebody please tell me how object returned by Assembly.CreateInstance() is different than AppDomain.currentDomain.CreateInstanceAndUnwrap () When a webservice calls my businessclass which dynamically loads a dll and invokes a method on a object, I get an error "MissingMethodException" if I load the assembly and create instance using reflection (Assembly.CreateInstance) and do not get the exception if I use AppDomain.CurrentDomain.CreateInstanceAndUnwrap. Can somebody please tell me how these methods are different Are there any performance implications of using CreteInstanceandUnwrap method Aditi Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 6
    - IIs 5 and .net 2 - major issues Hello, I installed .net framework 2.0 on a PC with Windows 2000 profess. No when I goto IIS and right click on a site and try to click the ASP.net tab = my IIS hangs and never opens the tab. The properties window will not close or end task.... I have to restart the pc to make it work. I really need to get this fix Any ideas please Please point me anywhere that could help with this issue. Thanks Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 7
    - Please help me Dear Sir, After populating the records from a text file into gird, and when we select another text file to populate into the same grid control the following message is coming " Cannot create child list for a filed". dataGrid1.DataMember = "csvCustomer"; The error will come inthis position. What I have to do to read another file in the same grid. Please help Thanks in advance. Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 8
    - SQL connections stop & Webservices Hello, I appeal to all to save me from this situation. I have a WebService in VB.net by IIS and a operation to connect to the SQL server and run a query and others operations. All fine... But after a certain time only the SQL operations don't respond nothing, the others are OK. So the problem is not in the IIS i think and something between the IIS and the SQL Server. Can you give me some light about this PLEASEEEE Thanks If any of you need the source say it. Thanks Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 9
    - converting of wsdl to cs file Hi all, I want to convert my wsdl file to cs file. Can any one help me with an example. Thank you. kris Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 10
    - Element prefixes Hi All, I'm relatively new to XML and have been happily generating "simple" XML documents based on a schema (xsd) using the "standard" .net process, which basically goes like this: XSD -> generate class based on XSD -> use class to deserialize to an XML it's a beautiful thing! Now I am coming across things like SSE (simple sharing extensions) and am seeing xml documents with element prefixes . Example: Code Snippet <channel> <sx:sharing since="Tue, 1 Nov 2004 09:43:33 GMT" until="Fri, 1 Mar 2005 09:43:33 GMT" version="0.91" > <sx:related link=" http://x.com/all.xml " type="complete" /> <sx:related link=" http://y.net/B.xml " type="aggregated" title="Family Contacts (Dad's Copy)" /> <sx:related link=" http://y.net/C.xml " type="aggregated" title="Family Contacts (Suzy's Copy)" /> </sx:sharing> ... </channel> This may sound elementary to most, but I've been trying and searching in vain for guidance/documentation on how to create an XSD that works (by hand or by using the generation tool of xsd.exe). The goal is to simply generate the above. The concept/semantics are understood as in "the sx prefix is defined in another namespace which you'll find in xmlns x="somehwere" ...but the "grunt work" of getting the concept working in code is missing... I'm only using SSE as an example but the real core question is how to generate the element prefix, in the above it would be " sx ", using the same process of: xsd -> class (via xsd tool) -> serialize/deserialize based on class SSE is not the only use for this. You'll find more RSS extensions ( g: for google base; media: for yahoo, itunes , etc. etc.)...so your assistance will be extremely useful If I create an xml document by hand and use xsd.exe to create a schema for it, it will create 2 xsd files (or more if you have more extensions in use). I've used the xsd tool to create the class by sending both xsds as arguments (not documented but actually works), but the serialized output does not generate the prefix. So before I drop the beautiful process of xsd -> class -> serialize/deserialize and use the more involved/manual process of using xmlwriters to write elements "manually", I hope there is an answer.. Thanks in advance.... Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 11
    - ActiveX Dll access from Web Services I have poked around (searched) the forum for an answer to this, but, though some situations are close, I have yet to find one that matches or actually solves my problem. I am trying to access an ActiveX DLL from web services. This works on my development box without a problem using the interop dll created when I add the reference. However, when I copy the files over to the server (Windows 2003), the instances of the dll don't seem to be aligned. That is, I get an object (no errors) but it's not the right one, because it shouldn't have a value of nothing. BTW - this also works on the server if I do an application type project versus a website type project. I have moved the use of the ActiveX dll from the web service class to a .NET class to a VB6 class with the same results. Code Info - the imports are the ActiveX DLLs I need to access. oHosts.UIActiveSession should provide a link to the application I need to access and is only nothing from the web service. If I create a Windows Application that uses HostTest it runs fine on the server. I could be wrong but this doesn't seem difficult OR different from what a lot of other developers are facing with solutions that use the older technology. Right Thanks in advance for any help. Michael <WebMethod()> _ Public Function GetZPP( ByVal RecLoc As String ) As String Dim o As New ClassLibrary1.HostTest Dim s As String s = o.GetZPP(RecLoc) Return s End Function 'ClassLibrary1.HostTest: Imports k1aHostConstantsLib Imports k1aHostInterface Imports k1aHostToolKit Public Class HostTest Public Function GetZPP( ByVal RLoc As String ) As String Dim oHosts As New HostSessions Dim oHost As New HostSession Dim sResponse As String Dim oResponse As HostResponse sResponse = "INIT" Try sResponse = "Before UIActiveSession" oHost = oHosts.UIActiveSession sResponse = "After UIActiveSession" & CStr (oHosts.Count) oHost.SendSpecialKey(322) sResponse = "After Send Special Key" oResponse = oHost.Send( "RT" & RLoc) sResponse = "After Host Send" oHost = Nothing oHosts = Nothing sResponse = oResponse.Text Catch ex As Exception sResponse = sResponse & "|" & ex.Message & vbCrLf & vbCrLf & ex.StackTrace & vbCrLf & vbCrLf & ex.Source Finally oHost = Nothing oHosts = Nothing oResponse = Nothing End Try Return sResponse End Function Public Sub New () End Sub End Class Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 12
    - components of "All" value of bitwise enumeration as comma-separated string? Say I have a bitwise enumeration like this: [FlagsAttribute] public enum MyEnum { None = 0, Blue = 1, Red = 2, Yellow = 4, All = Blue | Red | Yellow } and I set: string myString = (MyEnum.All).ToString(); In debug I find that myString is set to "All". According to everything I have read, I was expecting it to be set to "Blue,Red,Yellow". Certainly, if I set: string myString = (MyEnum.Blue | MyEnum.Red | MyEnum.Yellow).ToString(); then in debug myString is set to "Blue,Red,Yellow". Is there a way to get the components of an "All" value as a comma-separated string I've tried to find an existing answer to this, but since it's difficult to summarise in one line, I have had no luck - sorry. I'd be very grateful for any help anyone can offer. Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 13
    - How do I handle this exception - where is it coming from? I am using remoting to perform some long runnign calculations. In order for the gui to stay responsive, I'm using threading as per the following example (simplified). try { Thread t = new Thread ( new System.Threading. ParameterizedThreadStart (calculator.Calculate)); //calculator is a remote object. t.Start(model); t.Join(); } catch ( Exception ex) { _log.Error(ex); } finally { _log.Debug( "asfd" ); } I have set a the timeout on the Tcpchannel to 10 seconds. In the event that the calculation takes longer than 10 seconds, I get the following exception. Trouble is, it's not caught by the above exceptoin handler. And the finally clause never gets executed. In desparation I tried adding the following handlers: Application .ThreadException += new ThreadExceptionEventHandler (Application_ThreadException); AppDomain .CurrentDomain.UnhandledException += new UnhandledExceptionEventHandler (CurrentDomain_UnhandledException); thread exception handerl never gets called. The UnhandledExceptionEventHandler does, and that;s whre I'm doing the logging. But IsTerminating is set to true, and the whole app dies. HOW DO I TRAP AND HANDLE THIS EXCEPTION!!!! Thanks, JG 2007-08-27 09:27:01,247 [4] ERROR ModelForm.CurrentDomain_UnhandledException - Unhandled exception. System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond aft er a period of time, or established connection failed because connected host has failed to respond Server stack trace: at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags) at System.Runtime.Remoting.Channels.SocketStream.Read(Byte[] buffer, Int32 offset, Int32 size) at System.Runtime.Remoting.Channels.SocketHandler.ReadFromSocket(Byte[] buffer, Int32 offset, Int32 count) at System.Runtime.Remoting.Channels.SocketHandler.BufferMoreData() at System.Runtime.Remoting.Channels.SocketHandler.Read(Byte[] buffer, Int32 offset, Int32 count) at System.Runtime.Remoting.Channels.SocketHandler.ReadAndMatchFourBytes(Byte[] buffer) at System.Runtime.Remoting.Channels.Tcp.TcpSocketHandler.ReadVersionAndOperation(UInt16& operation) at System.Runtime.Remoting.Channels.Tcp.TcpClientSocketHandler.ReadHeaders() at System.Runtime.Remoting.Channels.Tcp.TcpClientTransportSink.ProcessMessage(IMessage msg, ITransportHeaders request Headers, Stream requestStream, ITransportHeaders& responseHeaders, Stream& responseStream) at System.Runtime.Remoting.Channels.BinaryClientFormatterSink.SyncProcessMessage(IMessage msg) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at StrongMan.Calculators.ICalculator.Calculate(Object o) at System.Threading.ThreadHelper.ThreadStart_Context(Object state) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart(Object obj) Unhandled Exception: System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond Server stack trace: at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags) at System.Runtime.Remoting.Channels.SocketStream.Read(Byte[] buffer, Int32 offset, Int32 size) at System.Runtime.Remoting.Channels.SocketHandler.ReadFromSocket(Byte[] buffer, Int32 offset, Int32 count) at System.Runtime.Remoting.Channels.SocketHandler.BufferMoreData() at System.Runtime.Remoting.Channels.SocketHandler.Read(Byte[] buffer, Int32 offset, Int32 count) at System.Runtime.Remoting.Channels.SocketHandler.ReadAndMatchFourBytes(Byte[] buffer) at System.Runtime.Remoting.Channels.Tcp.TcpSocketHandler.ReadVersionAndOperation(UInt16& operation) at System.Runtime.Remoting.Channels.Tcp.TcpClientSocketHandler.ReadHeaders() at System.Runtime.Remoting.Channels.Tcp.TcpClientTransportSink.ProcessMessage(IMessage msg, ITransportHeaders request Headers, Stream requestStream, ITransportHeaders& responseHeaders, Stream& responseStream) at System.Runtime.Remoting.Channels.BinaryClientFormatterSink.SyncProcessMessage(IMessage msg) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at StrongMan.Calculators.ICalculator.Calculate(Object o) at System.Threading.ThreadHelper.ThreadStart_Context(Object state) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart(Object obj) Press any key to continue . . . Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 14
    - Late Binding (plugin base) Hello there, I'm trying to write my own 'plugin base' (a class which can be imported and be used to load plugins, and perform actions on them). First of all, here is my code to load the plugin (dll file selected in an OpenFileDialog): Code Block Public Function loadPlugin(ByVal filename As String) As Boolean Dim isValidPlugin As Boolean = False If My.Computer.FileSystem.FileExists(filename) Then Dim oAssembly As Reflection.Assembly = Reflection.Assembly.LoadFrom(filename) For Each type As System.Type In oAssembly.GetTypes If type.Name = Global.iPlugin.plugins.entry Then isValidPlugin = True End If Next If isValidPlugin Then Dim oType As System.Type = oAssembly.GetType(oAssembly.GetName.Name & "." & Global.iPlugin.plugins.entry) Dim plugin As iPlugin = Activator.CreateInstance(oType) For Each plug As iPlugin In Me.plugins If plug.info.filename = plugin.info.filename Then MsgBox("Plugin already loaded") Return Nothing End If Next plugin.init() Me.plugins.Add(plugin) AddHandler plugin.statusChanged, AddressOf Me.plugin_statusChanged oAssembly = Nothing oType = Nothing plugin = Nothing Return True Else MsgBox("File '" & filename & "' is not a valid plugin") oAssembly = Nothing Return False End If Else MsgBox("Could not find file '" & filename & "'") Return False End If End Function This is my interface: Code Block Public Interface iPlugin Structure pluginInfo Dim filename As String Dim name As String Dim version As String Dim company As String Dim developer As String Dim description As String Dim website As String Dim email As String Dim status As pluginStatus Dim statusString As String Dim icon As System.Drawing.Icon Dim image As System.Drawing.Bitmap End Structure Enum pluginStatus PLUGIN_RUNNING = 1 PLUGIN_PAUSED = 3 PLUGIN_STOPPED = 2 PLUGIN_INITIALIZING = 0 PLUGIN_IDLE = -1 End Enum Structure pluginCommand Dim name As String Dim description As String Sub execCmd(ByVal args() As Object) RaiseEvent exec(args) End Sub Event exec(ByVal args() As Object) End Structure ReadOnly Property info() As pluginInfo Sub init() Sub dispose() Sub pause() Sub unpause() ReadOnly Property status() As pluginStatus ReadOnly Property menuItem() As System.Windows.Forms.ToolStripMenuItem ReadOnly Property commands() As List(Of pluginCommand) Event statusChanged(ByVal plugin As iPlugin, ByVal newStatus As pluginStatus) End Interface Now here is my problem: I was testing my plugin base, and I noticed that after I FIRST try to load a non-valid plugin, I can't load any valid plugin file afterwards anymore. Instead, it throws me an error like this Translation: Can't convert an object of type CLASS.entry to type iPlugin.iPlugin But when I first load a valid plugin, then a non-valid one, and then again a valid one, everything works well Any help here would be appreciated !! Grtz, Tom. Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 15
    - RegEx for numeber with/without decimal part Hello, Can anyone tell what's wrong with this regex \d{1,2},\d | \d{1,2} I want to write number with 1 or 2 digit with o without decimal part, the decimal part only with one digit, for example: 1,1 22,1 1 22 Also I tried with: ^\d{1,2},\d{1}$ | ^\d{1,2}$ ^\d{1,2} | (,\d{1})$ Please help!!! Cyntia Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development
  - 16
    - colon Hi gurus I am new to c# or dot net i am having n xi interface which sends a soap msg to the webservice ( genrated by dot net ) . this soap message has a "ab1:" which is not accepted by the webservice and the receiption is failed . i would like to eliminate the "ab1:" from the soapmessage "ab1:acknowledgementsbase x mlns:ab1 = " urn:xxxxx.com/xi/utils.acknowledgements" Please advice on this its a burning issue right in my company thanks Tag: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event .NET Development

furmangg

I'm using an SqlDependency so I'll get an alert when the data under a query changes. When the query does not meet the criteria spelled out here http://msdn2.microsoft.com/en-us/library/aewzkxxh.aspx then I immediately get a SqlNotificationEventArgs event with the "Invalid" note. This is good.

I would like to know that a query is invalid before I try it with my ASP.NET application. Is there a sproc I can give to my SQL developers so they can test that they haven't used any stuff that would invalidate SqlDependency What I'm hoping is that there's already a system sproc which could be called...

exec sp_QueryInvalidForNotification "exec myTestSproc 99"

Does such a sproc exist Or does anyone know how to write one

Top

Re: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event

Peter Gvozdjak - MSFT

Moving to the .NET Framework Data Access and Storage forum since this uses managed code.

Top

Re: .NET Framework Data Access and Storage sproc to determine if query will produce Invalid SqlNotificationEventArgs event

furmangg

I disagree with your assessment of the topic of this question. I'm asking for a SQL Server stored proc related to query notifications and service broker. I should have posted this in the Service Broker forum... and now I've done that:

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1201846&SiteID=1&mode=1

Feel free to delete this thread.

Top