Jessica Alba's Q&A profile

• SQL Server Execute "Select" depending on the input parameters

  Hello, a question please. Could anyone say me if I can create a store procedure with 2 'select's statements into. Besides, I'd want to know if I can execute a "select" depending on input parameters. Something like this: create storeproc Param1, param2 if param1 <> null Select * from table where id = param1 else Select * from table where id = param2 end if Thanks in advance.... ...Show All

• SQL Server Is "MARS" Supported

  Does the Compact edition support the MARS feature (multiple active result sets) of SQL Server 2005 To be fair, MARS support was added in SQL Server Mobile 3.0. Unless you are using a previous version, it is very much supported. The difference from SQL Server here is that there is no flag that you need to set to turn this feature on/off. It is always 'on'. As mentioned above, batched sql queries are not supported. ...Show All

• Visual Studio 2008 (Pre-release) video example not working

  public Scene1() { this.InitializeComponent(); MediaPlayer player = new MediaPlayer(); player.Open(new Uri("pack://application:,,/rock.wmv")); VideoDrawing aVideoDrawing = new VideoDrawing(); aVideoDrawing.Rect = new Rect(100, 100, 100, 100); aVideoDrawing.Player = player; player.Play(); I took this from the msdn page but changed the Uri as I had added a .wmv to the project. All I get is a blank screen. Any help would be great - thanks thx Guilaume but that is not the solution as I have mp11 installed and if I use mediaelement inside the xaml instead of using c# then it works fine but not with the code as it stands. any other ideas would be appreciated - thanks ...Show All

• SQL Server sql login

  I am just learning Sql 2000. I need to give access specific databases on a server to new users. When I right click on the database to create a new users,in Enterprise manager, only the server I am on shows up. The new users are not yet in the server. The dropdown doesn't give me access to browse to a company server that users are on. Am I missing something How can I give users access when I can't find the company server Please help. Ok. Just found out why I can't see the users on the company server. The Sql Server is not on a domain. So, how do I grant access to the database to users or a group ...Show All

• SQL Server Where are the SQL Management tools???

  I just finished installing SQL Server 2005 Developer Beta 2. There are no menu items for the manager or any thing else. Where are these things installed.  How do I access them There is a known issue with the interaction of Tools installed with Developer (Beta/CTP) Edition and Express. If you edinstall Express first the only way you can install the tools with Developer is to first uninstall the tools Express installed - note that if you install Express through VS it does a full Express installation.   Working around the Tools.msi issues with SQL Server Express: Scenario 1: Install VS w/ Express First 1) Install VS with Express 2) Go to Add/Remove Programs and remove "SQL Server Tools Express" 3) Install SQL Server Beta ...Show All

• Windows Forms How to show a default text when no rows is bounded in a grid?

  Hi All, I have bounded a grid with some data. Now i need to show a text "No items bounded" when the grid doesn't have any rows to bind in it. I have tried this coding.... in VS 2005 grid_RowDataBound if (grid.Rows.Count == 0) { lblStatus.Text = "No items found" ; } But this is not working.... Can anyone help me Regards, Cbe Hi, Cbe By default, when you bind a DataGridView to a dataset like or datatable like datasource, and allow user to add new row, the row counting of the DataGridView would contain a "New Row", so when no items bound, the count is 1 instead of 0. You can count the rows in the datasource instead of the DataGridView. Reg ...Show All

• SQL Server Need help in starting out

  Hi Everyone: I am just starting out on SSIS, and have the following business challenge that I would like to solve utilizing SSIS. There are two SQL Server data stores, one would be the source, and other would be the destination. I need to grab some data from store 1, and insert that data into store 2. Here are my questions: 1) Before i move the data to store 2, i have to check some criterias by callin some sps, and then the end result would need to be inserted into the destination database. Can anyone tell me how would i setup the control flow, to accomodate that in SSIS 2) Can someone email me a sample package that does something similar I just need a starting point so i can build the design of my package. Basically i need to ...Show All

