MA2005's Q&A profile

• SQL Server How to setup a many-to-many schema to favor retreival speed.

  I'm am novice in the RDMS world. I would like to set up a database that will scale with a large dataset of over 1,000,000 unique records. In a nutshell, I have about a million+ documents that are stored on a file server as TIFF files. Each document has 2 or more persons (names) associated with that document like "John Smith" or "Mr. John Doe" etc.. A person can be related to many documents (depending on how many transactions they conducted over the years) and any document can be related to many people as most of the transactions were from multiple sellers and multiple buyers. The end users almost always searches for documents by using the first and last name of the person related to the document along with other docume ...Show All

• Windows Forms Please Help Urgent - Events.RemoveHandler

  Hi, I have an inherited form which contains some controls. I have reference to one of these controls (A button) and want to remove its click event so i can add my own click eventhandler to it. When i try to look in the form's Events collection it doesnt seem to be a straightforward collection which i can loop through. And i dont know exactly what the keys are to be able to access the required entry and then delete the event handler from this collection. So can someone please tell me how i can remove an event of a control. i cant use this because amendButton.Click -= new EventHandler( dont have access to these parameters ) If someone could point me in the right direction i would be very grateful. Many Thanks ...Show All

• .NET Development MailMessageEventArgs - body.replace does not work for <%RecordDate%> or <%User%> but does for the others.

  I am unable to get the following replacements working in my email template. Body.replace does not work for <%RecordDate%> or <%User%> but does <%username%> and <%password%>. I am using OnSendingMail with the Changepassword control. Here is my code. 1) aspx file => <div class="content_right"> <asp:ChangePassword ID="ChangePasswordControl" runat="server" CancelDestinationPageUrl="~/Registration/MyProfile.aspx" ChangePasswordFailureText="Current password incorrect or New Password invalid. <br />Password length minimum: {0}. <br />Non-alphanumeric characters required: {1}." ContinueButtonType="Button" ContinueDes ...Show All

• Visual Basic Colour Combo Box

  Hi, How do i get a combo box to display system colours As i am using it so the user can select the background colour for a graph. I have tried colourcb.text = color() but this produces an error any ideas Andy Not that I'm aware of but try this: Public Class Form1 Dim Colours() As KnownColor Dim F As New Font("Arial", 12, FontStyle.Bold) Dim WithEvents CMBO As New ComboBox Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load CMBO.SetBounds(50, 50, 200, 20) CMBO.DrawMode = DrawMode.OwnerDrawFixed CMBO.Font = F Me.Controls.Add(CMBO) Colours = DirectCast([Enum].GetValues(GetType(KnownColor)), KnownColor()) For Each C As KnownColor In Colours ...Show All

• Smart Device Development Datagrid row height

  Is it possible to change the row height in the datagrid A user can manually change it, but I need to change the default value from startup. There's no API to set that, sorry. Default size is determined from font size, so no good way to change it as well. ...Show All

• Visual Basic signer's certificate is not valid

  I have programmed succesfully with VB 4.0 for years and have recently started to "Update" myself with Visual Basic 2005. I tried to build an application to distribute via CD. I received the following error: Error 2 SignTool reported an error 'Failed to sign bin\Release\Counting Stewards data entry.publish\\setup.exe. SignTool Error: ISignedCode::Sign returned error: 0x80880253 The signer's certificate is not valid for signing. SignTool Error: An error occurred while attempting to sign: bin\Release\Counting Stewards data entry.publish\\setup.exe '. CSDE I am totally "out to lunch." I have no clue of what this is about and cannot find anything in my references which address it. I have found no code on line ...Show All

• SQL Server Web Service Access

  Hi there, I have a problem accessing web service using Web service Task. I set up the task and can see methods available, but the result of execution is only that: < Result > The result is null. Either the result is null or the Web method returns void. </ Result > I can connect and get data using C# application. The difference is that I use a token in connection there. What should I do with Web Service Task to fix it Thanks in advance. By "token" you mean un/pw I haven't taken a look at the web service task since SP1 came out (fixed the issue with static parameters) - but there are a few options if you need more than built in Web service task is pr ...Show All

• Commerce Server Problem with searching Profiles using ProfileManagementContext

  Hi, I am trying to search the records of Organization profile by using the ProfileManagementContext class. I'm getting the error when i'm calling the following code, // Build dataset of searchable entities for a profile. DataSet searchableEntities = profile.GetSearchableEntities(); // Build search clause for the Organization. SearchClauseFactory factory = profile.GetSearchClauseFactory(searchableEntities, "Organization"); I'm getting the error message as follows, System.ArgumentException: DataSet is missing the 'Organization' table. Parameter name: searchableEntities It seems that the GetSearchableEntities() returns an empty dataset. I checked the Profile Authoriza ...Show All

