I have a problem with my SQL statement with the WHERE statement and I also need to return the declared variable. and I have a function which also needs to return the returned value but it's not passed in as parameter it passed back with a variable declared in the sql statement using the Return keyword I can't use OUPUT for declared variables so if there here's my code.
[Code]....
I have the following stored procedure and if I execute this on our SQL analyser it returns the record no problem what so ever. BUT if I execute this through ASP.NET (I am using EntitySpace objects) to generate this query into data table and it saying that: "Cursorfetch: The number of variables declared in the INTO list must match that of selected columns."
I've discussed this with EntitySpace team and they said it's query issue? We are stuck with this issue and any guidance or hints that will be good.
The environment that we use:
.NET 4
EntitySpace 2010
SQL Server 2005 Database
ALTER PROCEDURE [dbo].[rpt_CPRRespondListReport]
(
@SurveyID INT
)
AS
BEGIN
SET NOCOUNT ON;
[Code]....
I have a Master Page which controls the styling of my site. In the Code Behind, there are a few class instances instantiated as well as variables. These classes validate user access and then create user objects
I have a few Web Content Forms which carries out instructions based on the user objects. So far it seems that on each Web Content Form I have to create new instances of the classes found on the Master Page. This is doubling my work for every Web Content Form.
Is there anyway I can inhereit Classes and objects instantiated in the Master Page Code Behind?
For some reason it seems as though variables that I declare in javascript sometimes persist themselves across applications even when I do a response.redirect. I thought that a response.redirect would clear them out.
View 1 RepliesI'm trying to determine whether it is better to declare the connection outside with it's own using statement or to create it inside the sqlcommand itself. This is in regards to a single command interaction with the database (no loops).
[Code]....
Or
[Code]....
I wan to retrieve spesific data from northwind and list in my compare page.
in the first page i used gridview with checkboxes. all selected values get with session and then
send to my second page. I can display this values in the page but how can i retrieve all product details from my northwind db i dont know.
here is my second page code behind.
[Code]....
and aspx page
[Code]....
I´m having a SQL query statement in management studio that runs prefect. I can´t have it set in a gridview.In SQL management studio I´m declaring some variables. It seems like I´m not able to declare inside the query statement in a gridview. Do I have to do the declaring outside the gridview?Here is my code in management studio
[Code]....
I am looking to cache a dataset and then filter the results as they will be used repeatedly. However, I don't know how to assign values in the filtered dataset to variables in C#. I have looked on the internet for the past few hours but all I can get in binding the dataset to a control.
View 4 RepliesI have a stored procedure which returns a value to state if the userlogin is valid. but i want to return the data and store it in a data session as i will require the user details in the checkout page.
is it best to get individual parameters out of the stored procedure then assign the variables to a datatable which is then assigned to session Or how can i get all the details returned from the stored procedure for the table? not sure which would be the most effective solution?
I need to declare a variable xyz, then, using a select statement, pass a variable into it so I can then insert it into a table.
Dim @xyz As
Integer
set @xyz = (select xyz
from systable)
1. I get a squiggly line below the @.
2. I get informed that set and let are no longer supported.
3. When I remove the @ I get the squiggly below select.
I got variables to send as parameters to Stored Procedure,
How to send it using SqlParameter[] arrParam?
How to write those variables to the arrParam?
im developing a silverlight project using silverlight 3, vs2008 and linq2sql. when projects starts, im storing all the data from database into some static list variables. so when ever i need data, im reading it from those static list variables. all i want to know is, is it good to store data in static list variables and use it when ever necessary or is it good to get data directly from DataClassesDataContext object like db.mytable. which is the rite and fastest way or retrieving data. i mean which will use less connections to database?
View 2 Replies[Code]....
this is my html code
[Code]....
this is my code behind
[Code]....
this is my bal code
acuttally
in my javascript popup i am getting the checked values but i need it in record by record in the lblsave data
I'm trying to combine a date and time from separate variables in my asp.net insert sql. pointers? I'm getting the following error
Conversion failed when converting date and/or time from character string.
[Code]....
I am looking to retrieve data from a database and assign those values to class objects which in turn will be turned into session variables. I am using an object datasource to retrieve the data from the database but I cannot find anywhere that shows how to assign these values to variables. The data is returned in a dataset. There is the added problem that there will be mulitple items returned which will have to be assigned to different arraylists of objects based on the a primary key in the database.
View 4 RepliesI am trying to get the results of the variables from a stored procedure to write out somewhere so I can see what values are being passed through for each variable in a button click. Does anyone know how to do that. Here is my code for the button click:
[Code]....
Here is my variables in the stored procedure. The first is the select statement and then the update:
[Code]....
I've specnt a day experimenting on this and am none the wiser.
I am using ASP.NET 4 Menu control and I have tried styling it using both techniques (but not at the same time as this is not recommended) i.e. :
(1) ASP.NET e.g.
<StaticMenuStyle BorderStyle="Solid" BorderWidth="1px" />
And
(2) CssClass e.g.
. StaticMenuStyle
{
/*my css rules here ... */
}
When I view the rendered output source in a Internet Explorer I see the following code in the HEAD section:
[Code]....
Also, in the BODY of the HTML I see the following:
<a title="Menu Option" class="level1" href="/path/default.aspx">Menu Option</a> (When using ASP.NET for styling)
<a title="Menu Option" class="level1 staticMenuItemStyle" href="/path/default.aspx">Menu Option</a> (When using CssClass)
I would like clean and minimal HTML rendered output (using AP.NET Web Forms not MVC).
I assume the #Menu1 and class="level1" is automatically generated.
Questions
(A) Is it possible to have the #Menu style code placed in an External style sheet file by ASP.NET at runtime rather than in the HEAD section of the output web page? If so, how is this done?
(B) Where is the code for class="level1" and do we have any control over this?
in my application i trying to implement the cache (ouput) but it is not working fine,that is it is every time getting from cache only this is my code.
<%@ OutputCache VaryByParam ="none"
Location="Client" Duration="10" %>.
Code:
protected void btn_Click(object sender, EventArgs e)
{
DataView dtv;
dtv = (DataView [code].....
[Code]....
Well I'm not familiar with SP's yet, and I can't find a single example of what I want to do. basically I want to retrieve the town & county where the customers id are equal (note there will only ever be 1 result)
I can't figure out how to address the results to be stored within the output variables.
At a bit of a loss here. As the subject says, I have a repeater control that uses the variable xmlN which is declared in my Sub Page_Load. Posted code below.
[Code]....
ASCX File:
<asp:datagrid runat="server" id="gridFormFields" datakeyfield="FieldID"
autogeneratecolumns="False"
onitemcommand="gridFormFields_ItemCommand" onitemdatabound="gridFormFields_ItemDataBound">
<columns>
[Code]....
In the code behind, the Control returned by FindControl is null. Why? How can I access the buttonMoveUpFormField and buttonMoveDownFormField controls? From the code behind, is it possible to access controls which are declared in the ItemTemplate section of the TemplateColumn section of a DataGrid?
i am trying to collect 2 variables from one hyperlink, and use those variables in the page_load to set as session. but i don't know how to collect those 2 variables
such :
<a href="javascript:;" onclick="wsChangeColor('mainData', '#FF0000','#FFE4E1');return false;" title="Change color" id="red">1</a>
i would like to collect '#FF0000','#FFE4E1' or direct set '#FF0000','#FFE4E1' to string then send to pageload, how can i do this by only clicking on it ?
Can a dataview be declared as public?
Dim dvEditTreatmentType As DataView = New DataView(dsTreatmentEndDate.Tables(0), "IsNull(DialysisEndDate, '') = ''", "", DataViewRowState.CurrentRows)
can this be declared as public Dataview? is there a way to do it?
My web application works if I don't compile it, when I compile, it gives me this nasty error and I am clueless to what I did wrong?
Here is the error: No where in my line 113 has any Eval nor my entire page has any Eval, I used Bind so what is going on? the strange thing is if I leave the page as is with out Publish web site option the same page works perfectly fine.
BC30451: Name 'Eval' is not declared
Line 111: <asp:TemplateField HeaderText="Property Name" SortExpression="PropertyName">
Line 112: <ItemTemplate>
Line 113: <asp:Label ID="PropertyNameLabel" runat="server" Text='<%# Bind("PropertyName") %>'></asp:Label>
Source File: c:inetpubwwwrootJPM2010UserPropertySearch.aspx Line: 113
I have been given two pieces of code and i am trying to place them together (with no luck) its kinda hard sayin i have little knowledge of asp.net, i need to get this done in order to pass my work placement It is a simple search that can take text entered into a text box, or a dropdown list and populate the table with the required fields
[Code]....