badandy's Q&A profile

• SQL Server Update Statement for all Records based on value of last record

  Does anyone know how I could write a SQL Server 2000 Script that will read through all records in a table and based on the value in a column on the previous record, increment the value by 5, and update. I will need to have the first record have the column = to 5, the second record = 10, 3rd = 15 etc... all the way through the end of the table. thanks in advance for any help you may provide. I can give you the main pieces of this structure. The 3 main fields of this script would be Node_Identifier (KEY) char Node_Description varchar Display_Sequence numeric This table controls the way that ...Show All

• Visual Studio 2008 (Pre-release) Why not go one step further and allow persistence?

  I always wondered why the LINQ project does not go the extra mile and provide persistence to the LINQ project. DLINQ is a good step; but, from an OO point of view, one goes backwards: from a Database Schema to an OO Model. It should be from an OO model to the Database Schema, and the database schema automatically updated. I believe LINQ should provide that to be complete. :-) Call it LINQS (S=Save).   I assume you're not just storing blobs in the database I think there are a couple things you would need to answer: - Is identity management supported - Is change tracking supported ...Show All

• Visual C# datasets -- hide password information from the user

  I have a dataset that has 6 columns. Two of these columns contain passwords. I need to use these passwords for FTP purposes, but I would like the user to see only "****" when they run the program. How can I do this Yes, this dataset is bound to a datagridview. The response I got in another forum was to just hide the columns. The problem with this is if the user would like to add another row of information, they could not add the passwords since the columns would be hidden. I tried making a separate form for adding in new information, but am having some problems, so would like the user to just add their new information right to t ...Show All

• SQL Server Passing Parameters to Sybase

  I can't seem to pass parameters to a stored procedure in Sybase; I get 'An error occured while retrieving the parameters in the query. Unknown SQL Type - 28265.' Has anyone successfully done this Any advice would be well appreciated. Thanks! ...Show All

• Visual Studio Express Editions Microsoft Visual Web Developer 2005 Express Edition: Build a Web Site Now!

  Is this title still available for download I have downloaded and registered VB Express, C# Express, WebDeveloper Express, and SQL Server 2005 Express, but I don't see a link at the Registration Benefits Portal for this title. Thanks Hi! I'm not sure, but someone on the ASP.NET forums might know. The best place for asking ASP.NET questions is on the ASP.NET community site, and in the forums there. Check out http://www.asp.net/welcome.aspx tabindex=1&tabid=39 . HTH, PEte ...Show All

• SQL Server SSRS 2005 XML datasource & report subscription question

  I'm working to enable subscriptions on some reports that have an active directory web service as a datasource as well as a standard datasource to a SQL server db. I'm admittedly new to reporting services '05, but some research tells me I can't do the job with the current configuration. As the AD web service is an XML datasource, I'm not sure if I can pass an expression...and the reporting service manager won't let me store the credentials on the server...please help! I'll rebuild these things if I have to -- I just need some direction on how to build the reports so a subscription is possible and the data is specific to the user requestin ...Show All

• Visual Studio Express Editions Namespaces

  Could some one point me to a tutorial on how and more importantly when to use a namespace. My background is VB 6 so I am not familar with the concept. Thanks. A namespace basically is a partition.  For example, the app I write is fairly large, and I use a different namespace for each discreet part of it.  I also had to do a lot of code to talk to a number of similar programs, so I create a namespace for the code to import from each program, so that within the namespace I can have names like DataImporter, instead of AvimarkDataImporter, etc.  Basically, by creating partitions, you limit which ...Show All

