m.shuhrat's Q&A profile

• .NET Development create, read & write in XML file...?

  Hi... I dont know much about XML.... In my application , I want to make a XML file & then after reading the contains of that XML file , i have to edit those contains using my application. Can anybody give me any link which will help me for this... Thanks & Regards, Vinay Hi... I have a added a .xml file using VS8's add new item option... I wrote some lines also in it...but its giving error as - Invalid token 'Text' at root level of document. here is what i added in my xml file...what is the problem... I am getting error on the 3 rd line… ( - < VMT >) of this xmlfile which I wrote… //////////////////////////////////////////////////////// ...Show All

• SQL Server SSIS Excel import

  In SQL Server 2000 DTS there is an Extended Connection properties window that you can set the IMEX property for importing Excel spreadsheets into a SQL Server table. Does anyone know where this is in SQL Server 2005 SSIS Thanks, The way to add the option is as follows: Add an Excel Connection Manager to the package. Selecting a sample file. Create a parameter at the package level called ConnectionString and assign it the value: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<FileName>;Extended Properties="EXCEL 8.0;HDR=NO;IMEX=1"; Replace <FileName> with the fully qualified (ie path and filename) of the sample Excel file from 1. In the properties for the Connection ...Show All

• SQL Server Long duration Pre-Execute phase

  Does anyone know why SSIS sometimes just sits in the Pre-Execute phase of a data flow and does nothing It doesn't matter how elaborate the data flow is or the volume of data. It can sometimes take 80% of the task's run time. Are you able to monitor activity on the source system Perhaps the problem is there. A shot in the dark - perhaps the problem is the one documented here: http://blogs.conchango.com/jamiethomson/archive/2006/02/21/2930.aspx Just a thought!!! -Jamie ...Show All

• Smart Device Development Windows Mobile 2005, keyboard

  I have to write an application, which should work in background, gather keyboard data, and send the new key codes to the foreground window. It is needed for input of cyrilical letters. Keyboard hooks are not working. Can you advise a solution Thank you. I have already used the sample given in the link above but I get "not supported exeception" on the line where SetWindowsHookEx is called. I executed it in Windows Mobile 5.0 Pocke PC emulator. I assume this means Hook is not supported. Can u provide any info on this. ...Show All

• SQL Server What SQL Server version should I use to develop on and install on a client pc for a winforms app?

  Hi all, I've finally received my first official assignment using vb.net and SQL Server. I have been developing / learning with both on the express editions. I've also just run into some issues trying to access a SQL Server 2005 Express .mdf thru SQL Server 2005 Pro. We just couldn't get it to open. Connecting or Attaching etc... We had to install SQL Server Express on the other PC to get it to open the SQL Server 2005 Express .mdf. --- Now that I am ready to develop in ernest, I would like to setup my own controlled development environment. Our target is a winforms application with a SQL Server 2005 Database for WinXP or Vista. I'm ready to purchase Visual Studio 2005 Pro once I figure out the best development en ...Show All

