traci779's Q&A profile

• .NET Development How to use variables in SELECT statement with Excel?

  Hi I have read quite a few posts on this subject but none quite match the problem I have. I need to retrieve a single cells value ( price ) , from a specified worksheet from an excel work book - prices.xls. The name of the relavant worksheet name is pulled from the current SQLServer product table as sheetName . Also there are 2 user input variables inWidth & inDrop . So the basic logic of my query would be: SELECT price from @ sheetName WHERE ( drop = @ inDrop AND width = @ inWidth )   ( drop and  width are the worksheet columns) I have tried many variations of the above and only  have problems when using a variable for the worksheet name. I would like to create a ...Show All

• SQL Server Cant restore the database backup in SQL server 2005?

  I wrote a sql like this to restore my database backup use test RESTORE DATABASE [Lorenzo] FROM DISK = N'D:\Lorenzo' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10 GO But this is the error message that i am getting, but still i have 58.5GB free space in my hard drive what is the wrongwith this SQL server 2005 i am using sql server 2005 standard edition ! ===== Error===== Msg 3257, Level 16, State 1, Line 2 There is insufficient free space on disk volume 'C:\' to create the database. The database requires 63689129984 additional free bytes, while only 54682599424 bytes are available. Msg 3119, Level 16, State 4, Line 2 Problems were identified while planning for the RESTORE statement. Previous messages provide details. Msg 3013, Le ...Show All

• .NET Development VWD Express-Accessing the SqlDataSource: Can not open user default database. Login failed.

  Hi all, In my VWD 2005 Express program, I created a website "DobsonCh11" that had (1) Norwind.mdf file in my SQL Server Management Studio Express(SQL Server Express), (2)  Northwind.mdb and Northwind mdf files in the App_Data folder, and (3) the following default.aspx.vb:  Imports System.Data.OleDb Imports System.Data.SqlClient Partial Class _Default Inherits System.Web.UI.Page Protected Sub form1_Load( ByVal sender As Object , ByVal e As System.EventArgs) Handles form1.Load If Not Me .IsPostBack Then Me .Title = "Connect/query local databases" Me .Button1.Text = "Query Access" Me .Button2.Text = "Query SQL Server" Me .Button1.Width = 125 ...Show All

• Visual Basic Where do I start?

  I'm relatively new to the Visual Basic language and the Studio environment. What is the best way for me to store data that a user can view, edit, and update via the DataGridView I want this program to run solely on the end users PC with no need for an internet connection or any special database software. I would also like the user to be able to add columns to the data they're storing. So my question is, what is the best way to do this in Visual Basic XML is probably your best best since you can store it in a file, have a rudimentary hierarchical structure to work with, and you can load it into a dataset object for easy use with the Data ...Show All

• Smart Device Development Including .dll error

  Hi, I want to use ASTA SIP library for my program to establish telephone calls. but i m been facing problem while including .dll files. there are two files have to include for this purpose. 1. C:\program files\AstaSIP\.NET\CompactFramework\libsipcf.dll and second is to support on x86 architecture in simulated environment 2. C:\program files\AstaSIP\.NET\CompactFramework\x86\eval\libsipnative.dll when i try to include these two files by option Project->Add Reference, libcipcf.dll can be added but when i try to add libsipnative i got this error "A reference to libsipnative.dll could not be added" when i try to run this program i get run time error "Can't find PInvoke DLL 'libsipnative.dll'." // ...Show All

• Visual Studio Team System lock(this)/SyncLock Me and FxCop/CA

  It's a somewhat subjective topic; but, it seems the general consensus is that using "this" (or "Me" in VB) for synchronization (e.g. lock(this) or SyncLock Me) is not safe. There's several references in MSDN to lock(this) as being "generally acceptable" as well as warnings against its use. I'm just curious why there isn't at least a warning about lock(this) or SyncLock Me with FxCop/Code-Analysis Peter, This check is on the cards for Orcas. This will probably be included under the DoNotLockOnObjectsWithWeakIdentity rule (which will be renamed). Regards David ...Show All

• Visual Studio Tools for Office outlook 2007 categories property

  Hi All, I'm using an application which Puts a string into the categories property of the outlook mail. In outlook 2003 this string value is retained in the categories property across mail forwards and replies. I noticed we access the application from outlook 2007 beta client, then while replying to a mail that category property is not retained (it becomes null). Any idea why is this happening in outlook 2007 Is there any work around to solve this. Thanks in advance Thanks for the reply. Is there any other property in the outlook mailitem property which we can use to store persistent values I want to attach a string with a mail (hidden) and want it to be retained across replies and forwards. ...Show All

