JRQ's Q&A profile

• .NET Development Adding a List to another

  Hi! I wanna know if is it possible to add a List to another. Are there some method to do it in List class Thanks. Hi Danilo OK, what you're looking for is clearer, now. This forum is for VSTO-related questions. Your problem has more to do with the .NET Framework, generally. So I'm moving your message to a more appropriate forum :-) ...Show All

• .NET Development Permissions problem running from IIS

  Web application uses old style ASP pages at the front, and a vb.net 2005 DLL at the backend. The IIS web is setup with Integrated authentication, and Anonymous is turned off. One option in the app involves running through the shell command a .NET EXE. That .NET EXE attempts to do some WMI stuff but it doesn't have the permissions to do that. The Shell command is inside the vb.net 2005 DLL. I log into the browser as Administrator, and the winapi username shows up correctly as administrator in debug sessions. So why doesn't my shelled application have all the permissions that administrator has ------------------------------ more info.. ASP Page > x = createobject("mydll.myclass") c = x.shellthatEXE () In My ...Show All

• SQL Server Improving conversion performance

  I have a varchar(max) field that is on its way to a Term Lookup task, so it requires conversion to DT_NTEXT before it gets there. The conversion is taking a really, really, really long time. In my current example I have about 400 rows. Granted the length of the varchar(max) if I 'select max(len(myColumn))' is approximately 14,000,000 so I understand that I'm moving a lot of data. But I'm on a x64 machine with 4 dual core processors and watching Task Manager I can see that I'm only using 1 core out of 8. Anything I'm missing that can speed this up Thanks, Frank Thanks for the pointer to the excution thread information. It was taking upwards of 20 minutes to convert the sampling of rows I had. I w ...Show All

• Visual Basic Open and Close DB Connections

  Hi there people, I am in the process of creating a DAL for my application. I have created all the functions to query\insert\update the data in a set of modules for each table. My issue\question is. I cannot decide how to handle the connection to the database..i.e. the open and close of the connection after each query\insert etc has fired. here is a brief layout of my module i have created public SQLCON for connection and SQLCMD for the command objects then I call them from each function. Is that an ok efficient way of doing it or is there another way, although this works with no problems I am not convinced it’s the correct way. Imports System.Data.SqlClient Module pathsDAL Public SqlCon As New SqlCon ...Show All

• Visual C# Events

  I know how events/delegates works. its when implementing them that seems to be the problem with me. now... I have: a Form several classes the form knows nothing, it only knows about 1 class, which it instantiates. this class instantiates other classes. The form, nor do the other classes, need to know about each other. now, I have successfully created events which when raised from the main form, one of the classes acts upon it - thats all good. what I want now, is the complete opposite. I want to make an event where, in one of these classes (not the class the main form creates) I can raise so that the main form picks it up and acts upon it. Since I am mostly confused at times when events are involv ...Show All

• SQL Server Regarding Publications in Transactional Replication...

  Hi,                     We are using transactional replication with updatable subscriptions in SQL Server 2005 . In our case both the publisher and the distributor is the same server. The subscription type is the Pull Subscription. It is set to run in the continuous running mode .                   Can we have more than one publication in the same Distributor Please refer the link below : http://msdn2.microsoft.com/en-us/library/ms152471.aspx This link has a recommendation of the following under the heading " Queued Updating Subscriptions" ...Show All

• SQL Server Ignore conversion error

  I have a table that has a date column formatted as char(6), MMDDYY.  The dates need to be converted to datetime.  I use the following command: UPDATE  Table1 SET  CorrectedDate = CONVERT(datetime, SUBSTRING(Date, 5, 2) + SUBSTRING(Date, 1, 2) + SUBSTRING(Date, 3, 2), 1) That works until it hits a date formatted incorrectly.  The date could have blank spaces, double zeros or an invalid month/day/year (e.g. 033986).  The command stops with a conversion error and no values are written to the CorrectedDate fields. Is there a way to have the command skip the invalid dates and continue to write the datetime conversion for the dates that are formatted correctly Edit: Forgot to mention this is on ...Show All

• Windows Forms Enabling new line in a Multi line EDit Box after pressing enter or Tab key

  Hi, Please tell me how to enable new line in a multi line Edit Box after pressing enter or Tab key. ========Suresh Hi, I am guessing you are using a textbox I which case make sure that the MULTILINE and WordWrap properties are both set to TRUE. Use the following as examples of how to add a new line to a textbox>> textbox1.text="Hello" & VBCRLf & "there!" or>> put this line at the top of your code window>> Imports Microsoft.VisualBasic.ControlChars ' then use>> textbox1.text="Hello" & NewLine & "there!" Hope this is what you want or to get the cursor at the start of a newline>> textbox1.text=textbox1 ...Show All

