Nilesh Ingale's Q&A profile

• SQL Server Question about querying xml returned by eventdata() function in ddl trigger

  Hi All, I wanted to query the xml returned by the eventdata() function in a ddl trigger to view it in result set. I made that code but it returned null, any help please create trigger DatabaseEvents on database for ddl_database_level_events as --select eventdata().value('(/EVENT_INSTANCE/EventType/text())[1]','nvarchar(max)') declare @data xml select @data = eventdata () select Col . value ( '(/EventType/text())[1]' , 'nvarchar(max)' ) as 'Event Type' , Col . value ( '(/PostTime/text())[1]' , 'datetime' ) as 'Post Time' from @data . nodes ( '/EVENT_INSTANCE' ) as EventsTable ( Col ) go Thank you in advance, Bishoy The path expression ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Need Help With A load of stuff

  I need code straight code for XNAGSE 1.0 becuase i am working on xwing flight and i need sone stuff like, Anti-Alising x6 not x2 Motion Blur A tutorial on Lens effect if you can help please reply and NO I AM NOT A N00B Here's some stuff on Lens Effect: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1112676&SiteID=1 Motion blur: http://chronos.x10hosting.com/article/20/motion-blur-sample-hlsl ...Show All

• .NET Development Raise event when “Html <DIV>” Change data, Ajax purpose

  Ajax, When server send data to client html div, I want to raise a event or function automatically trigger once data arrive to “Div”. Something like “on change”. “OnAfterupdate” event only for datasrc it seems. Some one please help me to give a tip. Raise event when “DIV” Change data Or how to trigger a function automatically when the data arrives to “DIV” <script language="JavaScript1.2"> hex=255 // Initial color value. var inName=""; function fadetext(itemName){     if(itemName)inName=itemName;     if(hex>0) {  //If color is not black yet         hex-=11; // increase color darkness         document.getEle ...Show All

• SQL Server Confusion on Cube Design

  Hello everyone. I'm having a bit of trouble getting my head around designing a new cube and I'm hoping this forum can help. I have a database which contains the following simplified structure: tbl_Panelist: panelist_id tbl_Question: question_id tbl_Answer: answer_id tbl_Result_Set: panelist_id question_id answer_id I'm trying to design a cube which will allow analyzing of the counts of how many panelists answered each question by each answer. For example if Q1 has possible answers of A,B,C and Q2 has possible answers of X,Y, I'd like to be able to browse the cube and see X Y A 10 5 B 3, 2 indicating that 10 people answered Q1 with A and Q2 with X. My current thinking has been to create a ...Show All

• Visual Basic Irritating effect from combo

  I have got a form that I open, in the forms load event i do the following Me .EDF1TableAdapter.Fill( Me .DataSet1.EDF1) Me .ENameComboBox.Text = "" Me .ENameComboBox.DroppedDown = True Me .ENameComboBox.Focus() when the form loads, the combobox is dropdown and does have focus, but its got a mouse cursor showing wait it does go away after you click in the combobox if you dont dropdown the combo it does do it, why Davids Learning its working fine for now. didnt the first time I put it at the end Thanks for helping Davids Learning ...Show All

• Smart Device Development RAPI fails on Smartphone but works on Pocket PC

  In spite of the RAPI Security configuration being set to "allowed" I am unable to execute a function with CeRapiInvoke on a Smartphone device. It works properly on the Pocket PC device. CeRapiInvoke returns S_OK on the Pocket PC device, but returns 0x80090006 Invalid Signature on the Smartphone device. GetLastError returns 2148073478. CeRapiInit returns S_OK on both devices. I have the rapitest.dll file (my RAPI dll) in the Windows folder on both devices. I have tried this on both a real Smartphone device and on the Motorola Q emulator. Here is the relevant desktop code: WCHAR szCmd[cchSzMax]; LPTSTR szOut = NULL; BOOL fStream = FALSE; BYTE * pBuf = NULL; HRESULT hr; const WCHAR c_szDllName[] = L "rapitest" ; ...Show All

• SQL Server Sql Server 2000 to SLQ Broker - newbie question

  Hi! I have a legacy database in SQL 2000 which I want to submit transactions thru triggers to SQL Broker, until I eventually upgrade this db to 2005. Can you tell me if this is possible Thanks thanks Remus, However, I'm still confused. Reading MSN's site, it states any application than can submit T-SQL can utilize SQL Broker Any ideas Thanks Again Debbie ...Show All

• Visual Studio Express Editions They've Vanished?

  All of my menu items and toolbar items have vanished, all the code is still there, all the references to them are still there in each of the properties windows it's just that the icons are not there. Is there any way to get them back Has anyone identified the source cause of this problem, or is it just a bug I've experienced a similar problem as Graham twice now. One munute my menu items are present, and then they're gone. I'm not sure when it's happening, but I can telll you that I am NOT manipulating the menu during run-time - It's a static structure... (BTW - VS Hotfix KB920805 is installed) ...Show All

