Ashesman's Q&A profile

• Visual Studio Tools for Office How to access Tables

  I'm developing a spread sheet application using Visual Studio 2005 tools for office.In my excel application there are tables.I need to access these tables from c#.How can I achieve this You have to decide how to best identify the tables. In Excel, one generally uses the RANGE object to identify things. In some cases, it's appropriate to select the entire table, then assign it a name (or apply a RangeName host control - this is covered in the VSTO documentation). If the data area grows and shrinks a lot, then the UsedRange property might be more appropriate. ...Show All

• Visual Studio Express Editions Date problems...

  Hi all I have an SP... and when I execute it like the following: EXEC p_InsertNewStudent 'Joe' , 'Jimbo' , 'Blogs' , '1985/07/25' , '1343226' , 111111 , 222222 ; It works.   But if i do the following, which is what I want: EXEC p_InsertNewStudent 'Joe' , 'Jimbo' , 'Blogs' , '25/07/1985' , '1343226' , 111111 , 222222 ; I get: Error converting data type varchar to datetime. Neot the difference in the order of my date items... A small but frustrating problem!!!  Can someone please help Thanks for your time Chris     Have a look at the CONVERT function of T-SQL. For your date format dd/mm/yyyy use this: CONVERT(datetime, '25/08/1999', 103) ...Show All

• Smart Device Development POCKET PC SMART PHONE

  i can not build a pocket pc or smart phone device under any language. i am using mvs 2005 standard edition. i do believe that this allows me the use of smart devices.    i have just rebuilt my machine, by clearing all files under mvs, program list, corecon, device emulator and pocket pc 5.0 sdk, and reloading mvs and pocket pc 5.0. i have rebuilt my machine 13 times now, and this problem has existed for 6 weeks. please help   !!!!!!!!!!!! ps: can u activate the build configuration from your location or does mvs need to be uninstalled are installed again hey, i beta tested the original WORD 20 years ago, and look how well WORD has turned out.......... did you know that there were other w ...Show All

• Visual C# how do i convert days into months

  I have TimeSpan object witch is a result of substraction. TimeSpan duration = _endDate.Date.Subtract(_startDate.Date); I want to know how many full months are there in this time span object. and i want it to be rounded up till. For example i have duration of 32 days it means it's 2 months. Sure calendar should be taken into account too. So i must calculate this month thing from perspective of today. So how many months are there in this timespan object counting from today public static int DateTimeMonthsSpan( DateTime dateTime1, DateTime dateTime2) { return (dateTime2.Year * 12 + dateTime2.Month) - (dateTime1.Year * 12 + dateTime1.Month); } ...Show All

• Visual Studio Team System Adding a user to all team projects

  Perhaps I am not searching correctly in this forum but I cannot find an answer. Is there a way to add a user as a Reader for all team projects in one step rather than having to add the user individually to each team project Thank you! Stephen The best option I can think of is to create a single group, either TFS or AD, and then add that group to all project groups manually. Then, when you want to add a new user to all projects, simply add them to this group. You could also write an OM call using the ICommonStructureService and IGroupSecurityServer services to first "ListProjects()" and then loop through those to find the "Reader" group and add the user to it. If you'd like, I cou ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. GSE and Vista

  So I heard on letskilldave (and the FAQ mentions it too) that there will be no Vista support for awhile, but I was really curious as to what the policy of GSE on Vista was. Is there some technical reason that it will not run, or is it something discouraged due to lack of testing e.g., will I be able to convince it to run by fooling/mangling the installer, or will it explode when I try to do anything with it Having just installed Vista 5536 on my best machine (the one sitting next to my 360 and the one with a new video card) and loving it, I don't think I could stand switching back to XP. I also need to do some ‘real’ dev under Vista, so that makes things difficult too ;( Thanks for any info anyone knowledgeable can ...Show All

• Commerce Server Browse.aspx and ProductList.ascx

  More of an asp.net question than a commerce server specific one, but here goes. In the starter site, on Browse.aspx, the CommerceSite.Controls namespace is declared at the beginning of the page and the ProductList.ascx control is registered immediately after. This let's you drop a <site:ProductList> user control in to display products whose data comes from ProductFilterDataSource. I've got the need to dynamically create ProductList user controls (quantity from 1-n) depending on the category and I need to do it from code behind. I'm having problems registering and namespace and user ProductList user control properly so that my Browse.aspx.cs code behind file can utilize it. Clear as mud Thanks for any suggestions. Brad ...Show All

• Visual Studio Installation error

  ***EndOfSession***[09/27/06,19 :19:17] Microsoft Visual Studio 2005 Professional Edition - ITA: [2] ERROR:Si e verificato un errore imprevisto durante l'installazione di questo pacchetto. Probabile problema con questo pacchetto. Il codice errore e 2350. [09/27/06,19:32:50] setup.exe: [2] ISetupComponent::Pre/Post /Install() failed in ISetupManager::InstallManagerHe lper() with HRESULT -2147023293. [09/27/06,19:32:50] setup.exe: [2] Component error string not specified in ISetupManager::AddToActionResul tCollection() [09/27/06,19:34:09] VS70pgui: [2] DepCheck indicates Microsoft Visual Studio 2005 Professional Edition - ITA is not installed. [09/27/06,19:34:09] VS70pgui: [2] Unknown component status for.NET Compact Framework 1.0 SP ...Show All

