Ahmed_khemiri's Q&A profile

• SQL Server SQL Low performance

  Dears, I am connection to SQL SERVER 2005 using an ODBC connection through ASP. I have a database with about 2 million records. When I run a huge query from a client all other clients can not work during mentioned huge query return results. Sometimes the time will goes far an all other connections will drop due to Time Out problem. Any suggestion Check indexes first. If you do a serach in a data or join tables and do not have proper indexes on a joined/searched fields, it will work very slow. Also check if your query locks records. If it does, it is also possible that other users will not be able to ...Show All

• Visual Studio How to insert a watermark in crystal reports

    Hi all, I m still not finding a way to insert a watermark into the detail section of a crytal report.   answer asap. thanks... Vishal.   ...Show All

• Visual Studio Team System Checking the number of elseif statements in a loop

  Hi All Can any 1 help me. I want to write a rule to check the number of elseif conditions in a if statement.  Can any one write to me if it possible to write this type of rule and if it is possible then how to go ahead with this. Thanks Biswa FxCop can (currently) only scan compiled assemblies (DLLs and EXEs).  All source-level branching commands (if, elseif, etc) turn into general-purpose CIL commands (brfalse, blt, etc)... the same CIL instructions can be generated a variety of ways, so you can never really be sure what was originally there. -Ryan / Kardax ...Show All

• Visual Basic Backgroundworker and Timer

  Happy Coding in 2006, Everyone! Can I set a Backgroundworker to do work in a certain time interval, like timer_tick event Thanks. Hi, No, the backgroundworker is written just to run code in the background, and that's it. If you want some sort of timer functionality, you really want to use...a timer :) You could emulate it (but it wouldn't be precise) by writing a loop into your backgroundworkers code like this: Do   Thread.Sleep(some timer period)   DoMyRealWork() Loop But it wouldn't be very good for precise timings. ...Show All

• Windows Forms datagrid / variable problem

  Please bear with me, I'm new to this, so I'm sure there may be a better way to do this. But with my limited knowledge, its the only way I can think of doing it. I have a hidden datagrid which selects the data out of a sqlserver database. It will have multiple rows (up to 10). I need to be able to read the data in and populate it into text boxes on the web page for the user to be able to modify (but not write it back to the database, it will be written to a text file to be used later). I am able to populate the text boxes easily when there is only one row of data, but with multiple rows, I can't figure out how to populate each of the text ...Show All

• Visual Studio Tools for Office Error on Visual Studio Tools for Office "v3" install

  Hi everyone!!! I was really excited with the release of the "v3" June CTP, and i directly go to download it, follow the instructions and then an error raised saying this: "Error 1937.An error occurred during the installation of assembly 'Microsoft.VisualStudio.Tools.Applications.Contract,Version="8.0.0.0",PublicKeyToken="b03f5f7f11d50a3a",Culture="neutral",FileVersion="8.0.50727.146",ProcessorArchitecture="MSIL"'. The signature or catalog could not be verified or is not valid. HRESULT: 0x80131045. " Well, I think: "Maybe the in the download something goes wro ...Show All

• Visual Studio Team System Representing external non-WSDL Web Services in the AD ? ADAM Servers as a external DB?

  I'm currently trying to architect a distributed systems diagram. I am using Microsoft's DSfW as well as an ADAM server. However, there appears to be no ability for me to represent these in my application diagram. DSfW generates no WSDL so I cannot add it as an External Web Service. ADSI is not represented as a data provider so I cannot make the ADAM server an external database. Do these exist yet and how can I grab/import them into the App Designer Hello There are many types of external services that don't have specific shapes or endpoints for the application designer. However you can use a GenericApplication shape along with a Gene ...Show All

• .NET Development Best option for persisting DataSet changes?

  I've seen examples where dataset changes can be persisted in different ways. Any logical advantage of using one over the others Option1 (Not specific) --------------------------------- if(myDS.HasChanges){    tableAdapter.Update(myDS); } Option2  (specific to a table) --------------------------------------- if(myDS.HasChanges){    tableAdapter.Update(myDS.CustomerTable); } Option3 (making a copy of just the changes) ------------------------------------------------------------ if(myDS.HasChanges){   DataSet dataSetChanged = myDS.GetChanges(DataRowState.Modified);   if( !dataSetChanged.HasErrors  ...Show All

