FanZai's Q&A profile

• SQL Server How can i prevent that all data can be seen with notepad?

  Hello, is there a way to say to SQL Server to make the data not readable Regards Markus Hello Andrea, > I understand your topic, but security is a whole "platform" consideration... > security is a set of implementations, first of all restricted access to the file as well... Yes. But I'm speaking also for the home user or for small companies. They mostly don't have pleasure, time or money to invest in a security platform. They just want to install the software. Work with it and want the certainty that their private, secret data is stored in a SUFFICIANT secure manner. And not in such a unsecure manner as it is today. > so the physical file should not be arbitr ...Show All

• Visual Studio 2008 (Pre-release) DLING Query

  How to write a DLING query statement to do something like var myTrack = { from t in db.Tracks where (t.ID == track.ID t.ID ) && (t.Name==track.Name t.Name) select t).First(); track is the serach criteria object. i got the compliation error "Operator ' ' cannot be applied to oparands of type 'bool' and 'string' anyone know how to reslove this thanks advance Your best bet may be to construct this query by composition: var query = db.Tracks; if (track.ID.HasValue) query = query.Where (t => t.ID == track.ID.Value); if (track.Name.HasValue) query = query.Where (t => t.Name == track.Name.Value); Track myTrack = query.First(); You might have t ...Show All

• Visual Studio Express Editions save in Excel

  Hello! How can i set the size of the textboxes in my code excel 2003 Imports Microsoft.Office.Interop Dim xlApp As Microsoft.Office.Interop.Excel.Application Dim xlBook As Microsoft.Office.Interop.Excel.Workbook Dim xlSheet As Microsoft.Office.Interop.Excel.Worksheet xlApp = CType (CreateObject( "Excel.Application" ), _ Microsoft.Office.Interop.Excel.Application) xlBook = CType (xlApp.Workbooks.Add, _ Microsoft.Office.Interop.Excel.Workbook) xlSheet = CType (xlBook.Worksheets(1), _ Microsoft.Office.Interop.Excel.Worksheet) xlSheet.Cells(1, 1) = TextBox1.Text xlSheet.Cells(2, 2) = TextBox2.Text . xlSheet.Application.Visible = True ...Show All

• Windows Forms How do you not allow user to resize rows in a datagrid for C#?

  I am making a form in C#. It has a datagrid that pulls information from a SQL table. How do I get it so the users can not resize the rows in the datagrid. I do want the datagrid enabled as I need to select currentrowindexes to do stuff with the data in the form. I just want to know how do I prevent the user from resizing the rows This can easily be changed in the properties of the component (if using VCS Express Edition), else just include: dataGridView1.AllowUserToResizeRows = false ; :P ...Show All

• SQL Server User is not associated with a trusted SQL Server connection

  I set up SQL Express and Visual Studio Team System for the first time yesterday. I created a web service (on my localhost IIS) and added an MDF file to my App_Data folder. I added a table with five fields. I'm trying to connect to the database in my web service, but when my web service gets to the connection line it returns the error System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection. When I add in my domain name and password to the connection string I get the error System.Data.SqlClient.SqlException: Login failed for user 'redmond\danmor'. The user is not associated with a trusted SQL Server connection. I've queried these SQL forums, and the advice is u ...Show All

• Visual Studio Express Editions Error: Unbound reference in aggregate expression

  Trying to configure tableaddapter on a table with a Sum(child.Total) expression i get "Unbound reference in aggregate expression 'system,data,aggregatenode' Anyway I can fix this Cammyr, How is your problem going I found a same question in Google and there is an answer like: I'm not exactly sure what you are asking, but I'm assuming you want to "fix" your dataset so you can edit it again. If so, then yes you can fix it. With Visual Studio 2003 and 2005 projects, almost everything is stored as valid code in whatever language you are using (e.g. VB.Net or C#). So your dataset is nothing more than a collection of .vb or .cs files. If you are using VS2003, then all your dataset ...Show All

• Visual Studio Reporting in VB .Net 2005

  Hi, I have MS Access as the backend, and using VS 2005. I want to create a report, where I could load pictures in the section. I will get the path of the picture's path from the database. Anyway of doing this, as I couldnt find any solution so far. Please kindly help. Thanks in Advance.  Here is how I dynamically change a picture/logo on a crystal report using VB.Net 2002/2003/2005 and with the bundled version of Crystal Reports that comes with them. 1) store the pics on the server.  DO NOT KEEP THEM IN YOUR DATABASE!  way to much overhead on your database. 2) store the full pathname to the pics in a table in your database.  Much smaller and easier on your database . 3) In your VB.Net report dataset put i ...Show All

