jojobar's Q&A profile

• SQL Server protected sql database file

  how can I create sql database file and it cann't be use or open (open mean to design view or structure) . my case is: I have Acces db and this db has its own username and password, no body can read, write or view the designing, so it is useless. But there are somesoftware able to break and hacking db access. I think sql database file is more secure, so how can I do it Hi..... Thanks for your solution, there is a quetion plz. Can I Change the owner of the database I mean I will create the database by sa user, and I will add new user, can I make him the owner ...Show All

• SQL Server Loop Through Flat Files Based On A Date Range

  Hello, I currently have a For Each File container that loops through all files from a specific directory. The files have a naming convention that looks like this; CDNSC.CDNSC.SC00015.01012007 The last segment of the file name is the date of the data in the file (mmddyyyy). The create date for these files is always a day later than indicated in the file name. What I would like to do is to have more control over the 'range' of files that are looped through by using the date portion of the file name to define what group of files should be looped through. Ideally, I would like to have a 'StartDate' variable and an 'EndDate' variable that I could define at run time for the package, and the package would loop through all of the files ...Show All

• Visual Basic Help Adding Datagridview cell values and diplaying them in a total column

  Below is the code I am using to add Qty and UnitPrice I am then displaying the total in the Total column. The code below is working, however I only see the updated total value if I enter and exit the Total cell. Is there a better way to do what I am trying to accomplish or is there a way to force the total cell to refresh when changes are made to Qty or UnitPrice Private Sub DataGridView1_CellValidating(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellValidatingEventArgs) Handles DataGridView1.CellValidating Dim varQty As Integer Dim varPrice As Integer Dim varTotPrice As Integer varQty = CType(DataGridView1.Rows(e.RowIndex).Cells("QtyDataGridViewTextBoxColumn").Value, Integer) varPri ...Show All

• Visual Studio Express Editions Browser and Player

  Hi! first: i am new to this! so heres the problem: i want to build a browser with a music player! i thought the browser is on one tab and the player is on an other. so i realy would like to know how to do this! thx! your leo Thanx But the problem is that there is no url to point to. I have the media stored in my 'Resources' object. As in 'My.Resources.shortfilmloop' I am storing it in the resource object because i dont want to have any lag from loading it from disk. Any Ideas ...Show All

• Community Chat Generic Lists & the System.Predicate Delegate.

  I may be missing something here, however I am baffled at the signature of the predicate delegate as defined for the Find methods of the generic List in 2.0. Could somebody please enlighten me as to the lack of an additional parameter with which to pass in search criteria I would have at least expected this to be overloaded with the option for something like the following: System.Predicate(Of T)(obj As T, match As Object) As Boolean This would make more sense to me. For my own purposes I have felt the need to pre-load any search criteria for my List searches into a higher-scope variable prior to hitting Find with the restrictive signature. Thanks in advance for helping to clear this up for me. Regards, David Kennedy ...Show All

• Architecture Any good Ntier real world (architecture)examples available for download?

  Hi all, Everybody talks about designing a good architecture Talking between tiers in stateless manner avoid chatty objects use interfaces Use factory patterns etc etccc But no one has published or uploaded some generic examples of different architectures so that you can see how things really work.(A complete solution)with different projects in it. Just tired of reading theory and not seeing any examples. Am I wrong Could anybody point me in the right direction or do i have to reinvent the wheel If I have to it will probably be a square one Thanks and apologies for moaning. EntitySpaces Persistence Layer and Business Objects for Microsoft . NET 2.0 The EntitySpa ...Show All

• SQL Server SQL Server 2005 Express & Vista Installation

  Hi I have installed the Beta version for Windows Vista and installed VS 2005 for Software Developers which includes SQL Server Express. When installing the SQL Server express part compatibility issues appear. Do i need to install a fresh copy of SQL Server Express which inlcludes Service Pack 1 I cannot connect to any mdf file through the data connection section in the VS 2005 IDE. Cant remember the exact error message, something like "Cannot find the entry or starting point". I am running a fresh install off the latest Dotnetnuke starter kit and get a database compatibility error so my guess is this could also be as a result of SP 1 not being installed Any help or suggestions appreciated. Thanks ...Show All

