Szindbad2's Q&A profile

• Windows Forms Delete row and updating database through datadset

  Hi, I am using following code to bind the myControl (Some bindable control): DataSet dsTrims = new DataSet (); dsTrims = MyProvider.ExecuteDataSet(System.Data. CommandType .Text, strWhere); this .bindingdataSource1.DataSource = dsTrims.Tables[0]; myControl.DataSource = bindingdataSource1; All the data get visible to myControl when run the application. I can also update row into myControl and this update also tak ...Show All

• SQL Server Stored Procedure Problem - Couldn't find forum specifically for SP's

  Help me please. I have created a stored procedure and I'm not sure where I am missing the syntax problem. I am fairly new to SQL and have tried to research this problem and cannot find anything helpful. Basically I have to pick the results from the same tables but have a trigger of "hotel" and "not hotel" basically. I have to have one record return that pulls from two records in the same table. I think I have a major probl ...Show All

• SQL Server DDS- New Concdern

  Hi All, We want to use Data driven subscription, but dont want the report to be published in a physical drive but rather to be published in a report server folder (at the portal) anyw ays to achive this ...Show All

• SQL Server .NET Runtime Optimization error on SQL Server 2005

  I posted this on the .NET Framework inside Sql Server forum as well.  Sorry if the cross-post offends anybody. I upgraded my primary production server this morning to SQL 2005.  Everything went fairly smoothly, but a couple of hours after my installation was complete, I found the following error in my event log:   Source: .NET Runtime Optimization Service EventID: 1101 .NET Runtime Optimization Service (clr_optimiz ...Show All

• Windows Forms Odd exception...

  Stack: Message: The process cannot access the file 'SomeDll.dll' because it is being used by another process. Source : mscorlib System.IO.IOException: The process cannot access the file 'SomeDll.dll' because it is being used by another process. at System.IO.Directory.DeleteHelper(String fullPath, String userPath, Boolean recursive) at System.IO.Directory.Delete(String fullPath, String userPath, Boolean recursive) at System.Deployment.Applicat ...Show All

• SQL Server Measure Groups in AS2000

  Hi, I have a lot of CurrencyMeasures, > 80, and a would like to create something like a 'measuregroup' in AS2000. I e Euro, Dollar should be measuregroups that contain measures, i.e Group_Euro_InvoiceAmount, Group_Euro_TaxAmount. Do anyone have some ideas about this Hi, From my understanding, measure groups are related to a fact table. Therefore if all of your measures are coming from the same f ...Show All

• SQL Server SQL Server 2005, MS Access Merge Replication?

  Hey there! In a nutshell, I want to do a merge replication with a SQL Server and several Access databases. I haven't been able to find anything in the documentation or 3rd party books. Is this possible Thanks! - Erik What version of SQL Server are you using This feature has been deprecated in SQL Server 2005. Here is a pointer to the old documentation http://msdn.microsoft.com/library/def ...Show All

• .NET Development Who can solve this problem? Is there any genius?

  Hi all (genius people),                  I am getting a problem consuming a web service. Here is the scenario, I have a web application in vb.net 2005 (ASP.NET 2.0) and a web service made in c#.net 2003. I have deployed the web service well. It can be accessed through browser. Even I can successfully add its web reference in my web application. After deploying ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DirectX10 only on Vista?

  I've searched everywhere but all I can find is rumors, rumors and even more rumors. Will the final version of directX 10 run on windows XP "I've searched everywhere but all I can find is rumors, rumors and even more rumors. Will the final version of directX 10 run on windows XP " As far as I am aware. Direct3D10 wont run on Windows XP. Direct3D10 will only run on Vista. Also as ...Show All

• .NET Development Why it is .NET?

  Could anybody explain why MS named the new Technology as .NET and added the .NET to all the VS component like VC++.NET,VB.NET,ADO.NET .... Regards Shaji Kumar.V.K It's just a marketing term to reflect the ethos of the platform. The early beta books I got for asp.net referred to asp NG, which stood for asp next generation. Microsoft marketing changed this to .net, and then added it across the platform. Unfortunately IMHO, they badly confused ...Show All

• .NET Development sqlexception on null insert, but db has default value set on columns

  this should be dead easy but has got me pulling my hair out. i've dragged and dropped a table from my dataset onto my form to create a total RAD details view data entry form. so far so simple. the sql server table on the db isnt allowing nulls, but i've set defaults for all the columns, yet when i try and save a new row from my form im getting a sqlexception terminating the insert due to nulls not being allowed. why arent the defaults bein ...Show All

• .NET Development ORA-12154 error when connection to Oracle Database from C#

  I'm trying to connect to an Oracle Database 9.0.2 using OracleClient in C#. I get the error "ORA-12154 Could not resolve service name" when trying to connect to the database. I've checked the TNSNAMES.ora file an it seems ok. The project where I get this error was previously a .VS 2003 project which I converted to a VS 2005 project. As a test I created a small project in VS 2005 where I connected to the same Oracle database with ...Show All

• SQL Server sql server agent job execution of a package failed

  Hi, when I try to run a package as Job I receive the following error Executed as user: SITA\sqlserveragent_svc. The package execution failed. The step failed. Has someone an idea how I can get more detailed information about WHY the job failed Tha package was created in BIDS and imported into MSDB. Running the package from the Integration Services context menu works, but starting it as a job from SQL Server Agent fails. Any idea or ...Show All

• .NET Development prevent header being added in xml file

  Hi, I get errors reading an xml file with my MDA, and its because of this header in the xml file: < xml version="1.0" standalone="yes" > How can i remove it and make sure that its not comming back Manually removal didn't work. After appending from xml file to xml file, its being added again. Can anybody help me with this issue What you'll want to do is create your own XmlTextWri ...Show All

• Visual Basic add item in String() in VB .net

  Hi guys! If a have for example Dim myList As String() and inside my program I want to add items to this variable how can I do this Thanks! Hi, cgraus is right, the collection or array list is the way to go. if you have code that already uses the array though, this could be the approach you need:   Dim myStrings() As String     Dim myStringElements As Integer = 0     Priva ...Show All