I have written a local intranet program so that users can chech the status of different projects.
I use session variables to keep tract of the project number and the phasecode of the project they are viewing. How ever if there are more then two users then the one that changes the project number...
I am able to add a new record to the dataset with the following code.
Dim i As Integer
Dim anyRow As DataRow = Me.objpagers.COMM.NewRow
Me.objpagers.COMM.Rows.Add(anyRow)
i = Me.objpagers.COMM.Count
Me.grdCOMM.CurrentRowIndex = i
grboxadd.Visible =...
Using a stored procedure in an SQL Database with VB calling it:
CREATE procedure dbo.up_select_company
@code_id varchar(4)
as
select *
from company
where code = @code_id
VB part:
cmdcompany.Parameters.Append cmdcompany.CreateParameter("@code_id", adVarChar, adParamInput, 4, varcode)...
Using a stored procedure in an SQL Database with VB calling it:
CREATE procedure dbo.up_select_company
@code_id varchar(4)
as
select *
from company
where code = @code_id
VB part:
cmdcompany.Parameters.Append cmdcompany.CreateParameter("@code_id", adVarChar, adParamInput, 4, varcode)...
I am unable to export a report created by crystal reports to a word doc through code alone. Vb code will only display it in the crystal reports preview. But I would like to have VB call it and save it with out user interface. Can this be done? If so how
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.