thuthinh's Q&A profile

• SQL Server Consolidation - Changing replicated data in a central subscribing site

  Hi all, I am new to replication and have a few questions. 1) Are there any "hooks" available to insert processing when a subscriber is about to copy data from a replicating site 2) Is it possible for a subscriber to change only his local copy of the data - without replicating the changes back to the publisher I realise that once the data changes in one place it isn't really replicated anymore, and I realise that my limited knowledge of the subject might well mean I'm not even asking the right questions. Therefore, I shall try to describe as best I can my scenario. I wish to use many servers for transactional input (to distribute the workload) and use replication to publish the inputted data to a subscribing centra ...Show All

• .NET Development arrays to sql server table

  Using vb8, I would like to be able to programmatically save data in arrays to an existing sql server 2005 table. I've found tons of info on how to load db data into arrays but not the reverse. Can anybody offer some clues It's no secret that I consider ADO far less code intensive than ADO.NET. I can do this with VB6 and ADO quickly and easily with about half a dozen lines of code. However, knowing when to use DataAdapters, DataSets and/or DataTables is what ruffles my feathers. I've read dozens of pages in BOL, assorted forums and numerous websites. Unfortunately, the normally very helpful walkthroughs concentrate on using designers and wizards; coding for dlls seems all but ignored. If there is a plai ...Show All

• Visual Studio Team System Postbuild and prebuild scripts

  I am using the newly released CTP 5 and have been trying to use the postbuild scripts and prebuild scripts to add certificates as well as permissions for a database. However, when I try to deploy the project I get an error saying that it can't find a procedure when trying to assign the permissions and it looks like the postbuild scripts and prebuild scripts are being combined and run together, both before any of the other database scripts (tables, procedures, functions, etc.) are deployed. My question is there a better way to deploy the permissions for the database other then putting them in the postbuild script or is there a way to fix it so that the postbuild scripts is run only after the main database scripts are run ...Show All

• Visual Studio 2008 (Pre-release) How to pass parameters to a DataBinding in XAML? - I want (need) to seed the construction of the DataBinding source object.

  I have a set of generic (generalized) DataBinding source objects, each of which maps to a different UI control type (eg. collections for ComboBox, single value for checkbox, etc.). <CheckBox.IsChecked> <Binding Path="Value" Source="{StaticResource SingleValueBinder}" /> </CheckBox.IsChecked> or <ComboBox Name="MyCombo" Height="21" Margin="20,20,20,20" ItemsSource="{Binding Source={StaticResource ItemsSourceBinder}, Path=Values}" IsSynchronizedWithCurrentItem="True"> </ComboBox> These objects are basically serving as adaptors and internally map to a host of specific object values. I need someway to specify which of the unde ...Show All

