Tom_Liu's Q&A profile

• Visual C# SQL schema discovery - find primary key

  Hi, since DataTable.Load(IDataReader) does not read primary keys, how can I find them Probably using DbConnection.GetSchema... It would be great to have this done within common schema collections, however, SQL Server specific would be acceptable as temporary solution. Thanks, Jan You can use sql view: SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE TABLE_NAME = 'YourTableName' Probably every DBMS has different way of storing this information. I know that for getting table schema i used completly different way of getting that information from SQL and Access. For sql was a view like this one, but for Access it was using GetOleDbSchemaTable method of oledbconnection ...Show All

• Smart Device Development Removing the Title Bar from the Form using Compact Framework

  Hi All, i was wondering if anyone knows of a way that I can remove the Title bar from the UI forms using C#. You used to be able to do this using Win32 dialog boxes, however I can't seem to find out how you can do it using managed code. Anyone know Thanks, Hi Rachad In addition to Sergey's sugestion, try setting the Form.FormBorderStyle to None and the Form.ControlBox to false. This works for my device. This should hide the window title (caption). The Start Menu will still be visible. If you want a real 'Full Screen' do what Richard suggests. HTH Michael ...Show All

• SQL Server running ssis package with a remote sql agent?

  hi all, thanks for the valuable information all the time!!! saved me a lot of time... our team developes a system for text data improvement using ssis . we have a few heavy packages that we want to execute on two separate "SSIS servers" that will be dedicated to runnung these packages only, and repeatedly. the main sql server will be placed on a different server machine . my question is: what is the best way to do this if we schedule these packages as a job of the Sql Ajent- does that mean that the packages will be executed on the sql server machine (which is not what we want) or could we define a remote machine to run the package on, and specify our "SSIS servers" or- should we use a simple scedua ...Show All

• Visual Basic Password char in textbox

  Hi, Somebody knows how I can set only to the first five characters in a textbox the passoword char. Example: *****8965 The characters can’t be replaced with *. Dim TheTextBoxValue As String Private Sub Button1_Click ( ByVal sender As System .Object, ByVal e As System . EventArgs ) Handles Button1 . Click MessageBox . Show ( TheTextBoxValue ) End Sub Private Sub TextBox1_KeyPress ( ByVal sender As Object , ByVal e As System . Windows . Forms . KeyPressEventArgs ) Handles TextBox1 . KeyPress If Char . IsLetterOrDigit ( e . KeyChar ) Then If Me . TextBox1 . Text . Length < 5 Then ...Show All

• .NET Development .Net 1.1 forward compatibility

  Hi I have an C# application compiled with VS 2003 (.Net 1.1) that needs to use a dll compiled with VS 2005 (.Net) 2.0. The machine have both runtimes installed but the application refuses to use the dll since it been created by newer version. Is there any way to work in VS 2003 with .Net 2.0 dll's Thanks. Michael Vainer wrote: Is there any way to work in VS 2003 with .Net 2.0 dll's Not directly, no. But if you could define interfaces for the functionality you need in a v1.1 assembly and implement those in the v2.0 assembly, you could possibly code just against the interfaces. If you then configure the application to load the 2.0 CLR even though it was compiled for 1.1, you c ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Why I can't see any game component in VC# express 2005 toolbox?

  After I saw the demo of game component video from XNA team blog, I want to try.But I can not find any game component in toolbox. What is the problem Thanks mrMercury - I got that part - but I'm looking for the code (or just the components) for the ones that were shown in the demo (grid, camera, etc.) ...Show All

• SQL Server Any one help me out!

  Hi I have a requirement in SSRS where in i need to generate a report in which initially there will be one record (say, a manager of a department and some values corresponding to him ) now i need to provide a drill-down on this employee(mamager) such that the next level of employees reporting to him should be displayed with all the parameters and this has to continue till the leaf level employee. Thanks in advance. The following is a code example of my implementation. Copy the xml into a file and save as .RDL. You may need to modify the connection as locally I have SQL 2005 installed as a named instance. The code flattens a table by performing a join onto itself for every level in the hier ...Show All

