jzfredricks's Q&A profile

• SQL Server How to make Update relation?

  I have two tables: TableX & TableY there is two similar fields (Size) with the same datatype, I want to make a relation in a way if I change the value in (TableX.Size) the same value will be applied to (TableY.Size). How to I'm not sure that you are really talking about needing a 'relation'. It sounds as though you only want a method that will change TableY values when a similar value in TableX is changed. That 'could' be done with a TRIGGER. But first, it will be necessary for you to identify which row in TableY is to be changed as a result of a particular row in TableX getting changed. In other words, "How do the two tables 'relate' to each other " ...Show All

• Visual Studio Express Editions User Searches 2 fields to find a database record in application.

  Hi, I am learning Visual studio 2005 Express Suites (very new learner). I am attempting, in a form to have a user type in a first name and last name into a text box each, then click a button to find a person in the database. The associated database fields are: StudentID, StudentFirstName, StudentLastName (StudentID is a foreign key in a a couple of other tables). The text box field names are: TxtBFirstName and TxtBLastName. The button name is: BSearch There seems to be a way to do this type of search through the bindingsource [studentsbindingsource] where I click the little arrow, choose "Add Query", click "Query Builder", then edit the SQL query. I am confused as to how to phrase the WHERE clause - basically it would ...Show All

• SQL Server Window Title in RS 2005

  Hi, am calling MSSRS Reports from an asp.net application. the Reports are opened in a new browser window, In MSSSRS 2000, the new windows opened have the window Title equal to the report name. but in MSSSRS 2005 the window title justs shows "Report Viewer" as the window title for all the report.s Can anyone gimme a quick solution, so that the report name appears in the window title when i call the reports in MSSSRS 2005. Quick solution will be appreciated. Thanks. Hi thanks Kaisa, the solution works perfectly, but then i will have to change the Report.aspx file on the client(customer) side, i would appreciate if there is any other solution that could be sent with the report (rdl) file ...Show All

• Windows Live Developer Forums Convert Local Live Polygon coordinate to Lat/Long

  First off, MS release of Local.Live is great in the sense that users can now zoom in, highlight an area, and then share that highlighted area via the polygon feature of scratch pad. My question: Is there a way to go from local.live's coded polygon coordinates to lat/long We'd really like to collect polygons drawn on local.live and re-use them in a VE implementation. However, the polygon points are encoded and VE wants lat/long points. Ultimately we could try to re-build WLL, but trying to build the scratch pad looks tricky. For example, given this URL: http://local.live.com/ v=2&sp=Polygon.pfy1bp5c6008_pfy19f5c63q3_pfxt1f5c63t0_pfxsrx5c5zst_pfxty85c5z46_pfy0j75c5z2t_pfy19f5c5zkz_pfy1bp5c6035_pfy1bp5c6008_Test%20field____%2 ...Show All

• .NET Development Encode Problem

  I try to load file like *.doc,*.txt and use FileStream class Read that,but it display abnormally. thanks in advance. jiangzw. Its not in my knowledge that if there is anyway to check encoding of a file without opening it. Anyhow have you tried to use Default Constructor of StreamReader without specifying any Encoding May be it'll itself evaluate and use right Encoding Does this help Best Regards, ...Show All

• Visual Studio Tools for Office Create worksheet with precoded events attached?

  Hi, If I have a class worksheet e.g. sheet1.cs. Is it possible to add multiple instances of this worksheet to a workbook For example if the user clicks a button a button a new sheet of sheet1.cs will be created each time with all previously coded events and controls associated with it Thanks in advance. Ben. Hi, Thanks for the reply. I have been trying to wire up events to a newly created worksheet today , but have so far been unsucessful. If you could point me to a link with an example of this or create a small code sample, it would greatly be appreciated. Thanks. Ben. ...Show All

• Internet Explorer Development IE 7 opening to Run Once page with error on it.

  I downloaded updates last week. I have been using IE7 for a while with no problem. I dwnloaded the updates. Now when I open my browser the page tries to go to http://runonce.msn.com/runonce2.aspx . There is an error reported for this page and it will not open up I get a blue screen. How do I eliminate this I have my home page set in the tools section but when opening it won't go to my home page until I hit the home button on the tool bar. Hello i had the same problem but i do know the answer on how to fix it you will not need to reinstall anything, go to start then click run, in the box type gpedit.msc once this is open you should find a window comes up with a menu down the left hand side, clic ...Show All

• SQL Server How to get rowcount

  Hi, How to get the row count for a particular query being executed within a session and scope. is there any option to get the value being displayed in the messages tab when a query is executed (no of rows affected). is there anything equivalent to scope_identity for getting the identity value inserted in a session and scope. Vivek S to obtain number of rows affected... @@RowCount (return an int) RowCount_Big() (return a big int) to obtain last genereted identiy value... @@IDENTITY, SCOPE_IDENTITY, and IDENT_CURRENT are similar functions because they all return the last value inserted into the IDENTITY column of a table. @@IDENTITY and SCOPE_IDENTITY return the last identity value gene ...Show All

