Asp.net - Calling Procedures From Different Pages
Nov 4, 2011
I have a Custom.ascx file that is used on a number of pages. Custom.ascx contains a couple of controls and a button called cmdCustomPageButton. When the user click on cmdCustomPageButton, cmdCustomPageButton executes a Protected Sub that gets some data from a database.
Page1.aspx that is using Custom.ascx has its own set of controls and procedures that it executes. It contains a button called cmdPage1Button and a procedure called RetriveData that is being called by other procedures as well within Page1.aspx. When cmdPage1Button is clicked it calls RetriveData. RetriveData is only applicable to Page1.aspx. Page2.aspx and Page3.aspx both has a procedure similar to RetriveData but is only relevant to its own page.
Try to explain using code:
Custom.ascx
Public Class Custom
Protected Sub cmdCustomPageButton_Click(Byval sender as Object, ByVal e as EventArgs) Handels
[CODE]..............
The question. How do I call the different RetriveData procedure form the relevant pages being it Page1, Page2 or Page3 when cmdCustomPageButton is clicked ?
View 2 Replies
ADVERTISEMENT
Dec 20, 2011
I am using Stanav's PdfManipulation2.AddImageToPage(..., Pages) for iTextSharp library (v5.1.3) and was not able to add the image to specific pages: e.g. to add to only page 1 and 3 of a five pages PDF
Dim Pages() As Integer
Pages = New Integer() {1, 3}
PdfManipulation2.AddImageToPage(..., Pages)
Calling AddImageToPage() with the the optional Pages parameter will add the image to all pages though.
View 14 Replies
Jul 10, 2009
calling stored procedures using ADO.NET. We have an application developed, which uses SQL Sever as backend and Visual foxpro as front end. In this application every thing is done by database only. That is all insert, update, delete operations are done by SQL Server only. So we have to provide some input and output paramaters to stored procedures. Some time these procedure carry out insert, update, delete operations as well as return some data in the form of tables.
View 4 Replies
Aug 30, 2009
As I teach myself VB, I'm working on using the backgroundworker. Mostly I'd like to use it to update a progress bar. But here the problem I'm running into...
When I use it like this:
Private Sub TestWorker_DoWork(ByVal sender As Object, ByVal e As System.ComponentModel.DoWorkEventArgs) Handles TestWorker.DoWork
Dim ListText As String
For Value As Integer = 0 To 100
If TestWorker.CancellationPending Then
[Code] .....
Where GetPlayerNames() is the Sub that really contains a majority of my code, which uses a class library I wrote, and calls other functions, etc. But this just causes the backgroundworker to skip right to the RunWorkerCompleted and executes no code. It seems to me you should be able to call procedures from the DoWork and then pass updates back via the ProgressChanged event. I can't image you need to consolidate all your code into the DoWork.
View 13 Replies
Dec 4, 2009
I would like to know the pros and cons of calling procedures with Call Keyword and without Call in VB.NET?
Private Sub ProOne()
// Code Are Here
End Sub[code].....
View 5 Replies
Jan 17, 2010
My boss has given me an asp.net web application that was done by his former employee. Now my boss has no contact with that employee. He wants me to make some changes in that web application. I went through the application. There is no documentation present for that application . Its a huge application. It contains many directories. I think it was a team work. It has many asp pages, aspx pages, jsp pages, xml pages, css pages, etc... How to understand other person or team's website or web application that was written in asp or asp.net and vb or vb.net?
View 4 Replies
Jun 8, 2009
Can someone tell me how to get the name of the child page being called in a Master page scenario. For example, if I have the following masterpage:
<%@ Master Language="VB" CodeFile="MasterPage.master.vb" Inherits="MasterPage" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
[Code]...
And I create a page called Test.aspx which inherits this masterpage, how can I, from the masterpage, know that Test.aspx has been requested (since this masterpage can be inherited by more then 1 aspx page)?
View 5 Replies
Dec 7, 2010
I have 2 master pages with same (href) links on top of the page. Now these links load on the same master page when clicked on (by requirement). The problem is both these master pages have same links, so basically the same page shall be loaded in the master page.
Now what i need is when the person is on Master Page 1 and clicks on the link it should load in the same page. Whereas if the user is on Master Page 2 and clicks on the same link, i should be able to change the master page from 1 to 2 and load that in Master Page 2.
View 2 Replies
Mar 19, 2009
I have a form on a .NET webserver using aspx pages with the vb code-behind pages. The form collects the entered data and then emails it, that part works fine.Right after it gets emailed, this code checks to see if the email was sent or not and then updates the landing page accordingly. I used to use just an IF THEN statement, but now that doesn't work in these new .NET pages. Here's the end of the code that I am having difficulties with:
[Code]...
View 10 Replies
Jun 19, 2009
I have heard of setting server specs to have HTML pages parsed as PHP pages by changing the .htaccess or httpd.conf files. Is there a similar solution to have HTML pages parsed as ASPX pages?
A website I am working on does not want their PageRank to lower since their HTML pages are already indexed and used on other websites but wants to use some dynamic features of aspx pages (like include the navigation file so that changes to the nav will only have to be done in that one file).
View 2 Replies
Jul 13, 2011
i have this program which records the every printing made on a local computer.I am to record the number of pages of the document to be printed and the number of printed pages. i have this code but i don't know the number of pages and number printed pages always return 0 [Code].
View 1 Replies
May 10, 2009
I'm trying to learn how to use procedures?
Public Function mgboc(ByVal mboc1 As String, ByVal mboc2 As String) As String
Return mboc1, mboc2
End Function
But it doesnt work. I want it to "return" the parameters, but it won't even compile.
View 2 Replies
Jan 12, 2010
Why we use CLR procedures. Is there any significance of CLR Procedures or any example where CLR Procedure is the only solution?
View 4 Replies
Jan 20, 2012
How can i call a procedure to calculate the cost of the suv and compact car mileage twice with that same procedure? Thats the only part i cant figure out with this function/procedure stuff. Also am i doing the procedures right?
Quote:
'Developer: John Nelson
'Date: Janurary 18 , 2012
'App Name: Compare Fuel Cost
[code]....
View 5 Replies
Feb 28, 2011
i have made some stored procedures for the first time and now i want to use them in vb.net code
'"Insert Procedure"
Sub InsertSettingz()
'Store the settings for the reports
[code]......
View 2 Replies
Nov 23, 2011
I have a function in my program that adjust sales for multiple days. Sometimes it needs to adjust up to 3 months and the tasks takes a while so I decided to split up the work between multiple threads. The way I have it working is say I need to adjust 3 months. I have the first thread adjust sales for the 1st month, the second thread adjust sales for the 2nd month and finally a third thread that will adjust sales for the 3rd month. Since all three threads are performing the same tasks except for different date range they use the same procedures. Within those procedures I make a call to the database to extract the sales for the given month. At some point it seems like the threads start to use the same SQL Data Objects because I am receiving the below error."There is already an open DataReader associated with this Command which must be closed first."Below is the first procedure that is ran by each thread up to the line where it errors out.
Private Sub Process_Adjustments(ByRef objAdjustBillCodeThreadParameters As clsAdjustBillCodeThreadParameters)
Dim cmd As SqlClient.SqlCommand
[code]....
So all three threads call this subroutine and the first thread does the data fill with no issues and then sometimes even the second thread does the data fill with no issue but then the third thread crashes and produces the above error. It seems as though the threads are sharing the same SQL Objects when all objects are local to the sub and I always thought each thread had it's own memory to work with. So I thought each thread would call the sub create it's own objects in memory, but that does not seem like what it's doing. I have other multithreading processes in my application that work perfectly fine, this is the first time I am attempting to multithread in this manner where I am using the same procedure within multiple threads.
Just thought of something that I might be doing wrong. The subroutine in question is in the same class where the threads are created. Should the subroutine be in it's own class, and therefore each instantiation of that class?
View 3 Replies
Feb 3, 2010
I created a subprocedure to change the background color of the selected matching labels in this concetration game. Now I want to change it back to silver when all the labels are selected I tried all the insertion points I could think of for a EndGame function but none have worked. I'm thinking I'm barking up the wrong tree.[code]
View 1 Replies
Feb 18, 2010
I've lived in the VB6 world for the last 15 years and am only now starting to learn .NET. I've got a long way to go, but I am hung up on a fundamental issue about collections.I live and die by collections in VB6; I use them for just about everything I do.So I am very used to having the abilities that the intrinsic VB6 Collection has.Things like adding items with keys, referencing items by key or index, having the "Add" method return an instance of the object, being able to add custom procedures to the collection, having it strongly typed, etc.But all of the collection information I have read about in .NET doesn't really do all of this.(I am starting out in VB.NET, with the possibility of moving to C# at a later time, so i am trying to stay away from the Microsoft.VisualBasic namespace.)
View 11 Replies
Jul 25, 2009
Some question about Ado.net and SQL Server stored procedures. We have a stored procedure in SQL Server as described below
Procedure dob.PendingCalls
@UsID As Char(10), @Sts As Integer OUTPUT , @Msg As VarChar(100) OUTPUT
AS
Begin
[code]....
we are using vb.net in visual studio 2003. Now if ExecuteNonQuery is used then we do not get rows. If ExecuteReader is used then we get rows [ with forward-only access which is of no use to us] but we cannot get output parameters values returned by stored procedure?
View 13 Replies
Jun 3, 2011
Im currently working on a car service program on Visual Basic. The user simply selects some radio buttons, enters a couple of values and at the end the lablels are SubTotal, VAT and Total. Can anyone tell me how I calculate the VAT, the VAT rate I need to use is 20%. I currently have an appropiate answer for the Sub Total. I know I need to multiply the SubTotal amount by 0.2 but how do I do this using Procedures and Functions?
View 5 Replies
Dec 29, 2011
I have a block of related sub routines I would like to "group" together within class to make navigating a littel easier. When I say group, I mean achieve the same functionality of being able collapse and expand a block of code as would with single procedure or class. Two alternative ways I can think to accomplish this is either use a partial class for those procedures or use namespace. I just wanted to see if VS for VB.Net had another way to be able group and collapse blocks of procedures.
View 3 Replies
Jun 11, 2012
Am looking for a Currency Text Box control that will accept numeric key input and display entry as Currency according to Users Regional Settings.
Additionally, when an assignment is made such as Currencycontrol.text= 123.45 + 500 , user will see value displayed as $623.45 or formatted to regional specifications.
I do need a control rather than formatting procedures since my form could have 24 or more currency fields.
View 4 Replies
Nov 30, 2011
If I write many subs and functions in my code, the tools on the interface will stop responding to some of the subs and functions. What can I do about that?
View 1 Replies
Jul 26, 2010
The code below is right to execute more store procedures?
Dim mySQLCommand1 As New SqlCommand("sTruncate", myConn)
Dim mySQLCommand2 As New SqlCommand("sAddress", myConn)
Dim mySQLCommand3 As New SqlCommand("sProvider", myConn)
[code]....
View 1 Replies
Jun 9, 2010
I am new to LINQ and trying to learn it. I have a stored proc which returns XML Raw and I need to call this proc using VB.NET and LINQ...
View 3 Replies
Aug 6, 2009
I initially posted this in the wrong forum. I need help getting this to run properly. I'm trying to construct a fractions calculator. In order to complete it, I need to do it like this:Using Select Case statements, four Function procedures should be called based on the operation selected. Each Function procedure will calculate the correct operation and return the Decimal value to the calling procedure. The original procedure will print the result.
Now, the result should be calculated to the hundreths place and the input values should be validated by a Try-Catch Block.And of course, I've been having trouble with how to do this. I've attempted many times and this is what I have so far:
[Code]...
View 2 Replies
May 10, 2009
I just happened to be reading through a post and stumbled upon this and was curious. As I was remiss to go off topic in someone else's post, I've dragged it out here.What we are doing here is logically incorrect. We loop thru all the records and set the sheet locked state and button image. But since the button is just one element, so effectively the image set would be that of the last record.We need to separate the two procedures and the events they take effect too.Ideally we should set the sheet locked state while loading it. (maybe the form_load event etc.). And we should set the button image when we switch the sheets (e.g. sheet change/activate events). The selection of events however depends on your requirements and wisdom.
[code]...
I noticed how the image was accessed above. My question is this, what is the differences between the above method and Image = Image.FromFile(Path) and if any, what are the advantages/disadvantages of each? This is just for knowledge purpose and is not pertaining to any particular problem.
View 1 Replies
Mar 30, 2009
I want to call a Stored Procedure using SqlDataSource. I've been reading the library documentation of the classes but i'm getting slightly confused. To call a stored procedure, I understand that I have to change the selectcommandtype and then set the selectcommand property to the name of the procedure.
'Change command type to stored procedure
SqlDataSource1.SelectCommandType = SqlDataSourceCommandType.StoredProcedure
'set name of stored procedure
[code].....
View 5 Replies
Aug 28, 2009
For some reason my stored procedures are all executing twice! I have a static function that runs an SP given its name and the parameters and fills a datatable.
Public Shared Function RunSP(ByVal spName As String, ByRef spParams As Dictionary(Of String, String), ByRef pDataTable As DataTable) As Integer
Dim cmd As New SqlCommand
Dim lAdapter As SqlDataAdapter
[code]....
Is there something wrong with the code? I've checked with the debugger and the appropriate SPs are definitely only being called once, i.e. this function only runs once for a particular insertion function, but two things are inserted into the table.
View 2 Replies
Jul 28, 2009
I'm doing a program with VISUAL BASIC 2008 and i want to update a DB by using STORED PROCEDURES.
The DB is in SQL 2005, And I want to insert [NAME,LASTNAME,SEX].
I want to know what kind of conection use and how to send de parameters to the SP.
View 1 Replies
