PaulVC's Q&A profile

• SQL Server Configure datepart's first day of the week

  Hello, I would like to configure the first day of the week as monday. I know how to set it on sql using set datefirst 1. But i do that in the server that im working and on the report my week is wrong. It isnt using monday has the initial day, but sunday. Im using the datepart on the expression of a field, the RS probably is getting another configuration, why Is he picking it up from the VB engine If so how can i configure Is he picking up from another db What is the db that he normally gets it from If the thing that i did is almost right but it doesnt configure the server but only my session, how can i configure the db/server properlly. Thank you hey man, try this - http://www.vsmsdn.com/devnet/Thread.aspx Thread ...Show All

• Visual Basic Displaying changed data

  Hey there. Not sure if this is in the right subject, but here it goes. I'm developing a windows application in VB .Net 2003 and SQL Server 2000 and what I need to is make the application so when one user adds a record it displays on another users screen almost instantaneously, my current method uses a timer, however problems occur for the users when trying to modify the data. Can anybody help If so please let me know. Can you be a little more specific about what you mean by "problems occur" In particular, what problems are occuring ...Show All

• Visual C# HttpException:"Cannot have multiple items selected in a DropDownList"

  I am using a DropDownList on my webpage. I have populated it from Database by using DataBind() method after providing him binding informaion. It works fine. But when ever i try to select an item by code. it generates the HttpException with message "Cannot have multiple items selected in a DropDownList". Few things: I am not doing post back, this exceptoin occurs on very first call. I am not selecing more then one values. I have also tried with by calling ClearSelection() before selecting an item. I have tried with multiple ways and i got the same error in every case. by usign .SelectedIndex by using .Text by using .SelectedItem by using .SelectedValue I had debug the c ...Show All

• .NET Development Where do I find class properties?

  SUMMARY: Where do I find the properties of classes such as IPHostEntry FOLLOWUP: Where do I find a simple description of how to use the class I.E. Set these variables, initialize with these functions, then do this. When I create a Windows project and put a TextBox in the new window, on the right side of my screen I find a properties window. This lists the variables of the TextBox. These variables contains much information that I can utilize when working with a TextBox. With the cursor on a TextBox, pressing F1 brings up the help file with a nice description of the TextBox. It begins with “Windows Forms text boxes are used to …” and proceeds to tell me what they are used for. Then I put the cursor on the phrase IP ...Show All

• Windows Forms Problem adding stored proc commands to Typed DataSet

  This one appears to be a bug in the Typed DataSet designer in Visual Studio 2005 but maybe I'm just missing something. Here is how it happens: I have a table "Friends" already setup in my Typed DataSet with only a Fill query configured on it's table adapter. I switch over to SQL Management Studio, connect as "sa" and create a stored proc "Friends_Insert" and then I grant Execute permission on the stored proc to my non-admin sql user account "jason". I switch back to VS2005 and in the DataSet designer I click the "FriendsTableAdapter" object. It's Connection property shows a connection string configured to connect to SQL Server 2005 as "jason". I click the InsertCommand property an ...Show All

• Visual C# Short path

  Hi all, I'm creating a game and I nead to know the shortest path from point A to point B. I started programming it, but I still get a lot of problems that I can't get rid of. Here is an example of a situation I mean: A: Starting point B: Location to end at X: Place where you can't walk at 1: The path that should be chosen. (You can not move diagonaly.) B 1 1 1 X X X 1 X 1 1 X 1 X A 1 1 What is the best way to program any situation, so you can retrieve the best and shortest path. I started with some basics and etcetera..But what must I exactly do Using random Using ...Show All

• Smart Device Development Custom Mail Client Development

  Hi, I'm opening this thread again because someone closed my previous thread without actually reading my posting. This posting IS related to smart devices. PPC is the abreviation for Pocket PC. Is that not a smart device Anyhow, my previous posting was: Is the hotmail team or live team planning on opening up hotmail anytime soon I'm writing a ppc mail mash application and want to incorporate hotmail. I think a hotmail web service is long overdue! Regards, RJ WebCentric Software Systems, LLC www.WebCentricSoft.com ...Show All

• Visual Studio sending variables over a network

  Hi All! I mostly develop real-time dsp software with platform-specific IDE's, but most coding, offline debugging and simulations are done in VisualStudio because I'm so used to it. There's one major drawback atm though: I can't do anything without having a visual representation of audio/video data, it's impossible to see what's going on by staring at an array of samples. Right now I send everything to a Labview program (over a tcp connection) by inserting lines of code whenever I have to watch something. This is getting unmanagable though as I have to recompile the program anytime I add a new watch. So I'd like to get rid of the code for sending the data, and plug it into a plugin that does the same. Just like you would right-click a varia ...Show All

