Sanophy's Q&A profile

• Visual Basic Speed up assigning points to a 2D array

  The program that I’ve written works but is incredibly slow and I am wondering if there are more efficient ways to accomplishing my intensive tasks. I have a large text file with real world xy co-ordinates. Each co-ordinate is an easting and a northing for a point. My overall goal is to read in all of the points and assign those points to a raster grid where each cell represents a specified area in the real world (i.e. 10meters by 10 meters). The value of a cell simply represents if a point is present in it or not (1 or 0) The extent of the raster grid is 1000m x 1000m and the smallest cell size I’m working with is 0.1m so the output grid would have a size of 10000 cells by 10000 cells. I dimension an array c ...Show All

• .NET Development Connection Timeout

  I have a problem with Connection Pool running out of connections. I have a site which can get upwords of 1000 conncurrent hits at once. We never had problems with the connections when using classic ASP. But now we are running into the issue with timing out before getting an available connection. We are closing all of the connections. We have bumped up the max pool size to 700 but i don't feel this is really the right solution. Should we not use ADO.NET and go back to using ODBC as stated before we don't have this problem with our classic ASP which uses ODBC connections. Thanks for any help! Do you only close connection or call Dispose method as well Calling dispose could release connections fas ...Show All

• Visual Studio Team System Kill connections prior to dropping database

  Hi, I'm working on using VSTS4DBP as my deployment tool for databases and I'm excited about the ability to use it from MSBuild. So, I'm working on my deployment script and one thing I want to do is drop the database if it already exists prior to recreating it again. Hence, I clicked the "Always recreate database" button in the project properties which causes the following to go into the deployment script: IF ( DB_ID ( N 'MyDB' ) IS NOT NULL) DROP DATABASE [MyDB] ; GO That's all good except that if someone is connected to the database (which is a possibility) then the deployment will fail with the message: Error 3 Msg 3702, Level 16, State 4, Line 3 Cannot drop database "MyDB" beca ...Show All

• Visual C# Creating paths from database data

  Sorry for the undescriptive subject, I couldn't think of anything! I have a stored procedure that returns the following from a nested set: COUNTRY 0 CITY1 1 CITY1 Region 2 SITE 1 3 CITY2 1 CITY2 Region 1 2 SITE 1 3 SITE 2 3 CITY2 Region 2 2 SITE 1 3 SITE 2 3 A depth of 0 is only reached once, which is the root. A depth of 3 represents a leaf, and all others are paths to the leaf. I wish to store this data in a dataset (or other ) and loop through the set cr ...Show All

