hazz's Q&A profile

• Windows Forms Using StreamWriter To Write HTML File

  hiii can any body tell me how can i use streamwiter to *create an HTML file *write on the that file *using HTML tags in wrting in case i need to write in a formated Way (bold,italic,color,write data in HTML table) ...... if its not available using StreamWriter where could it be thanx in advance ......... hiii thanks it is working ok but the problem now is that how can i add a variable data in a cell for example if i want to add that date(DateTime.Today) ... or a value of a variable ... coz i noticed that i can only add strings only to the cells ... thanx again ...Show All

• SQL Server Time of last table write

  Greetings. Can TSQL be used to retrieve the date and time of the last time a table was written to Thanks. alan Alan: TSQL can be used to retrieve this information IF your tables are constructed support this kind of activity.  We typically keep (1) create_user, (2) create_DT, (3) mod_user, (4) mod_DT as standard data elements of our tables.  These columns are updated by trigger whenever a record is inserted or updated.  If your tables do not retain this type of information you might want to consider adding it.  Understand that this does add some overhead; however, there are times in which this information is a quite valuable. Dave ...Show All

• Visual Studio Tools for Office Problem loading VSTO Excel Workbook project on Vista RTM, Visual Studio 2005, Office 2007 & VSTO SE

  I get the following error when loading an VSTO Excel Workbook project: --------------------------- Microsoft Visual Studio --------------------------- A compatible version of Microsoft Office Excel 2003 is not installed on this computer. You must install Microsoft Office Excel 2003 SP1 and the Visual Studio 2005 Tools for Office runtime (VSTOR.exe). Select the Repair option when you install the runtime. VSTOR.exe is available on the Visual Studio 2005 Tools for Office installation media or at the Microsoft Download Center ( http://go.microsoft.com/fwlink/ linkid=49612 ). --------------------------- OK Help --------------------------- My Configuration: Windows Vista RTM Office 2007 RTM Visual Studio 2005 Team Edition for Software ...Show All

• SQL Server Problem getting some numbers/strings

  Hello i got some strings like this 12|56112 Lahnstein-Oberlahnstein|Nordallee 3|rz-Kasten 6|57612 Olsen|Dorfstrasse 2|rz-Kasten i want to get all between this stripes "|". At the End it should look like this strRoute    strPLZ    strOrt     strStrasse         strInfo 12              57612     Olsen    Dorfstrasse 2   rz-Kasten with this Query i get the first 1-2 Numbers how can i get the other stuff  like PLZ Ort.... select          strBeschreibung , CASE when Patinde ...Show All

• SQL Server SQL Server 2005 JDBC Driver Output Parameter/Result Set issue

  I'm having an issue with the JDBC driver when I execute a stored procedure that both has a return value and also returns a result set. If I attempt to retrieve the return value (registered as an output parameter) after I execute the stored procedure, then any subsequent attempts to retrieve the result set always return null. Is this by design If I use the result set first and then later get the return value that works; however, in my situation I need to first check the return value before I work on the result set. Am I'm I doing something wrong Code: CallableStatement cs = connection.prepareCall("{ = call spGetCustomer( , ) }"); cs.registerOutputParameter(1, Types.INTEGER); cs.setString(2,"blahblahblah"); cs.setB ...Show All

• .NET Development Problem in calling .vbs file and getting output

  I am using System.Diagnostics. Process class to call a vbs file and want to get out put from that file(whatever it echo on standard output) from a code behind of an asp.net 2.0 application. Code is: System.Diagnostics.Process p = new System.Diagnostics.Process(); p.StartInfo.FileName = this.Page.MapPath(this.ResolveUrl("Script/ALI.vbs")); p.StartInfo.UseShellExecute = true; p.StartInfo.RedirectStandardOutput = true; p.Start(); p.WaitForExit(); System.IO.StreamReader sr = p.StandardOutput; txtComments.Text = sr.ReadToEnd(); Now the problem in above code is that if I set UseShellExecute = false , it says on executing Start() that its not a win32 application. OK if I set UseShellExecu ...Show All

• Visual Studio 2008 (Pre-release) Can CallbackChannel Serialize

  I need to persistence the CallbackChannel when server reboot, and recover it after the server restarted.But I when I try to serialize the CallbackChannel object by BinaryFormatter class, there are some error happened.I want to know,is it possible to serialize a CallbackChannel object If it is, how Thanks for help, I try it but found new issue. Cause the wsDualHttpBinding is reliable in default, so I found if the server reboot, the channel from client to server are in fault state. That's means client can't communicate with rebooted server by the channel created early. It throw exceptions when invoke remote method, sometines are TimeoutException and others are CommunicationException. I want to ask is' ...Show All

• .NET Development <clear /> tag

  What happens if we failed to give <clear /> tag in <pages> tag of web.config file regards, kailai ...Show All

• .NET Development Creating a new website in Visual Studio 2005.

  When I create a new website in Visual Studio 2005, VS2005 always puts my solution file in C:\Documents and Settings\my_login_name\My Documents\Visual Studio 2005\Projects\my_project_name. Is there a way to customize this behavior and to have it ask me where I want my solution file is instead of always putting it in the default location Then the rest of my file are always put in C:\inetpub\wwwroot\my_project_name. This is again, not the location where I want to put the files. I want the solution file and the rest of the files in one location of my choice arbitrarily in my C: drive, then have a virtual directory in IIS pointing to the location. Are there any ways to change these behaviors It is irritating. ...Show All

• SQL Server Unable to connect if mirror down

  We have an application running with a principal, mirror, and witness. If we bring the principal server down, it looks like failover occurs successfully, but the application is not able to access the database. If we bring the server back (so it is now functioning as the mirror), the application is now able to connect to the database. Why isn’t the application able to connect without the mirror up Any suggestions What was the error at that time Error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes P ...Show All

• Visual Basic Problem in VB Designer

  Hello all. Hope you can help me with this, i've been searching the forums for the past hour with something the same, however haven't found anything. I know lots of you have had problems with the form designer giving errors and refusing to show the actual form, mostly because of some transition in software i take it (i aren't a Full time programmer, its just a hobby.) My problem is similar, vb refuses to show me my form and now i have even more problems. the last thing i did before this happened was try to add an imagebox to the form. Heres a few errors i get: every label i have is no longer declared event 'load' cannot be found - My other problem is, i managed to close the designer window during this problem and i cant remember how to get ...Show All

• Visual Studio 2008 (Pre-release) Entity Data Model Designer

  I am using the March 2007 Orcas CTP and have created the EDM model using the wizard. Now, I want some changes so I am tweaking the CSDL, SSDL and MSL files by hand. Of course this leads me to long for the EDM designer tool. When will this be available in a CTP I just came in to ask the same question... Great minds think alike... Guy Burstein http://blogs.microsoft.co.il/blogs/bursteg/ ...Show All

• Visual Studio Express Editions c-mon guys..help me out

  I asked for help in my other thread.. button help needed... big problem.... I had a couple of replies...but I am still stuck....can you help please thaks for the replies guys.... but saving the urls is fine for me...as I can save the urls that I want......ie...google.com... but if someone else was to use my browser....I want them to be able to assign the buttons to their preferences... actually I messed up....because I have 10 menu items named site1 to site10......... the idea was to save your favorite sites to the menu items......but my favotite sites are not your favorite sites.... see the problem I need a way to save the menu items to the documents folder....so that the user can change them....... I ...Show All

• SQL Server No available values in Report Builder parameter

  In a Report builder report I have runtime prompt filter on a field. But I am not able to see the available values in the dropdown for this field. My filter is on a "New Field" with the formula : IF(LENGTH(FieldName)>0,FieldName,("Blank")) However if my filter is on the FieldName directly and not on the New Field with the above formula I do get the available values. Is there any way I can get the available values in a dropdown for the New Field True any field which is present in the Model can be shown in the dropdown. I was exploring if a new formula field that is not actually present in the model, might also have 'Available values'.Thanks for your response. ...Show All

• Windows Forms Changing size property

  How do I enable the changing of size of a control like combobox Thanks. regards Alu Hi AlucardHellSing & others   My solution to second CurrentCellAddress problem is to use CurrentCellChanged event.     Here is all the code needed to implement it’s usage     // form1.cs   public partial class Form1 : Form {            // your super code                // my code at the end              //            // Your workhors ...Show All