'SqlConnection' is not defined in the behind code as follows:
Source Error:
[Code]...
Source File: I:WebsitesCMPHostFox BackupDefault.aspx.vb Line: 24
Snippet reads as follows:
[Code]...
I know you can point to a OnSelecting event on the aspx page datasource. But I've created my SqlDataSource in the code behind. Is there any way to point to a selecting event in the code behind (I need this to provide the parameters)? Or should I just include all my logic in the Page_Load event (where I keep my SqlConnection)Here's what I have so far:
protected void Page_Load(object sender, EventArgs e)
{
SqlCommand myCommand = new SqlCommand();
[code]...
i have 5 methods in classA. each and every methods i have open the sqlconnection and close it, instead of that is there anyway to create a sqlconnection at one time if its opened then no need to create a new connection, if its closed then we have to connect.
View 5 RepliesIs it possible to use a pre-existing ConnectionString in this construction?
myConnection = New SqlConnection("server=localhost;" & "database=pubs;Trusted_Connection=Yes")
Regards -Penn
I have a whole bunch of data access methods where in each one I am doing this
[Code]....
and them moving on with my SqlCommand and SqlDataReader and so on.Is this creating to many instances of an SQLConnection?I was thinking doing this instead. Creating a SqlConnection Manager which would look like this
[Code]....
and then in my database access methods
[Code]....
Is this a good or bad idea and why?Also would this even be neccesary?
i am making a simple cms system
but I have a problem when updating some information
here is the code
[Code]....
and in the page load everything is fine
[Code]....
can capture return value from a SQL by using SqlConnection SqlCommand
[Code]....
I'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 am using "ASP .Net 2.0" with "SQL Server 2005". What is better and preffered approach towards making a sqlconnection to interect with database?
1. To open new connection each time we need to interact with DB and then close the connection
2. Or to make a shared database connection for whole web application.
'i'm working with visual studio 2005 asp.net c#. and i want to bind my website to my database with the "sqlConnection"
how do i get and set details from the database to the website fields with the sqlCommend and ect...
I am in the process of adding my custom aspx pages to the LAYOUTS folder(a folder I created) in a WSPbuilder solution in VS08. The problem I am having is when I build the solution it fails because the controls(Load, Textboxes, dropdown lists,etc) in the code behind file for the custom aspx pages say they are not defined. They all have a blue squiggly line and I get over 100 errors.what to do to get the WSP to recognize the code behind pages.
View 3 RepliesI am trying to create a type of table on sql 2008. The following sql fails saying Incorrect syntax near the keyword 'AS'. what i am doing wrong as this looks fine to me.
View 1 Repliesi have created a function to call username to pass user id as pararameter,
how to call userdefined function in asp.net
here is my function in sql
CREATE FUNCTION getusername
( @userid bigint )
RETURNS table
AS
RETURN (
SELECT login_id
FROM mst_useraccount
WHERE user_key =@userid
)
go
I have a page with a Textbox, a Button and a Label control. On Button_Click event , I store the value of Textbox in a variable called S using code behind.
I want to show the value of S in the Lable control using inline code but not using the code behind. ?
I have the following Report class that I want to serve as the base class for my pages.
I will have several aspx files MyReport1.aspx, MyReport2.aspx, ... MyReportN.aspx
---------
Report.cs
---------
public class Report : Page
{
protected readonly ListView reportListView; [code]....
I receive the error (Both DataSource and DataSourceID are defined on 'DataList1'. Remove one definition) in the following code. Could anyone help me sort this out. I do not have anything named DatasourceID that I can find.
[code]...
How to Use a Variable Defined in Code Behind File on inline code for same page..
View 7 Repliesi am trying to export a table from access database to excel sheet but i am facing error saying Type 'System.Data.OleDb.OleDbCommand' is not defined.
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim AccessConn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:Documents and SettingsUSERDesktopD0605data.accdb")
AccessConn.Open()
'New sheet in Workbook
Dim AccessCommand As New System.Data.OleDb.OleDbCommand("SELECT * INTO [Excel 8.0;DATABASE=C:Documents and SettingsUSERDesktopD0605data1.xlsx;HDR=NO;].[Sheet1] from [Table1]", AccessConn)
AccessCommand.ExecuteNonQuery()
AccessConn.Close()
End Sub
End Class
When i click for bug an aplication.
it's always show this a notification
{"Both DataSource and DataSourceID are defined on 'GridView1'. Remove one definition."}
view on browser application
Line 33: Line 34: GridView1.DataSource = dtLine 35: GridView1.DataBind()Line 36: End SubLine 37:
This is an my vb code
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Me.IsPostBack Then
Me.BindGrid()
End If
End Sub
Private Sub BindGrid()
[Code] .....
I'm working on two gridviews , each one binded to an sqldatasource object,when I want to modify the 2nd gridview (DataSource=DataTable) an error fired !Both DataSource and DataSourceID are defined on 'GridView1'. Remove one definition.
View 4 RepliesI have a strange problem. I am adding a LinqDatasource object, and set the context:
[Code]....
Then I get this error:The type 'System.Data.Linq.DataContext' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.
On web.config I already have this:
<add assembly="System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
NOTE: The datacontext is in a different project (DLL proect) where I added a refernce to System.Data.Linq.
is there another way adding a refernce to a web project? or only though teh web.config?
I'm not really a ASP.NET programmer, but i am learning. Here's my question. IF you had a set of code that was written in ASP.NET 2.0 and used a specific namespace and used @Import command in the header of your page, BUT you did not have any of the code that defined the namespace, how would approach building a development server that would use this namespace?
What page would you define the namespace ? How would you specify the value the a variable contained in this namespace?
I have some templates but they use a specific namespace. I want to setup this same namespace on my server so i can preview the code.
I've downloaded and installed the Visual Studio Express 2010 tool (great free app). Its helpful,
I am using webformrouting in my asp.net c# application.
In my global.asax file i define a couple of routes.
My question is, how can i get a list of all routes defined from code behind (on a page)?
I have impelemented my own mvc pattern to my website , when I add desired type for my ObjectDataSource pointing to the controller class although GridView refreshes schema in designer just fine I get an error in runtime saying : "No parameterless constructor defined for this object." which is self explaining but I wonder why does it happening because I've used this pattern once and didn't have that issue , here is the bit of code that is causing this issue , what to do to keep my mvc and make it work :
[Code]....
I created a webpage names Default.aspx. In its code behind i defined another public class named Test. Test class is not accessible in other pages code behind although it is defined as public.
View 8 Replies