xuyca's Q&A profile

• Visual Studio Team System readonly isn't read only

  hello everybody, i have a big problem in sharepoint 2003 when i open a file from a document library by simply clicking the link it opens as read-only. but when i change the file and save it back it replaces the original file. This is not read-only as the title bar says. How can i make the file realy read-only i want this because you have to open the file with the drop down menu and then edit file (so with a little change at the script it checks out automatically) can anyone help me with this problem kind regards One of the Sharepoint community forums might be a better place to ask this question. The jump page for all Sharepoint community resources is: http://www.microsoft.com/sharepoint/community.mspx Specifically, ...Show All

• SQL Server Service Broker and routing

  Hi We are currently starting new project and evaluating possibility of using Service Broker in it but seems there could be some problems We have a central server with a central database and several hundred of “mobile” users. Information ( actually a subset which is specific to a particular user ) should be sent from/to central database and we wanted to use Service Broker for this. When you set up a route in Service Broker you need to define Network address which I believe should be an IP address or DNS name. The problem for us is that our “mobile” users do not have static IP addresses and I am not sure we can assign a unique dns to all of them. Mobile users can connect to internet in different places… and hence get ...Show All

• Windows Forms Question on Use of DataGridView Control

  I am a noob here, so forgive the ignorance. I'm creating an application that will seach an Access database for a specific value and then use that value in a calculation. The result of that calculation is displayed to the user. Is the DataGridView control the correct method for finding the specific data in the Access database Thanks, Doug You can use a datagrid view to display the value in the database. Your datagridview is going to contain a single row and a single column. I think databinding is the concept that you are looking for. ...Show All

• SQL Server can send email using dbmail

  Hi I can't send email using sp_send_dbmail stored proc when I execute this stored proc in msdb I face no error but executing it in other databases raises an error saying this stored proc does not exist. when I executed this query select * from sys.transmission_queue I recived no result set. please tell me what to do. thanks pooyan. ...Show All

• Visual C# Inserting a first/top line into a Combobox (Windows Forms App)

  I'm using VS2005 and need to insert a line to appear as the first item in my combobox, but unlike VS2003 you don't seem to be able to use the ListItem object as it's not available in Windows Forms. Can someone please show me how to insert "Please Select" into my combobox Many thanks I tried that but I get a runtime error: "Items collection can't be modified when the DataSource property is set" Are there any other ways of getting around this ...Show All

• Visual Studio 2008 (Pre-release) MediaElement in Streaming Scenarios

  I asked this question in another thread and did not really get an answer. I'm not sure if it was because I was in the wrong area so i'll ask it again. Is there any way to get access to properties and events related to the current media being played by the player. In a scenario where one is streaming media, I cant seem to find a way to get this information for display purposes. What the heck am I to do ! WPF does not provide any metadata APIs for Media (audio/video). If you are interested in these properties, please look at the WMP SDK. ...Show All

• SQL Server Scrubbing data in a data flow task

  I can only assume that I either did something very stupid, the examples are completely wrong, or I don't have the slightest clue what it is that I'm doing. I'm trying to do one of those incredibly complicated things in SSIS that was a brain-dead, point click operation in DTS.  I want to strip characters out of an input stream from a flat file source before loading them into a table.  I've defined my data flow task.  I have my flat file source properly defined.  I have my SQL Server destination properly defined.  For the life of me, I can't figure out how to scrub the data that I want. My input is a csv file that has 22 columns of data.  Column 22 contains data and if data was not present, there is a - in ...Show All

