When I load my page I populate my repeater with the following code.
Dim conn As Data.SqlClient.SqlConnection
Dim Comm As Data.SqlClient.SqlCommand
Dim reader As Data.SqlClient.SqlDataReader
[code]...
how make the class for database activities and it can be used in code behind
coz i want avoid the connection opening, closing activities, insert,update etc methods in code behind frequently.
the class should include connection open and closing method, passing values to stored procedures etc.
How should we construct it?
I try to connect my database for so long so i wrote two type of codes. Let's discuse first on.
I have database called PhoneDirectory.
It have only one table named Residents.
I have button wiht ID="Button1".
I want when i click this button to see all of my residents.
I want to see the result in DetailsView and to be able to edin, delete and add new resident.
First try with SqlDataSource so i wrote this:
<asp:SqlDataSource ID="Resident Details" runat="server" ProviderName="System.Data.SqlClient" ConnectionStrings="<%$ ConnectionStrings:ThisIsTheConnection%>"
First off, I am just getting started with ASP.NET so I expect this is something that I am doing.
i am trying to make a connection to a MS SQL database on my local machine.
I have the following in web.config
[code]....
I want to setup a DB connection from aspx page and not from aspx.vb.
View 1 Replieswhen i make control (visible=false) onpage load event, this mean this control is created and Make Load on Server? becasuse i have ajax html editor when i make it hidden onpageload event, all My Controls rendered fast, but when i make it visible its slow down page , althouh ajax html editor is not in any updatepanel.
last question :when any DataControl ( for example DataList)Contain Datasource (assume ArrayList) and This ArrayList is null , this datalist created ? and Make Load on Sever? and the speed of page is the same as there is no datalist?
I have a script that loads diferent photo in same div on masterpage for diferent pages.
So my question is how can I know what page is currently loaded so I can use something like this:
onpageload...
Dim pageID as String
pageID = ?????????
If pageID = "default1.aspx" Then
image1.ImageUrl = "~/zagreb.jpg"
ElseIf pageID = "default2.aspx" Then
image1.ImageUrl = "~/split.jpg"
End If
maybe I can put some kind of ID on every page but how?
HTTPresponse does not help to much becouse links looks diferent every time (default.aspx?sasa , default.aspx876786 .....)
[code]...
I have something like this. I want to make "Package Recap" invisible when the page is loaded. It is in the .
I set a labelA visible=false when page load.
How to make labelA blinking while meet a condition.
For example,
if ordercity="New York" then
labelA.visible=true
labelA blinking (how to code)
End if
in this code i have generated runtime checkboxlist controls. my prob is in the page load i want to get the chekboxlist items selected for the items which the user has selected previously and saved. now i get only the last item in the loop as selected and the remaining are not selected.
// page load
protected void Page_Load(object sender, EventArgs e)
{
dsQuest1 = objCDAL.FetchQuestion(Convert.ToInt16(Request.QueryString["QID"]));
QID2 = Convert.ToInt16(Request.QueryString["QID"].ToString());
DataSet dsQuest = objCDAL.FetchQuestion(Convert.ToInt16(Request.QueryString["QID"]));...
I added this script on my page..it didnt work
[code]....
I see the first header expanded when page's loaded. How to make them all collapsed on page load?
I have a list of items that loads when I call the page controller and I have an Ajax.BeginForm that calls the same (Index) Action. If the Action sees that it's an Ajax request (Request.IsAjaxRequest()) then it returns a partial view. I even have a div that contains a message about the results loading. That all works fine, but my results can sometimes take awhile and I'd like to hit the page first and then make the Ajax request so the user sees the page quickly and sees the "loading" message. I know I could click my filter button (triggering the ajax call) using jquery on document.ready, but is there a more MVC way to do this?
View 4 RepliesI want a browser to go full screen as soon as my page loads. Is it possible in javascript. I know the shortcut key for this F11 but requirement is on page load only.
After reading the solution provided below. I achieved full screen but here i got a trap. I was using timer to make my page postback to get fresh data after every 5 second. And here I found after every 5 sec new window opens up but I want full screen to go only once and next time content gets refreshed there itself.
I have a data grid in which I have to display around 12,000 records. Even if I do paging it is difficult to display all the records. Is there any other control or something else so that I can display all these records. Even if I make these as alphabetical also, some times I have to load 1000 records in a page which is difficult.
View 2 Repliesit's possible to put the database connection settings into a base page class so that I can auto-init them on a page. like this document: [URL] but with instructions in VB.net
View 1 Repliesi have created a custom aspx page whithin my sharepoint site with a sql server connection to a database on that server to select data when i view the page it works but when another user tries to view it it gives the following error :Server Error in '/' Application. Login failed for user 'GRINCORGuguK'.Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'GRINCORGuguK'.Source Error: The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:Add a "Debug=true" directive at the top of the file that generated the error. Example:
<%@ Page Language="C#" Debug="true" %>
or:2) Add the following section to the configuration file of your application:Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario. tack Trace:
[SqlException (0x80131904): Login failed for user 'GRINCORGuguK'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +248
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +245
[code]...
I am using VS2008 and oracle 10g ODP.Net. The oracle database that I used in the connection is working and tested it using sql plus.The connection string when used in a GriDView works perfectly. Now when I created a new listview control with the same connection it gives an error.Database schema could not be retrieved for this connection. Please make sure connection settings are correct and the database is online
Object reference not set to an instance of an object at VSDataObjectSupport (478,6)
how we can make database with ASP.NET in net page ?
View 1 RepliesA Login.aspx has been created to enforce security on several forms of a web site.How can it be best called by each form at page load and return to that form after succesful login? How could that requirement be declared in web.config?
View 3 RepliesWhen we set allowpaging=true and specify the pagesize=xx, and when we change the page of the gird view then, does paging in gridview make a database call when its page gets changed ?
View 4 RepliesI'm creating a website of 5 pages using c# (asp.net).
How do i link 2 pages, ie., on click of a button on first page should take me to second page.
How to make a secure login page using sql database by matching a user name and password and redirect them to differnt page as admin and user
View 2 RepliesIam trying to make a socket connection and am facing with the following error.
Socket tempSocket =new
Socket(ipe.AddressFamily,
SocketType.Stream,
ProtocolType.Tcp);
The tempSocket is connected to the particular IP and tempSocket.Connected is giving me value as True. But the property MultiCastLoopBack property is giving me the following error with error code 10042.
"An unknown, invalid, or unsupported option or level was specified in a getsockopt or setsockopt call."
So is there any problem with the IP or Tcp is not supported with Stream as SocketType?
I want to download a file from database using asp.net c# code in page load event.My table design as below
Table Name: tblFiledownload
Id - int
Data - varbinary(MAX)
FileName - varchar(50)
FileExtension - varchar(50)
For some reason it takes 7 seconds to open a connection to a sql server database for the firt time, subsequent connections takes a second.
I'm using C# and asp.net
Its after compilation, i essence every time i restart the site, which means every time it needs to actualy create the "first" connection. i understand that setting up connection pooling has overhead, but i have never seen that i should take 7 second to set it up.