konstantinos_1000's Q&A profile

• SQL Server Row_Number() fails to return anything

  I am using SQLExpress and want to do some custom paging with a grid but can not get the sproc to produce any results. I don't get any error just a resultset of 0 rows whenever I include the row_number function. Sample Table : refID int identity increments by 1 refSubject nvarchar(100) refBody nText Sample sproc that works create proc sp_RefListing as select refid , refsubject from myTable Sample Sproc that doesn't work : with OrderedRefList as (Select refid ,refsubject ,row_number() OVER (order by refsubject) as rownum from myTable) select refid ,refsubject ,rownum from OrderedRefList where rownum < 10 When I execute I get no errors or warnings during save, but I get no data. Is the ...Show All

• .NET Development Page Load Firing Twice

  I converted to 2.0 and now hte page load fires twice on my web sites. I understand there may be a place where the converted inserted code that loads the page twice, but I can't find it in the code behind. I'm using vb. Thanks. Not a silly question at all. I am seeing the same behavior on two of my pages involving a CrossPage Post. It seems like if I do not go through the same logic to initialize all the controls twice (which is potentially a lot of overhead) the page won't look right. On the first Page_Load, Page.PreviousPage is set; the second time around Page.PreviousPage Is Nothing, ...Show All

• Visual Studio Visual Studio project templates are missing

  Hi! My Visual Studio 2005 project templates have disappeared. I've already tried to run "msdev /installvstemplates", but they didn't appear. Any other suggestions TIA Hi and thanks for your answer. But I didn't use a registry cleaner. It was a fresh install of Vista RTM Business + VS 2005, VSS 2005 + .NET 3.0 Extensions + SP1. Registrycleaners are useless with the beginning of XP, because of the besser loading algorithm of the reg-hives. ...Show All

• Visual Studio Express Editions trying to build my first class file - need help

  I hope this is the right forum to post this question, if not, if someone can point me to the right forum. I'm trying to create a static class file that I can use to send auto-generated emails within my application. I want to create a static class so I can directly reference the class members. I'm pretty new to C#.NET and using Visual Web Developer Express Edition. Normally, when I want to send an auto-generated email, I use the following method from the System.Net.Mail class: const string ToAddress = "xxxx@xxxxx.com"; MailMessage mm = new MailMessage("xxxxx@xxxxxxxxxxxx.com", ToAddress); mm.Subject = "Subject goes here"; mm.Body = strmsg; mm.IsBodyHtml = true; SmtpClient smtp = new SmtpClient(); ...Show All

• Windows Forms Application.EnableVisualStyles and .DoEvents()

  Hi All; I've got a groovy little windows app (VB.Net 2003) going with some tab controls and tab pages. I'm also attempting to EnableVisualStyles but am not able to display the tab's text when using EnableVisualStyles. I have Application.DoEvents following as suggested in several different threads I've found on the web that are mentioned to combat the bug in 1.1 framework. Can anyone offer further suggestions Code as follows. Thanks, GRaab Public Sub Main() Dim mainForm As mdiServiceCare = Nothing Try Application.EnableVisualStyles() Application.DoEvents() mainForm = New mdiServiceCare Application.Run(mainForm) Catch ex As Exception MsgBox(ex.Message) End Try End ...Show All

• Windows Forms Web Sites not using HRef links!!!!

  Hi there, I am developing an windows application in VB.Net language. The purpose of the application is to access web sites, and collect information for processing client-side. Currently the application connects to the site using the site's domain URL, downloads the index/default main page in a stream of ASCII characters, isolates "href=" tags, parses the URL attached to it and stores it in a file - like a "spider" or "robot". The file holding the collected URL's is then accessed, and the URL's are loaded into the client's RAM. These URL's are then accessed in turn, and the resulting pages downloaded, as above, in a stream of ASCII characters. The application then searches the string of chara ...Show All

• .NET Development Using 'Stream' from unmanaged code.

  Is there a typelib definition for System.IO.Stream (_Stream) I would like to create a COM method that takes a Stream derived object (FileStream, MemoryStream etc). Is this a valid thing to do BChristensen wrote: Is there a typelib definition for System.IO.Stream (_Stream) Yes, in mscorlib.tlb in the framework directory. ...Show All

• Visual Basic Could someone point me in the right direction?

  Not even sure where to start. Need to subtract quantity from inventory table when quantity is added to invoice table. Start with transaction stored procedure Any guidance would be appreciated. Cammyr, Please take a look at the System.Transactions namesapce in MSDN as the following link and choose the proper class needed in your project: http://msdn2.microsoft.com/en-us/library/system.transactions.aspx ...Show All