• Visual Basic Write data in VB.NET to Access using SQL

  Okay, I have an Administrator page that is able to create new users. I have a simple adduserform that has a TabControl added in it with a tab for General Info and User Info. Those have quite a few texboxes for input and outside of the TabControl are 3 buttons that are Save, Clear, and Exit. What I want to do is have the Save write the data to my small database that I have for users. If you want to see an example of my screen you can see it here.... http://redbearcustoms.no-ip.info/VB/adduserform.html Yes, I was wondering if there was any way that I could post a picture of my screens without having to link to another site. ...Show All

• Smart Device Development Extending Context menu for Windows mobile 5.0 Samrtphone Contacts

  I have a Cab project which extends contact's contextmenu items. But When I installed the same cab file on smartphone it installed successfully but contextmenu items remains same Could there be any change in the installation file. this is my ini file to built the cab file [Version] Signature   = "$Windows NT$"        Provider    = "MyProject"            CESignature = "$Windows CE$"        [CEStrings] AppName     = "MyWireless"     InstallDir  = %CE1%\%AppName%       [Strings] NOW_PPC_Dir     = D:\Projects\MyOffice\OriginalPocketPC\ ...Show All

• .NET Development Is the problem solved?

  i need a regular expression that matches a paragraph bounded by ^XA and ^XZ! sample string to parse: ^XA etc, etc.. ' <--- start of the paragraph ^FO etc, etc... ' line 2 ^FO etc, etc... ' line 3 and so on ^FWB ' Field separator ^FO etc, etc. ^FWN - field terminator ^FO etc, etc ' more fields and then finally... ^XZ ' <-- end of the paragraph ' new line that separates the same pattern above ^XA etc, etc --- --- ^XZ I have tried "\^\D\D.+" but didn't worked! For all those kind people out there, i need to store the match or matches into array! i'm a newbie so if you could provide the code and some explanation, that would ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Weird backface glitch

  I'm not sure what's going on here; I wouldn't be surprised if it's just my video card. But has anyone seen this before cellphone_rendering_bugs.jpg That's a series of screenshots I took as the model rotated... the original model in Maya has all its normals facing the right way. I exported it as an FBX200611 model. I'm (unfortunately) using a Compaq Presario with an NVIDIA GeForce 6150 LE video card. I thought it might have been a matter of the near/far draw limits being too far apart and the Z buffer lacking the precision to draw this relatively small area properly, but I turned it down to 1.0 -> 100.0 and it still happens. Any thoughts I saw some things like this when I wasn't taking the parent bone ...Show All

• Windows Forms Recources, images

  Hey, I added a image to the recources of one of my projects, but when I try to have the program have thta image be the background of the menustrip then it wont, no matter how many times I select it and say OK it still has no background and the properties of it where it says background image it says None... ... ...How to I fix this Thanks :) Actualy I dont need to do that, you guys led me to the problem, k, so, I put in the Form1 Load event: menuStrip1.BackgroundImage = SurfScape1. Then IntelliSense only gives me 2 options: Form 1 or Program There should be more..So I tryed menuStrip1.BackgroundImage = SurfScape. And then it gives me the options it should. That is why. A little while ago I remade this pro ...Show All

• SQL Server how to use the OLEDB command to call a oracle function?

  HI, I want to use the OLEDB command to call a oracle function, but i havnt found any materials about how to do that, my oracle function is as below: CREATE OR REPLACE function GET_ZONEID_FROM_SYFZ(ycz varchar2,xc varchar2,strat_id varchar2) return varchar2 IS  zone_id_result varchar2(10) ; begin  PKG_DM_DQ.GET_ZONEID_FROM_SYFZ(ycz,xc,strat_id,zone_id_result);  return zone_id_result; end; In OLEDB command transformation component, i fill the sql command with "select GET_ZONEID_FROM_SYFZ( , , ) from dual", but i dont have it worked. The error message is :provider can not derive parameter information and setparameterinfo has not been called. Who have any idea about how to make it work Thanks ~~   ...Show All

• SQL Server DataGridView: How can I update data in a DataGridView?

  Hi guys, Im having some issues understanding how to manipulate the data that is in my DataGridView The View is created by calling a stored procedure from VB code and works on two tables: people pswds The columns required from Table people are (personid, userid and sort). The columns required from Table pswds are (comment and activeuser). Table people is parent table while pswds is the child table. The Relationship works between both tables using primary keys from both tables: which is called personid in both. The link below shows the Relationship Diagram for the Two tables: http://cale.csd.anglia.ac.uk/~csd03ib/images/RelationTables.bmp The code for the Stored procedure can be found at the follow ...Show All