• .NET Development Calendar DayRender

  Can you please change the syntax to this pc of code. I want to use this on my page behind. I found this code on line. I am not able to fix the syntax. Thanks Private Sub Calendar1_DayRender(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DayRenderEventArgs) Handles Calendar1.DayRender 'Clear the link from this day e.Cell.Controls.Clear() 'Add the custom link System.Web.UI.HtmlControls.HtmlGenericControl(Link = New System.Web.UI.HtmlControls.HtmlGenericControl) Link.TagName = "a" Link.InnerText = e.Day.DayNumberText Link.Attributes.Add("href", String.Format(window.opener.document.{0}.value = \'{1:d}\'; window.close();", Request.QueryString["field"], e.Day.Date)) ...Show All

• Visual Basic Secure SQL Login Info

  Hi, I am currently working on a program that will connect MySQL database using MyOLEDB Driver. I used Dim fdCon As New OleDb.OleDbConnection("Provider=MySQLProv;Data Source= DATABASE ;User Id= USERNAME ;Password= PASSWORD ;") I am wondering is it secure to hard-code the username and password If not, how could I secure these info Thanks in advance! No, it is not secure... Ideally you should prompt the user for these the first time your application loads and then store it using DPAPI. If you search around you'll find a few DPAPI libraries for .NET. Also, have a look at the Configuration Management Application Block/Enterprise Library which supports encrypted configuration. ...Show All

• .NET Development IL Code Insertion

  hi everyone! as one can guess from my last posting i am currently playing around with the System.Reflection and System.Reflection.Emit namespaces. I already know how to retrieve metadata from an existing assembly and how to create new assemblies on the fly. Now i wonder if it is possible to insert IL code into existing assemblies, e.g. i have an assembly and want to add code, but not on the fly as it is done in the articele "Rewrite MSIL code on the Fly" by Aleksandr Mikunov (http://msdn.microsoft.com/msdnmag/issues/03/09/NETProfilingAPI/default.aspx) As a result i want to have a tool which takes an existing assembly as an input file and returns a new assembly (also on disk) with added functionality. Well I am sure it can be done ...Show All

• Visual Studio Express Editions copy dataset

  hey everyone, this is not very new question, sorry about that, but i dont know how to manage to do this. i want to a copy dataset with the tables and stuff, and here's the example code they give: Private Sub CopyDataSet(ByVal myDataSet As DataSet ) ' Create an object variable for the copy. Dim copyDataSet As DataSet copyDataSet = myDataSet.Copy() ' Insert code to work with the copy. End Sub what else should i do with the code to get this work, because that dataset.copy() does'nt add new dataset itself, right the row "insert code to work with the copy" is the problem i guess. what short of code will i need then could'nt find any samples, and dont know how to do it myself. any help for this is appreciated. thanks ...Show All

• Community Chat hola

  hola minombre es sahady y quiusiera que me dieran pasos en espanol para entrar a los foros who gave you the ability to post spanish and enter the forums (sorry, google translator stinks.) Translation: (which is very bad): quien te dio la capacidad de fijar a espanoles y de entrar en los foros (hedores apesadumbrados, del google del traductor.) ...Show All

• Visual Studio Tools for Office Right Click Event on Email Item

  Right now i am trying to edit the right click menu of outlook 2003 using VSTO. also i want its events so that i can do some necessary work becore the right click menu. Any help regarding this would be appreciated. Ryan Gregg - MSFT wrote: With the body, you can add items to the context menu only if the user is using WordMail for their e-mail editor, and then only by adding items to the command bars for the context menu in Word. Ryan, this no longer works in Outlook 2007. Create a new message and try this in VBA: Set doc = Application.ActiveInspector.WordEditor Debug.Print doc.CommandBars.count You'll get an error that the member isn't available in email. This is a surprising step backwards, given all t ...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 Hi, I've uploaded my project : http://files.filefront.com/VideoDrawingTestzip/;6304937;;/fileinfo.html Compile it and run, it should work. The Video.wmv file properties are set to copy it to the output directory on each build. Guillaume ...Show All

• Visual Studio Express Editions 2 versions?

  If you install Visual Basic 2005 Express Edition can you then intstall C++ Express Edition as well, without having to uninstall one or the other Thanks, Chedders ...Show All

• Windows Search Technologies Save to file a Windows Desktop Search result?

  I posted this thread yesterday but it's gone... strange! One of my disks crashed and I want to get info on what files were on that drive. I have indexed the drive on Windows Desktop Search so i can search through all the files. But i want to save the search result to a text file etc for later use. How can I do this with WDS Morty, Oslo OK I tried to save the results to a folder but could not. I need to analyze all of the emails sent and received to/from an individual. I executed a search using his last name (this is a unique name therefore I will not get false hits). In the search results I see 272 results. Now I need to make a softcopy of each email. After making a softcopy (1) I then need to print each ...Show All

• Commerce Server Site Refresh not working for Business Apps

  Hello everyone, I can't seem to refresh the site cache from the BizApps on CS2007 RTM. I have the BizApps installed on a dedicated server and even with the hotfix KB 922068 applied I can't get the sitecache refresh feature working This is the error I get. System.InvalidOperationException: There was an error generating the XML document. ---> System.InvalidOperationException: Instance validation error: '0' is not a valid value for System.Net.HttpStatusCode. at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationWriterList1.Write1_HttpStatusCode(HttpStatusCode v) at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationWriterList1.Write3_CacheRefreshFailureInformation(String n, String ns, CacheRefreshFailureInfo ...Show All

• Windows Forms Creating Microsoft Windows Installer (.msi) file from VS2005 project

  Hi, I could not find a clear answer to the following question so I hope someone on this list/group could offer some advice. Can anyone suggest suitable examples/walk through documentation or even general documentation I can read or try that describes the VS2005 process for creating an .MSI file from a project I am creating. The project is to be fully standalone running on client machines however it requires .NET on the client machine and uses .NET Programmability Support for MSWord2003. I can currently install the published project (directory of .exe, .dll files etc...) which gets and installs the .NET framework from the microsoft site and requires manual intervention to add .NET Programmability support. I want to know if it ...Show All