• Visual Studio Team System How do I list the changes between one label and another?

  I applied a label to the root folder of my Team Project ($\OSPACS) to mark the release v1.0 to my customer. A few months later I applied a further label to $\OSPACS to mark release v1.1. How can I obtain a list of the files that have changed between the two versions It seems that the only way I can do this is to copy v1.1 into my workspace ('Get a Specific Version' ), select each file in the Solution in turn and then compare it with the version in the repository that has been labeled v1.0; a very long and boring process! Does anyone know of any tool that can make this sort of task easier Is there a better way of doing this The old Visual D ...Show All

• SQL Server DATEDIFF in Report Builder

  I'm having a bit of trouble with the DATEDIFF function in my Report Model project and in Report Builder. I am trying to create a new Expression field that will work out a persons age from the current date and their Date of Birth, here is the formula that I have entered, DATEDIFF("y", NOW(), DOB) where DOB is the field that holds the persons date of birth in the database. When I enter this into the formula box and click OK i get the following error, "Operation is not valid due to the current state of the object." The detailed error text is Program Location:    at Microsoft.ReportingServices.Modeling.Expression.GetResultType() ...Show All

• Visual Studio Express Editions Does .NET Express Edition Support Sqlserver 2000?

  Hi, Does .NET Express edition support sql server 2000 I am new to .net 2005, I want to learn Visual Basic Express Edition 2005.... Where I can start with....... Does anyone have simple a to z example or article or website to start with ami The IDE will not connect through any of the wizards, but you should be able to connect using a current connection string and building the connections manually in code. ...Show All

• SQL Server OLAP Data Distribution

  Hi Guys, I'm having a bottleneck with my RAM due to large OLAP data. Disregarding additional memory, I want to distribute the OLAP data to different disk so that Disk que will be distributed, in these way it can lessen the bottleneck. Is there a way to do this thanks... For AS2K you can move the data folder to a different drive and folder - but everything must be contained underneath that same folder. For AS2K5 you can also move the data folder, but it also allows you to specify a different device and folder per partition, measure group, or cube. All of the metadata files must sit under the data f ...Show All

• Visual Studio Tools for Office Where is my cursor?

  I have developed and outlook add-in that contains a custom task pane hosting a windows form user control inside it. The user control had a textbox and a button. The button has an event handler attached to it. When the end user enter some text in the textbox while compposing a new email and click the button, I want to insert the text from textbox into the body section of the email. The problem is that how can I identify where my cursor is currently positioned As I want to insert text at cursor position, is there any way to find out solution to this problem Any help will be appreciated. I hope you have some s ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Exporting .X with Maya

  Hi all, I'm having some issues exporting geometry from Maya 6.5 with the sdk plugin, and was wondering if perhaps there was something wrong with the mesh's topology. What exactly can and can't be exported I assume that a mesh must be triangulated, but does it need to be continuous (no holes), and what is the limit to the number of materials that can be applied If you'd like to see what I'm talking about, or try to export it yourself, the .mb of the mesh in question can be found at: robmeridy.com/mesh.mb Thanks in advance, Rob Meridy Your observations are correct about the model. We will look at the model t ...Show All

• Windows Forms FindControl.

  Hi everyone, Does anyone know what would be the similar of FindControl method from Web library to from Windows.Forms library I need to get what controls do I have inside a panel, like TextBox, etc. Thanks in advancing. Doria Hi Doria, I see that you want change the value of a property. I use the following code to do this: PropertyDescriptorCollection props; PropertyDescriptor propParent; QPictureBackGround mp_object = new QPictureBackGround(); props = TypeDescriptor.GetProperties(mp_object); propParent = props["PropertyNameToChangeValue"]; propParent.SetValue(mp_object, NewValue); If you look the ...Show All