Search:
Type: Posts; User: techyspecy
Search:
Search took 0.39 seconds.
-
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...
-
Unbelievable these MS people ... :mad:
http://support.microsoft.com/default.aspx?scid=kb;en-us;823679
-
Public Overloads Function ExecuteStoredProcedure(ByVal page As Integer, ByVal pageSize As Integer, _
ByRef recordCount As Long, ByVal...
-
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)
-
-
I do not think you understood my question very well ...
-
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...
-
Geez, you're hardcore .. :bigyello:
-
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...
-
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,...
-
anybody ? whats wrong with that code ??
-
:)
You can create a XML document with a normal String variable.
E.g;
Dim myXML As String
myXML = "<Root>"
myXML = myXML & "<Name>XYX</Name>"
-
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...
-
Thats the whole point, name cannot be the key because name can be repeated for a different menu item ...
-
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...
-
-
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...
-
Private Sub LoadAndInvoke()
Dim t As Type = Me.GetType
t.InvokeMember("MyMessage", Reflection.BindingFlags.InvokeMethod, Nothing, Me, Nothing)
End Sub
Public Function...
-
-
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 ?
-
Thanks Matt, will try that and let you know ...
-
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...
-
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 ...
-
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...
-
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...
-
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...
-
Rest in Peace Mikey.
:mike: :duck:
-
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...
-
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...
-
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...
-
Actually hiding the progress bar is very easy, just call Me.Refresh to hide the progress bar.
-
Use CDO Objects for sending emails if you can. Search for CDO and my ID. You should get some examples.
ciao.
-
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.
-
-
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...
-
You are assuming that there will always be a primary key in the table. And what about UDFs and VIEWs ????
-
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, ...
-
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),...
-
No that is when they're going to release 'ORCAS'. The 2005 version of .NET. :D
-
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...
|
Click Here to Expand Forum to Full Width
|