Aditya Kirloskar's Q&A profile

• SQL Server Is Conversion from SQL Server Express to Full SQL Server Required?

  If I develop my app in SQL Server 2005 Express, and then want to use a hosting service that only offers full SQL Server 2005, do I have to do some kind of conversion to my DB file, and if so, what might that be   (I notice that there are hosting services that provide SQL Server Express...I'd like to know how much work it would be to be able to use other services.) Any guidance on this would be appreciated. Thanks! it is an easy process to upgrade the database... you have two methods that you can use. the first is to use the detatch/attach method... with this you would just detatch the database on you server and then have the hosting company attach it for you. Or you could just use ...Show All

• Visual Basic Updating a bit field with a VB checkbox and a Stored Procedure

  I have added a checkbox to a visual Basic windows application.  I would like  the checkbox when clicked to run the following stored procedure in order to change the bit value in sql server to 1: Create proc [dbo] . [Checked] @id int as update Check set Checked = 1 where ID = @ID I'd like the following stored procedure to run when the box is unchecked. Create proc [dbo] . [UnChecked] @id int as update Check set Checked =0 where ID = @ID Is this a standard process   And how can I accomplish this   I am using VS2005 and SQL Server 2005 Express Edition.  Also I am in the dataset window.  I am not sure which to add a datatable, tableadapter, or a query ...Show All

• Windows Forms How to detect or read a textbox and combobox in a tabcontrol wheather it has a data or not?-VB.net

  Hi I have a windows form with 5 tab pages in 'tabcontrol1' last tab page has 'tabcontrol2' with further 4 tab pages. If any of the textbox or combobox has any value in tabpages of tabcontrol2 then do some or trigger any action. My question is how do I read,detect or check for any data entered in the fields (textbox and combobox) Advance thanks ...Show All

• Visual Studio 2008 (Pre-release) RichTextBox How To!

  Hi, I have searched the net and the documentation that shipped with Beta 2 and have not found any results or information that was able to aid me.  Hopefully there are some RichTextBox experts that could please help me with the following things: How can I make the RichTextBox single line   (this was possible in Win32, and no, changing the control template to a textbox does not work!  Because then it essentially is a textbox!) Why is it so difficult to control drag/drop operations in both the textbox and RichTextBox   I would like to control over what is dropped onto the textbox, for instance if images is dropped or texted I would like to be able to Is it possible when doing a drag/drop operation, I de ...Show All

• Visual C++ why doesn't the cursor piont to the excuted line in single step debug?

  i use vc2005. when i debug in a function,the cursor doesn't piont to the excuted line. it piont to the third line before the excuted line.but in other functions , everything is normal.why Are you using C++ or C++/CLI   I opened a bug where yellow arrow, a.k.a. "next statement (not called the cursor), would point to the wrong line during single-stepping in C++/CLI code, but it was a relatively rare scenario that was apparently already fixed for SP1. ...Show All

• Software Development for Windows Vista Security with workflows exposed as web services

  Often times web service developers require web methods to use the SoapHeader attribute so that the soap header can be inspected prior to executing the method.  If we cannot control web methods that are workflow endpoints how do we control access to the endpoint   How do we write custom code to interpret the header   Thye web method is autogenerated and developers do not have any way to apply the SoapHeaderAttribute to the web method representing the workflow endpoint. Obviously we cannot do it in the workflow because by the time the workflow code is executing, the soap document has already been deserialize and passed to the workflow code.  Anyone have any thoughts Some would say that we could secure the service us ...Show All

• SQL Server display TODAY's records...

  I am saving files in SQL Server 2005 with a datetime field called news_date_time and I want to display all today's records regardless of the record time. I tried this code but didn't work.. [code] SqlCommand sql_command = new SqlCommand("SELECT * FROM files_news WHERE news_date_time = TODAY ORDER BY news_date_time DESC", sql_connection); [/code] Well then you need to contact MS to inform them and all SQL users that an index is removed from a field where a conversion takes place. Good luck, Adamus     No, nothing is removed.  The index is simply not usable.  I highly recommend that you do some background reading on indexes and how they work; ...Show All

• .NET Development Passing an Object to a dialog

  Hello, I am trying to pass an object between various dialogs, how can I do this I have seen this "myDialog.ShowDialog(this)" before...does that mean I can do "myDialog.ShowDialog(myObject)" as well If so, how do I reference the object in the newly opened dialog Thanks in advance, JD Hi JD, you cannot pass a generic object from one dialog to another inside ShowDialog because this does display another dialog where the one which calls ShowDialog becomes the parent dialog which is activated when the child dialog exits. You can very easily create a member function or a property of each Dialog class e.g. partial class MainForm { CData mySharedData; public CDataClass Data { get { return mySharedData; ...Show All

• SQL Server SQL 2005 Express New Login

  Hello all Im new to SQL 2005 express so please bare with me, I have set up wireless peer to peer network and I am trying to access an express database from one machine to another. I can transfer files no problem. When I try to create a new login, I am forced to only select logins local to the machine with the database. When I try and create a new login by typing <machinename><windows account > of the second PC, SQL can not see it. I have tried both Windows authentication and mixed mode... no success. Any ideas Thanks That is standard Windows behaviour: either use accounts or groups from the local machine or make the machine member of a domain to allow domain users to get ...Show All

• SQL Server help needed to drop a table!!!

  hi, can any one tell me how to drop a table...i tried to delete using the command : drop table sample; but it displays an error stating that, Cannot drop the table 'dbo.sample', because it does not exist or you do not have permission. pls post the reply asap -Sweety To verify that the table does indeed exists, try: SET ROWCOUNT 1 SELECT * FROM MyTable SET ROWCOUNT 0 Then if you receive data, and the statement DROP TABLE MyTable again fails, check your permissions. It is possible that your login does not have permission to remove a table. ...Show All

• .NET Development Deciding minimum value based on type

  Hi, Is there a way I can find what is the minimum value of a type using reflection e.g. If the type is int, it should be 0, if its string, it should be string.Empty. if its datetime, it should be minimum date time etc and if its object, it should be null. I have to achieve this using reflection and need to compare these values as well, e.g. if two values are equal or one of the value is minimum value for that type. Any standard way of doing this Or I would have to write code for it \ Please advice. Thanks, Hiten Umm, yeah, default(T) works only with type parameters, not the Type variable. Well, one way is to check to see if the type in question is a value type. All value types have defau ...Show All

• Windows Forms Windows Service Problem on 2000 Server

  I have a windows service written in C# on .net 2.0. When it starts it first checks some keys in the registry to make sure they are there. If they are not there it displays a small window to the user to enter them. In the service configuration I have set the Allow Service To Interact With The Desktop. This program works fine on 2003 Server and Windows XP but I cannot get it to work on 2000 Server. It seems it cannot read the registry and is getting stuck somewhere. Does anyknow know if any problems like this on 2000 Server Thanks In Advance. Martin Its set to logon as the local system account and there is no information in the event log at all. However this has given me and idea. I will t ...Show All

• Visual Basic .NET Events in COM VB.NET

  Does any one know why .NET events are not firing in COM I have got a .NET class which is accessed by VB6 COM.dll. The Events in .NET doesn't seems to fire in COM. Any clues There are a couple of things that you need to check to make sure that events fire: Make sure they are markes as public and comvisible(true) Make sure that the assemlies are markes as comvisible(true) Make sure that all the parameters are correctly decorated and can be marshaled correctly I would suggest to start testing with events with no parameters, then one that passes an integer, and so forth, to make sure you know where things go wrong. Hope this helps, ...Show All

• SQL Server I need to understand

  How di I understand what SQL Server Integration Services mean Can some one help me Charlene Reeves wrote: How di I understand what SQL Server Integration Services mean Can some one help me SQL Server Integration Services is a data integration tool provided with Microsoft SQL Server. Perhaps you could ask a more specific question -Jamie ...Show All

• Smart Device Development how to start app without form?

  I have a windows mobile 5 app with compact framework 2.0 in vb 2005. I want to start the app by initialising my controlling class - I don't want to start the app with a form. The problem is I can't use application.run() - I have to use application.run(formname) but as the app is a wizard app the first form may be different each time. My controlling class knows what form to show first but of course when it does the whole app exits straight away as I haven't used application.run from sub main. Any ideas sub main code below. Sub Main() ' Prompt for login. Dim Login As New frmLogin Dim LoginResult As Integer = Login.PromptForLogin() Select Case LoginResult Case frmLogin.LoginOutcome.Successf ...Show All