jsvonline.com's Q&A profile

• Visual Basic Error while inserting data in to sql server from vb.net 2003

  Hello, I have a problem while inserting data in to sql server from vb.net. the code given below works perfectly but when i try to insert string with single quotes it is not working properly. Ex. string: 'This is a sample question' myCommand = New SqlCommand("Insert into " & TableName() & " (Questions,Option1,Option2" & _ ",Option3,Option4,CorrectAnswer,LODType) values ('" & strQuestion & "','" & strOption1 & _ "','" & strOption2 & "','" & strOption3 & "','" & strOption4 & "','" & strCAns & "','" & strLODType & "')", conn) I think the problem in the insert qu ...Show All

• Software Development for Windows Vista Retrieve the property value of an activity Of Workflow Instance

  I need to retrieve the property value of an activity inside a running workflow (while the workflow is still running) from an asp page.   I was browsing the forum and got to know taht it can be done by using SQLTracking service, and SqlTrackingQuery.   Can someone please provide code example of retrieving data from tracking database based on a GUID workflowInstanceID   I am using .net Framework 3.0.   Thanks much in advance. Hi sam - you are right, you can use tracking for retrieving activity data from a running workflow. You should use UserTrackPoints and Activity.TrackData method to accomplish your need. For example, please look at Technologies > Tracking ...Show All

• SQL Server OLE DB Source Adapter & variables.

  Hi All, Using a data access mode of SQL Command, I have a stmt that returns one date ( e.g select max(LastChangedDate) from TblA ). I want to store the result in a variable. How do I do this Cheers, Tamim. Tamim Sadikali wrote: "I intend executing each of them in parallel, which I can only do within the Data Flow" -- Why You could use multiple SQL tasks. What would be wrong with that So multiple unconnected Execute SQL Tasks would be processed in parallel Yes, the should run in parallel (hardward permit). A single processor, litle memory, etc may make harder to see such parallelism. Tamim Sadikali wrote: I firstly establish when data was last flowed down, into each ...Show All

• .NET Development XmlSerializer on properties and indexers ... how do they work?

  I have to use XmlSerializer to serialize a class and I've found big problems serializing properties and indexers. I assumed that if you serialize a class with public properties (or an indexers) containing a field, even private, the serialization process would serialize that field too assuming it is needed to that public property. This is not the case ... For example I want to serialize the following class: [Serializable] public class Test { readonly int[] a; // same results with private readonly int b; // same results with private public Test(int[] v1, int b) { a = v1; b = v2; } public Test() : this(new int[] {10, 10}, 50) { } public int this[int i] { get { return a[ i ]; } set { a[ i ] = value; } } pub ...Show All

• Software Development for Windows Vista Creating a timer event

  I am trying a create a timer event in my sharepoint sequential workflow. I am using EventScopeActivity and have one Sequencial Activity and one delay activity. On the delay activity, if the sequential activity is not complete, i need to execute some code once a day. I do not seem to get the Delay activity to work. Any help will be appreciated. Atul, Were you able to figure out this problem I'm having exactly the same issue with delay activity within a listen activity in WSS 3.0 sequential workflow. Much appreciate any help. (fix or workaround) Thanks ...Show All

• SQL Server How to check whether SSIS is installed

  I'm using the import wizard to create a new table from a flat file source.  The table gets created but no data gets copied.  What's wrong   Here's the report: Operation stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection (Success) - Validating (Error)         Messages         * Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source - inSsrc_txt" (1).          (SQL Server Import and Export Wizard)      ...Show All

• SQL Server searching date range

  i have a date field with which i'd like to search several date ranges. the date field is populated as month, day, year (2/23/2007). I'd like to select date using the following criteria: < 30 days (i.e. select * from date where today's date < 30) 30 - 60 days (i.e. select * from date where today's date >= 30 and <= 60) > 90 days (i.e. select * from date where today's date < 90) Is there a simple way of acheiving this Thanks! Kubmg: What follows is dependent on the target field being a datetime column: select * from dataTable where theDate < getdate() - 30 select * from dataTable where theDate >= getdate() - 60   and theDate <  getdate() - 3 ...Show All

• Visual FoxPro crosstab wizard

  hello everybody I use vfp 6.0. Can i select fields from multiple tables in crosstab wizard's  Step No. 1 We can select fields from multiple tables in query wizard. thanx' I don't know what crosstab wizard does (I don't use wizards). But thinking it asks for an alias as you describe answer is yes. Create your cursor before wizard using an SQL querying multiple tables if it doesn't let you do that in wizard. ...Show All

