NoEgo's Q&A profile
.NET Development Exception Details.
System.Data.OleDb.OleDbException: No value given for one or more required parameters. This is the trouble ~ But i don't know how solve it :P The code follow's down: public void bindDataGrid( string ProductId) { OleDbConnection myConn = new OleDbConnection (); OleDbDataAdapter myOleDbDataAdapter = new OleDbDataAdapter (); string sqlStr, connStr; DataSet myDataSet = new DataSet (); connStr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source=C:/Inetpub/wwwroot/csharp2005/Products.mdb" ; sqlStr = "SELECT ProductId, ProductName, Price FROM Products WHERE Price > 40 ORDER BY Price" + ProductId; myConn = new OleDbConnection (connStr); myConn.Open(); myOl ...Show All
SQL Server Hide some columns in Matrix but not in subtotal
Hi all, I would like a matrix that look like this: 2006/01 2006/02 2006/03 Total % % % % Amount Amount Class. BU1 98,82% 78,53% 88,12% 88,49% € 217.763.099,50 € 207.328.766,75 BU2 64,98% 32,53% 92,19% 63,23% 5.093.781.522,65 € € 287.731.766,75 BU3 74,71% 45,78% 78,69% 66,39% € 847.871.349,50 € 819.123.124,75 I want detailed subtotals but I don't want the "Amount" and "Amount Class." values in the details of my Matrix. I've not found other w ...Show All
.NET Development Trying to get a simple .Open() to work
This is a newbie question, sorry if it's been answered a million times before. I have googled this extensively and haven't found anything that is making ANY difference, and have already spent 3 solid days trying everything under the sun. I am using MS Visual C# 2005 and SQL 2005 Mobile. Both running on local PC. I am running as administrator on this machine. All protocols enabled in SQL services, also under SQL Native client configuration. I am able to use the wizards in MS VC# to access the SQL database and create datasets, they are able to access the SQL server. Under Surface Area config, Local and Remote connections is checked, using both TCP/IP & Named Pipes. The SQL database is set to 'Log on as built in account - local system'. ...Show All
Software Development for Windows Vista Question on an old 16-bit application
We have a legacy 16-bit application that we still support. It was originally designed for Windows 3.1 (remember that ) and its architecture requires a "feature" of 16-bit DLLs where different applications could share the memory space of a common DLL. In the example, the central admin.dll stores the state of the logged in user to the application. Other "modules" can then call that DLL and read and update the state. This has worked all the way up to Windows XP. As we know, in the 32-bit world, and the more secure world of application programming, we wouldn't want to allow different applications to "borrow" the memory space of a DLL, so each application gets its own instance of the DLL, but it seems there was ...Show All
Software Development for Windows Vista Run As Administrator in Vista
I have an application that requires Backup and Restore Privileges. The application enables these privileges and works find in XP but, when executed normally as an Administrator in Vista, the application fails. The Call to AdjustTokenPrivilege fails with ERROR_NOT_ALL_ASSIGNED. However, when I right click and run as administrator the call succeeds and the apps works. This brings me to my questions: 1. Why would an app not run with the privileges of the person that executes it (an administrator user in this case).... Vista Security 2. How can I work around this I would imagine there is a local security setting the I can change to allow the app to run with the privileges of the user I would be curious if this setting exists but, it ...Show All
SharePoint Products and Technologies Copy Item action behavior in with SharePoint Designer workflow
Hi, Using MOSS 2007 and SharePoint Designer. My source document library is a doc lib without folder; my target document library contains both doc items and folder items. I want to copy a document from the source doc lib to a folder within the target doc lib. I've built a workflow in SharePoint Designer(SPD), I used the Copy item action and it only allows me to specify a document library name for the target so the document end up in the main level of the target document library. I would like to copy the document within a folder of this target library; the folder name being based on an attribute value of the source document. Is it possible to achieve this with SPD Thanks in advance, Alain L. ...Show All
Visual C++ [VC++ 2005 SP1] IntelliSense stops working when using stdext::hash_map
After installing Service Pack 1 for Visual Studio 2005 I noticed that IntelliSense does not work in my project any more. I figured out that IntelliSense stops working when using the hash_map or hash_set template, located in the namespace stdext. Actually, QuickInfo still functions, but AutoCompletition refuses to operate completely, it is not available for any keyword in the project. When exchanging the IntelliSense DLL feacp.dll [14.00.50727.762 (SP.050727-7600)] installed by the service pack with the RTM version of this file [14.00.50727.42 (RTM.050727-4200)], i.e. the one that was installed before applying SP1, IntelliSense is working again like a charm! Conclusion: The IntellSense DLL feacp.dll delivered with SP1 is buggy! To ...Show All
Architecture Database Views and ORM?
Hello everyone, Perhaps someone can provide some direction for the problem that I face. We're building a standard web-based, 3-tier enterprise application using our own light-weight object-relational mapping layer. Serveral web pages have been identified for optimization in our system, as it has been shown that they recieve a lot of user traffic, and they all contain a fair number of complex gridviews. On each page-load, there is a lot of database contention as it pulls out the necessary data and builds the domain object graph. For example, a number of the gridviews display data from entities nested within other entities, which results in a lot of lazy-loading going on behind the scenes. I would like to optimize some of the grid views on t ...Show All
Windows Forms datarelation and dataview
Simple q regarding .net 2003 I got several tables A master and e few details/child tables add datarelations to it and bind it to controls... so far so good Now i wan't to filter/search the mastertable, Sound easy but when i use a dataview i lose sync with the detail/child tables Remco I am having the same problem. Hopefully the following example will help people understand what we're trying to do.... Consider you have a DataSet which is made up of Customer information and related Orders, that is, one dataset with 2 distinct tables, "Customers" and "Orders". We create a DataRelation object called "CustomersToOrder" on the dataset which link ...Show All
Visual Studio Express Editions how to modify a timer?
hi all, i found this simple timer on http://www.developer.com/lang/other/article.php/792901 5: using System; 6: using System.Timers; 7: 8: class myApp 9: { 10: public static void Main() 11: { 12: Timer myTimer = new Timer(); 13: myTimer.Elapsed += new ElapsedEventHandler( DisplayTimeEvent ); 14: myTimer.Interval = 1000; 15: myTimer.Start(); 16: 17: 18: 19: 20: 21: } 22: 23: pub ...Show All
.NET Development How to send the SMS using vb.net
Hello Friends i developing windows desktop application in vb.net for sending SMS through internet, but i have no idea about that. so plz help me for writing this code. Irshad Hi, well there is nothing directly to send SMS in .NET framework, so first of all you will need to contact a provider to get access to some components or webservices for using it to send, usually mobile provider companies has something, so ask mobile providers in your country. After that it will be just using that webservice or component. Anyway, for this kind of questions is better to go to the VB.NET development forums, where you will get lot of VB.NET help, as this forum is related only for Team System issu ...Show All
SQL Server buckets or quartile
Hi all, Dreaded moment has come:) I need to produce a report against MSAS 2005 with quartiles buckets, meaning that besides actual value of the measure, it needs to display following: Value 1st 2nd 3rd 4th X Min - Max Min - Max Min - Max Min - Max ------------------------------------------------------------------- 80 85 - 95 75 - 85 55 - 75 12 - 55 where 1st is range of values of top 25% performing entities and so forth. It's supposed to be sliceable by any hierarchy in the cube. I tried to use TopPercent 25%, but never could get it work in calculated member. Any idea, comment, reference highly appreciated. Thanks Extendong your example with emp ...Show All
Visual Studio Team System Importing existing tasks into the new Team Project
We just introduced Team System in our environment. Project just started but PM had about 50 tasks already created and assigned in MS Project. Can we import those tasks in out Team Project Here are the steps I took to get this done (not sure if they are the official steps, but it did work). It is still work in progress, but I am making progress. 1. Install Team Explorer. 2. Connect to your team's project. 3. Create a new task (Menu -> Team -> Add work Item -> Task ) 4. Select the task in the query results screen and then select View -> Open Selection in Microsoft Project. 5. Now that MS Project is now opened, also open your existing .mpp file. Ensure you have the Team Tool bar v ...Show All
Visual Studio Express Editions VB.NET or C++, Which is best?
I want to start learning C++ and I want to know the type of applications that it is best at making and whether or not it is better than VB. The queston is, what are you trying to achieve It's like asking what's best, a hammer or a screwriver Your task at hand usually determines which language you will use. Both languages can be used to program anything, generally. ...Show All
Microsoft ISV Community Center Forums Workbooks.Open (... problem
Hi all, I am trying to open a workbook in readonly mode. I have tried Workbooks.Open(WorkFN, 2, True) but this is asking to assign the result to a variable. i.e. it won't compile without an "=" sign. What am I doing wrong I just want to open the file, copy some stuff out of it, and then close it again. Fell at the first hurdle! Cheers, Steve. Hi Just lose your brackets and all should be well i.e. Workbooks.Open WorkFn, 2, True ...Show All