• SQL Server Two instances accessing the same data file.

  Is this possible: Can a single database be shared between two servers. We would like one database to be accessed from two instances. Our need is to give a copy of a DW for users who will do adhoc queries and potentially cause performance issues on the server. We want to give them their own server, but not have to duplicate a TB of data. Hence, can instance01 and instance02 both access the same .mdf containing the data. Second being read only. I think clustering will not easly allow us to direct user A to one cluster etc. TIA Glenn Hi Glenn, No, this is not possible. There is no way to meet your requirements without duplicating the data volume so to speak (log shipping, mirroring, replication etc) Cheers, ...Show All

• SQL Server kpis in excel 2007

  Hello all, i am a new user of excel 2007.i would like to know whether i can define any kpis in excel for the data from database and the cube as well if they are not already defined in cube and i would like to know about dynamically generating charts when a cell in the excel is clicked. Excel 2007 kan show KPI:s defined in SSAS2005. But Excel 2007 also have a new feature called color coding where you at least can show statuses by colors and/or icons. In SSAS2005 you can both define the status expression and trend expression for a KPI. HTH Thomas Ivarsson ...Show All

• Visual C++ Cannot Get Proper Build of Petzold's DLL Sample Code

  I am attempting to build Charles Petzold's sample code for DLLs. The code in particular is the EdrLib code. The problem I am having is that a DLL is built but does not work. It is not even close to what appears to be the proper size, i.e. my debug build is 44K while the debug build supplied with Petzold's code is 197K. On further examination using the test harness I built using Petzold's code, EdrTest, it works with Petzold's dll but not with mine. The working environment is Visual Studio Professional 2005 on a Win2K box with the Windows 2003 Server SDK. Am I missing something critical. The project was set up as a Win32 projec, DLL, empty project. Thanks in advance for your assistance. SvenC wrote: Hi Ken, can yo ...Show All

• Visual Studio 2008 (Pre-release) Binding a Data Template in a GridView with values using Code behind.

  Hi, I am trying to Bind an XML file to the Gridview. I have done it by declaring a Data Template on Xaml side and have bound the Template to the GridView columns from code behind but when I create a Data Template using the code behind the values are not binding to my Gridview columns .. The Data Template is getting bound but it doesnt have the XML files values .. Any ideas .. Everything using Code Behind .. When I define it in code the Data Template gets bound but not the values .. DataTemplate dt = new DataTemplate (); FrameworkElementFactory txt = new FrameworkElementFactory ( typeof ( TextBox )); Binding b = new Binding (); b.XPath = "IsVisible" ; (Column Name) txt.SetBinding ...Show All

• Visual C++ VC2005 : Disable c++ exception in Dll application

  Hy, I create a simple Dll application that use stl. I try to disable exception to optimize my application. First, I disable exception in project properties and I define "#define _HAS_EXCEPTIONS 0 " in my prefix include. But it doesn't link, I have this error : error LNK2019: unresolved external symbol "__declspec(dllimport) public: void __thiscall std::exception::_Raise(void)const " (__imp_ _Raise@exception@std@@QBEXXZ) referenced in function "protected: static void __cdecl std::vector<int,class std::allocator<int> >::_Xlen(void)" ( _Xlen@ $vector@HV $allocator@H@std@@@std@@KAXXZ) 1>Exception.obj : error LNK2019: unresolved external symbol "__declspec(dllimport) public: __thiscall std::exce ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Create Vector from Angle

  I have an angle of rotation in radians. Is there an easy way to convert this to a vector, as I have a 2D sprite ship I want to be able to rotate, and move in the direction of the rotation Simon Hmm i was always under the impression that 0 degrees was down in computer world - in which case my code was correct. I suppose your choice makes more sense but i've just always used 0deg = down. ...Show All

• .NET Development How to implement Undo and redo Operations in Xml file using C#.NET

  Hi all, I am trying to implement Undo and Redo Operations in Xml file using C#.NET for desktop application. Can anyone of you give me an idea how I can perform this Thanks in advance Rama Krishna Hi Rama, Have a look at the command design pattern. In short every change you make to your xml file would be stored in a command object, the command object would have two methods Execute and UndoExecute. One method (Execute) makes the change to your xml file the other method (UndoExecute) undoes the change. You store these command in an array or collection or some other stack like object. As you do a change create the command object call it's execute and push it on the stack, as the user undo's the change pop the command and call i ...Show All

• SharePoint Products and Technologies Hide Menu Items

  Hi How do you hide the built in menu options on a sharepoint site (i.e. Site Settings, Create, etc) I have a user which I have setup as a "Reader" yet he seems to have full control over the site. Also, I have a web part on the home page which has a link labelled "Add New Link" - again this user has access to this link and is able to add links to the site - how can I disable this Thanks in advance! Will It actually sounds like the user may have more rights than you think. Would they belong to a group that may have elevated rights SharePoint V3 has been written so that if you do not have rights to a particular action you will not see it. ...Show All