Tryin2Bgood's Q&A profile

• SQL Server Install SQL Server 2005 Exp with ToolKit

  Hi, I would like to have SQL Server 2005 Express with the most features as possibles. It seems to be correct about 'AdvancedEdition' but, when I installed the "ToolkitEdition", in order to get "Business Intelligence Development Studio", I was not able to open this option. The file 'devenv.exe' is missed. Do you have some procedure and links to get best set up with theses features for SQL Server 2005 Express Thanks. You shouldn't try copying files around manually, the file locations are tied to how you install your products and there are many dependencies between groups of files. You should just follow the directions I pointed you to. Search from devenv.exe on your comput ...Show All

• SQL Server Finding the Max Value

  I have a report that is grouped by week. The details of the week have the date, time interval (half hour), and the maximum value for that day. So in the example below I am showing the week of May 21st. Then I have all of the days of that week, sorted by date as requested, with the halfhour the maximum value occured in on that day. So Monday the 22nd has the maximum value for the week at 254 (and is highlighted in red). Where the are below, I need to display '1400' which is the interval, but have not yet been able to figure out how to do this. I tried the following expression: =iif(max(Fields!MaxValue.Value) = Fields!MaxValue.Value, Fields!Interva.Value, "X") but this only works if the first day is the maximum value. ...Show All

• .NET Development Read ReadBinHex

  Hi, suppose i have an xml file which contain the following data: <items> <item> 0A141E2832</item> </items> how can i read the item element in ReadBinHex method from xmlTextReader please note that the item data is not a fixed length and this is the main issue. a sample code in c# may be helpfull for me. Thanks. You can use XmlReader.ReadValueChunk() method to read it chunk by chunck. http://msdn2.microsoft.com/en-us/library/system.xml.xmlreader.readvaluechunk.aspx ...Show All

• SQL Server Cannot use credentials for proxy account

  Hi, because my package does not run with SQL-Server-Agent, but without problems if started by "hand", I created a new credential which contains the information needed for the package. I did this as described on: http://msdn2.microsoft.com/en-us/library/ms190703.aspx . After that i tried to create an proxy account, but when I chose the created credential, Management Studio says "Der Proxy "[name_of_credential] ist kein gultiger Windows-Benutzer(Microsoft SQL Server, Fehler: 14529)". This means something like: "This Proxy is not a valid windows-user. Error: 14529". Any hints how to use a credential that is not a windows-user Regards, Jan Wagner GethWho wr ...Show All

• Windows Forms Remove blank lines from a textbox

  Blank lines in a textbox can be: A series of spaces followed by a carriage return OR A carriage return OR A line filled with tabs How can I remove all blank lines from the text entered in my textbox interesting... this.textBox1.Text = Regex.Replace(textBox1.Text , "\t", ""); this.textBox1.Text = Regex.Replace(textBox1.Text,"\r\n\r\n","\r\n"); seems to work for the overall textbox. Now how can I store each para into an aray ...Show All

• .NET Development Updating a DB and getting an id

  Hi, I've a little problem of "speed" I think... I'm writting in a table, and after this, I try to read the ID that is assigned to ne new row in the table.. But I suppose that I read so much faster and the row isn't still wrote. Here is an example: CadenaSQL = "INSERT INTO Modul (Etiq, Num, Tip, idER)" CadenaSQL = CadenaSQL & " VALUES ('" & ER(IndexER).Modul(i).Etiq CadenaSQL = CadenaSQL & "', " & ER(IndexER).Modul(i).Num CadenaSQL = CadenaSQL & ", " & ER(IndexER).Modul(i).Tipusl CadenaSQL = CadenaSQL & ", " & ER(IndexER).idER & ")" If Not ExecuteSQL(CadenaSQL) Then MsgBox("Errorr") End If CadenaSQL = "SELECT idModul FROM ...Show All

• SQL Server Append Headers / Footer Rows to Existing Text File

  Help, I have a client that requres me to add a header line and trailer line to a flat file. The trick is the header and footer row is required to have a length of 120 with 5 colunmns while the data included in the query has a length of 1125 and about 70 columns. How can I append a header row to a file through SSIS. ...Show All