• Visual Studio Team System Install Visual Studio Team Edition for Database Professionals

  I'm installing the product under VS 2005 team edition for software developers but got the following message: Visual Studio 2005 Team Edition for Database Professionals trial edition requires Visual Studio 2005 Team Suite be installed before you install Visual Studio 2005 Team Edition for Database Professionals trial edition. I'm just wondering why we cannot install the product under VS team edition for software developers! How to upgrade VS team edition for software developers to Team Suite Thank you VST Data Pro is a separate Team Edition which in the trial version can not be installed without a prior installation of Team Suite. It is enough to install the trail version of Team Suite which is available from the MS d ...Show All

• Visual Basic CType exceptions

  I am working with vs 2003. I use the CType(, ) function a lot and have found that when needs to raise an exception it is very slow the first time it happens. As an example, try CType( "", DateTime) catch ... can take seconds to return the first time it is called after starting a debug session. If I then call the same thing again, it returns immediately. From this I gather that some code is being loaded. Is there some way to avoid this delay or force a preload of whatever is being loaded I am seeing this while debugging my project and I haven't checked for the delay using a release build, in case there is a difference. Your answer doesn't address my question. I used the CType("", Datetime) as an example. Most of th ...Show All

• Visual Studio Tools for Office Creating a URL (web link) that would create a calendar item

  Hi, I'm not sure if this is the right forum, but it is the closest one I found in regards to my question. I have a web app that sends emails. In those emails along with some text the app sends an appointment information such as who, when, where, appointment duration etc ... I can create a vcs file (VCalendar format) that contains all this information, click on it and the appointment appears in the Outlook calendar. My question is, can the information from the vcs file be formatted as a URL, so I could just place the URL in the email instead of generating the vcs file on fly, placing it on the server and inserting the url to the file in the email. Thanks. Cliff notes: want to have all the vcalendar info in the actual ur ...Show All

• Visual Studio Express Editions VB hangs on project load

  I have a problem here thats driving me insane! I was working on a project and VB hung itself. Now it's impossible to load the project, every time I load it it hangs. This happens on no other project only this one! Is there something wrong with the project, is it corrupt (after all of my hard work) or am i doing something wrong Please help me SP021, It seems that you meet a strange problem. Are you familiar with the CLR in .NET Framework There is a reference book called Applied Microsoft .NET Framework which describe the principal of .NET Framework. Generally speaking, there are so many problems cause the project load error, I can't get the enough information on your description and I don't know whether your project is fine or ...Show All

• Visual Studio Express Editions idiots code book

  hi everyone, i am a beginner to vb as are many who post here, i am putting together a book that explains all code statements and explains how they work and what they are doing better then some of the books i have read. i there is anyone who can submit their error mesages and solutions that will be great, also i will be posting all kinds of command questions as i have already done to others on other posts and i would be gratefull for yoiur explanation comments. i want to start with accept changes why do i use it and wehn dio i use it, what is it for thanks Ok, I've just decided to put my book online. It will take a while though. It's about 150 pages long and I need to convert it to html. ...Show All

• Windows Forms datagridview to xml

  Hi, I was wondering how i can overwrite an existing xml file when a row is deleted in datagridview with the data that currently is in the gridview The same data in an xml file are displayed in this datagridview. So i want to keep the xml file updated. This is what i got so far: this.grid.RowsRemoved += new DataGridViewRowsRemovedEventHandler(grid_RowsRemoved); private void grid_RowsRemoved(object sender, DataGridViewRowsRemovedEventArgs e) { foreach(DataRow dr in this.commands.Tables[0].Rows) { if (dr.RowState == DataRowState.Deleted) { this.commands.Tables[0].Rows.Remove(dr); } } this.commands.AcceptChanges(); } Can anyone help me with this Thanks in advance! -- modified at 9:30 Friday 15th December, 2006 ...Show All

• Windows Live Developer Forums How to customize the pushpin popup window

  Im a newb on this stuff I'm trying to convert a VEMaps program from version 2 to the latest. The problem I'm having is trying to manipulate the overall look of the popup window that comes up when you roll your mouse over a pin. In version 2 the developer used the innerHTML parameter of the AddPushpin method to add custom javascript code that would popup a custom window.. is there an easy way to do that in the latest version.. Version 2 AddPushpin method: AddPushpin(id,lat,lon,width,height,className,innerHtml,zIndex) Any help would be great Thanks Kirk I'm having a similar problem getting Javascript inside the popup window to run. for example if I try something like this: var detailsHTML = '<script>a ...Show All