marcoMB's Q&A profile

• .NET Development GetChanges() always returns null table

  I have a database with two tables. ContactInfo (Contact ID int (PK), Last Name varchar(50)) AltAddress (AltAddressID int (PK), Address varchar(50), ContactID (FK)) I'm wanting to display and update related in text boxes on a form. Each ContactInfo entry will only have one AltAddress entry. I've added the text boxes from the DataSources windows and it creates two Binding Source objects. ContactInfoBindingSource(dataSource = testDataSet, dataMember = ContactInfo); AlternateAddressBindingSource(dataSource = contactInfoBindingSource, dataMember = altAddressContactID_fk) This works for displaying the data correctly! My problem is when I try to get changes to the altAddressTable, it always returns a null table. Here is the line ...Show All

• SQL Server HELP !! HELP: Trigger to send REPORT !!!

  Hi all, Report Manager is failing to email out the reports !!! And... I can not use Report Manager to configure the trigger ! How can I trigger manually to have SQL 2005 email out the reports again OR how can I trigger to run those emailing jobs again Thanks, Frank I don't really understand the question. How are the subscriptions configured (Timed or Snapshot ) If they are configured to fire on a snapshot then you just need to update the report execution snapshot. If they are on a schedule, you could fire the SQL Agent job manually or call FireEvent passing in TimedSubscription and the subscriptionId. Does that answer your question ...Show All

• Smart Device Development label background color not working

  Hello Im creating some labels for my program on PPC with mobile 5.0 and VS 2005. I noticed that that my labels won't accept background color other than those belonging to System color. how can i use other color for my label like yellow, blue or green http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=178752&SiteID=1 ...Show All

• Software Development for Windows Vista Restart Manager TC 30

  Our product has a waiver to be run always as administrator. When the product is run as administrator and RMTool (as normal user) sends a shutdown signal (-S) to the application no WM_QUERYENDSESSION message is recieved by the application. Instead a 10005 event message is sent. Is it possible to avoid this 10005 message, Machine restart is required Even when a normal user is sending the request BR, Daniel If both is as administrator it works nice. The program recieves the correct messages and the 10005 event message can be avoided. Problem is that Vista Certified crew want it to work both ways. Daniel ...Show All

• Windows Forms How to detect the changes on listview

  For .Net FW2.0, I can detect the changes on datagridview by subscibe the event "RowAdded","RowRemoved","CellValidated". Step by Step: 1.Write a method Eventchanged(object sender, EventArgs e), I will set a bool value to be true; public void Eventchanged(object sender, EventArgs e) { this.detectObject.Ischanged = true; } 2.subscribe the event after form loaded; this.dataGridView.RowAdded += new EventHandler(Eventchanged); this.datatGridView.RowRemoved += new EventHandler(Eventchanged); this.datatGridView.CellValidated += new EventHandler(Eventchanged); 3.Through the local variable detectObject, I can know if user have changed the content in the control datagridView. But I can not find the same events ...Show All

• Visual Basic Help with Post Message

  Declaration: <DllImport("user32.dll", _ CallingConvention:=CallingConvention.StdCall, _ CharSet:=CharSet.Auto, _ EntryPoint:="PostMessageA", _ SetLastError:=True)> _ Shared Function Post( _ ByVal hwnd As IntPtr, _ ByVal wMsg As Int32, _ ByVal wParam As Int32, _ ByVal lParam As Int32) As Int32 End Function Constants: Public Const WM_LBUTTONDOWN As Int32 = &H201 Public Const WM_LBUTTONUP As Int32 = &H202 Sub: Sub LeftClick(ByVal Handle As IntPtr, ByVal XCoord As Int32, ByVal YCoord As Int32) Post(Handle, WM_LBUTTONDOWN, 1, XCoord + YCoord) ' Left mouse button down Post(Handle, WM_LBUTTONUP, 0, XCoord + YCoord) ' Left mouse button up End Sub Problem: This met ...Show All

• Visual C++ Boot from CD or HDD,how can I know?

  Hi all: I've got a question that in my program I have to know where the system boot from,CD or HDD.So how can I do that Thanks! Hello Re: Boot from CD or HDD,how can I know Such questions are outside the scope of this forum - for the scope of the VC General forum please look at: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=19445&SiteID=1 For such issues please use the newsgroups at http://msdn.microsoft.com/newsgroups . OTP Thanks Damien ...Show All

