Search results for query: *

  1. S

    SQL Stored Procedure

    Hi friends,,, I am using SQL server and VB.net 2005 as frontend.. Sending data in form of Parameters and executing the stored procedure at backend. While saving I use 3 seperate Application SQL Stored procedure to save the contents of a grid PR_insert PR_update PR_delete My question is , thet...
  2. S

    Populating Combobox slow

    It means I have 9000 items in my combo boxes. Performance problems didn't rear their ugly heads until I added AutoComplete capability. I'll eliminate that if I have to, but what do I do about the user wanting this search mechanism? Marlin.. in such case you can suggest user to use wild card...
  3. S

    Sql Server 2005 concurrent users

    We are going to provide some software solution on VB.Net 2005 and SQL server 2005. SQL Server comes with min 5 concurent users. and the total no of users going to work on thae application are 100. My quest am i supposed to buy 100 user license SQL Server 2005 or the min. user license will serve...
  4. S

    Help on SQL Statement

    Thanks a lot, for your help. Its working fine. Thx.
  5. S

    Help on SQL Statement

    we are executing the following sql statement succesfully in MS Access SELECT DISTINCT LS_ATTO.ATTODescription AS UserName, LS_ATTO.ATTOID AS UserId, IIf(PASSWD.Supervisor=0,3,PASSWD.SUPERVISOR) AS Supervisor FROM LS_ATTO LEFT JOIN Passwd ON LS_ATTO.UserID = Passwd.UserID WHERE...
  6. S

    How to restrict SA of SQl Server

    We created a database, with a new owner "AA" and Password "BB". While we create any table ,view or any procedure it gets prefixed with dbo... This feature makes it public in nature.. our requirement is The table we created with owner "AA" and password "BB" should only be handled by user AA...
  7. S

    Datatable _data Validation

    In our program , datagrid sources is table "AA". With in that table we are capturing following values xx from to 1 10 15 2 16 25 3 26 31 through select command on datatable we can execute certain checks . But we are facing froblem where , if user capture new information...
  8. S

    Sql 2005 Connectivity

    Thanks a lot Cjard..
  9. S

    Dead Lock

    We are using procedures for DML and DDL actions. From the procedure we want to handle Loacking Mechanish. Ex. If one transaction is open by user 1 , the record should automatically attain lock. If some other user wnats to get access to the same record, immediately there should be a prompt...
  10. S

    Sql 2005 Connectivity

    It gives us following error TITLE: Connect to Server ------------------------------ Cannot connect to COMP-2. ------------------------------ ADDITIONAL INFORMATION: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When...
  11. S

    Sql 2005 Connectivity

    We Are Using Sql 2005. We Loaded Sql On Server. On Client Machine We Loaded Sql Client . From Sql Client We Want To Connect Sql Centralised Server. How To Connect
  12. S

    VB.Net Vs ASP.Net Comparision

    Thanks Cjard Thanks a lot for giving right words to my question. I was concentration on Microsoft technology and thats why so much centric towords VB.Net and ASP.Net You said ver well... Now the question is On Microsoft Technology , what solution will be more effective ..... the +ve and -ve...
  13. S

    VB.Net Vs ASP.Net Comparision

    Thaks VIS for fast response. I want +ve and -ve auspects of both the tech. I am working on Application, and is developed in VB.Net 2005 and Backend is SQl. Entire Applcation is on VB Forms. If the same we try to develop on ASP.Net Which will be better option.... Again It is an Interanet...
  14. S

    VB.Net Vs ASP.Net Comparision

    Hi, Need help. I am trying to find out comparative study between VB.Net Vs ASP.Net development environment. I was confused about where to post this question.... ultimately i posted in VB Forms. We have developed a commercial application of Vb.net with SQL Backend. There is a exhaustive...
  15. S

    Datagridview display text

    Hi You will find this query as joke, but really i need this solution. I am using datagridview combobox column. Display member is of higher length - XXX - 99999999999999 when I display it on grid , as per width and my requirement it shows XXX... and rest of the information remains...
  16. S

    Date Insert problem

    Dear friends, I am landed to a troublesome area and need help. On my form as per requirement various Text boxes are there to capture Date information. It is not mandatory that all the time all date columns will be assigned value.This date information is conditional. while inserting the...
  17. S

    Tree View - Word Wrap

    Question Elaborated Dear Jmcilhiney, Thanks for taking pain and responding on this question. Actually the detailed problem is as follows I created a tree control Parent ---- Child ----- sub Child This tree is working efficiently. But the bottle neck is , when i display Node Text of higher...
  18. S

    Tree View - Word Wrap

    HI, NEED HELP IN CONTROLLING THE DISPLAY OF TEXT IN A WRAP MODE ON TREEVIEW NODE AAA BBB CCCCCCCCCCCCCCCCCCCCCCCCCC CCCCCCCCCCCCCCCCCCCCCCCCCC CCCCCCCCCCCCCCCCCCCCCCCCCC CCCCCCCCCCCCCCCCCCCCCCCCCC CCCCCCCCCCCCCCCCCCCCCCCCCC CCCCCCCCCCCCCCCCCCCCCCCCCC
  19. S

    Populating Combobox slow

    Cjard, Thanks for the suggestion. In the example defined earlier we are following the same as suggested by you. But still we were trying to find out a faster way to do the same.
  20. S

    Populating Combobox slow

    We are trying to rebuild a current Access 2002 (XP) mdb program to VB.NET with a SQL database - we are having problems with a suitable combobox. There are many threads discussing multiple column comboboxes in .NET. We are having success with the multiple columns similar to the combobox from...
Back
Top