Search:

Type: Posts; User: techyspecy

Page 1 of 13 1 2 3 4

Search: Search took 0.39 seconds.

  1. Replies
    0
    Views
    584

    Passing Unicode data ..

    I have a Stored Procedure which takes a ntext parameter. I somehow have to pass this "N" character with SqlParameter collection while I am building my parameters from VB.NET application. If I do not...
  2. Replies
    1
    Views
    591

    Re: Timeout Expired Error ..

    Unbelievable these MS people ... :mad:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;823679
  3. Replies
    1
    Views
    591

    Timeout Expired Error ..

    Public Overloads Function ExecuteStoredProcedure(ByVal page As Integer, ByVal pageSize As Integer, _
    ByRef recordCount As Long, ByVal...
  4. Replies
    10
    Views
    1,077

    Re: Stored Procedure

    Try this ..

    CREATE PROCEDURE dbo.Test
    @make varchar(17)
    AS

    Declare @sql varchar(1000)
    Set @sql = ''
    Set @sql = ' Select X From X Where X Like ''%' + @make + '%'''
    Exec(@sql)
  5. Replies
    4
    Views
    865

    Re: Fill method ..

    Tx ..
  6. Replies
    4
    Views
    865

    Re: Fill method ..

    I do not think you understood my question very well ...
  7. Replies
    4
    Views
    865

    Fill method ..

    I understand DataAdapter's fill method does provide the option of controlling paging through ADO code. You can specify the starting position and number of records to fill the DataSet/DataTable with...
  8. Replies
    9
    Views
    483

    Re: :sigh: valentines

    Geez, you're hardcore .. :bigyello:
  9. Replies
    2
    Views
    604

    Caller Class ..

    I have three Classes.

    ClassA
    ClassB
    ClassC

    ClassA is a public class which exposes a shared instance to other classes. ClassB and ClassC are using ClassA. There is a method in ClassA called...
  10. Replies
    3
    Views
    861

    Crystal Progress

    In VB.NET, when you open a Crystal Report in CrystalReportViewer, which property do I have to set to display the progress bar in CrystalReportViewer ??? If you ever noticed, in crystal enterprise,...
  11. Replies
    5
    Views
    877

    anybody ? whats wrong with that code ??

    anybody ? whats wrong with that code ??
  12. Replies
    3
    Views
    750

    :) You can create a XML document with a...

    :)

    You can create a XML document with a normal String variable.

    E.g;

    Dim myXML As String

    myXML = "<Root>"
    myXML = myXML & "<Name>XYX</Name>"
  13. Replies
    5
    Views
    877

    I am trying to do this ... Public Class...

    I am trying to do this ...

    Public Class CustomMenuItem : Inherits System.Windows.Forms.MenuItem
    Dim TagValue As Integer

    Sub New()
    MyBase.New()
    End Sub

    Public...
  14. Replies
    5
    Views
    877

    Thats the whole point, name cannot be the key...

    Thats the whole point, name cannot be the key because name can be repeated for a different menu item ...
  15. Replies
    5
    Views
    877

    Unique Menus

    I am adding menu's based on the information coming from the databases. Now there is no tag property available for menus. The function name that each menu item is suppose to call is also coming from...
  16. Thread: docking ..

    by techyspecy
    Replies
    3
    Views
    686

    how ?

    how ?
  17. Thread: docking ..

    by techyspecy
    Replies
    3
    Views
    686

    docking ..

    why is it impossible to have two controls on a form and both have Fill property set for Docking ???? So if one control collapses the other one should take the screen space and vice versa ??? Is there...
  18. Replies
    2
    Views
    598

    Private Sub LoadAndInvoke() Dim t As...

    Private Sub LoadAndInvoke()
    Dim t As Type = Me.GetType
    t.InvokeMember("MyMessage", Reflection.BindingFlags.InvokeMethod, Nothing, Me, Nothing)
    End Sub

    Public Function...
  19. Replies
    2
    Views
    598

    :confused:

    :confused:
  20. Replies
    2
    Views
    598

    RESOLVED - Dynamic method ..

    Can somebody post an example of how to call a procedure or function dynamically using system.reflection ?? I have seen lot of people talking about it but yet to see how it works ... anybody ?
  21. Thread: Tooltip

    by techyspecy
    Replies
    6
    Views
    886

    Thanks Matt, will try that and let you know ...

    Thanks Matt, will try that and let you know ...
  22. Thread: Tooltip

    by techyspecy
    Replies
    6
    Views
    886

    Well, the problem is, the screens are built...

    Well, the problem is, the screens are built dynamically based on database definitions. With your suggestions, I will somehow have to maintain all tootip controls for each combobox ... that will be a...
  23. Thread: Tooltip

    by techyspecy
    Replies
    6
    Views
    886

    Yeah, I'd like to do something similar .. any...

    Yeah, I'd like to do something similar .. any idea ? I do not want to put tooltips on combobox everytime user moves the cursor on it ... that would be lot of tooltips ...
  24. Thread: Tooltip

    by techyspecy
    Replies
    6
    Views
    886

    Tooltip

    I have a combobox, and it has some items with fairly large width. I cannot make my combo that wide. However, when user clicks on combo to drop the list I have increased the list size. But once user...
  25. Replies
    0
    Views
    438

    Query Builder

    Anybody ever worked or built a query builder tool in VB.NET ? I am looking for one .. or at least some pointers. I want my users to be able to build queries based on database objects by just...
  26. Replies
    0
    Views
    462

    Query Builder

    Anybody ever worked or built a query builder tool in VB.NET ? I am looking for one .. or at least some pointers. I want my users to be able to build queries based on database objects by just...
  27. Thread: Parksie

    by techyspecy
    Replies
    193
    Views
    26,552

    Rest in Peace Mikey. :mike: :duck:

    Rest in Peace Mikey.

    :mike: :duck:
  28. Without going in the details of N-Tier with WOKA...

    Without going in the details of N-Tier with WOKA .... :)

    You should split DLLs where it makes sense. A DLL for all Global functions that are going to be used throughout the application for...
  29. Replies
    2
    Views
    13,511

    xp_starmail and procedures like this require...

    xp_starmail and procedures like this require exchange server account and logon information. which is more cumbersome and problematic. While my SP does not require such things, only SMTP services...
  30. Replies
    7
    Views
    592

    Try this ... Select a.StudentID, ...

    Try this ...

    Select
    a.StudentID,
    (Select b.Title From Applicant b where b.Appnum = a.Appnum),
    (Select b.LastName From Applicant b where b.Appnum = a.Appnum),
    (Select...
  31. Replies
    19
    Views
    13,142

    Actually hiding the progress bar is very easy,...

    Actually hiding the progress bar is very easy, just call Me.Refresh to hide the progress bar.
  32. Replies
    4
    Views
    615

    Use CDO Objects for sending emails if you can....

    Use CDO Objects for sending emails if you can. Search for CDO and my ID. You should get some examples.

    ciao.
  33. Replies
    26
    Views
    1,361

    Poll: I wish I had the ability to ban the moderators...

    I wish I had the ability to ban the moderators ... :D
    No seriously, T-SQL is very powerful and provides great performance enhancements over the other method of writing things in components.
  34. Replies
    26
    Views
    1,361

    Poll: T-SQL any day.

    T-SQL any day.
  35. Thread: pageing

    by techyspecy
    Replies
    10
    Views
    751

    Re: pageing

    What are you talking about ??? Cursor will not send you any data, you will have to go to database again and then use the pagesize and absolutepage to get the data. Otherwise there is a potential of...
  36. Thread: pageing

    by techyspecy
    Replies
    10
    Views
    751

    You are assuming that there will always be a...

    You are assuming that there will always be a primary key in the table. And what about UDFs and VIEWs ????
  37. Thread: pageing

    by techyspecy
    Replies
    10
    Views
    751

    Here, I wrote it for our applications .. works...

    Here, I wrote it for our applications .. works fine for us. You can pass UDF,VIEW,TABLE .. just about anything for the Tablename.

    CREATE PROCEDURE DBO.SP_Table_Paging
    (
    @Page Int, ...
  38. Replies
    2
    Views
    13,511

    SQL Stored Procedure to Send Emails ..

    You will need Execute Access on Some SPs on your Master database on SQL server. But its pretty slick.

    CREATE PROCEDURE [dbo].[USP_Send_CDOSysmail]
    (
    @From varchar(100),
    @To varchar(100),...
  39. Thread: Whidbey

    by techyspecy
    Replies
    8
    Views
    517

    No that is when they're going to release 'ORCAS'....

    No that is when they're going to release 'ORCAS'. The 2005 version of .NET. :D
  40. Replies
    16
    Views
    640

    ASP is not annoying. Usage of 3rd Party ActiveX...

    ASP is not annoying. Usage of 3rd Party ActiveX controls in an web application is always discouraged and bad practice for numerous reasons. We work in ASP all the time, we have built our own controls...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width