• Silverlight (formerly WPF/E) Any one have samples of 3D text (the code), like the ones in Joe Stegman video?

  Any one have samples of 3D text (the code), like the ones in Joe Stegman video I would like to do something like this, but have no clue where to begin. thanks I'm working on figuring out the source for the 3d text, but it won't be until the new year. Using some of the 3d to 2d work that Flash developers do would be the start (like http://www.adobe.com/devnet/flash/articles/flash_3d.html ) Slyi - Regarding the text effects that you posted, no right now we do not have that ability. -mark Program Manager Microsoft This post is provided "as-is" ...Show All

• Visual Studio Team System Get list of Iterations and Builds via OM

  I need to get the list of iterations for a project and a list of the builds for the project using C#. These lists will then be put into a combo box for a new interface we are building. I was trying to use ICommonStructureService but could not find what I was looking for. Did the trick. Here's the implementation I did for iterations: private void PopulateIteration() { TeamFoundationServer tfs = TeamFoundationServerFactory .GetServer(Server); ICommonStructureService m_css = ( ICommonStructureService )tfs.GetService( typeof ( ICommonStructureService )); ProjectInfo projectInfo = m_css.GetProjectFromName(DefaultProject); NodeInfo [] nodes = m_css.ListStructures(projectInfo.Uri); // With this you obtain ...Show All

• SQL Server report on two database

  hi all i m facing a problem in reporting services. i have a global database, in which i m mainting user inormation like database name, server name and all credentails about user database. i want that when my report is open a user parameter will display, on the basis of that users id report will display data from his database. server name can be different, database name can be different but schema of database will be same for all user. so pls help me Don't use a single shared data source. If all datasets use the same shared data source then naturally having that expression based will affect all datasets that use it. Use multiple data sources, a different one for each dataset. Try not using a shared data source. On the data tab, ...Show All

• .NET Development Invalid attempt to read when no data is present.

  Why I am getting Invalid attempt to read when no data is present this is my stored procedure followed by the code.. STORED PROCEDURE: USE shefa set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= ALTER PROCEDURE [dbo].[sp_get_user] @login_user_id varchar(255), @login_password varchar(255) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; SELECT * FROM persons WHERE login_user_id = @login_user_id AND login_password = @login_password AND is_staff = 'Y' A ...Show All

• SQL Server long running transaction blocking queue

  Hello, I seem to be misunderstanding the way transactions work with service broker queues. We have developed and deployed a service broker application that 5 queues and a windows service for each queue on multiple servers (3 currently). Due to a last minute issue, we had to not use transactions when the services executed a recieve and I am not updating the code base to use transactions and am running into blocking issues. One of the services runs for 90 seconds (spooling to the printer) and all of the servers block on the receive operation for this queue. I thought that if I was receving messages from a single conversation, other receives against this queue would not block. Thanks, Jim Stallings ...Show All

• Visual Studio 2008 (Pre-release) ExceptionHandling - best practices

  Hi, I was wondering if there are already any exception handling best practices or patterns for WCF Assuming, you are developing a real world enterprise application, do you have any patterns for handling all the exceptions like they occur on broken connections, etc. Thanks, Tom There's no way to automatically handle exceptions. However, if you are using RM, the WCF infrastructure will retry under the covers. I believe there are some knobs you can tweak on the ReliableMessagingBindingElement (can you check the documentation for those knobs) ...Show All

• SQL Server Use VPN to connect remotely to SQL Express server

  Hello, I'm using a Windows XP Home laptop to connect to a network of one of my customers. The administrator of the customer has given me a username and password for a VPN connection. I've got the VPN connection working and I can ping the SQL Express server. This server is using Windows Authentication. For the users of my VB application we have added a group to the Active Directory and added this group as a user to the SQL Express Server. This works and the users can access the database from within the application. The SQL Express Server allows remote connections and the browser service is also running. I would like to use the SQL management Studio Express on my laptop to access the remote SQL Express server and manage the database ...Show All

• Visual Basic Languages that are supported by Speech API ?

  Hello, I can easily get the computer to read text in english in a textfield /// can it read text in other languages as well i tried but it did't do anything Just from the download http://www.microsoft.com/downloads/details.aspx FamilyId=5E86EC97-40A7-453F-B0EE-6583171B4530&displaylang=en#RelatedLinks http://www.microsoft.com/speech/download/old/sapi5.asp It would look like languages other than english are supported. Since this is a SAPI question, I think you can get a better answer from this news group: http://www.microsoft.com/communities/newsgroups/en-us/default.aspx dg=microsoft.public.speech_tech&cat=en_US_adb1a4c1-4dfb-4d53-9962-8dbad91aee8d&lang=en&cr=US . ...Show All