• SQL Server Query for 4 weeks average ..Need help

  i have 3 tables, each with a date(it has daily dates) column(column name is same in all tables) Each table has columns say "value1","value2", "value3" i want data from all these tables together.such that my first column will have data weeks and other 3 columns count1,count2,count3 will have average of next 4 weeks count..placed infront of week. weeks count(value1) count(value2) count(value3 ) 1/1/2005 101 88 221 1/8/2005 100 81 151 1/15/2005 87 96 301 Average calculations Here : week 1 2 3 4 Count1: 101 = ( 99 + 105 + 110 + 87 )/4 100 = (105 + 110 + 87 + 98 )/4 Plz lemme know if u have any suggestions.. Sumit: I ...Show All

• Smart Device Development Problem tryin to start MSMQ on Arm V2 CTP Emulator

  Hello All, I am trying to start MSMQ on the Arm 4VI V2 CTP Emulator and I get an error: Operation failed. Error Code 0x00000425 I have checked the services on the emulator and I do have the MMQ1: listed but not started. I have tried the MSMQAdm start and I get an unknown error. Thanks in advance for any help :) Bob Hanson Hello All, I had just tried to use the msmqadm register command on the emulator and it did return a guid. I then tried to use the msmqadm start and it then DID work. I rechecked this with the services list command and sure enough, all is good :) No issue any more. Bob Hanson - One happy camper :) ...Show All

• .NET Development MessageQueue: is there a way to receive by topic?

  Hi, i'm used to JMS where you can publish a message with a certain topic and then one or many clients subscribe to the message queue, with a specific topic, in order to receive only the messages that are addressed to them. I haven't found a way to achieve this with the MessageQueue object using only one queue. I think i can do the same creating as many queues as topics, but i think the application will loose in performance. So to resume, the things i'm not being able to do are: - broadcast a message to many receivers - receive only a message specifiying some sort of topic. Thanks for your time! nacho. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Absolute and relative mouse movement

  Usually when dealing with mouse input you want the data from the mouse in two forms, one is absolute that you might use to draw a cursor or know which part of the window/screen a user has clicked on, and the other is relative where you are only interested in how much the mouse has moved. Currently, the MouseState only seems to report the mouse movement in the absolute form. This means anyone using the mouse to control, for example, a first person camera would find their movement limited by the size of their window/screen. I have tried playing around with the Mouse.IsCaptured property but it doesn't seem to make much difference, quite possibly because I don't know how to use it. Am I correct in thinking that getting relative mouse input dat ...Show All

• SQL Server DROP DATABASE -> database in use error

  when I do DROP DATABASE I'm getting errors because it's in use. But if I do a delete from the mgmt studio gui I have the option to close all connections as part of the delete. Is there a way to achieve the same effect from a sql script Here is an article I wrote about that: http://drsql.spaces.msn.com/blog/cns!80677FB08B3162E4!950.entry Basically: alter database <databaseName> set single_user with rollback immediate I find this indispensible when testing database creation scripts with a few windows open and I need to drop the database, recreate it with scripts, fix some stupid bug and then re-run things. Two tricks: First, most every dialog in SSMS and SSMSE ...Show All

• SQL Server Problem using Monthname function

  I am trying to have the below formula populate a portion of a textbox The right(Parameters!ToTimeDimensionCloseYYYYMM. label , 2 ) is because I am dealing with " YYYYMM " and I only want the "MM" portion. =iif(right(Parameters!ToTimeDimensionCloseYYYYMM. label , 2 )=01,Monthname(12),monthname(right(Parameters!ToTimeDimensionCloseYYYYMM. label , 2 )) ) When I use this formula it will work for December, however for the rest of the months if a user chose 200603, it will read "March" when I really want it to read "February". =iif(right(Parameters!ToTimeDimensionCloseYYYYMM. label,2 )=01,Monthname(12),monthname(right(Parameters!ToTimeDimensionCloseYYYYMM. label ,2)-1))) However, w ...Show All

• SQL Server Using expressions in custom data flow transformation

  Hi, I'm creating a custom data flow transformation in c#. I would like to use expressions within this component in the same way as in the derived column component: specifying the expression as a custom property of an output column, then evaluating this expression for each row of the buffer and using this evaluated expression to populate my output column values. So I've added an custom expression on my output column, and set its expression type to CPET_NOTIFY IDTSCustomProperty90 exp = col.CustomPropertyCollection.New(); exp.Name = "Expression" ; exp.ExpressionType = DTSCustomPropertyExpressionType .CPET_NOTIFY; But in the ProcessInput method I don't manage to get the evaluated expressions, when I use exp ...Show All