On an ASP.NET page, I have a SqlDataSource configured with the following SELECT command:
SELECT AVG(Rating) FROM [Ratings] WHERE ([AlbumID] = @AlbumID)
How would I place that average value into a label?
Here is the sqldatasource config code: <asp:SqlDataSource ID="SqlDataSource1" runat="server"
View 1 RepliesHow can I execute a stored procedure using sqldatasource and get the return value in vb.net.
View 2 Repliesi have SQLDataSource and stored procedure "newsSelectLastHeading" that returns newsHeading
<asp:SqlDataSource ID="newsSelect" runat="server"
ConnectionString="<%$ ConnectionStrings:newsConnectionString %>"
SelectCommand="EXECUTE newsSelectLastHeading">
</asp:SqlDataSource>
[code]...
i have a grid bound to sqldatasource control which gets its data from stored procedure. in page load event i code a dropdownlist where i take the selectedvalue parameter for the parameter query. only when a second dependant dropdownlist is selected (coded in dropdownlist1 selected event)is data returned ?
View 12 RepliesI'm using MikesDotNettings([URL] code mentioned: Bind Data From a SQLDataSource to a Label, and I'm getting this error:
"An SqlParameter with ParameterName 'ID' is not contained by this SqlParameterCollection."
This is what I have, I'm using my own data to try and populate the labels:
[Code]....
I need to assign the values to a labels (strings) as I need to use them for another caluculation.Can you or anyone looking at this figure this out?
I have a text box in a FormView that I use to display the return value from the stored procedure that I'm using to maintain the data. For assorted reasons, I'm not able to use the built in ability of the FormView to manipulate the data.
I have the following code at the end of the procedure that calls the stored procedure. It is a snippet that omits the bulk of the procedure.
[Code]....
As is, the label text is updated with the message. However, when I uncomment out the code that manipulates the SQL Data Source and rebinds the FormView, the label text is NOT updated. I can't figure out why it craps out.
1) AdvisoryMessageText is declared at the class level for the code behind, so it should be retaining the value across all of the procedures as their caloled.
2) TextBoxAdvisoryMessage is contained within the FormView EditTemplate.
this is my code
[Code].....
i want to read lbl_TotalCount value after changes value's.i when click on the client Button with named Button1,the lbl_TotalCount value increase.but,when i click the server Button with named btn_saveForm, value of lbl_TotalCount is zero.
If I want to access the method in which we define update query, how can I access that method on aspx page & update the data in a grid view without direct use of an query on aspx page under sql data source?
View 28 RepliesI am using JavaScript to call a web service. The JS is correctly receiving and passing the web service information.
At the moment, the web service returns a country name as a string to a JavaScript alert pop up box as follows:
[Code]....
I want to change this so that web service returns the country name to a label inside an insert item template of a form view.
Is there a way to pass in the label variable to the OnComplete function signature and still account for the variable args?, such as:
[Code]....
getting ans using data in my example.:first I would like to tell that sqldatasource return only one row.
[Code]....
I have a simple gridview. I can view the data and I have gotten the insert to work (code behind).
Code:
Dim vRepairId As String = Request.QueryString("REPAIRID")
SqlDS_WOAccount.InsertParameters("WorkOrderID").DefaultValue = vRepairId
SqlDS_WOAccount.Insert()
<asp:GridView ID="GridViewAccount" runat="server" AutoGenerateColumns="False"
BackColor="White" BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px"
CellPadding="3" DataSourceID="SqlDS_WOAccount" Font-Size="8pt" Width="100%">
<RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
<Columns>
[code]...
I am trying to get a parameter for my update from the gridview but it is an ID column that I do not want displayed. If I display the data in a boundfield it works fine but if I set the visibility to false the parameter is no longer sent to the update stored procedure. There does not appear to be a hiddenfield column that I can put into the gridview.I have tried to set the parameters through the code behind but I am not certain on how to access the data I want the following code does not work (It sets the parameter to nothing
Protected Sub grvFacilityDisciplineBillingRate_RowUpdating(ByVal sender As Object, ByVal e As GridViewUpdateEventArgs) Handles grvFacilityDisciplineBillingRate.RowUpdating
Dim row As GridViewRow = grvFacilityDisciplineBillingRate.Rows(e.RowIndex)[code]...
And this is the front end with the two ID columns displayed, which is not what I want
<asp:SqlDataSource ID="sqlDisciplineBillingRate" runat="server" DataSourceMode="DataSet" SelectCommandType="StoredProcedure" SelectCommand="SP_Facility_DisciplineBillingRates" UpdateCommandType="StoredProcedure" UpdateCommand="SP_DiscplineBillingRate_Update" ConnectionString="<%$ ConnectionStrings:Trustaff_ESig2 %>">[code]....
I have GridView1 and SqlDataSource1. I use EnableEditing to GridView1. This is Code of GridView
<
asp:GridView
ID="GridView1"
Width="100%"
runat="server"
AutoGenerateColumns="False"
BackColor="White"
BorderColor="#3366CC"
BorderStyle="None"
BorderWidth="1px"
CellPadding="4"
DataKeyNames="DoctorID"
DataSourceID="SqlDataSource1">
<RowStyle
BackColor="White"
ForeColor="#003399"
/>
<Columns>
<asp:BoundField
DataField="DoctorID"
HeaderText="DoctorID"
InsertVisible="False"
ReadOnly="True"
SortExpression="DoctorID"
/>
<asp:BoundField
DataField="DoctorName"
HeaderText="DoctorName"
SortExpression="DoctorName"
/>
<asp:BoundField
DataField="City"
HeaderText="City"
SortExpression="City"
/>
<asp:BoundField
DataField="Str"
HeaderText="Str"
SortExpression="Str"
/>
<asp:BoundField
DataField="StrRegion"
HeaderText="StrRegion"
SortExpression="StrRegion"
/>
<asp:BoundField
DataField="StringLevels"
HeaderText="StringLevels"
SortExpression="StringLevels"
/>
<asp:BoundField
DataField="Streat"
HeaderText="Streat"
SortExpression="Streat"
/>
<asp:BoundField
DataField="Email"
HeaderText="Email"
SortExpression="Email"
/>
<asp:BoundField
DataField="Mobile"
HeaderText="Mobile"
SortExpression="Mobile"
/>
<asp:BoundField
DataField="HomePhone"
HeaderText="HomePhone"
SortExpression="HomePhone"
/>
<asp:BoundField
DataField="ClinicPhone"
HeaderText="ClinicPhone"
SortExpression="ClinicPhone"
/>
<asp:BoundField
DataField="Fax"
HeaderText="Fax"
SortExpression="Fax"
/>
<asp:BoundField
DataField="address_details"
HeaderText="address_details"
SortExpression="address_details"
/>
<asp:BoundField
DataField="Expr1"
HeaderText="Expr1"
SortExpression="Expr1"
/>
<asp:BoundField
DataField="VisitPlaceStr"
HeaderText="VisitPlaceStr"
SortExpression="VisitPlaceStr"
/>
<asp:CommandField
ShowEditButton="True"
/>
</Columns>
<FooterStyle
BackColor="#99CCCC"
ForeColor="#003399"
/>............
i am using a gridview which shows the data and a select column. when the user selects a record a detailsview is shown with the respective details and an edit button inside it. when the user clicks on the edit button the entire detailsview becomes editable and the user can now edit the selected record .here the problem starts cause when the user clicks on the update button there is an error stating that illegal variable/number or parameter not found.i am using sqldatasource to bind the gridview and detailsview with an unique RequestId fieldwhich detailsview sql datasource uses to bind the record uniquely.
View 3 Replieshow to bind maxid from table in Label using storedprocedure...
View 1 RepliesI have a FormView which is bound to an SQLDataSource. When a user clicks on a save button the form, I need to write any changes made to the FormView back to the table.
I have a Stored Procedure on my MSSQL 2005 database that should be executed when the user clicks on the save button.
It appears the Update is firing, but when I trap the DbCommand object in the SQLDataSource's 'Updating' event, all of the parameters that should be passed to the Stored Procedure are coming through as NULLs. Consequently, the Stored Procedure isn't updating anything.
In the click event of the save button I'm explicitly firing the SQLDataSource's Update method:
[Code]....
The parameters in the SQLDataSource <UpdateParameters></UpdateParameters> section appear to be correct.
Can anyone give me an idea on what to investigate to figure out why it appears the Update is only picking up NULLs?
I've already spent hours in searching through the forum to be able to do the following:I have a SQL datasource defined with a checkbox in it. Purpose is to update one column (userid) behind the table for only that row when the checkbox is selected.This is the code I'm currently having:
[Code]....
I am building a web site, it's used to manage the data in SQL server so the another web site(connect to the same SQL database) can receive the new infoSo far I've build 2 parts, one manages the news system, the another manages the album system, news manage system work perfect, when I update, add or delete news form the web site (using sqldatasource, INSERT, DELETE and UPDATE command), the data inside SQL changes as well.
View 2 RepliesUsing vb.net/asp.net 2005.
I have a gridview that is using a SQLdataSource with an update statement and I am able to print out the update statement listed in the SQLDataSource by doing this:
[Code]....
but for some reason the record is not being updated so I want to know how do I print out the entire Update statement, including the value of the EmailAddressID to make certain that the update statement is being set correctly?
I can test the update statement above manually, taking the EmailAddressID for that record and then run the update statement manually using SQL Server Mgmt then it updates the record correctly so I know the update statement set in the SQLDataSource is ok. However I still want to print out the update statement that is supposed to be executed in the vb code, how to do this?
I see there is an event called "SqlDataSource1_Updating",
is it possible to print out the actual update statement there?
Just to be clear in the asp.net page I want to do something to print out the actual full update statement, ex:
<SQL>
UPDATE [EmailTable] SET [EmailAddress] = @EmailAddress WHERE [EmailAddressID] = 22
</SQL>
i couldnt find a specific answer to this question, i am relatively new to .net :)
i have a gridview that is displaying data from a sqldatasource in my page_load event. i need to loop through the records and update each value of a particular column BEFORE being set into the GridView.
i have tried converting to a data set and looping through updating the values, however it seems that one i initially run my query the values get set right into the GridView and i can't update them after that.
Do I need to add one of the GridView functions like Databound and do the loop in there?
Is it possible to use a SQLDataSource to populate a gridview but not use the SQLDataSource for Updating?
I wanted to add the update code in the Gridview_RowUpdating event since it is a complex update I need to do.
I get this message when i click the update button
Updating is not supported by data source 'SqlDataSource1' unless UpdateCommand is specified.
I'm trying to update items in my SQL database from a ListView. It works, but all entries in the database update. Not just the one I'm working on. I backed up the database prior to testing, so there's not any issues there.This is how my SqlDataSource UPDATE command is setup:
SQL Code:
UPDATE entries SET duration = @duration, checkinDate = @checkinDate, receivedBy = @receivedBy, cosmeticDmgIn = @cosmeticDmgIn, STATUS = N'closed'
I don't have any code setup to update the database, which is probably the issue.When I load the ListView, select edit, type in my edits, and click "Update", all the rows in my database, for that column, are updated with that data.I tried inserting the parameters manually, within the ItemUpdating event, but it never works.
i am facing a minor problem but can't find out its syntaxi have listview, and inside the template i have 2 labels, in design time i bind 1 label to one column thatis 'type' and depending upon this type i want to bind other labels to different columnsif type is question than 2 label will have to show data of question columnif type is job than 2 label will have to show data of job, so on........how to accomplish this,in databinding event handler i can check the value of typebut i want to know the syntax of binding 2 label in run time, with different fields using EVAL
View 3 RepliesI have two image buttons in a gridview, one to approve the opening of the record and one to approve the closing of the record. I have added a CommandName to each button (OpenApproved and CloseApproved) and in the grids rowcommand I would like to update the database with the Username of the person clicking the button, Username goes into either the OpenLeadApprover or CloseLeadApprover field depending on which button is pressed. The grid has a sqldatasource with an Update stored procedure which has three parameters, @WorkOrderIDWhat I have tried to do in the RoeCommand event is declare a variable for the sqldatasource and add the parameter value to it, then run the update command. Here is the code:
[Code]....