Batikit's Q&A profile

• SQL Server SQL Server

  What are the different method to add security to sql server database WHat do you mean by that, in terms of administration liek the GUI or TSQL commands or security on object level or data level HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server ParallelPeriod MDX function not working

  I created a calculated measure called [Previous Year Percent Rejected]. I used the following expression: ( ParallelPeriod ([Year],1,[Time].[Time Hierarchy]. CurrentMember ),[Measures].[Percent Rejected]) The syntax checks out fine. However, when I try to use the calculation, I get an error message -- with a #VALUE! in the column. The error message reads " The parallel period expression expects a level expression for the argument. A hierarchy expression was used." I tried many different variations but I'm always receiving the same message. Any suggestions David If you're using AS 2005, the problem could be that there is also an attribute hierarchy associ ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. newbie question:spacewar, how to make it 1player

  Hi all, new to XNA. and starting with spacewar. I have read the FAQ, set it to keyboard since I'm using a PC. Now, how do i play it as a single player game Whenever I start its as two players controlled by the same PC keyboard Any easy way to change the settings If anyone remembers an old 80's arcade game, gravitron. Was thinking of using spacewar a starting point to make that game. thanks for any help It doesn't make much sense to make spacewar 1 player - there is no AI for the other player so the ship will jsut keep crashing into the sun even if you detached the keyboard from player 2. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=690745&SiteID=1 shows you how to give ...Show All

• Visual Studio Tools for Office How to get VSTO running with Visual Studio 2005?

  Hi, I have problem getting VSTO to work with VS 2005. I installed several times but i still dont see the "office" subtree when creating a new project. I installed in the following order. 1) Office 2003 Professional 2) Update Office 2003 to SP2 3) VS 2005 4) VSTO addon (vstor.exe) Then I also tried not updating to SP2 after browsing a few forums but it is still not working. Is there anyway to solve it Or is there an incompatibility with the version of software I am using Please help me, i have sleepless night because of this simple problem ( uninstalling and reinstalling take hours). Hmm, is vstor actually a runtime only Does this means I have to purchase the whole product Visual Studio 2005 Tools ...Show All

• Visual C++ msvcprtd.lib(MSVCP80D.dll) : error LNK2005

  I am having problems to port our product from vc7.0 to vc2005: Linking... LINK : warning LNK4076: invalid incremental status file '..\..\..\bigworld\tools\worldeditor\BigBang-debug.ilk'; linking nonincrementally msvcprtd.lib(MSVCP80D.dll) : error LNK2005: "public: __thiscall std::allocator<unsigned short>::allocator<unsigned short>(void)" ( 0 $allocator@G@std@@QAE@XZ) already defined in edgizmo.lib(solid_shape_mesh.obj) msvcprtd.lib(MSVCP80D.dll) : error LNK2005: "public: __thiscall std::allocator<unsigned short>::allocator<unsigned short>(class std::allocator<unsigned short> const &)" ( 0 $allocator@G@std@@QAE@ABV01@@Z) already defined in edgizmo.lib(solid_ ...Show All

• Software Development for Windows Vista WinXP and CardSpace problems still not addressed.

  Hello CardSpace Crowd, I am working very much part time on integrating simple PoC that uses Liberty Alliance with InfoCard being provisioned instead of anything else. In order to do some work have to have CardSpace from user perspective working i.e. working wallet. Unfortunately it doesn't work for me, no matter what I try. I have Installed extension for FireFox and IE7, .NET 3.0 and it always crashes once wallet applet displays or rather tries to display the content. So if I open Card Space from within Control Panel it crashes throwing 'Class not Registered' exception and I have no way of debugging it, as I am out of my depths when it comes to .NET and Win. When I try to install any card (https://www.xmldap.org/relyingparty/ or http://lab ...Show All

• Visual C# cannot select the row

  How do i select get the row number when i select a row. For example, i select row 3 .. How how i get the value 3 Anyone can help THis is my code, but it doesn't work GridViewRow row = gvReceive.SelectedRow; if (e.CommandName == "SerialNo" ) { lbl1.Visible = true ; lbl2.Visible = true ; lblProdNo.Text = rowCells[2].Text; txtSerialNo.Visible = true ; } hi Row index is start from 0 DataGridViewSelectedRowCollection col = dataGridView1.SelectedRows; DataGridViewRow row = col[0]; row.Index ...Show All

• Visual Studio Team System The DB name of the build file doesn't reflect the current name of the deployment DB

  The DB name of the build file doesn't reflect the current name of the deployment DB, i setup up the name of the DB in the Build properties and build the name is correctly reflected in the name of the build file : file:///F:/Databases/Millena/Brylane02/Brylane02/sql/Brylane02.SQLDEV.Brylane02.sql if i change the database to QADEV and save the configuration and reissue the build the name remains the same. This is important since we relay on this to tell us wich server to deploy this build. Rafet In addition the DB Name in the build setting is ignored and the deployment is pushed to the server the project was opened with. In order to get the build to go to another server you have to close the proje ...Show All

• .NET Development CompilerOptions.

  I am trying to use the C# CodeCom provider and in particular I find two options, one that specifies the "ReferencedAssemblies" and one that specifies the compiler options ("CompilerOptions"). If I specified the full path to some of the .NET 3.0 assemblies like: cp.ReferencedAssemblies.Add( "System.dll" ); cp.ReferencedAssemblies.Add(@ "C:\Program Files\Reference Assemblies\Microsoft\Framework\v3.0\System.ServiceModel.dll" ); This works. If I don't specify the path then I get errors indicting ServiceModel.dll could not be found. Rather than specifying the full path to all of the .NET 3.0 assemblies I would like to let the compiler know where else it can search for assemlies. I have chosen: ...Show All

• SQL Server Is WITH / Common Table Expression a syntactic sugar?

  I tried to use WITH to factor out the shared star join portion from a sql statement as it's usually the most expensive part. However, examing the execution plan shows that the WITH clause is merely a syntactic suger that will internally be plugged back as derived tables where the same star join is executed repeatedly. Is the intermediate rowset produced by a WITH caluse ever shared during the query execution CTE's are not perfect, but they are FAR from the evil of cursors. Cursors are just bad form in T-SQL. You can never loathe them enough :) But the answer to the original question is yes, it can, but it does so apparently very pessimistically. The people I discussed it with mentioned there being hac ...Show All