• .NET Development http download

  dear All , I am trying to download a file from Web Server to my local machine. I am using .Net Framework 1.1 and Visual Studio 2003 this is snipet of code I have used. private void Button2_ServerClick( object sender, System.EventArgs e) { string connString = "Data Source=cdodev;User Id=security;Password=security;Integrated Security=no;"; OracleConnection conn = new OracleConnection(connString); DataSet ds = new DataSet(); try { //string parentLink = TextBox_ParentLink.Text; string series = TextBox_Series.Text; string type = DropDownList_Type.SelectedItem.Text; conn.Open(); string dataString = "select b.url from tbl_crawler b where b.parentlink = '" ...Show All

• Visual Studio Team System Failed to create New Team Build Type

  Hi, I trye to create a New Team Build Type, but it does not work. An error box is displayed with the next message: "Failed to retrieve data from the server. Please verify that the Team Foundation server is running and try again." But the TFS is running normally, and I work without any problem. I'm using a workgroup version of the TFS, and I'm an administrator of the Server... Can you help me please # Team Foundation Trace for component VC started at 09/20/2006 16:45:42 [note all date/time values are in GMT]. # Trace listener: Microsoft.TeamFoundation.TeamFoundationTextWriterTraceListener # Config settings: Assert UI Enabled=False Launch Debugger=True ASP.NET=True # Trace switch set ...Show All

• Visual C# Visual C# - documentation

  Hello! I have to learn C# and Visual C# IDE in 10 days. Can you help me with a fast documentation for learning quickly Thanks' very much for help. 10 Days, I hope you have some programming experince! But here are some great resources: C# tutorial list Visual C# Developer Center C# Programmer's Reference - Tutorials Absolute Beginner’s Video Series C# windows forms applications Absolute Beginner’s Video Series C# web applications nice tips and tricks for C# developers Microsoft programmer's references index for some tutorials online ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. On screen Key bored/GamePad

  I'm trying to make an On screen Key bored/game pad But the problem is I Don't know much about this so can i even do this with xna or c# I'v got a felling that i need to hook the key bored. I know nothing about doing this in c#. I'm not sure you can even do this with c#. then i need to know how to send out the letter. i would also like to do one for a 360 controller and i don't have a clue about that. Can someone help me Just tell me were to start. ...Show All

• SQL Server Increase Aggregation Percentage

  Is there a way to force the design aggregation in BIDS to 100% All of my dimensions have attribute relations defined (as indicated in the designer) yet I can get only around 35% aggregations defined. My main issue is an Excel pivot table that the user wants to create that has 3 row dimensions. When the Excel pivot table is first built, access is fast, but when the user drills down to bottom level of each dimension, the query takes a long time. We have a Hyperion Essbase/Analyzer report that shows the same information rather quickly. The difference I can see is that Analyzer has a list bottom function and the cube space in Essbase is very large (I think Essbase builds an aggregation for everything thus the faster access speed). As ...Show All

• Visual C# Cancel Editing Form / Text Box Validating Event

  Hi there, I have a text box which fires the 'Validating' event. This checks for : String .IsNullOrEmpty(myTextbox.Text.ToString()) and if so, throws an error. I also have a cancel button on the form, which simply closes the form without saving. Trouble is, if the focus is set on the text box - when it is empty - then I press the cancel button, the Validating code is fired, and the cancel button code is not - so I cannot close the form. I could capture the Form KeyPress event, but this seems like an unnecessary overhead. Any ideas Thanks very much, Jonny Validation is caused by the control receiving focus and not by the control losing it. The CausesValidation property ...Show All

• SQL Server MDX to aggregate measure over specific dimensions

  Hi, I'm trying to write a calculated member in SSAS 2005 that will only aggregate across certain dimensions. For example, say I have five dimensions: D1 - 5. I only want the member to aggregate across three of these dimensions. So in the cube browser, when I drag these three dimensions in, I get the correct aggregated value. But when I then drag dimensions four and five in, I want this value to stay the same. (The measure is currently in a measure group that uses all five dimensions). I was thinking that the solution would be to have an MDX expression of the form ([Measures].[Measure], [D1].CurrentMember, [D2].CurrentMember, [D3].CurrentMember, [D4].[(All)], [D5].[(All)]) but I would prefer not to have to list all dimensions and their hie ...Show All

• Windows Forms Connection String to .Net 1.1 with Mysql

  Hi, I want to do the connection string to .Net 1.1 with Mysql.I have no Experiance in MySql It will be helpfull if get some sample for writting the connection. Thanks, Karthik Use the mysql dot net connector For mysql 5 http://dev.mysql.com/downloads/connector/net/5.0.html For earlier versions http://dev.mysql.com/downloads/connector/net/1.0.html ...Show All

• SQL Server From MySQL to MSSQL 2005

  Hello! I'm installing the MSSQL 2005. And i want to transfrom the DB from my old MySQL DataBase to new MSSQL Database. How can I do this With Import|Export Utils I can't do this task =( Pleasure Help me. Thanks That is a good idea, but it still leaves a big problem.  After you have the structure built, you still have to create a separate data reader with a sql statement for every table in the database.  When you have hundreds of tables, it presents a time challenge.  And on top of that, DTS can handle implicit data conversions (like boolean to bit), and SSIS requires explicit conversions for each of these data type changes. That's why the SQL 2000 DTS Import is still superior, where you c ...Show All

• Visual C# referencing a custom class instance

  Mine is a .NET C# app on VS2005. I have a "main" form class Form1 and a number of classes that are used on demand. One of them is CandlePlot . CandlePlot is instantiated in a function Funct1 which is called by a Click method. Funct1 creates the plot and places it on a newly generated TabPage. So far so good. Most of the code plot related I downloaded as a demo from NPlot.com website. It is great and honest software. I just need to improve it introducing some dynamic elements which appear to be absent in the original. The CandlePlot Class has DataSource property. Inside Funct1 where the Class CandlePlot is instantiated I initialize this property by assigning a DataTable to it. The DataTable is supplied as a parameter in a li ...Show All

• Visual C# Retrieve column names using metadata

  I am implementing an application that needs to quickly retrieve a list of column names of a table for an ODBC connection. Is there a way to use metadata to achieve the goal so that I don't need to run a query on the entire table Thanks. Hi, If you're using table adapters and dataset you can call the table adapter's FillShema method on the table you're interrested in. Next you just have to iterate on the table's column: DataSet ds = new DataSet (); ds . Tables . Add ( "MyTable" );   OdbcConnection conn = new OdbcConnection ( connString );   OdbcDataAdapter adapter = new OdbcDataAdapter (); adapter . SelectCommand = new Odbc Command (     &nb ...Show All