• SQL Server How to use information from a dimension in a calculated member

  It would be really useful to be able to extract information from an Analysis Services 2005 dimension such as:- "The number of seconds in the current time dimension member". This will enable calculated members such as the following to compute a process percent operation time. Member = [Measures].[Sum of seconds the process was operating] / "No of seconds in the current time dimension member" (eg.Day, Week, Month etc.) How can I get this information from the dimension for use in a calculated member Many thanks Hi Deepak, Thanks for the reply - I can now extract the shift length successfully, it was a ShiftID level problem!. Would you have an answer to my earlier ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. . TRIDEX .VB.NET XNA update#9 Camera Pick component.......

  hi guys just coded a camera picker component for the VB.net people.... Wow I luv components http://www.tridexconsultants.co.uk/pages/DirectxClasses.htm or direct file http://www.tridexconsultants.co.uk/pages/downloads/XNA%20VB.NET.zip ..Tridex ..... Hey Tridex, can you make sure you mark your announcements as comments so they don't show up as unanswered questions. Also since you are making a lot of updates , maybe you can just edit the post each time, or add a response to reduce the number of posts in the forum. ...Show All

• SQL Server Excel Destination Error: Column"xx" cannot convert between unicode and non-unicode string data types

  Good afternoon Trying out the Excel Destination in SSIS, I ran into the above error. I did try to ignore my 2 varchar fields and then it works fine. Thanks for any inputs. I'm jumping into this thread rather late, but I've had an experience with this problem that might be helpful to others. I've been trying to dump SQL query results into an EXCEL spreadsheet using SSIS, and that's when I first got this error message. After reading through the entries in this thread (and several others), I thought that the most direct method would be to edit the SQL Task that contained the query so that it would convert all of the columns I was returning to NVARCHAR. However, that didn't work, which was really frustrating. ...Show All

• Software Development for Windows Vista Just want to use a signature pad from my C# app - do i need tablet sdk ?

  I want to capture signatures and other handwritting as images and do this from a signature pad while using my C# application. Do I need the tablet sdk Hi Dom, the references to 'SelfRegModules' might be a red herring. My guess is that the problem is elsewhere. Are you using an InkPicture control in your app Thanks, Stefan Wick ...Show All

• Visual Studio Team System No appropriate mapping exists for - during baseless merge

  Please help - I'm baffled. I'm doing a tfs merge /baseless <source> <destination> /recursive No matter which direction I attempt to go (switching the source and destination) the destination path keeps getting a return stating: No appropriate mapping exists for <destination path> I do have mappings for both - so I'm not sure what I'm missing here. Any suggestions Please try to specify a server path for the second path. If the two paths are in different workspaces, the merge may not be able to correctly determine the versions to integrate. The server path will be something like "$/TeamProject/Maint_1.51.0.2/". Cheers, Adam ...Show All

• Smart Device Development Activesync will not sync all contacts

  When I use activesync 4.2 to sync my t-mobile sda smartphone, very few of my contacts get synced. It looks like it only syncs my messenger contacts. Can anyone help Some details on my system. Running Windows XP, Activesync 4.2, Office 2003, MSN with outlook connector. This forum is smart device development related. Since your question is not related to smart device development, it's off topic here. Please post to relevant forum or news group: http://support.microsoft.com/newsgroups/default.aspx Closing as off topic. ...Show All

• Visual Studio 2008 (Pre-release) Speech Recognition from WMV

  Colleagues, how could I recognise speech from WMV file using .NET 3.0 Thanks in advance! -- Sincerely, Dmitry Alekseenko You could try this, although it's for WAV files only: http://blogs.msdn.com/robertbrown/archive/2005/07/20/440983.aspx http://blogs.msdn.com/robertbrown/archive/2005/08/04/447845.aspx The samples are based on WinFX Beta 1. ...Show All

• Visual C# problem with making query wich contains parameter

  I'm trying to make a program to manage my moviedatabase a little more user friendly. Now i'm trying to add a new query to the adapter with the paramater. But every time i do this i get this error saying error in WHERE clause near '@'. Cannot parse query text. This is my query: SELECT ID, MapPos, Naam, Soort, Kwaliteit, Genre FROM Films where Naam = @naam It adds the method but without the parameter. Can anyone please help me, or say what i must do exactly :/ Thanx in advance Thanx anyways ahmedilyas Very good to have people like you here one other question though , a bit more sql oriented but still.. if i want to use the like statement, how can i do that SELECT ID, MapPos, Naam, Soort, Kwal ...Show All