• SQL Server DB Script

  hello I need to script my Db, tables and storedprocedures. so i can create another same DB Dim con As New SqlConnection(DBClass.Config.DBString) Dim cmdName As String = File.OpenText("pro.sql").ReadToEnd() Dim cmd As New SqlCommand(cmdName, con) cmd.CommandType = CommandType.Text con.Open() Try cmd.ExecuteNonQuery() MessageBox.Show("DB Created") Catch ex As Exception MessageBox.Show(ex.Message) End Try con.Close() Any suggestions plzzzzzzzzzzz if ur using sqlserver 2000 make use of the sql DMO functions...simple functions to achive wat u want... examples at C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Sqldmo similarly for SS 2005 though ...Show All

• .NET Development Code access Security- when to use and when not to

  Hi All, Can somebody please explain as in what types of application do we use Code access security and How CAS is generally used e.g do we add RequestRefuse for registry in every internet application. I want this classification for 4 types of applications broadly: 1. stand alone application 2. enterprise application 3. B2C application 4. B2B application I am new to architecture so just want to know as in which scenarios do we generally use CAS.Any broad guidelines Regards Thanks Nicole for the clearing my doubts otherwise i would have gone on the wrong track. It would be great if someone could put some scenarios from your past experiences where you used CAS. regards ...Show All

• Visual Basic Generics and abstract class

  For the sake of making the question simple, consider an abstract class '3Dshapes' with an abstract method 'getVolume'. Also consider two inherited classes, sphere and cylinder. For sphere I would need one variable for volume (radius). For the cylinder I would need two (radius, length). How can I define the abstract method in 3Dshapes to allow for a different number of parameters How about different data types A follow up; I can't think of why I would use it for shapes, but what if the abstract method were a function instead of a sub and I wanted the freedom to return different data types Thanks; Thanks for the reply, Certainly I could, for example, have the radius and length be set as properties instead of including the ...Show All

• Windows Forms DataGridView column filled from lookup table column

  I have two tables Company and Status. Company has a foreign key into Status – Status is the lookup table with two columns: ID and StatusName. I need to build a DGV that will provide a read-only list of what is the Company table, plus the StatusName for each record. All DGV columns are read-only textboxes. The Dataset already holds both tables, but not the relationship between them. The DGV columns are already set up to show records of the Company table but the Status column only shows the numeric foreign key value. Any chance I can do this without a database View or a stored procedure Here’s a bit of code. bindingSource1->DataSource=dataSet1->Tables-> default ...Show All

• Visual Studio Tools for Office Microsoft Office Projects Not Viewable

  Hi all I want to create project using C# that targets MS office Word. To accomplish this i have installed VSTO 2005 in my system. My system configuration is Windows XP SP 2 MS Office 2003 Professional SP 2 VS 2005 .Net Framework 2.0 I have also installed PIA redistributable package and office runtime. But the problem is that Microsoft Office 2005 Projects Folder aren't viewable in Project Types. I also tried VSTO 2005 client troubleshooter and the analysis report shows no warnings except that DisableDocumentAssemblies Policy Status Disabled  and Office Application Configuration Files No configuration files were found Please give some response as soon as possi ...Show All