• Visual C# How can I focus / select a control on another form when the current form closes

  I'm sure this is simple stuff for the pro's, so please point me where I can get some examples of focusing or selecting a control, i.e., a text box, on another form when the current form closes. Thanks in advance It sort of depends on how the forms are related.  Is the closing form like a dialog or settings window that is created by the other form   Then do it like: public class MainForm : Form {     SettingsForm settingsForm;     private void showSettings()     {         settingsForm = new SettingsForm();         settingsForm.Closed += new EventHandler(settingsForm_Closed); ...Show All

• SQL Server Add a column to table from stored proc

  Hello all, I want to alter a table in a stored proc to add a column dynamically. I am passing the name of the new column to the stored proc param. Does anyone know the syntax for this Here is the code: CREATE PROCEDURE procAddNewOptionType -- new option type parameter @OptionName varchar ( 50 ) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON ; -- Insert new option type into list of types INSERT INTO dbo . tblClientOptionList ( strOptionName ) VALUES ( @OptionName ); -- alter client options table to add new column passed to proc as @OptionName ALTER TABLE dbo . tblClientOptions ADD @OptionName BI ...Show All

• Visual Studio 2008 (Pre-release) Resize Controls in Canvas

  Hi, I want to use Canvas Panel in XamlBrowser Application And whenever my page is going to resize according to that my controls are also resized ... Can anyone guide me what to write in .xaml file and i don't want to write a single line in Page1.xaml.cs file... Code must be in Pag1.xaml file only.... Thanks in Advance.............. you could use binding to control the height/width of the controls so if the page/canvas height is changed and supose the controls (textblock) height is 1/2 of the page/canvas you could use a converter along with the binding. < TextBlock Height = " {Binding ElementName=tb1, Path=ActualHeight, Converter={StaticResource JScript}, Con ...Show All

• SQL Server When you open your SSIS project with other user, delays?

  hi everyone, A couple of issues. 1)I usually connect to my remote server via TS using a specific login (it belong to Admins) and through that user I open my SSIS projects (30 packages). Now, I have a new user and the same operation take a long time and I don't know why (same permissions) the reasons for this big delay. 2)When I'm gonna to press "Delete all Breakpoints" from Debug menu BIDS is closed. Previously appears a Microsoft dialog (Microsoft has encountered an error...) asking if you inform or not of these errors. Thanks in advance and regards, Hi Enric, If you get a delay with one user, and not the other, it sounds like a permission problem. Are you sure that user has the same acc ...Show All

• Visual Studio Express Editions how to use RSA Message Digest Algorithm MD5

  Dear All, I am writing a network application that requires to secure the user credentials before sending them out to the network. I am using native C++ (win32) with Visual C++ 2005 Express Edition for my developing The encoding algorithm that I would like to use to secure the user credentials is RSA Message Digest Algorithm MD5. My question; is there a built in library that offers and supports such kind of encoding Otherwise, I will need to built my own functions based on "RFC 1321 - The MD5 Message-Digest Algorithm". Thanks for your support in advance Bassam   Bassam72 wrote: My question; is there a built in library that offers and supports such kind ...Show All

• Visual Basic Math Questions

  This is my code I'm working with. I'm trying to use the sum from the lhGal to show in lhGal2.Text. Dim FirstNum, SecondNum, ThirdNum, FourthNum As Double 'Intial Fuel Add FirstNum = lhPounds.Text SecondNum = lhDensity.Text ThirdNum = lhGal.Text FourthNum = lhPounds2.Text lhGal.Text = FirstNum / SecondNum - 0.4 'Additional Fuel Added to bring to 1200 lhGal2.Text= FourthNum / SecondNum - lhGal You should also use Option Strict ON (type as the first line in your class file) This will force you to make explicit conversions...and will help avoid conversion errors! lhGal2.Text = Cstr((FourthNum / SecondNum) - Cdbl(lhGal.Text)) This still does not consider ...Show All

• Visual Studio Automation only gets the most current version of a file

  Previously, I archived the database, then restored it. I am not sure if this was the root of the issue or not. Now, when I use automation to get a previous version of a file, I either get the most current version of the file, or I get the error message: " An item with the name $/ASP.NET Projects/Intranet_DotNet.root/Intranet/AccountingModule already exists ". A call to GetVersionByLabel always returns the most current version number instead of the version number of the labeled file. A call to GetVersionByVersionNumber will return the error mentioned above if the version number is not the most current. I know the files in the VSS database are there because I can launch the VSS client and look at the history, and manual ...Show All