• .NET Development WebClient.UploadFile (or WebRequest) with larger files

  I have a utility to upload files to my web site. I actually have two chunks of code I'm testing with, one which calls WebClient.UploadFile and the other which uses one of the WebRequest approaches to upload the file bytes. With a smaller file (say, 50k'ish) either approach works just fine. With a somewhat larger file (say, 400k'ish) I'll get timeout errors. I'm unlikely to be uploading anything larger than half a Meg. The WebRequest code is very similar to stuff you've all seen; open the fileStream and read/write 4k chunks to the requestStream. If I set a breakpoint inside the read/write loop, I see it consistently makes it to just over 20 ...Show All

• Visual FoxPro Connect to Outlook Express and Microsoft Outlook

  Dear Expert, Can I know how to connect to the Outlook Express and Microsoft Outlook using FoxPro Like the data in a memo feild how I connect or send out using the Outlook Express and Microsoft Outlook Or Can I generete email using FoxPro Thank you.     Outlook Express Not directly. It is not a COM Server MS Outlook Yes through COM Automation. You take a reference with oOutlook = CreateObject("Outlook.Application") and then you have complete control of its object model. You can use an Object Browser and Intellisense to inspect the DOM. ht ...Show All

• Visual Studio 2008 (Pre-release) BasicHttpBinding Security

  Anyone here mind delving into the various forms of security available when BasicHttpBinding is used on the service side, and the client is a Pocket PC app utilizing ASMX on Compact Framework 2.0 I've read about all these great possibilities when using WSHttpBinding, etc, but nothing in tune with BasicHttpBinding. Are there any reliable security scenarios available, or am I just going down a dead end street Thanks. Hey Timmy, I think the more sticky problem you have is with the ASMX model on CF/PPC. In a desktop / server scenario, at least you have WSE3.0. There is nothing "officially" ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. drawing circles

  hi guys,               could u tell me how to draw a circle  around a perticular object in the world     sorry guys , again iam asking same question because iam a 4 months buddy to directx   iam drawing a circle in the world  around a perticular object. which should be scaled  or  rotated dynamically. e.g  the circle is around the object , if i drag or rotate the circle with mouse the object should rotate  of scale or move int the world.       some of answers posted here are ...Show All

• Smart Device Development "\Windows\wceload.exe", "/noaskdest/noui ?

  Hi, I am installing cab file of my application using wceload.exe. While my application already exist it gives message "My application is already installed.Reinstall I should not get this message and the application should silently installed.I tried using Rapi class of Opennetcf.Desktop.Communication as shown below.   Dim m_rapi As New RAPI m_rapi.CreateProcess("\Windows\wceload.exe", "/noaskdest/noui \Windows\MyApp_PPC.ARMV4.CAB") But still i am getting the message .So how can i prevent it Regards, Senthil. If that's exact command you're using there's a space missing between /noaskdest and /nou ...Show All

• SQL Server 100 SQL Databases

  Hello, Can someone show me the TSQL I need to write in order to create 100 SQL databases in one go. I want them to be called DB1, DB2, DB3, DB4...etc etc I know how to create one database; --------------------------------------------------- USE MASTER GO CREATE DATABASE DB1 ON PRIMARY ( NAME = DB1_dat, FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\DB1.mdf', SIZE=4, MAXSIZE=10, FILEGROWTH=1 ) ------------------------- But I don't want to do this 100 times, Thanks in advance ICW You will have to use dynamic SQL to execute the parameterized CREATE DATABASE statement in a WHILE loop. Search in Bo ...Show All

• Visual Basic Can not save project with vb.net 2005

  Hi, I can not save my project. I dont know how to fix it. The error: szAppName: vbexpress.exe szModname: hungapp szModver: 0.0.0.0 offset: 0000000 Win xp, sp2 Pls help. thanks Did you uninstall all previous versions of the .NET framework before you put VB Express on If not this may be the cause of all your problems. Uninstall all versions of VB and .NET framework then install the latest .NET framework then VB Express. ...Show All

• .NET Development Web Service that returns a DataSet Class

  Hi,        I want to return an object of a class that is inherited from dataset from my web service I am sure this is possible because i have seen web services like this but never got chance to look in to the code . I know it is straight forward to return data set like: DataSet ds=callwebservice.GetDataSet(); but i want my web service to return an object  like SomeClass SC=Callwebservice.GetDataSet(); please let me know if any one has any idea. Thanks in advance. You can definitely do this, but before you do, I recommend you read: http://www.hanselman.com/blog/ReturningDataSetsFromWebServicesIsTheS ...Show All