• SQL Server Management Studio Scripting Bug?

  In my install of management studio when I use the scripting wizard and get to the Choose Script Options dialog The Script Behavior drop down has only two options (Generate CREATE statements only, or Generate DROP statements only).  It doesn't have the option to generate a drop followed by a create.  If you read the description of the Script Behavior that is below the options you'll see that it advertises a Drop and create option.  Why doesn't the dropdown have all three options   Bug or not Yes, thank you for the reply. I too would enjoy seeing that functionality back, 2 passes to accomplish 1 thing is monotonous. ...Show All

• SQL Server exporing a table from one dattabse to another

  I have a database which is on a network and I want to transfer a table form this databse onto my local machine. Is this possible as in Access they have an export function but I can't find such a thing on sql server expresss. I have tried copying and pasting the data across but there are over 200,000 rows so I imagine it will take me for ever. As anyone any suggestions Cheers hi, SSMSE does not provide SSIS (SQL Server Integration Service) features to allow a task like that, but you can perform the very same activity via standard Transact-SQL code... SET NOCOUNT ON; USE tempdb; GO CREATE TABLE dbo.originalTB ( Id int NOT NULL PRIMARY KEY, data varchar(10) NULL ); GO PRINT 'populate it with some data'; ...Show All

• SQL Server Dynamic dimenssion security

  I am trying to pass the username to a vb function in the allowed members set of a dimenssion. For some reason it is not getting to the function. All of the other parameters are being received as I am logging them in the event log. Any ideas on why it looks like the username is not being picked up at all would be great. Thanks in advance. Chris Chris, I'm assuming you are using the UserName() function Can you post the MDX expression you have in the allowed members set definition You might try creating a test calculated member using some or all of the MDX expression you are using for that parameter just to make sure it is resolving in the manner you think it should... Dave F. ...Show All

• Gadgets Digital Signature

  Hi, Sorry if this is a total newbie question. But I am, and I didn't find anything about it in the forum yet. How can we add digital signature to a Sidebar Gadget TIA, Eric See this thread ...Show All

• Smart Device Development sorry

  Hi Forum! May I ask your help please. I want to change the character/symol order on my WM2003SE based device. (samsung SGH-I750) When I press for ex.: button 2 the order is: a, b, c, 2, a, a, a, a, a, a, c, and i would like to change it to : a, a, b, c, 2. the other symbols are unuseful for me. I tried to change the sym.txt in Windows folder but nothing happened. I read somewhere that the symbols are storen in T9ime.dll, or T9aw.dll but I can't edit these files. thanks for help Hi Forum! May I ask your help please. I want to change the character/symbol order on my WM2003SE based device (samsung SGH-I750). When I press for ex.: button 2 the order is: a, b, c, 2, a, a, a, a, a, a, c, and i would ...Show All

• Visual C# Conversion of Data to a letter(PDF format)

  Hi, I am writing this application (in C#.NET off course) for my organization where I extract data from a SQL server database and then print out the data in pdf format. I am done with this part, the part that I need help is that upon extraction of the customer information from the database, my company wants to print out a letter with the customer information on it which can be later mailed to the customer. So in short, for every customer there in the database, a letter needs to be generated with the extracted information on it and this letter needs to be in pdf format. I was doing some research and somebody somewhere mentioned crystal reports. I have no idea how to use crystal reports in this particular instance or in any instance for th ...Show All

• Visual Studio Team System TFS and running Test cases

  Hello guys, I am new to TFS. Using TFS I have to run some predefined Test cases. Just wanted to know whethers its possible and if so how can it be done. Thanks, Aditya Cannot cathch it what's you meaning Using TFS I have to run some predefined Testcases Can you explain it detaily ...Show All

• Visual Studio Team System Best Practice for Adding a NOT NULL Column

  What's the recommended process for adding a NOT NULL column on an existing table controlled by Database Professional This may seem like a no brainer by editing the table script but follow the process all the way from the time the developer modifies the table script AND uses Write Updates to update the a schema. The Write Updates button will fail because the NOT NULL column cannot be inserted without a default value when the table already has data in it. Do we really have to put a bogus default value just to get the column added We ended up putting a bogus default value so Database Professional could apply updates as it normally does and we could create a SQL script for our DBA to apply the updates to other databases. We then coded a ...Show All