sanjeevm's Q&A profile

• SQL Server SQL 2000 DTS Package owner.

  Can a SQL 2K DTS package be 'owned' by a SQL Server Standard Login ...Show All

• SQL Server Is SQL Server CE really the solution?

  Hi,   So far, with other programming platforms, I used to have the facility, embedded within application .exe, to:        1- Interface with already existing "multi-user" database (ex: Oracle, Access, etc.)        2- Create/access "local"/"Single-User" files for processing purposes.  (try to minimize network trafic...)   So far, I've read a lot about SQL Server products (SQL Server, Sql Server Express, SQL Server CE), at least all articles I could find, and would like to have your opinion on what would be the best approach        1- What SQL version to use for "multi-user" databases &n ...Show All

• Visual Studio I need the header to appear on next page

  Hello, I need the header of the table to appear on the next page when my report contains multiple tables (grouped by a certain field), and for example the data of last table on one page is continued on the next page, then the header does not appear for that table on the next page. can anyone help me thanks Thanks for that info Melody. A Friend of mine that used to live in West Palm built some databases for me and unfortunately she left the area as I did. ...Show All

• Windows Forms Editing tables without Primary Key

  Hello everyone. I am trying to work with a database in C# 2005 Express. One of the tables in that database doesn't have a Primary Key. However, it has a unique Foreign Key associated with each row. How can I select any particular row for editing on that table Its easy to select and edit tables which have a Primary Key by writing something like: dataset.TableNameRow row = dataset.TableName.FindBy(PrimaryKey); row.BeginEdit(); . . . row.EndEdit(); But how can I select and edit a row from a table which doesn't have a Primary Key Thanks in advance, Ashish i dont think you can actually access a row with no pk if u can't reference it.. if it is in a dgv maybe then but i havent tried it is good practice to keep an index or sum ...Show All

• SQL Server Two attributes in one dimension: One on row axis / One on column - how to hide empty values (ShowEmptyVals of PivotTable = true)

  Hi dear MS Developer and users of this forum, i have one little question (AS2005): I've created a dimension "Clients", it has two dimension attributes: "Clients" and "Industry line". Now I have in my fact table this entries: ---------------------------------------------- Client Sales Amount A 100 $ B 200 $ C 300 $ ----------------------------------------------- Dimension table "Clients" Client Industry line A 1 B 2 C NULL ----------------------------------------------- Name Columns of Attribute "Industry line" are taken from this table: Ind_line Name 1 Cosmetics ...Show All

• SQL Server Mobile merge simple question

  So when a mobile device pulls down information, say a typical order entry scenario, then continues to edit/add orders and merges those changes back to the server, when/how are those records ever purged from the device once they are no longer needed They aren't. The meta data which tracks the changes is, but the actual data rows aren't. -- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.   This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions.   Looking for a SQL Server replication book http://www.nwsu.com/0974973602. ...Show All

• Audio and Video Development Multilayer video

  Hi, I am a newbie to windows media programming. Now the functionality that I want to achieve is I want to add the image file like channel symbol in the video which will be shown in the video as second layer. Please let me know how can I achieve this functionality. Any help is highly appreciated. Regards, Nis Check out the various Windows Media newsgroups for your question: http://www.microsoft.com/windows/windowsmedia/community/newsgroups/WindowsMedia/default.mspx d=1 ...Show All

• Visual Studio Express Editions Help a dude out...please

  Im very new to programming, but I have the passion to learn. I am looking to make a program where you can type in "somthing" and press a button and place/replace that text in a specifyed file. This probably sounds confusing, but my goal is to make a program for a game that lets you easily customize it without trudging through all the files yourself. I know some basics, but if someone could please point me in the right direction that would be great! Thanks, Matt Hey thanks for the help, but I am very new to programing and what you were saying is a little over my head. Where would I insert that code In the button Text box Also...where would I specify the file I want in that code Haha, I feel stupid right now.. ...Show All

