Kamii47's Q&A profile

• Windows Forms User input validation

  hi all, i am writing a login screen. it has a username and password textbox. i want to validate the user input to allow a-z; 0-9 and - _ but nothing else...is there any way of checking for these characters only thanks, Minus sign is a special character, used also when specifying a range (a-z). If you need to include it as an allowed input character, you need to escape it (explicitly mark it as a single character). I'm glad you got it working... Andrej ...Show All

• Software Development for Windows Vista Show of Hands! Is WF by itself a viable approach to addressing a customer's workflow needs?

  Like many of us in the forum I am in the all too often unenviable position to influence my client's decisions. I currently have a lot of customers evaluating workflow, many for the 1st time. I personally have avoided building "custom" workflow solutions whenever possible as I have had success in the past implementing packaged workflow or BPM offerings, both Microsoft-based and less recently non-Microsoft-based. It's allowed me to focus my energies on building solutions and solving real business problems, not building infrastructure. Granted, there are customer situations that don't require or afford you the opportunity to buy a packaged solution to address a workflow/BPM need, but I would argue those are/should be the exception n ...Show All

• Visual Basic Error with Compute(Sum)

  First post on this forum which so far has been very useful. Here goes, I'm using vb 2005 express with sql server express. Have 3 forms Quotes Contracts Sales with corresponding datatables . On my Quotes form I am able to display the sum of the price column in a text box with the following code. Friend Sub btngettotal_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btngettotal.click Dim quotedetails As DataTable quotedetails = BaumannpaperDataSet.Tables("quotedetails") Dim total As New Object total = quotedetails.Compute("sum(price)", "price > 0") Me.TextBox7.Text = quotedetals.Compute("Sum(price)","").To String End Sub ...Show All

• SharePoint Products and Technologies SPFileCollection.Add with properties

  A few of the overloaded operators for the SPFileCollection.Add includes passing in a hashtable of properties. Does anyone know if this works I can't seem to add/set any properties thru the hashtable. Here is an example of setting the comment property when calling Add: Public Sub SaveFile( ByVal strURL As String , ByVal byteContent() As Byte , ByVal strComment As String ) D im spsSite As SPWeb = New SPSite(strURL).OpenWeb() Dim spsFile As SPFile = spsSite.GetFile(strURL) If Not spsFile.Exists Then Dim spsFileCol As SPFileCollection = spsFile.ParentFolder.Files Dim hash As New System.Collections.Hashtable hash.Add( "vti_sourcecontrolcheckincomment&quo ...Show All

• SQL Server INSERT command question

  I am working from C# VS2005 environment. My databases are in SQLEXPRESS. All tables have a unique Primary Key field. The key is just one field of int value that has seed 1 and autoIncrement 1. My question concerns a Stored Procedure that I just created. If "executed" fine. I did not get any compillation errors My question is: if I called this procedure from C# code with paramaters I specified will it create a NEW record for me which is my intent I did not specify the Primary Key field value: it is not among parameters. I hope that when the first record is created it will be seeded with value = 1 and the subsequent records will be autoincremented by 1 each time. Am I right If not then how shall I specify the Primary Key val ...Show All

• .NET Development ngen display Catastrophic failure

  Hello. When i running "ngen.exe dispay", i have message Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Message in system log .NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Service reached limit of transient errors. Will shut down. Last error returned from Service Manager: 0x8000ffff. I installed latest version .NET from microsoft.. What wrong with my .NET Framework Does "Ngen Queue Status" also give you a similar error message Did setup of the .Net Framework 2.0 succeed Can you try repairing the Framework install and see if Ngen still gives you an error Thanks, Pracheeti ...Show All

• SQL Server SSIS Package Error

  Hi, we have developed SSIS package in machine1 .when we copy the SSIS solution from Machine1 to Machine2 .when we open the SSIS solution in machine2 we are getting the following errors what could be the reason .help us pls. 1. Error loading Package_test.dtsx: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. d:\jegan\ssis prjs\fuzzy\fuzzy\Package_test.dtsx 2.Validation error. Data Flow Task: Fuzzy Grouping [3131]: The AcquireConnection method call to the connection manager "AIGS ...Show All

• .NET Development VB OdbcCommand.ExecuteNonQuery not returning -1 for DDL SQL stmts

  I am trying to use the OdbcCommand.ExecuteNonQuery method to execute DDLs and DMLs. The documentation says that -1 should be returned for DDL SQL stmts, but it returns 0 for DDL stmsts like CREATE/DROP TABLE. Is this a bug or am I doing something wrong gReadLine = txtSQL.Text cmd = New Odbc.OdbcCommand(gReadLine, cnx) cmd.CommandType = CommandType.Text gNumRows = cmd.ExecuteNonQuery() If gNumRows >= 0 Then lbOutput.Items.Add( "Number of Rows Affected : " & gNumRows) Else lbOutput.Items.Add( "SQL Operation Succeeded" ) End If Thanks in advance. ...Show All

