Divyajosephjohn's Q&A profile

• SQL Server Date question

  I currently get a date in the default format in my stored procedure. Up until now converting the date to type 101 was acceptable. Now they want the date to read something like Wednesday, November 8, 2006 or November 8, 2006. How do I do this convert in a single select statement I found the types that add the time but I have to make sure that the time isn't included for merge reasons. Help Jeff Mookey wrote: I currently get a date in the default format in my stored procedure. Up until now converting the date to type 101 was acceptable. Now they want the date to read something like Wednesday, November 8, 2006 or November 8, 2006. How do I do this convert in a single se ...Show All

• Visual Studio 2008 (Pre-release) Multiple Service Hosts for single MSMQ/clustered MSMQ

  How can I have service hosts, running on different servers, and bound to netMsmqBinding all pointing to the same MSMQ I need this to a) have a service host use a clustered MSMQ, and b) support scale-out by simply adding additional servers. When I try to set the service endpoint address to point to a Queue that is not hosted on the same server as the ServiceHost, no errors are reported but no requests are processed. Hope some can help. Thanks Thanks for your response. Unfortunately, Vista is not an option (its a desktop OS, and its late). I'm assuming that remote transaction read is a feature of MSMQ in Vista/Longhorn Server, and not directly related to WCF ...Show All

• Visual Studio Express Editions Search for name in text file

  OK, I am trying to read a name from a database then look for that name in a text file. So a record in the database will be "First Name", and search for that name and then read all of the data bellow that name untill there is a blank line. What would my procdure be and the text file will contain: First Name 1998 0.277 2000 0.282 2004 0.301 2001 0.234 2002 0.272 2003 0.288 1997 0.327 Second Name 1999 0.200 2001 0.193 2002 0.167 2003 0.282 2004 0.277 Third Name 2000 0.327 2001 0.256 1995 0.282 1996 0.271 1997 0.275 1998 0.277 1999 0.307 2002 0.286 2003 0.273 2004 0.304 Forth Name 1994 0.269 1995 0.308 1996 0.309 1997 0.328 1998 0.294 1999 0.333 2000 0.351 2001 0.306 2002 0.349 2003 0.325 2004 0.308 Here i ...Show All

• Visual Studio Express Editions textboxes and numerical input

  Alright, I've asked the question before, and I had a satisfactory answer. However, a new problem has run into the coding I implemented: Private Sub Textbox_KeyPress( ByVal sender As Object , ByVal e As KeyPressEventArgs) Handles Textbox.KeyPress If Char .IsDigit(e.KeyChar) = False And Char .IsControl(e.KeyChar) = False And Char .IsPunctuation(e.KeyChar) = False Then e.Handled = True End If End Sub what I want the code to do is to allow the person to put in both numbers and a decimal point, ".", however, I need a way to check what the person has put in to make sure they have not put in multiple decimals, like "5.2.7". I have even tried using IsNu ...Show All

• .NET Development Concurrency error when using ImportRow

  Hi, I am trying to import a row from one database to another with the same schema but the Update generates a Concurrency exception. Basically I just do this : ReadSrc() ReadDestination() For each SrcRow in dataTableSrc If rows do not match then dataTableDest.ImportRow(rowSrc) endif Next daDest.Update(dataTableDest) When I examine the table to be updated I see the imported row present with a status of "modified". I am using VS 2005, VB.NET, Access database, OledbConnection objects Any ideas Thanks, Mark David, Thanks for the reply. I fixed the State problem so the records to be added were State = "Unchanged", then did a SetAdd ...Show All

• Visual Studio Express Editions Can Visual Studio 2005 debug vbscript scripts?

  I've just downloaded Visual Basic 2005 Express Edition, which can open .vbs scripts, but doesn't highlight syntax, provide debugging etc for vbscript files. What edition of Visual Studio 2005 (if any) can provide this level of vbscript support The following worked for me to get me into a debugging session: CSCRIPT <filename>.vbs //X ...Show All

• SQL Server Management Studio Solution user-defined project folders?

  When you create a Solution/Project in Management Studio, it creates 3 folders for you - Connections, Queries, Miscellaneous. It does not appear that there exists the ability to create your own set of folders, either under the project or any of the 3 provided folders.  Does anyone know of a way to do this If you are working on a project that has hundreds, perhaps thousands of stored procedures, views, etc., there currently seems to be no way to organize them.  If this is true, this is an incredible MS oversight! Thanks! I already did. I also started my own post to this issue a long time ago. https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=127 ...Show All