• .NET Development Retrieving data from Excell 2003 - Could not find installable ISAM.

  I am trying to access some data in a Excel 2003 file and import it to a dataset using a oledb provider.Here is the code : string cnxString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=C:\\TEST.xls;" + "Extended Properties=Excel 8.0;"; this.excelConnection.ConnectionString = cnxString; this.excelConnection.Open();I keep getting this error :A first chance exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dllSystem.Data.OleDb.OleDbException: Could not find installable ISAM.I have search everywhere there is a space between data and source. I have read the KB articles but nothing seems to be doing it. Any help would be greatly appreciated.Thanks. ...Show All

• .NET Development VB 2005 - Copy row contents to another row in the same DataSet

  Hi, How can I copy the contents from one row to another in the same DataSet I'm using the TabelAdapter to fill the DataSets. For example: I've 2 existing rows and need to copy the contents (all fields) from one row to another. Then, before update change the key field so I don't have any problems. I've tryied to use the ItemArray but don't know how to load it to another existing row. Can someone help Thanks. Pedro Hi Bill, I don't want to add a new row. I just want to change an existing one with the contents of a source row (except key). Is this possible in a simple way Pedro ...Show All

• Customer Care Framework No public or private folder

  Hi, I couldn;t find any folders such as PUBLIC or PRIVATE when CCF Setup is extracted. Given below is the directory sturcture (at the first level) Volume in drive D is New Volume Directory of D:\SankaraNarayanan\CCF\ccfextract CCF2005_SW-License.rtf Redist.txt <DIR> Setup <DIR> SourceCode <DIR> UserDocuments Directory of D:\SankaraNarayanan\CCF\ccfextract\setup <DIR> CcfReports <DIR> CcfServer <DIR> CcfTools <DIR> Database <DIR> DemoApps <DIR> Others <DIR> SSP Directory of D:\SankaraNarayanan\CCF\ccfextract\SOURCECODE <DIR> Microsoft.Ccf <DIR> Microsoft.Ccf.Adapter <DIR> ...Show All

• Windows Forms The selected rows aren't displayed

  Hi I have a DataGridView control in my C# application and i want to select some rows in this control in the Load event of the containing form of the grid. The problem is that the rows aren't displayed as selected. The same code i use when a button is pressed (after the page is loaded) and it works fine. Is this a normal behaviour What should i do to select some rows before display de window with data grid Thank you ill try out your code (obviously implement it into my system) but just curious, what is ImportedFileCollection I assume its a class you have made, as I cannot seem to find it in the .NET Framework. The datagridview datasource has been set to the ImportedFileCollection - but what actua ...Show All

• SQL Server BULK INSERT Format File Problems with SQLNUMERICAL in SQL-Server 2005 Express

  I'm trying to set up a BULK INSERT Format File for some data that I've been sent, which, according to the data documentation, comes in fixed-width format fields (no delimiters except for end-of-row 0D0A) in SQL-Server 2005 Express. The following is the first line... "7999163 09182003 56586 56477 3601942 1278 22139 1102 113 118 51450 1 1 63535647 10000 7999162 09182003 56586 56477 3601942 1279 22139 1102 113 118 51450 1 1 63535647 10000 " Looking with a hex editor, all the above whitespace are 20's. From the documentation, I've constructed the following table... CREATE TABLE MQIC.DBO.ORDER_F ( TRACER_ID NUMERIC (10,0), DB_CREATE_DATE CHAR (8), DB_UPDATED_DATE CHAR ...Show All

• Customer Care Framework Unable to configure a phone in Agent Desktop

  I get this error in the Agent desktop Application. Phone Settings are configured through Admin Console, Softphone is installed and also all the required steps in Deployment doc. are properly executed. The error originates from PhoneMenu.cs, in InitCTI() function inwhich CtiHostedControl.InitializeLine(agentNumber) returns a NULL. Ok Lets take a step back here... Please answer a few questions for me 1) where you able to start the Default Agent desktop, where the phone menu appeared on the tool bar as usable 2) what is your end goal with CTI Inbound calls / outbound calls / both 3) what CTI / ADC system are you using / want to integrate to 4) are you trying to use the TapiDemo Code we provided ...Show All

• SQL Server Fetch Returning Duplicate Last Record

  Ok, this thing is returning the last record twice. If I have only one record it returns it twice, multiple records gives me the last one twice. I am sure some dumb pilot error is involved, HELP! Thanks in advance, Larry ALTER FUNCTION dbo.TestFoodDisLikes ( @ResidentID int ) RETURNS varchar (250) AS BEGIN DECLARE @RDLike varchar (50) DECLARE @RDLikeList varchar (250) BEGIN SELECT @RDLikeList = '' DECLARE RDLike_cursor CURSOR LOCAL SCROLL STATIC FOR SELECT FoodItem FROM tblFoodDislikes WHERE (ResidentID = @ResidentID) AND (Breakfast = 'True' ) OPEN RDLike_cursor FETCH NEXT FROM RDLike_cursor INTO @RDLike SELECT @RDLikeList = @RDLike ...Show All