• Visual Studio Create New Website option missing

  I install VS 2005 without problems. On the Start Page i have 2 options on the left when creating a project open: Project Website Create: Project Website So i have create/open a project and create/open a website. Few days later the option for website disappears even though all ive been doing is creating and opening websites. Why does it do that or is it some bug This happens on 2 machines - any ideas to resolve this Thanks see if you can reboot IIS however this shouldnt be the problem. you should still see that error even if IIS is not installed for example but the error will come as soon as you hit ok to create the solution. VS 2005 has its own "IIS" or mini server and does not rely much ...Show All

• Visual Studio 2008 (Pre-release) Take "screenshots" from MediaElement?

  Hello! Is it possible to to save the current frame of a MediaElement to a .jpg or any other image-format. After pausing the MediaElement I’d like to take a screenshot of what’s currently showing in the video... /erik ...Show All

• Visual Studio 2008 (Pre-release) Getting the Mesh position co-ordinates after Rotation.

  Hello, I have a MeshGeometry3D object in which I have set the Positions and TriangleIndices. I have added it to a GeometryModel3D object also. I then Rotate the Geometry Model using Transform3D group, Axis Angle Rotation 3D and Rotate Transform 3D. I now wish to obtain the new positions of the mesh. It seems that the rotation of the geometry model (and the mesh within) does not change the mesh positions. Kindly help. Regards, Rohit. PS: BTW could Geometrymodel3D.Transform.Value be of any use for this Hello, Thanks for your reply! I tried this but the problem still remains. I am further clarifying you about what I am doing. Please note that the code may contain minor s ...Show All

• Visual Basic file rename in VB .net

  Hello I try to rename a file by file.copy(oldPathName, newPathName) then file.delete(oldPathName) File.copy works. But somehow, a message saying oldPathName is being used by another process, when it tries to delete the old file. Any idea why this happened and how to make it works. Thanks Quin Why not use the My.Computer.FileSystem.RenameFile Method to do the job rather than creating your own combination of copy and delete. There are more issues involved in recreating your own two step process such as timing, and fallback if failure occurs. I've found its almost always better to use whats available rather than trying to recreate the wheel. My.Computer.Filesystem.RenameFile htt ...Show All

• Windows Forms DataGridView standard practice?

  OK so here is the deal. I would like to know what common practices are out there relating to my problem. First I have a class that defines a Question that has the following fields (QuestionID, CategoryID, QuestionText). I created a DataGridView and bound it to the object representation of Questions so all of the columns were generated in the designer as well. I set the bindingsource at runtime and things look fine. The grid contains all of the raw data. Now, I want to modify the grid to show the category name rather than the ID. The category name can be found in a lookup table. Note, I do NOT want to modify the Question class to contain the CategoryName and do a JOIN in the procedure to get the data. I want to keep the object ...Show All

• Visual Studio Breakpoint will not currently be hit. No symbols loaded for this document.

  I have been 'developing' with Visual Studio 2005 for about 3 weeks now - primarily .NET class libraries developed with VB. I am coming from VB6, although I did a lot of development with Visual C++ several years ago, so I am still trying to come to terms with the debugger. I have read many threads posted by people who are having a problem with breakpoints, specifically with the message in the subject line above. There have been many suggestions on how to fix this problem. Sometimes these suggestions work, sometimes they do not. Most of the suggestions involve deleting DLL and PDB files and rebuilding, or restarting Visual Studio. None of them suggest any problem with something the developer has done or any problem with the configuration of ...Show All

• Visual C# Alternative for Add Web Reference.

  Is there any other way for use Web services other than Add Web Reference.(use a static WS Url) this is because i like to have one client (same wsdl) but different server URL do i need to recomplie each client with the new URL each time or i can use app.setting for store the web service url if yes how thx In addition to ahmedilyas' comments, you can simply assign a value to the URL property of your web service object before invoking any methods. When you add a web reference the URL you specify in the wizard is stored in the config; it's this value that is used for the default of the URL property. ...Show All

• .NET Development DataTable doesn't have a simple sort method??

  Let me see, .NET framework 2.0 has a host of other very rarely used features (and I do mean rarely), yet something as basic as a DataTable.Sort is NO WHERE to be found. So once again I jump into the help files and start the Google search and find a few solutions, none simple and with the usual posts of "...why would you want to do that..." 1. DataTable.DefaultView.Sort returns DataView - Crystal Reports can't use this as a datasource 2. DataTable.Select() - returns DataRows - again can't bind to this I want to sort the DataTable itself, this should be easy, this should be a part of .NET Framework, this is clearly a feature many expected be part of .NET Framework (judging by the number of people asking the same questio ...Show All