• SQL Server Need to Subtract the result of two stored procedures

  I am trying to take the results from two stored procedure and subtract them to get credit from two columns. The stored procedures look like create PROCEDURE mw AS select * FROM pla p where p.st in ('ds', 'sd') and (iPlayerID = '5345') compute sum(p.amount) RETURN both procedure have the same syntax. I am not able to use AS in to insert the values into a variable. Is there a wizard to use That worked for a bit then I noticed that I need to apply the value to create credit. DECLARE @credit money SELECT @credit = sum ( amount )+( moneySpent - @moneyWon ) From Table Where status in ( 'var' , 'var' , 'var' , 'var' ) and id = '5455' select ...Show All

• Visual Basic How to Rotate Text in RTF

  Hi Folks, Any RTF experts out there I want to insert a text object that is rotated like what you can do in Powerpoint's text box or Word's Word Art. Unfortunately, when either is saved in RTF, the text content is lost in the raw code, so I cannot do a search and replace on the rotated text. Word only saves the text content if the text box is used with the alignment changed to vertical. Is there any way to create rotated text that is visible in the RTF code I am prepared to insert all the required positioning code myself, if I only knew what was required. Any ideas would be greatly appreciated. Hi Nobugz, I must be missing something here. My version of Word 2002 does not allow free ...Show All

• SQL Server OO Database Design performance question

  I am hoping someone has had a similar table design scenario and has a slick solution that i am not thinking of. Basically I have the following tables (kind of OO based design in this case). Create Table Entity (EntityID int, EntityTypeID) Create Table Company (EntityID, CompanyName) Create Table Contact (EntityID, FirstName, LastName) Create Table Group (EntityID, GroupName) Basically an Entity can be a Company, a Contact or a Group based on the EntityTypeID The trick becomes when I get an EntityID is how to get the name of the Entity in an efficient manner. You can make a view that does a Union to all three tables like such... select CompanyName as Name from Company union all Select FirstName + LastName ...Show All

• SQL Server How to write Condition in the Conditional Split control in SSIS

  HI i need to write the Condition for Insert and Update Reccord depending upon the Prod_ID. How to write the Follwing condtion in the Condition Split pls Anyone give me the Solution    "  if   Prod_ID  Exist then  UPDATE  Records     if Prod_ID   Not EXIST then INSERT Records "     how to write the above conditon in the Condional Split Thanks  &  Regards, Jeyakumar.M chennai     Jkumar wrote: Hi Thanks for your reply as very soon. I Already Wrote this condition in the Conditinal Split . Any have i am doubt for this one. Is it Correct or Not Just for my calrification for this i ma posting this ...Show All

• SQL Server Displaying a field in SQL Server MSE

  I have a long text field in a table. Is there a query that I can execute in Mgt. Studio Express that will display the whole of this field. It is too long to easily see in the table view and SELECT <fieldname> from <tablename> only displays part of the field before displaying ellipses (...). Many thanks, This depends on what your data is and how you're displaying it. If the data is an XML document then casting it to XML in the select will allow you to click on it and display nicely formatted XML. If it's just text then management studio has a configurable limit on how much it will display. Go to Tools->Options in the menu bar and navigate to Query Results->SQL Server->Results to ...Show All

• Windows Forms Is it Possible ObjectDataSource and datagridview

  I have an objectdatasource bound to a datagridview in a Windows forms app. The datasource object has a boolean field. I can load and display the data ok. If there are 20 are so rows and the AddRow row (*) is not visible  everything is ok. However if the addrow row comes into view or the mouse hovers over the boolean field then I get the error in the DataError event:  "System.FormatException: Formatted value of the cell has a wrong type".  I tried setting the CellStyle Null Value to false and 0. I tried setting the true and false values. I tried putting default values into the ObjectDataSource's constructor. I can't seem to get rid of the error or figure out what datatype the cell is expecting and what datatype is ge ...Show All

• Windows Forms newbie: Can't find the duplicate (xxx.Form1.resources) in "Resources" parameter, help please.

  Using C# and the latest VS 2005.  Hunted for just about every combination and twist on this error information.  This happens when I try to 'create project from existing code.'  Haven't yet found the answer for this Ultimate Question (42, doesn't work.)  Probably a very fundamental thing but I'm missing it as yet. Output C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Microsoft.CSHARP.Targets(147,9): error MSB3105: The item "obj\Debug\Webcam_Test.Form1.resources" was specified more than once in the "Resources" parameter. Duplicate items are not supported by the "Resources" parameter. Done building project "Webcam_Test.csproj" -- FAILED. Error List The item "obj\Debug\Webcam_Test.Form1.resources" was specified mo ...Show All