• SQL Server SQL CE and SQL Server 2005

  I have seen some referrences to this on this forum, but nothing specifically dealing with our question. We would like to use SQL Server 2005 on the server side, but need to keep using the SQL CE version on our mobile due to the OS. I'm assuming this is possible, but seem to be unable to find this discussed in any of the publications. Can anyone point me to the appropriate articles Thanks. yes, this is a supported scenario for both RDA and merge replication. See row #4 in the matrix included here: http://www.microsoft.com/sql/editions/sqlmobile/connectivity-tools.mspx -Darren ...Show All

• Visual C++ ComboBox that hides the arrow buton if only one element is in the list

  Hello! I need a ComboBox that hides the drop down button if only one or zero elements are in the list and acts/displays itself simply as a textbox. I thought of two ways to do that: 1. Create completely new user control with a textbox, button and listBox 2. Inherit from ComboBox and place a textbox in front of the whole combox if only one/zero element is in the list and hide that textbox if more are in it. For suggestion 1 I would feel like reinventing the wheel and for solution 2 I think it could become hard to think of any possible events, focus, colors,... that would need to be transfered to the textbox. Is there any cleaner solution for this I can't believe that this is a very uncommon wished behavior. Thanks f ...Show All

• Microsoft ISV Community Center Forums IsError function from VBA6.3 to v6.0

  Hi All, I'm having problems with a small VBA script that I wrote in v6.3 but need to implement in 6.0. Excel 2002 -> 2000. The following code works fine in the later version: For i = 2 To LastRow ' select the next row based on loop vString = "A" & i If IsError(Application.VLookup(Range(vString).Value, vRange, 31, False)) Then Y = "NEW" Else Y = Application.VLookup(Range(vString).Value, vRange, 31, False) End If ' write the result to the active workbook Cells(i, 31).Value = Y Next i But won't work in the earlier version as there's a type mismatch at the If Iserror ... line. Any ideas why or thoughts on a workaround Thanks, Steve. ...Show All

• SQL Server embedded deployment sql server express

  Hi,my problem is the following I can not completely understand how to deploy sse with my application To some degree I understand the explaning in   Mikes Documentation Things I don't get: 1) Do I not check the prerequisite server express because when I did  and run the setup.exe that I build  the thing that happens is that the sql package gets unpacked over and over along with a little message that it's taking a little longer then expected. I gues this is the fallpit where the actual setup.exe for sse is nothing being done with hence the wrapper.  A quote from Mikes document "If the VS Bootstrapper isn't flexible enough for you then". Well, I don't know what I'am doing wrong but ...Show All

• SQL Server Calling a stored procedure or function from another stored procedure

  Hello people, When I am trying to call a function I made from a stored procedure of my creation as well I am getting: Running [dbo].[DeleteSetByTime]. Cannot find either column "dbo" or the user-defined function or aggregate "dbo.TTLValue", or the name is ambiguous. No rows affected. (0 row(s) returned) @RETURN_VALUE = Finished running [dbo].[DeleteSetByTime]. This is my function: ALTER FUNCTION dbo.TTLValue ( ) RETURNS TABLE AS RETURN SELECT Settings.TTL FROM Settings WHERE Enabled= 'true' This is my stored procedure: ALTER PROCEDURE dbo.DeleteSetByTime AS BEGIN SET NOCOUNT ON DECLARE @TTL int SET @TTL = dbo.TTLValue() ...Show All

• .NET Development TCP Listener on active website?

  Can someone direct me to a tutorial on how to implement a TCP Listener on a website I need to listen for incoming TCP connection requests on a third-party-hosted (GoDaddy) website. I understand how to write the .aspx web pages, but how do I "run" my underlying application code I need to capture the incoming TCP packets, store them in an SQL database, and use this data to determine what information to display on the .aspx pages. I'm a bit confused about the basic architecture of running the app vs serving up the .aspx pages.... Pointers welcome! Durgaprasad, Thanks for the help. However, I may not have been clear as to what I am trying to do. I will be using a web-hosting company to host m ...Show All

• SQL Server Identifying Bad Record and Field Value

  To All: I'm importing a data file of 600,000 records. Some records contain bad data. What's the best way to identify the text file row and field that caused my package to bomb AT THE TIME IT bombs Thanks, r This topic is addressed in chapter 5 of the following book. Professional SQL Server 2005 Integration Services You could use transforms like "Conditional Split", "Lookup", etc. Here is the link for the book http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764584359,descCd-tableOfContents.html HTH.. ZULFIQAR SYED HTPP://ZULFIQAR.TYPEPAD.COM ...Show All