netweavernet's Q&A profile

• SQL Server Primary Key Auto Increment

  Hi, my table's primary key is int(4), auto increment with the seed 1, if I got 3 data inside, means the id should be 1, 2, 3 id fname lname ============================== 1 Stephen Saw 2 Ali Baba 3 ABC DEF suppose new record will have id of 4. Let say I deleted data with id 3, before adding new record, the new id will be 4 instead of 3, how can I made the new id to become 3 instead of 4 after delete the id 3's data. Is it possible to insert new record with id of 2 if I delete the Ali's record, but it will continue with id 4, or is there any method for me to reorder the id Thanks in advanced. u can do it , but its not a ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Unnormalized BasicEffec lights

  I have a cube using basic effect, and it seems that the magnitude of the direction vector for a diffuse light is proportional to it's intensity.  I was wondering if this is the intended behavior (that we always have to normalize light directions before setting them in basic effect). I.E., here is how I set up the effect (the model has only one effect): basic = ( BasicEffect )model.Meshes[0].MeshParts[0].Effect; basic.World = Matrix .CreateTranslation(5, 0, 0); basic.View = Matrix .CreateLookAt( new Vector3 (0, 0, 20),     new Vector3 (0, 0, 0),     Vector3 .Up); basic.Projection = Matrix .CreatePerspectiveFieldOfView(     ( float ) Math .PI / 4.0f,     ( float )g ...Show All

• .NET Development net framework admin

  Ok I am a novice user who was trying to download new drivers for my video card and need a new net framework so I downloaded net framework 3 onto my laptop. Problem is that it is telling my I have to be in admin mode to download driver. How do I get into admin mode from my laptop Please remember novice user but I would be very greatfull for your help. admin mode to download driver doesnt seem like a .NET issue to me but rather a driver thing. Be sure you are logged into the administrative account on your laptop. Be sure you have administrator priviledges to install software ...Show All

• SQL Server Problem with Dependencies and Default Values

  Dear Anyone, Im having trouble with RS2005 with regards to dependencies of report parameters and the default value. Below is my scenario: 1st parameter: List of Letters from A to Z Multiple Select 2nd Parameter: List of Names starting with the last name Uses 1 data set for list of values and default values Multiple Select Steps: Select 2 letters from the 1st parameter. This action would refresh the list of values of the 2nd parameter. Inspect the 2nd parameter. You will notice that all values are selected. Select another letter from the first parameter. This action would refresh the list of values of the 2nd parameter. Inspect the 2nd parameter. You will notice that not all is selected desp ...Show All

• .NET Development how to get datagrid dropdown selected value

  hi i created dropdownlist dynamically. i have drop down list in mydatagrid. and i loaded my database values in that and if i select any value from that dropdownlist it has to be shown in my textbox wthich is some where in my page. i am using c# asp.net(i need in server side) i need coding to do this ...Show All

• Smart Device Development What kind of server required?

  I am a newbie in WM5 application. I have a problem: My company needs me to setup an application so that the smartphone can constantly access the server and retrieve data... I have explored many about WM5, but it said little about the system archeticture... I may need to retrieve data from database and file... What kind of server do I need Is Microsoft Server 2003 suitable Do I need to install IIS Is Web Service the only method for the mobile to retrieve data from server What hardware / software I need to pay attention Pls advice... I have been hunting this for weeks but seldom found... When running the PPC 5.0 emulator and follow the web service example here: http://blogs.msdn.com/mohitgog/archive ...Show All

• Windows Forms Setup Project, Custom Actions Editor

  Hi, I'm using visual studio 2005 beta 2. I created setup project and in the Custom Actions Editor I added a vbs file. This file is using the WScript.Shell Object. When I run the setup.exe on the target computer (windows xp sp2) I get the error message: "There is a problem with the Windows Installer Package. A script required for this install to complete could not be run. Contact your support personal or package vendor." If I just copy the .vbs file to the target computer and double click it, it's working fine. If I use the script without using the WScript.Shell Object it's working fine. The lines which make my troubles are:    dim obj    set obj = WScript.CreateObject("WScript.Shell") Any idea  Th ...Show All

• Visual Studio Express Editions Default Form Background Colour

  Hello, I'm relatively new to coding and have stumbled across e.graphics. My question is, if i use e.graphics.clear, what is th default background colour for the form Will I have to make my own colour and if so, what are the argb values Is There an easier way Put the Clear() call before the DrawString() call and it will work a lot better. There is still a bit of flashing, it will take removing Clear() to solve that (hint: draw over the old text). ...Show All