• SQL Server Parallel execution of source SQL commands

  Hi, we're accessing a SQL Server as a source for some SSIS packages using quite complex SQL commands. We have dataflows getting data from up to 10 queries. The problem is that SSIS starts all these queries in parallel using up all the memory of the server (the source SQL server, not the server SSIS is running on). So the queries are very slow. Is there any way to force SSIS to start the queries after each other I already browsed the web for some answers on that and I'm not very optimistic... Maybe the only solution is really to feed the result of the query in raw files and process them later... Thanks, Jamie, thanks for the fast reply... As far as I understand (and that's what I see at least while debugging) precendenc ...Show All

• Visual Basic Determine the ID of a record from a Datagrid

  I've a Datagrid on my form and I need to know the value from the RecordID field regarding a particular cell that I've clicked. In other words, lets say I have a datagrid showing fields Name, Address, City and when I click on the cell regarding address I need to get the ClientID field from the database. How can I get that Thanks, Joao Pinto Using your code I receive an error message: Index was out of range. Must be non-negative and less than the size of the collection. Here is the code that I've: Private Sub DataGridView1_CellClick( ByVal sender As Object , ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellClick Dim Row As DataGridViewRow = ...Show All

• Software Development for Windows Vista How to detect the windows version in Visual C++

  Windows API GetVersionEx() returns the same result for Vista Starter, Home, Home Premium and the same result for Vista Business, Ultimate. How can I distinguish the Vista Starter from Home, Home Premium How about Vista Business, Ultimate... Is there a way to figure out in Visual Studio Thanks Use the new API GetProductInfo (...). Detailed info here: http://msdn2.microsoft.com/en-us/library/ms724358.aspx Thanks, Gabriel Topala http://www.gtopala.com ...Show All

• SQL Server FormatNumber >> Excel export?

  Hi all I want my measures to be exported(Excel) as numbers instead of text. When i simply use them as is it does this correct but as soon as I as the following number formating it no longer exports correctley. =FormatNumber(Fields!Example.Value,2,True,True,True) The same apllies to whe  I set the formatting in the text box properties to N Can some please tell me how I can acheive this result when exporting Thanks in advance G After personally trying the above recommendations, and having them not work for me, I determined the following: Let's say you want to mask-out '0' values, and you have a formula in a textbox like: =IIF(Fields!FieldName.Value=0,"",Cdbl(Fields!FieldName)) ...then, regardless of ...Show All

• Microsoft ISV Community Center Forums Happy Holidays

  Hello!!! I only want to thank you for the supporting. Thanks Team!! and wishing to you a Happy Holidays and an awesome 2007. 'Till next year. ...Show All

• Windows Forms Designer loses ALL controls when application run!

  I'm wondering if anyone has come across this before in Visual Studio 2005: I have a fairly large application with quite a few files, and from time to time, some files lose their controls in the designer when I run the application. If I then close the form and re-open it, the controls are there ... but I can run it all day and it'll keep on giving me the same issue - the controls (like everything!) just disappear and I'm left with a blank, gray background. It seems to happen most often on windows forms that are a little more complex ... ones that have more controls than the norm. Thoughts ...Show All

• Windows Forms Showing an animated waiting dialogue while invoking a remote method

  Hi, I’ve developed a smart application that uses .Net Remoting. When calling a remote method, the system hangs up till the method returns. It will be nice if I can find a way to provide the user with an animated dialog telling him that there is information being requested from the server. Any help IF you are using 2.0 .net, try exploring backgroundworker class... You can spin of the remoting call in the backgroundworker and show a progressbar (or whatever) till the Completed event is captured.... Hope this helps ...Show All

• SQL Server Moving Reporting Services

  I have reporing services in serverA, and i want to move all the reports to a new server serverB. ServerA ---Sqlserver2000, operating system windows2000 adv server ServerB ---Sqlserver2005, operang system windows2003 server. Is it true that i have to detach the db from one server and attach it on another. If this is corect what are the other steps i need to do after moving. please advice Thanks in advance i have already installed the server with default configuration... Your post also mentions about Visual Studio2005, does that mean reports in RS2005 can be deloyed only from VS2005..cant it be done from earler version of VS. I have fllowed the steps i mentioned earlier, restore DB from 2000 to 2005, and when i w ...Show All