• SQL Server OLAP Connectivity

  Hello all, We have Analysis Services 2000 with an OLAP cube. The cube has a role allowing access to all Windows domain users. From my development workstation we can connect to the cube, using Excel or a HTML page with the Office Web component, logged on as any user. However, from any other computer in the domain, and logged on with the same users, we cannot create a connection; the OLAP server is not visible! The client computers are all the same: Windows 2000 Pro and the users all belong to the domain. Why can we not connect Has anybody ever experienced this sort of problem We need to solve this by Monday, our deadline to show our OLAP application to the users. I would really appreciate somebody's help. Thanks in advance, J ...Show All

• .NET Development network programming

  hello, i would like to thank in advance for loking at my problems, i want to create a website and and windows application to interact with the exsisting software via telnet. sound complicated let me put some more light on it. The end user will send the command through website to a specific port on a computer were my windows application is running aling with the third party software(),i want my wndows application to continously listen to the port and detects thr request from the browser interface(website) and perform the certain action based on the command send from the browser based interface(website)and send the result back to website. I am succesfull in making interaction between 2 windows application one acting as server and ...Show All

• .NET Development window.showModalDialog problem

  I have button on Search.aspx page. when user clicks on that button a new window appears using following javascript function GotoSelectProgram(memberid) { var url2 = "SelectProgram.aspx MID="+memberid; str = window.showModalDialog(url2); } the above script will create new window for SelectProgram.aspx page. This new page has datagrid with few rows. and each row has ImageButton called Select. when user select any row i want to close that popup window and parent window should navigate to ProgramUpdate.aspx im using following c# code in click event of select button private void MemberDetails1_SelectorChanged(object sender, ProgramEventArgs e) { // some code here Response.Write("<script language='javascript'& ...Show All

• Visual Studio Express Editions cannot get specific line into textbox from TXT

  is there any way to search a TXT file for a specific string or take a specific line from it I have had my application generate a file based on what the user entered in all the text fields. now i want it to load the information back in for editing. Example: i've got a file called server.cfg (cfg is same as TXT); the following is the first few lines from the file. //============================================== //This file was generated by S.O.B's Server Tool //============================================== deathmatch 1 set hostname S.O.B's House of Frags rcon_password doodle11 fraglimit 30 timelimit 30 ----end of snippet----- i need it to take the line "set hostname S.O.B's House of Frags", and chop off every ...Show All

• SQL Server challenging likes wildcard

  Hi all, I need to search the field containing the word I enter, but this word is bracketed by " {{ " and " }} ". For example, I would like to search the keyword apple , I need to search by the following sql statement. select name from table where name likes '%{{apple}}%' But the case is that that column may contain some space between the bracket and the keyword. i.e. {{     apple  }} . How can I write a sql statement to search name from the keyword Thanks Spencer Thanks Rod, But this query will search the keyword ap ple , a pple , app le etc. This is the challenge for me. Spencer ...Show All

• Visual Studio Express Editions The Matsui riddle (Advanced programmers only)

  Sensei Matshui is now old and blind. He sits in the sun drenched courtyard of his dojo in Tokyo. He has fifty student in five rooms. 10 in each. All the students in the same room have the same name. They are  itchi, ni, san , si and go. They are well disciplined and obedient. Every time Mr. Matshui  receive a new batch of student he affixes the rule of the dojo on the door post of every room. The rule on the door post of the itchi's room says: only  one itchi  can stay in the courtyard at any given time. Itchi can/has to leave the courtyard only if it is told so or a call goes out for an other student from  one of  the other rooms. Although the blind sensei may call for itchi several times, no other itchi sho ...Show All

• Visual Studio Express Editions Saving Entire Forms

  How can I simply save an entire form in Visual Basic Express I have created two forms in in my project. One form asks the user to input information in text boxes. The other form simply reads the input in form1 and duplicates the user input. How do I then save form2 as it is Please help! I've been searching this answer for two days. I know it's probably right in front of me. thats great, thanks for the nice feedback - much appreciated. I try to make sure that I give the best possibly solution and to make sure that one does succeed and do things correctly :-) ...Show All

• SQL Server Populating a Lookup table

  I'm trying to do a table lookup in t-sql and runing into problems. I have two tables, City and County.. Table City: CityID CountyID CountyName 1 3 NULL 2 2 NULL 3 1 NULL Table County: CountyID CountyName 1 Los Angeles 2 Contra Costs I want to populate the NULL "CountyName" field in table City with the values from table County but I can't make it work! Any help appreciated. Barkingdog Hi, try the following one: UPDATE City SET CountyName = County.CountyName FROM City C INNER JOIN County ON C.CountyID = County.CountyId HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All