• Windows Forms Windows Form Dictionary

  Hi All, I want to make a dictionary with windows application. My data is html format. therefore, i use webBrowser control on my windows form. If the user click any word in webBrowser control, word mean must browse to user (like babylon). I have a windows form. My form has webBrowser control. I fill a html content with javascript (Dictionary.js) to webBrowser. Javascript (dictionary.js) can obtain the word if user double click on the word. I must to send this word another windows form. Thus, i will learn this word mean. My question is; Can the javascript call the windows form server code if it can not, how can i do that Note: Visual Studio 2005 C# Thanks any suggestion. Oznur I mea ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Effect file parameters

  Hi, I am unable to understand shaders so I use FX Composer. I created (loaded) an effect to one of my meshes and saved its code. When I try to apply it, I can't see anything. I don't know what parameters should I set so I ask for help. How can I make this reflection effect work Here is the XNA code: foreach (ModelMesh spheremesh in sphere.Meshes)             {                 foreach (ModelMeshPart modmeshpart in spheremesh.MeshParts)                 {               &n ...Show All

• SQL Server Datetime format regardless regional settings

  Hi, in tsql there is a common format for datetime (regardless regional settings) I use : 'mm/dd/yyyy' to access cols in database, but someone says that the right one is: yyyy-mm-dd. Any suggestion about that Thank a lot hmm..works fine with me...the lowest date in northwind is..1996-07-04 00:00:00.000.. i get 0 rows for all the queries u mentiones...and 1 each when i use <= .. neways...wat do u want to achieve exactally....see 112 is the ansi date format, which shud be used for date conversion and comparisons as its the standard....select convert(varchar(10), getdate(), 112) ... yyyy-mm-dd +time is how sql server present it as.. ...Show All

• SQL Server SSIS to SAP Integration

  Hi All I am new to SSIS and my first task is to find out if there are any good third party/strongly recommended connectors out there to connect to SAP. Our goal is to get information from SAP using SSIS and run transformations on source data Thanks I would strongly recommend that you check out this tools: http://www.theobald-software.com/IS_EN/index.php If you do want to extract or import data these tools would be fine - if you want a kind of "real" interopability and a process orientation you should consider if SSIS is the right tool to use or if it would be better to use BizTalk. For a better understanding which tool you should use in which case this link should h ...Show All

• Visual Studio Team System Recator-->Rename won't let me change the case of an object name

  As above. I want to change the name of a column from "MyId" to "MyID". When i try and make the change it moans at me saying: "A schema object with the name [Column] dbo.MyTable.MyId already exists. Choose a differernt name."   This is a little annoying to say the least! I think this is a legitimate thing to want to do.   Another problem. My workaround was to change it to "MyID_" and then to "MyID" which it didn't moan at but after those two operations the column was called "MyId" again. Not what I wanted at all (although the SQL script has changed - it looks like its just hanging onto some metadata somewhere I guess). Are these bugs or by design Should I raise them at Connect -Jamie ...Show All

• Visual Studio Express Editions CreateFontIndirect Assertion in wingdi.cpp

  Hi could any one help me in this piece of code which is causing an assertion CFont* myBold = (CFont*) GetFont(); if (myBold) { LOGFONT lf; myBold->GetLogFont(&lf); lf.lfWeight = FW_BOLD; lf.lfHeight = 18; myBold->CreateFontIndirect(&lf); //causing assertion here in wingdi.cpp } Thanks in advance Kiran You can't create a font with a pointer that is already allocated. You need to call myBold->DeleteObject() before you call myBold->CreateFontIndirect You can then call SetFont(myBold); afterwards to apply the font changes. -Reza ...Show All

• Visual Studio Team System Email Notification in VSTS

  We have installed a visual studio Team Foundation (180 trail pack) on windows 2003 platform. The server is working perfectly fine with all the client able to access the server. But the problem is with "PROJECT ALERT" and mail notification. My project leader wants to have ticker mail to the developer when a new task is assigned to him or any changes are made to it. I am not able to generate any kind of mail nor are the project alerts working. Any help on the issue will be appreciated. Rohit, did you get chance to try Luis's suggestion There is more detail on checking smtp config and other things to check at: http://blogs.msdn.com/narend/archive/2006/07/27/faq-on-vsts-subscriptions-and-common-probl ...Show All