biren j shah's Q&A profile

• Visual Studio Express Editions Newbie, SILLY question SQL/VB Form

  Ok....so I'm REALLY, REALLY new to programming.... I'm creating an app, and I've got a SQL db built for it....but in one column, I have to specify days of the week...It doesn't matter if I use list boxes or check boxes on my form, I get a "CallinDays Column does not allow NULLS" error whenever I attempt to save my data. How do I format that column in SQL (I'm using VBExpress 2005) to make it take the data from the list box and save ...Show All

• Visual Studio About Addin setup in VS2005

  Hi From what I understood from the documentation and experience, - addin registration can be done in the old way, using the registry - addins can be put in the (eg) Application Data\Microsoft\MSEnvShared\Addins directory, with the .Addin file containing the location of the addin assemblies. In this case, the location is either an absolute path or a relative path from the Addins folder. What if I want to use the .Addin registration but locat ...Show All

• Windows Forms Hiding Tabs

  How do i make a tab invisible or hidden on a tab control Simply remove the TabPage from the TabControl.TabPages collection. If you want to re-add it later, simply squirrel away a copy in a member variable of your Form (or elsewhere). public class MainForm : Form {    private List<TabPage> m_tabs = new List<TabPage>();    protected override void OnLoad(EventArgs e) {   & ...Show All

• Visual Studio 2008 (Pre-release) Possible to remote an Expression tree into Yukon?

  So this crazy idea came to me over lunch. Yukon hosts the CLR.  It can also host a web service.  Provided that the CLR hosted has access to all the stock .NET framework, I wonder how worthwhile it would be to: 1. Create an expression tree at the client side. 2. Transmit the tree to a service on Yukon. 3. Have Yukon execute the tree in the context of the database (security being managed, of course). 4. Transmit the results back to the c ...Show All

• SQL Server join results from multiple EXEC calls

  I would like to make inner join with results from different exec %procedureName% calls. thanks. insert into #temp exec Proc1 insert into #temp2 exec Proc2 insert into #temp3 exec Proc3 Then join or union the tables (depending on the data) If the reultsets are the same you can insert into 1 table instead of multiple tables Denis the SQL Menace http://sqlservercode.blogspot.com/ ...Show All

• Visual Studio Tools for Office Copy Excel range

  Hi, I am creating an Excel add-in using C#. Here is a scenario First a range is selected in sheet1 and also in sheet2. When my add-in is activated the content of the range in sheet1 and sheet2 switch it's content. The Range.Copy() method can help me half way. The problem is that when I have copied range from sheet1 to sheet2, it overwrites the content in sheet2. Does anyone have some hint, tips... or even a solution to this scena ...Show All

• Visual Studio unmanaged addin registration for all users

  What is the recommended way to register an unmanaged vs2005 addin for all users   It appears that the .addin xml file is only for managed addins; is this correct You are right. The .addin xml file is for managed add-ins. To register an unmanaged VS 2005 add-in, you can simply run "regsvr32 yourAddin.dll". If you want it registered for all users, before running the above command, open file AddIn.rgs and ...Show All

• Visual C# Create Too Many Forms

  is there way to create form just when i want like vb6 form.show() shows the form but in C# when i want to show the for i have to use form frm = new form(); that create too many form so when i pass value i cant pass it to the certain form i want and other question if i have more than one form how i can pass the value to the form i want i hope that it was clear sorry for my bad english ...Show All

• .NET Development connecting using localhost

  hi all, i'm using VS2003 .NET with SQL2000. after changing my computer's name (i think that was the "trigger"), i get the infamouse "SQL server does not exist or access denide" message if using "localhost" as my datasource in my connection string. i have no problem if i use the server name "hard coded" (datasource = myserver). any ideas how to make "localhost" work again thanks. ...Show All

• Visual C# IPAddress and IComparabe<T>

  Can anybody explain the reason why IPAddress does not implement IComparable interface I wanna use IPAddress in my binary search tree and using the GetBytes() method of the IPAddress for comparing seems to me very inefficient. Any alternatives Maksim, I can't tell for sure, but since there isn't a "natural" ordering of IP addresses, any implementation of IComparable would have been arbitrary. For instance, you might use network or ...Show All

• Visual Studio Tools for Office Accessing Sheets from a new class

  I'm sorry if this is too basic, but it's giving me a real headache. In one of the click events in my action pane I'm trying to access the value of some cells in sheet1. I'm not having much luck. I've tried the following: x=globals.sheet1.cells(2,4) x=globals.sheet1.cells(2,4).ToString x=project.globals.sheet1.cells(2,4) x=project.globals.sheet1.cells(2,4).ToString x=globals.sheet1.innerobject.cells(2,4) x=globals.sheet ...Show All

• Visual Studio Express Editions Export IDE Settings ?

  Hi, There is two different users working with vs c++ express. How do I export all IDE settings of one user to another I'm to lazy to tweak every setting manually, maybe there is a way to copy some file thanks Vilius Tools => Import and Export Settings... , you can export IDE's settings to a vssettings file (there are options to select what do you want to export, eg. general settings , help filter and fa ...Show All

• Visual Studio Express Editions How to save images to sql?

  Hi! I'm trying to save a jpg pictures to a SQL database. The application first opens a dialog box to select the file (picture) I want to store in the database. When selected and pressing button no.2 it should be saved into the databade, but... I'm not sure what I'm doing wrong, but when I do the debugging I get the next error messages: 1. The ConnectionString property has not been initialized. Here is the code I'm using: Option ...Show All

• Windows Forms How to change a disabled textbox's forecolor?

  When a textbox become disable. it's fore color changed to gray one. But I Realy need to change it's fore color while it's disable. Is there any way to do that hi, user know very well when something is grey then its disabled so its not good choice to change the forecolor but if you want to do that i don't think you can do that unless you used your custom control anyway you can achieve that but seting ...Show All

• Visual Studio Team System Compile on Check-In

  Now I know there is a way to do this and please excuse me if this answered elsewhere. How do I set a policy for check-in that requires a project and/or solution build prior to allowing the check-in to committ   I am wanting to enforce the 'don't break the project or solution rule' and let continuous integration handle the 'don't break the build rule'. The second part I have a handle on but the first part of not committing a check-i ...Show All