• Community Chat Buying questions about Zune

  Hello! I am considering getting a Zune (I have no music player at the moment, and am willing to give Microsoft's music player a shot), but I am very concerned about it being a "1.0" product; how much upgrading can Microsoft perform on the Zune through firmware/software upgrades before Zune 2.0 is released (I guess I'm concerned about plunking down $300 for a music player this year, only to see a new, improved version of Zune come out next year...) Specifically, I am wondering if the list of supported video and audio formats will ever be expanded through firmware and/or software upgrades, or if those will require a new Zune product... I am primarily interested in listening to my CD collection (the subscription service doesn't interest ...Show All

• SQL Server Wrong Totals in Calculated Measure

  Hi, I am using SSAS 2005 and the backend relational database is Sybase. We have a very very huge number of rows daily. The dimensions itself contains about 100 attributes. I created calculated measures using the 'calculation' tab in BI studio. The calculations contain an IIF condition and arthimetic addition's of two or more measures. The formula can also contain another calculated measure created similarly. These calculated measures are viewed on a natural hierarchy, like country,state,city.etc. Although the lowest level granular row values of the calculated measure are perfectly correct, the Totals of each level in the hierarchy column at the bottom displays incorrect values. For some the value is displayed as zero (0) or ...Show All

• SQL Server PIVOT sql_variant into underlying dataypes

  Does anyone know of a way to PIVOT an sql_variant column so that the resulting columns will be their proper underlying datatypes I wish this to be done in a View. I currently do this by hard coding the conversion as follows: SELECT A, B, C MAX(CASE Letters WHEN 'D' THEN CONVERT(int, LetterValue) ELSE Null END AS D, MAX(CASE Letters WHEN 'E' THEN CONVERT(datetime, LetterValue) ELSE Null END AS E, MAX(CASE Letters WHEN 'F' THEN CONVERT(varchar, LetterValue) ELSE Null END AS F FROM Alphabet GROUP BY A, B, C I would like to take advantage of the SQL_VARINIANT_PROPERTY(LetterValue, 'BaseType') function so I do away with the hard coding. Any ideas Jim: Is this the transformation you are looking fo ...Show All

• SQL Server KB 920346 - Incorrect JOIN used by query optimizer

  I wanted to check if anyone has experienced query optimizer choosing incorrect joins in sql 2k5 server. I have noticed that despite of applying the SP2 (which contains the fix described in KB 920346), my multi join query uses nested loop join instead of hash join, While this does not seem to be the problem with sql 2k. Also to note that I have tried updating statistics on the DB Below is the query I am using: SET STATISTICS PROFILE ON SELECT t.state, UPPER(ex.router_clli), ISNULL(r.bmf_clli, ''), r.vendor, r.model, t.interface_key, ex.interface_name, ISNULL(rpd.circuit_group, ' ') AS circuit_group, ISNULL(rpd.circuit_type, ' ') AS circuit_type, ex.utilization, ex.limit_value, ex.exhaust_date, exhaust_date_displ ...Show All

• Visual Studio MSBuild AfterOnBuildSuccees???

  Hello out there, I have a pretty simple question. I already implemented the AfterOnBuildBreak target where an email is sent to all the changeset users. Now I would like to implement something like 'AfterOnBuildSuccess' to Inform the in an XML file stored changeset users that the Build was successfully completed, but I can't find any target in this direction. The only things I found is stuff for a TaskFailure but that seems not useful for me...   I would appreciate any help... Bye   TheRolle Try asking this on the Build Automation forum: http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=481&SiteID=1 I can move this thread, but I'm not sure if you'll find it again ...Show All

• Visual Studio Team System Problems using <SetVariables> in various places

  Maybe I'm asking for too much, or trying to leverage too much abstraction and cleaningness from SQLCMD-Variables, but here are my findings so far. Maybe someone can shed some light on this: MSBuild vars in SQLCMD-Vars are NOT resolved, if they are placed in the (local) .user file. Having multiple <SetVariables> blocks within .user and .dbproj file seems to cause problems to team-build. The same goes for comments between <Variable> items. I've set the value to a couple of test-variables in various places to try to understand what TeamBuild/MSBuild and VS does, but I can't seem to get a consistent result. I then created multiple <SetVariables> blocks with a comment above it to organize them a bit (yes, I use quite ...Show All

• Visual Studio Express Editions End, Stop, Application.exit coming up with compile errors..

  Yes, I know this is probally a noob question, but...Does anybody know why end; , stop; , and application.exit; wont' work It comes up with a compile error, would what I have (or don't have) in Using effect anything. I'm just moving from visual basic 2005 to C Sharp, and I need enough knowledge to be able to convert one of my big vb games to C sharp. So right now I'm just trying out different statements, and stuff, seeing how it works with C#. Application .Exit; Error Output: Error 1 Only assignment, call, increment, decrement, and new object expressions can be used as a statement. C:\Users\Shaun\Documents\Programming\Visual Basic\Current Project(S)\FirstProject\FirstProject\ ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Designing C# & XNA games

  Hi I'm currently learning C# from a couple of books with the sole aim of being able to use XNA.  I have just a couple of questions: At the moment I focusing on console (DOS like),OOPs, and so on.  With XNA, is there any point in learning Windows Forms programming   Also, I found that understanding & following game code is one thing but being able to design a game (or any program) is another thing entirely.  It's hard to code without some higher level plan or visual aid.  Are there any techniques or affordable software available that game designers use in the design process.  I've heard of things which might be applicable, such as :- Psuedocode, UML process diagrams, he ...Show All

• Architecture Implementing DTO's in.Net

  Hi, Can anyone suggest some good approaches to build Data Transfer Objects using .Net custom classes. Also would like to make them bindable friendly. Meaning when I have an array of entities and would like to bind the same to a datagrid. what interfaces do I need to implement to make it bindable to the datagrid. Thanks Sai First you should definately read Martin Fowler's Patterns of Enterprise Application Architecture if you have not already - there is a whole pattern/chapter on DTOs with example implementations in Java. The Java code is easy to understand and translate into C# or VB.NET. Since the DTOs are just data holders you might be tempted to just create a class with some public members. For da ...Show All

• SQL Server Sql Permission

  What's Defference between Control Server And SysAdmin Role The easy answer is consider CONTROL SERVER and SYSADMIN as equivalents, do not grant CONTROL SERVER to somebody you wouldn't add as a SYSADMIN. In SQL Server 2005, the difference is basically that all permissions (including CONTROL SERVER) are subject to the same GRANT/DENY/REVOKE rules (i.e. if while evaluating if it is possible to take an action, if there is any denied permission it will take precedence over a granted one), while role membership of SYSADMIN will cause that the principal will not be subject to any permission check (i.e. denied permissions are bypassed). I can think of a few behavioral differences are: ...Show All