slein's Q&A profile

• .NET Development Convert date in textbox to either datetime or null

  Hi, I have built a simple search procedure to query an orders database by company name, contact name etc and one of the fields I would like to search on is the order date. I have a masked textbox that can optionally be populated and if it is I want to do the search to include this. Stored proc looks like: create proc search_orders ( @company_name varchar ( 100 ) = null, @order_date datetime =null) Calling code looks like: this .orders_searchTableAdapter.Fill( this .ordersDataSet.orders_search, company_name, order_date); I can pick up the strings (company name) using the .Text; property of a textbox, I then check if it == "" and if so set it to null (I've discovered strings are allowed to be null ...Show All

• SQL Server Installation Error

  to I keep getting the following error "SQL Server Setup was unable add user NT AUTHORITY\NETWORK SERVICE to local group SQLServer2005DTSUser" everytime i try to load SQL 2005. How can i stop this to be able to complete the install Here are a couple of things to try: 1. Check the installation log files, located at %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files for more details on the error. (Search for the text string "value 3" to get to the failed log) 2. Try to add the service manually to the local groups using the Computer Management Admin tool. Then re-run setup. Thanks, Sam Lester (MSFT) ...Show All

• Visual C++ Help Me Please

  Hi im learnig VC++ 2005 and something wierd is goin on with my compiler.. when ever i build and run my projects an error pops up saying "This Application Has failed to start because MSVCP80D.dll was not found. Re-installing the Application may fix the problem." but here is the wierd part the file MSVCP80D.dll is present in my C:\WINDOWS\WinSxS\x86_Microsoft.VC80.DebugCRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_f75eb16c folder i can see it but how come VS is not detecting it and i even tried re-installing the software but it doesn't seem to work can someone please help me!!! Thanks Ok, then try adding the following to Project > Properties > Configuration Properties > Linker > Manifest File > ...Show All

• SQL Server SSAS2000 cube. Number of rows processed is equal to 0

  I created a copy of the cube in the same database. Then substituted fact table with different table that have same structure as old one. New table contains 1000 rows. New cube processes with no errors but number of rows processed is equal to 0. If I browse to the fact table in Cube Editor I can see that the table is not empty. Why cube does not pick up any rows Check the log file and get the SQL or while processing cube get the SQL from "Process" window and run that sql in Query Analyzer to check are you getting data ...Show All

• Visual Studio Tools for Office Word Bookmark check

  i'm using C# .net 2.0 Is it possible to check if a word template has a certain bookmark if bookmark name "babababab" then end if is something like this possible Hi The simplest way is presuming application is the Word Application Object if (application.ActiveDocument.Bookmarks.Exists("babababab")) { } else { } ...Show All

• Windows Forms we got an error "operator is not valid for DBNull and type Integer"

  we got an error "operator is not valid for DBNull and type Integer" when i enter nothing to the datagrid cell.Now i somtime i want to enter nothing in some datagrid cell If Not JvGrid.Item(counter, 2) Is Nothing And Not JvGrid(counter, 2) Is DBNull.Value And Not JvGrid.Item(counter, 2) = 0 And Not JvGrid.Item(counter, 3) Is Nothing And Not JvGrid(counter, 3) Is DBNull.Value And Not JvGrid.Item(counter, 3) = 0 Then MessageBox.Show("Invalid Entry ") Exit Function End If i would try it like that first, ( counter replaced with 0 here for my purpose) compare to item.value If Not Me .Item(0, 2).Value Is Nothing And Not Me .Item(0, 2).Value _ ...Show All

• Visual Studio 2008 (Pre-release) Configuring a service in code

  Hi, I would like to know of there is a way to configure a WCF service in code only, i.e. not using the web.config or app.config file at all. Thanks. Johan. Hi Ralph, thanks for you response. My services is hosted in IIS 6.0 using wsHttPBinding. Will configuration still be possible as explained above ...Show All

• Software Development for Windows Vista Creating an activity's property fiels based on DB table fiels??

  Hi, I want to create a database that holds the roles and users (employee). I'm about re-hosting the designer to develop general purposes modeling environment so that the business user can model their own process. my question is can I add a field to each activity's properties so that it will look up the roles table and get a drop down list with values from that table to let the user select an appropriate role for the selected activity from that table Thanks Let me re-phrase your question: you want to have a property "Role" on your custom activity and have a dropdown list in the property browser so that user can select a role; the value for the dropdown list comes from a databas ...Show All

• Software Development for Windows Vista Books about WWF

  Hi all, Can somebody suggest a good book on WWF Thanks in advance! Zen Here are some articles on WF: http://wf.netfx3.com/content/resources.aspx And some books: http://shopping.msn.com/prices/shp/ itemId=459215216,stext=windows%20workflow%20foundation http://shopping.msn.com/prices/shp/ itemId=97562313,stext=windows%20workflow%20foundation http://shopping.msn.com/prices/shp/ itemId=582773251,stext=windows%20workflow%20foundation I would personally recommend the book in the first link since it is more up to date. The book in the second link is the first book that was published on workflow and it might be a good starter. Hope this helps, Thanks Elif ...Show All

• Visual Studio Express Editions Visual Studio 2005 - ASP.NET - Creating tables - IRRITATING FEATURE

  Why, when I make any table in Visual Studio, does it make every cell 100px width for example, if a choose to make a table with two rows and two columns (no specified width), it creates this: <table > < tr > < td style ="width: 100px"> </ td > < td style ="width: 100px"> </ td > </ tr > < tr > < td style ="width: 100px"> </ td > < td style ="width: 100px"> </ td > </ tr > </ table > These questions are not handled on this board. Users are referred to: http://forums.asp.net/ which specializes in these kinds of questions. ...Show All

• Visual Basic Irritating effect from combo

  I have got a form that I open, in the forms load event i do the following Me .EDF1TableAdapter.Fill( Me .DataSet1.EDF1) Me .ENameComboBox.Text = "" Me .ENameComboBox.DroppedDown = True Me .ENameComboBox.Focus() when the form loads, the combobox is dropdown and does have focus, but its got a mouse cursor showing wait it does go away after you click in the combobox if you dont dropdown the combo it does do it, why Davids Learning its working fine for now. didnt the first time I put it at the end Thanks for helping Davids Learning ...Show All

• SQL Server How to Redistribute sqlExpress

  Hi, I asked this question in another thread that was already going but has had no activeity for a month or so.. I have read the command line artical and the clickonce artical about installing the sqlExpress on the client as a silent install. There are alot of holes in the articals and i am in big time need to get this resolved. I would like someone to point me in the right direction on: 1. Client install sqlExpress from a link from my site ( with only click here type prompts ) 2. Client install sqlExpress from msi that is with my application 3. The absolute mininum componets for sqlExpress to run on the client 4. Is it possiable to install sqlExpress in my application directory and not under the clients ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. PIX Experiment File Version Mismatch Problem

  Hello. Everyone. I've just got a problem with using the PIX utility. When I want to use the PIX, it almost always messages me: "PIX Experiment File Version Mismatch" This program expects and experiment file version of 202, but the file 'C:\Some Directory Path\PIXD4.tmp ' has a version of 0. Proceeding may cause this program to crash or behave incorrectly. Continue loading file So, I can't anything to do with the PIX, .... even just one screen capture. Anyone know about why this problem is occured And, how can I solve this problem I really want to utilize the PIX program. Help me~~~ ...Show All

• Commerce Server Commerce Server 2007 and Peer to Peer replication

  Was wondering if there was any specific thought into accomodating peer to peer replication for commerce server 2007 db's. It appears that the transactions db has done away with identity fields but other cs db's still use them. I was wondering if there was a white paper or even better someone who has already implemented this. Is there anything specific to commerce server I should be aware of before attempting this or do I just need to follow the standard implementation of peer to peer replication Thanks in advance.... -- Sean The core issue you will face is that SQL database replication has not been extensively tested by us so we will not be able to support you in the event that you have problems doing ...Show All

• SQL Server why not showing nulls?

  Hi, I have two tbls joined via a varchar field.. which in tbl I have to use a CASE statement to format it correctly for the JOIN.. All works well.. however, if I add a WHERE clause to the statement, with the WHERE clause affecting only one of the JOINED tbls.. All the NULLS are not shown. I should get results like: Postcode Count tf4 0 tf5 23 tf6 15 tf7 0 etc Whereas, when I add the where clause, none of the "zeros" are shown, so I get: tf5 23 tf6 15 Why is this Here's the SQL: SELECT ISNULL(COUNT(CASE LEN(REPLACE(dbo.Customers_Trade.PostCode, ' ', '')) WHEN 5 THEN LEFT(REPLACE(dbo.Customers_Trade.PostCode, ' ', ''), 2) WHEN 6 THEN LEFT(REPLACE(dbo.Customers_Trade.PostCode, ' ', ''), 3) ELSE LEFT(REPLACE(dbo.Customers_Trade.Po ...Show All