• SQL Server Use SQL Express Edition in company

  I plan to use Visual Web Developer 2005 Express Edition create web application which access SQL database(Express Edition). Is there any license require for this 2 software if I use its in company Please provide information to me. Thank you! hi, SQLExpress is free to install and use... you can perhaps freely sign for distribution rigths at http://www.microsoft.com/sql/editions/express/redistregister.mspx regards ...Show All

• Smart Device Development Convert this please. Windows Form app to SmartDevice app

  I have snipet code from Windows app, but also I want to build SmartDevice app. could you convert my code please 3 codes : 1. code for browse network folder only Dim NetDrives As New List( Of String ) Dim drives() As System.IO.DriveInfo drives = System.IO.DriveInfo.GetDrives For Each dr As System.IO.DriveInfo In drives If dr.DriveType = IO.DriveType.Network Then NetDrives.Add(dr.Name) End If Next Dim dir As String = System.IO.Directory.GetParent(System.Environment.GetFolderPath(Environment.SpecialFolder.Personal)).FullName dir &= "\NetHood" Me .OpenFileDialog1.InitialDirectory = dir Me .OpenFileDialog1.FileName = String .Empty While Me .Open ...Show All

• Visual FoxPro The size of a formular

  Please tell me, how can I know everytime, the size (widht and height) of the formular (Sizable) Thank you. In Version 9.0 you can use the ANCHOR property of the Image control. If you are using earlier version of FoxPro, then you will have to add code to the Form's RESIZE() event to ensure that the image stays centered. ...Show All

• .NET Development scheduler for asp.net which sent mail at regular interval

  Hi I want a scheduler which sent E-mails at scheduled time in asp.net. does any one have any idea. Please reply me. nilay, what exactly do you need .... I mean a scheduler in asp.net doesn't seem to be something doable.... I would suggest you to implement the scheduler as a different process in your web server or if possible use the windows scheduled tasks.... will it work for you Regards Rodrigo ...Show All

• Visual C# documentcomplete event

  I've got a really weird problem with my application; it works on some pc's, and it doesn't on some others. What I've got: A Visual C# 2005 console application with references to MSHTML and SHDOCVW. I use mshtml to get a list of currently open browser windows, and attach events to it to edit the list when a new browser window is created or closed. I attach a documentComplete event to each open browser window and handle it the event there (let's say it prints out the url where is navigated to). So when I run this program, it should detect when I open a new browser window, when I close one, and it should print out the url of a site when it is done loading it. And there's my problem. On a few pc's, it all works perfectly. But o ...Show All

• Audio and Video Development Difference between Primary Video Set and Secondary Video Set?

  As per spec, Substitute Audio Video in Secondary Video set is for substitution of Main Audio/Video in the corresponding Primary Video set . Why is this sort of substitution required. Can any one expalin the necessity of this substitution in real time HDDVD movie discs. Secondary audio video clips can contain SubVideo or SubAudio tracks. SubVideo/SubVideo is an audio/video track in addtion to the main audio/video track. Sample application: Additionally to our main movie you can deliver a sub video / audio track that contains the director comments. If the user wants to see/hear the director comments you can run this secondary av clip in parallel to the primary av clip and mix the sub video / sub audio wi ...Show All

• Windows Forms Coloring TabControl.

  As far as I can see TabControl object has no properties of either Back or ForeColor. Is it possible to assign these properties to this object Another question: TabPage object does have both properties but when you assign a color to it it does not cover the whole TabPage: the tab itself remains gray. Is it possible to give it colors Many thanks. I just created a small Test App to recreate your scenario and didn't see any problems. I defined a variable to store the desired TabPage Height and set it in the Constructor after InitializeComponent(). I added a tabPage_SizeChanged eventhandler to all tabpages (if tabPage1 is not selected it will not fire the SizeChanged event until it is). I checked and modified the hei ...Show All

• Visual C# Interfacings with Web Application

  Our company dial with other company via Web based application we have access to our account in there site, we enter a lot of request using simple form then we get the results in the same page in table format. What we need to interface (automate) the process between our system (C# .NET 2.0) and there site (Java Servlet JSP Secure), our system provide the information that we need to enter every day in there system and receive there response. How we can make this kind of interface Thank you. SDev SDev, Sorry for the late reply, I missed your previous post. See these articles: http://www.west-wind.com/presentations/dotnetWebRequest/dotnetWebRequest.htm http://www.developerfusion.co.uk/show ...Show All