• Visual C++ Won't jump to ErrorList when building

  Hi, When building my C++ projects in VS2005 and having errors and warnings, the IDE will not jump to the ErrorList window when done, it stays on the output window. The ErrorList is docked together with the Ouput window (and some other windows). I've seen this work on other computers. Any ideas why it's not working on mine /Mikael   Mikael Pahmp wrote: the IDE will not jump to the ErrorList window when done, it stays on the output window .... I've seen this work on other computers. Any ideas why it's not working on mine I haven't seen this happening automatically. You can write a macro to do this though e.g. Sub RebuildSolutionMacro()     DTE.ExecuteCommand( ...Show All

• Visual Studio Visual Studio 2005 Service Pack 1 Beta

  Has anyone else tried to install the beta of Visual Studio 2005 Service Pack 1 Just running the setup program hogs my machine. It literally took over an hour, maybe more, for the message box to come up asking me if I wanted to install it. I tried it around 4:15pm yesterday and since it was still going even past 5pm I just left work figuring it would be installed by the time I came back in the morning. Well, I'm back and all I see is the message asking if I want to install. I say yes and then a few minutes later it comes back saying I have to uninstall the Web Application Projects addon because the release version is included in the service pack. Great, I hit OK and now I have to start all the way over! I've never seen an install program h ...Show All

• Windows Forms "Like" Clause is Not Working Using VS and Access db

  I am trying to pull some data in VS2005 from a Microsoft Access 2003 database. I build my own SQL with a "Like" clause. I have tested this SQL in Access(with and without the "Like" clause) and it pulls data but will not pull data via VS. Is there something special that I need to do to use the "Like" clause Here is the SQL "Like" clause: WHERE MANUFACTURER Like '*JOHNSON*' Thanks, cj ...Show All

• Visual Studio Express Editions Action on Click Error

  Hello, I have a form in my program with a short datagridview (Meaning not all information is there). I would like to be able to click on a row in the datagridview and open another form, which would then be populated with all the information from the database for whatever contact was clicked on in form 1. I have everything in an MDIParent. Here is the code that I have: CustDetail newMDIChild = new CustDetail(); newMDIChild.MdiParent = this; newMDIChild.Show(); I am getting this error: No overload for method 'CustDetail' takes (0) arguments. Any help would be greatly appreciated. I can't seem to get the onclick function to work.... Thanks... What you need is CustDetail newMDIChild = new CustDetail( her ...Show All

• Visual Basic Built-in Function for finding out the Number of Lines In a Text File

  Hi, In my application , I'm having a requirement to find the number of lines in a particular text (.txt) file. Is there any built-in File-Handling function to do this Or can we read the content of the file to a string variable and then is there any String manipulation functions to find out the number of lines in a file. Or , there is no other go , we should only have a loop and then find out the number of lines in using some logic. But by doing so , in case of a large file may degrade the performance of the application. Kindly suggest me some solution for this ! Thanks in Advance, Lokesh R to find the number of lines in a file, I believe you would need to read it line by ...Show All

• .NET Development How to change the application priority

  Hello, i would like to change my app (main thread) priority. So i tried to: System.Threading. Thread .CurrentThread.Priority = System.Threading. ThreadPriority .AboveNormal; However if i run Task Manager, with priorities listed, no change is visible (priority remains normal). What am i doing wrong, please Thank you. I'm feeling really lazy to write right now so please have a look on it yourself here: http://www.cafeaulait.org/course/week11/02.html http://www.google.com/search sourceid=ie7&rls=com.microsoft:en-US&ie=utf8&oe=utf8&q=Process+vs+thread Best Regards, ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA help

  Hi, I'm reallly new at XNA but i was wondering, after I have coded my game and want to test it on my 360 how do I get it to my 360. Do i need like the XDK for the 360, or do i jsut FTP, or do i have to have my 360 hooked up to my WindowsSP2 computer. I know how to write C# (kinda im still learing) but i just can't figure out how to get the gam to my 360. please help Dootuz I don't think you can do that just yet. I thought I read that the tools to port it to XBox will be ready later, but not yet in this stage of beta. ...Show All