• Internet Explorer Development BUG in IE7 HTML table implementation

  I can't seem to get rid of the extra few pixels of white space at the bottom of each table cell that contains an image. The page displays how I want it in Firefox: http://i20.photobucket.com/albums/b243/parsophie/firefox_page.jpg but the problem only occurs in IE: http://i20.photobucket.com/albums/b243/parsophie/ie_page.jpg I have tried adjusting heights, padding, margins etc. values, but I haven't found a solution. Has anyone had a similar problem and/or could help me Thanks This looks like a bug in the microsoft implementation of HTML table formatting. Firefox seems to have implemented this properly, but IE7 hasn't. Am I right, or what ...Show All

• SQL Server Stored procedure issue. a bridge too far for me

  i have a query that i need to extend but just dont have the knowledge to do so, so hoping someone here could help me this is my current query:- SELECT ES.PatientID, DATEDIFF(day, EP.DateofBirth, GetDate())/365 AS Age, CASE EP.SexCode WHEN 'M' THEN 'MALE' ELSE 'FEMALE'END AS Gender, COUNT(H.HRDID)AS HRD, ES.FourRegularDrugs, isnull(ES.FourRegularDrugsNo,0) as NoOfDrugs, ES.ReadmissSixMonths, PCE.[Primary diagnosis] FROM tblStudyServices ES INNER JOIN tblPatient EP ON EP.PatientID = ES.PatientID INNER JOIN PAS.dbo.[PAS Patient Details] PP ON PP.[PAS key] = EP.PatientInternalNumber INNER JOIN PAS.dbo.[PAS Admission Details] [PAD] ON [PAD].[PAS key 1] = PP.[PAS key] INNER JOIN PAS.dbo.[PAS Consultant Episode] PCE ON PCE.[PAS key 1] = PA ...Show All

• SQL Server SQL SERVER 2005 ENTERPRISE EDITION installing problem on vista ultimate RTM

  when i was installing   ss2005  i got two warnings: - SQL Server Edition Operating System Compatibility (Warning) Messages SQL Server Edition Operating System Compatibility   I-IS Feature Requirement (Warning) Messages IIS Feature Requirement then in the next step ,there was only one option i could choose(workstation components,books online and develop tools), all the services were grey and not selected ,here 's the log file Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version      : Professional  (Build 6000) Time            : Wed Dec 06 13:01:54 2006   TJM-PC : The current system ...Show All

• SQL Server Problem connecting to Distributor after coming back on-line

  I have a Merge-Pull subscription setup on a laptop running SQL 2000 synchronizing with a SQL 2005 database. For the most part everything works fine. However, when I take the laptop off the network for more than 10 minutes and then reconnect back to the network, I see the following status message for the synchronization agent: The process could not connect to Distributor 'OurServer\InstanceName'. Specified SQL server not found. NOTE: The step was retried the requested number of times (10) without succeeding. It seems that the agent never picks up and starts again once this occurs. Is there a "best practice" for handling this situation For example, is there some way to tell the agent to auto-start once a network conne ...Show All

• Visual C# directoryentry

  hi i have a problem with the first argument of this methode directoryentry.Invoke( ); where can i find the methodname that i should post as the first argument what the available methodename hi all my dear friends: i was tired of trying all the ways and see the same exeption . please take a look at my code , that i use to add a user to active directory : DirectoryEntry de = new DirectoryEntry(" LDAP://192.168.0.1/cn=Users,dc=soheila,dc=org ", " Administrator@soheila.org ", "sohama3t", AuthenticationTypes.ServerBind); DirectoryEntry de2 = new DirectoryEntry(" LDAP://192.168.0.1/cn=Administrator,cn=Users,dc=soheila,dc=org ", " Administrator@soh ...Show All

• .NET Development What Trim function do i use??

  i have this string 2004-07-31 00:00:00.0 i want to trim the underlined text off so that it only shows 2004-07-31....I used the TrimEnd and passed it an char array but that did not head the results i needed...any help on how i should do this Tryin2Bgood wrote: I found this cool function String.Remove(10, 11) that did it for me...thanks 4 the help lol one of many it seems .. glad you sorted it though :) ...Show All

• Visual Studio 2008 (Pre-release) Integrating AJAX with WPF

  Hi all, I want to know whether it is possible to Integrate AJAX with WPF, or any information regarding that. Prajakta Hi Chad Thanks for your reply.That was a help, I need to integrate AJAX with a specific WPF application, i will investigate in that prespective .If you get any further clues do reply me back. Prajakta, ...Show All