I have a very specifically designed table in a .aspx page. I have an <asp:SqlDataSource> tag that works fine with a DetailsView. I have tried DetailsView, ListView, Gridview etc. and cannot obtain the desired design. Is it possible to execute a Stored Procedure and have the individual results displayed in the individual cells of a web page table? This seems like it should be simple but it apparently is not.
View 2 RepliesI have a stored procedure, and I want to save the results of the stored procedure into a table. Is there a way I can do this with a simple query without creating the table beforehand.
View 8 RepliesI have created a search form based on my SQL database to search for individual records based on 3 types of criteria. The form is up and running but I want to be able to add some more code. I have assigned Stored Procedure to each click event for each button. What I wantr to be able to do is after value is added to text box and button is clicked if there are no reults to display than a message box is displayed with adequate message detailing this. Also is it possible to add a count of records to the form. Once value has been enetered ij tyext box and stored procedure runs and fills dataset with required data can I display a box to show number of records from this search.
[Code]...
I had the great fortune to receive the task of converting an ancient VBA Access order tracking application into a stand alone VB application. Along the way I was trying to parameterize their SQL queries, most everything has gone well but now I am getting an error I can't figure out."Item cannot be found in the collection corresponding to the requested name or ordinal."Iam kind of stuck using as much as the old code as possible because the client "knows VB" and wants to be able to edit the code after I'm gone.
[Code]...
My app calls for the use of an SP that doesn't return rows from a table, but results based on certain conditions.
View 3 RepliesAnd I like the speed of the datareader over a datatable, so I'd like to make this work! Using VB.NET 2005. All the prior responses to the same problem say to return to datareader or use a datatable. I have no idea what return to datareader means.
View 3 RepliesI have an asp.net page that contains a javascript function. I am using a vb.net code behind to run a stored procedure against the database to pull back address information. Results can be 1 or more rows. I need to pass the results to the javascript for processing. My code is as follows:
VB.NET
Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
[Code].....
I'm having a devel of a time getting what I figure is something simple to work.
I need to set up a Combobox where the list of items is created by accessing a stored procedure.
The SQL code is simply (I left off the code to create the sp);
SELECT ItemCode
FROM vw_CodeList
GROUP BY ItemCode
ORDER BY ItemCode
I have a linqtosql dbml where I dropped a stored procedure into the designer interface.
Stored procedure name:
GetUser(@userid int)
Select * from users_tbl where userid=@userid
[code].....
My application produces this error System.Data.SqlClient.SqlException: Login failed for user..This started after I added a stored proc in my dbml file. It works fine in my local enviroment, but throws that error when deploy to staging sever. the user it displays is foreign to me?
View 1 Repliesthis is the first time i am calling a stored procedure via vb.net and i would like to make sure i have everything correct before i execute it. This is my code:
[Code]...
The stored procedure returns 6 colums worth of data and i would like to add that data to a listview. I'm not sure i have the correct sytax for doing that but this is what i used in my previous sql code (running a query with, not a stored procedure). Also, i'm not sure how to go about getting data for the @xxx names above from a textbox? How do i pass the values into the @xxx names from the users textbox? The MS SQL mangement studio code is this for the the stored procedure:
[Code]...
In VB.NET, how do I do the following?
Execute a Stored Procedure
Read through the DataTable returned
My experience with Stored Procedures is limited and I'm hoping this will solve my payroll problems. Further, for what I'm attempting to accomplish a Stored Procedure may not be the best answer.I'm attempting a Payroll function in which the goal of the Stored Procedure is to fetch the data for a given Payroll Period, do math on the first returned employee, output a calculated result, then move to the next. Let me explain a bit more...Based on a Pay Period ID which is given to the Stored Procedure, I would like it to do the following:Select the employee in that period, add a total of his hours worked, then add that employees total commissions, whichever amount is greater - return that value (along with the totals - such as the total hours and total commission) - then move to the next employee until completed.
View 2 RepliesI'm working on a web application called AssetCenter. I have 2 projects, one of them is the application (ACWEBNET) and the other is the web service (IMACWEBSVCS) that contains service related information.
[Code]...
I am using SSMS 2008 and VB. I'm a novice VB developer. I am trying to display results of a simple stored proc on my ASPX page. But I get the error below. Here is my code behind for the ASPX page:
>MsgBox(GlobalFunctions.GlobalF.GetDevSQLServerStoredProcedure())
And my code from GlobalF namespace:
Public Shared Function GetDevSQLServerStoredProcedure()
Dim conn As SQLConnection
Dim DSPageData As New System.Data.DataSet[code]....
I'm using a stored procedure, but am receiving a "Procedure sp_OrderTracking_Update_UpdateItem has no parameters and arguments were supplied" error. Here is my stored procedure:
[Code]...
How to insert images into sql table without using a stored procedure? I am working on a windows form for employees profiles (vb.net) and i have a combobox and a few textboxes. My combobox is manually connected to a database and also the other controls. When I fill the blanks and hit save, automatically the data is saved in my db and when I look into my combobox I see the new employee name. When I select a name, every control get filled. I have a picture box where the selected picture profile will be display. The picture will be display also when I select a name from a combobox. It will be retrieve from db table GeneralInfo Column Foto. What I need is to include in my sql statements the code to be able to save, update and delete the image from and to db.
This is part of my insert code:
Private Sub savenewprofileonload(ByVal sender As System.Object, ByVal e As System.EventArg)Handles btn_saveprofile_onnewprofile_tap1.Click
Dim mconn As New SqlConnection("Data Source=(local); Initial Catalog=mydb;Integrated Security=true;")
Dim cmd As New SqlCommand
[Code] .....
How would I use a value from an output parameter from a stored procedure in a vb 2005 application. I would like to capture a run date from the procedure and show it on several forms in the app.
View 2 RepliesI have a datatable with some rows I need to insert that datatable in to database using a stored procedure.
For Each row As DataRow In dt.Rows
cmd.Parameters.Add(New MySqlParameter("@DOWNLOAD_ID", dt.Rows(0)("DOWNLOAD_ID").ToString()))
cmd.Parameters.Add(New MySqlParameter("@FINALY_FIELDCODE", dt.Rows(0)("FINALY_FIELDCODE").ToString().Replace("|", "").ToString()))[code]....
When i do this I got an exception {"Parameter '@DOWNLOAD_ID' has already been defined."} How to get rid of this exception and can we insert the datatable with out for loop.
i am new to stored procedure and VB.Net, i am trying to insert a value to a column in a table in my database using VB.Net and Stored procedure Here's the procedure:
1. A user will input a value to a textbox, for example lastname.
2. When the user click the save button, the button will call the stored procedure.
Here's my code in stored procedure:
[Code]...
I have a stored procedure that creates temporary table to populate return table. It works perfectly fine when I execute it on SQL management studio but when I try to import this sttored procedure, it give me an error Invalid object name '#TOTAL' which #TOTAL is the temp table that is created.Does VS2010 not allow temporary tables in Stored Procedure?
[Code]...
I am in need of being able to show a user the contents of a Oracle stored procedure. I have no idea of how to go about actually getting and then displaying the code contained in a stored procedure. Does anyone know of a way? I know how to call and execute a stored procedure but is about it. I am developing using VB.NET 2010 with Oracle 10G as my back end.
View 3 RepliesCheck if park_id already exist in table calendar by stored procedure? [code]...
View 2 RepliesIn a DataSetIf I right-click on a TablesetAdd QueryCreate New Stored Procedure. The creation will fail for me using a SQL 2008 database. "There was a Problem with the UPDATE stored procedure. The stored procedure was not created."If I "Preview the SQL Script..." copy it and run it manually it fails because it is not putting brackets around my user name. "CREATE PROCEDURE SDSDBLUESKY.UpdateQuery" Fails"CREATE PROCEDURE [SDSDBLUESKY].UpdateQuery" WorksThis is a work around because it links to this if I do manually when it gives me the preview option, and don't rewrite it. But is there some setting change in VS2005 to get this to work correctly in the first place?
View 1 RepliesHow I can execute a stored procedure and the put the results into a webbrowser to display. I know html so I will format the stuff to look how I want it to.
View 6 RepliesThe store procedure which give me the information I need is:
USE [UCSMIS]
GO
SET ANSI_NULLS ON
[Code].....
When I try to add it to my report it gives an error, is it because of the temp table and how should I go about it?
I currently have this working already for one of my combo box's, but when i try to use the same code i get this error ''There is no row at position 6.'' . The are 2 fields in the table asset_type_id, asset_type_name', im trying to dispaly the values in a combo box for the field 'asset_type_name.
the code for ' Friend Sub RetrieveCustomerInformation2()' works but the other friend sub throws the error.
Imports System.Data.SqlClient
Imports System.Data
Imports System
Imports System.Data.OleDb
[Code]...
need to know how to control web page (html , php ) submit and get in background and display resuts ?like if page has input text that results in data
View 3 Replieshow I can get the WebBrowser1 control to display an HTML file stored locally on disk when it launches, similar to a homepage. My attempts have all resulted in failure. I am currently trying the following:
[Code]...
If you need me to supply more information, I am happy to do so.
I have a stored procedure to update a table, but needs a couple of values from another table.
the first two selects get the value from the table and then are used in the update statement.
The select statments:
Select @iStatusDropDownValueID = iDropDownValueID
From DropDownValue
Inner Join DropDownValueType On DropDownValue.iDropDownValueTypeID =
[Code].....
First, the values that are retrieved by the first two select statements are always the same. So they could be passed in by the code itself. I don't know that this will speed things up at all, just make the entire stored procedure better and easier to read.
Second, if the "Value Name" should change this store procedure will break (which is possible, but not often).
I am looking for any insight into the Best Practices for this situation.