• SQL Server StrToMember performance issue

  I am building a parameterised report against a cube. After starting with an MDX statement that performed perfectly well and parameterising it the performance went downhill fast. I was able to replicate similar symptons against the Adventure Works cube. In this example I am getting sales values at 2 different dates and breaking them down by Sales Territory and Customer Geography dimensons. In fact they could be any dimensions, but I do need to add a crossjoin in order for the problem to show itself. WITH MEMBER Measures.FirstDateAmount as --([Date].[Date].&[32],[Measures].[Internet Sales Amount]) ( StrToMember ('[Date].[Date].&[32]'),[Measures].[Internet Sales Amount]) MEMBER Measures.SecondDateAmount as ([Dat ...Show All

• SQL Server Group by on a concatenate field

  Select TOP 100 CONVERT(VarChar(10),Service_Prefix)+ '' + CONVERT(VarChar(10),Service_Code) as CODE, Date_Issued, sum(Amount) from dbo.Enterprise_Credits_Import_90_days where CONVERT(VarChar(10),Service_Prefix)+ '' + CONVERT(VarChar(10),Service_Code) <> ' 0' and Service_Prefix like 'F' Group by How can I group by the field that I selected as CODE I would be careful about grouping on such a value as this: Group by CONVERT(VarChar(10),Service_Prefix)+ '' + CONVERT(VarChar(10),Service_Code), Date_Issued Instead of doing all of this conversion stuff in the bowels of the query do it either: 1. In the user interface and write the query as: Select TOP 100 Service_Prefix, Service_Code, ...Show All

• .NET Development finalize new columns added to a table

  I can't seem to get column changes I make to a datatable to appear in the database. DataColumn col = table.Columns.Add(); // set col parameters adapter.Update(table); But nothing gets updated. How do you update a table when you insert or delete columns If you are trying to modify structure of the table in a database through modification of the structure of the datatable, then it will not work as you expected. Provider only transfers changes in the data content, not in a structure. If you need to add column to the table in a database, you would need to execute ALTER TABLE statement that specifies what you need to accomplish ...Show All

• Smart Device Development The Operation could not be completed. The array bounds are invalid

  Hi I am trying to a debug a simple "hello world" application. When i press F5, the project builds and deploys but always fails to run. I get a successful build and deployment message in the output window. After the successful deployment, i get a error window "The Operation could not be completed. The array bounds are invalid". Environment :- Win XP Pro VS.Net 2005 Windows Pocket PC 2003 SE. Langugage C# I tried hitting ctrl F5, it also doesnt work. I can also see the emulator is connected properly. Any help at the earliest shall be highly appreciable. Karthik Hi Sivarv, Yes, exactly: 1. Tools->Connect to Device has succeeded 2. Build->Deploy Solution has succe ...Show All

• Windows Forms How can I get the event when a Form is loaded and shown on the screen?

  I have a form that takes a long time to load due to some data that is being loaded on the OnLoad event. This makes the application unresponsive when the form is being opened. So what I want to do is to display a panel on top of the form that shows "LOADING..." until the form is finished loadong. The problem is that I want to start the time consuming function only after the form has been loaded and shown on the screen but I have no event for that.. Ways to solve the problem: 1. Call a BackgroundWorker thread for the time consuming function. The problem is that if the time consuming function is updating the GUI then i need to create a delegate for every change that it wants to perform on the GUI and it might also make the GUI lo ...Show All

• Windows Forms exit addnew

  hi i want to know how to prevent the addnew to occur in this situation. Private Sub BindingNavigatorAddNewItem_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BindingNavigatorAddNewItem.Click If type = 0 Then If Me .ToolStripButton1.Text = "Supplier" Then CODE TO PREVENT MY DATAGRIDVIEW TO DISPLAY THE NEW RECORD LINE MsgBox( "Please select a supplier" ) Exit Sub End If End If End Sub First set the AddNewItem property of your BindingNavigator to (none) . Private Sub BindingNavigatorAddNewItem_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BindingNavigatorAddNewItem.Click ...Show All

• Visual C# pagecontrol

  Now everybody,i have a very headache problem,i setup a tabcontrol called tabcontrol1 which contains three tabpages,each has a datagrid,and a just a query button on toolbar .i want to have this function:when i entered tabpage1,and click button,it get the information from database(or use some sqlconnection,sqladapter,etc),when i entered tabpage2,do the same action,it gets data from database2.i want to use if sentences,but just if (tabpage1.enter( have this property )) { do something like sqldatadapter.fill...) if(tabpage2.enter...... ...... Andrej Tozon wrote: You can use the if sentence like in the following snippet: private void tabControl1_Selected( object sender, TabControlE ...Show All

• Visual Studio Express Editions Newbie question on editing

  I do not know how to do the EDITING in steps4 and 5 below and don’t want to try (by opening the files in word pad) and mess things up. Please help. Thanks in advance, Gerhard From http://msdn.microsoft.com/vstudio/express/visualc/usingpsdk/ Step 4: Update the corewin_express.vsprops file. One more step is needed to make the Win32 template work in Visual C++ Express. You need to edit the corewin_express.vsprops file (found in C:\Program Files\Microsoft Visual Studio 8\VC\VCProjectDefaults) and Change the string that reads: AdditionalDependencies="kernel32.lib" to AdditionalDependencies="kernel32.lib user32.lib gdi32.lib winspool.lib comdlg32.lib advapi32.lib shell32.lib ole32.lib oleaut32.lib uuid. ...Show All