• SQL Server Error when attempting to use Windows Authentication

  When attempting to use windows Authentication for the data source. I get the error below. I can run the report from the report server, but when running from another machine over the intranet the error occurs. An error has occurred during report processing. Cannot create a connection to data source 'MyDataSource'. For more information about this error navigate to the report server on the local server machine, or enable remote errors John, Reporting Services relies on the authentication capabilities of the underlying network. So, RS does not authenticate users itself. Have a look at the roles and the Browser role in particular. See which users have been assigned to this role. It's possible there aren't ...Show All

• Visual Studio 2008 (Pre-release) One Endpoint with Multiple Addresses on Same Port

  Is it possible to create a single endpoint with multiple addresses For example, I'd like to create a Web service and be able to access it with http://localhost:8000 http://127.0.0.1:8000 http://machine-dns-name:8000 If you try to open a ServiceHost specifying one of these as the base address and the others as alternate addresses, it immediately fails. Enable port-sharing doesn't seem to fix it. Thanks, \Steven Hi. First, I incorrectly mentioned http when I really use net.tcp. Second, respectfully, if you're suggesting that "it just works", well, it doesn't. For example, I can register the ServiceHost instance with any one of the above addresses, net.tcp://dns-name:8000/ for ex ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Microsoft's future policy for redistributing Xbox 360 games?

  Before I commit serious time and effort to the XNA framework, I'm wondering if anyone knows Microsoft plans for allowing us to redistribute our games for Xbox360. I'm an academic. Let's say I want to make some educational/simulation games that my students can use on the Xbox 360. Will I be able to provide them with a CD or download link in XBox live As far as I can tell so far, the only games I can write are for myself. r2d2-proton wrote: We'll all use the same API's and have access to the same distribution channels. Not really. The publishers that the industry companies use aren't usually going to distribute indies games. ...Show All

• Visual Basic how to compile a .dll into my .exe file?

  My code calls functions provided in an io.dll file. The problem is when I pass my exe file to others, I need to send this io.dll to them and ask them to put that in the same directory of .exe file. Is there any way I can compile this .dll file into my code so that only one file is necessary to pass around Thanks. Have you considered using a setup project (or Click Once publishing) to install your app & dll Then, all your user needs to do is double-click your setup (or click a link on a web page) to get everything where it needs to go. --Matt--* ...Show All

• Internet Explorer Development IHTMLDocument3::getElementById not returning an element

  Hi, I have written the following code to (supposedly) get an element inside a web browser object: bool CWebBrowser2::getElementById(CStringW& szId, IHTMLElement **pElem) { CComPtr<IDispatch> pDisp = (IDispatch*)GetDocument(); CComPtr<IHTMLDocument3> pDoc; HRESULT hr = pDisp->QueryInterface(IID_IHTMLDocument3, ( void **)&pDoc); if (SUCCEEDED(hr)) { hr = pDoc->getElementById(CComBSTR(szId), pElem); return ( bool )(SUCCEEDED(hr)); } } Unfortunately, the value of pElem is always returned as 0. I call the function with the szId following code: CComPtr<IHTMLElement> pElem; if (getElementById(CStringW(L"artistname"), &pElem)) { ...Show All

• Visual C# testing for an unitialized, or null, object

  I use "if (myobjref == null)" and "if ((myobjref is myobj) == false)" with the same result, ie neither return 'true' if myobjref is not initialized. What am I doing wrong The use of is is used to determine if a valid object is a typeof a specified object and allow for the code to handle posilble failures gracefully. 1 If an objects type is unknown, simply casting the object to the wrong type can cause a runtime exception to be thrown. So use of the is functionality can aviod that. The testing of null is a generic way to tell if an object's reference is valid. 2 For example class MyClass {     int a;     int b; } class OtherClass ...Show All

• Visual Studio Little trick: Run solution in Exp hive via 'Send To' menu

  Hi, Maybe this trick will help you to save time... Create a shortcut in C:\Documents and Settings\<your_account>\SendTo\ directory and set "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\devenv.exe" /rootsuffix Exp as a location of item. That's all - now you can Send any .sln file To be opened with devenv in Exp hive! Thank you, Carl! But your reply is not an answer because there is no question posted...   So I 've unmarked it. ...Show All