|
Hi Everybody,
I am working with classic ASP. In one of my webpage i forgot to close a recordset. This recordset contains good amount of data. And I found this mistake very late. I have currected it.
But I still want to
1) Is it affects on site speed?
2) How dose such mistakes affects Websites? What are the effects of such mistakes?
Kiran Sajanikar.
|
|
|
|
|
Kiran S. S. wrote: 1) Is it affects on site speed?
If you open tooo much of connection then it will affect on site speed. But the GC will clear the object that are no longer used for a particular time.
Kiran S. S. wrote: 2) How dose such mistakes affects Websites? What are the effects of such mistakes?
Opening a lot of connections makes your server tired.
|
|
|
|
|
Michael Sync wrote: But the GC will clear the object that are no longer used for a particular time.
He is saying about classic ASP not .NET. GC won't be available there.
|
|
|
|
|
N a v a n e e t h wrote: classic ASP
Oh. I didn't notice.. I thought he is using ADODB in .NET. ya.. thanks.
|
|
|
|
|
So What are effects in such cases?
Kiran Sajanikar
Software Engineer
CleverBIT softwares.
Pune.
|
|
|
|
|
Kiran S. S. wrote: How dose such mistakes affects Websites? What are the effects of such mistakes?
I guess the connection will be open. This may cause timeout errors if more number of concurrent requests are coming.
|
|
|
|
|
In that page i have used two recordsets. One recordset and connection i have closed carefully. But i forgot to close that remained recordset.
Kiran Sajanikar
Software Engineer
CleverBIT softwares.
Pune.
|
|
|
|
|
i have work in asp.net web site and i put details view for employees registration i put drop down list in the edit and new mode and i fill that with data when i run the website this drop down list was fill in the edit mode but in the new mode no data appear in the drop down list but when i search that drop down list i found it has data but no data appear for me
thanks alot
md_refay
|
|
|
|
|
i have loaded values in my dropdown list box... if i select the same value in to my gridview it should not allow tha same "PARTNUMBAR AND DESCRIPTION " from my database... i am having same discription name with different part number....
Wt i need is,
It should not aloow the same part number and decsription inside my gridview textbox..
help me....
|
|
|
|
|
The dropdown will be shown what you bind. If you don't want to allow this, you should filter in SQL statment.
|
|
|
|
|
Hi,
You can filter your DropDownList data at SQL statement and also you can do it from your code behind.
e.g.
DrpName.Items.Remove(DrpName.Items[index])
Hope this will help you.
Regards.
Keep Smiling 
|
|
|
|
|
Please can any body suggest me to upload video file to mysql database using
C#
|
|
|
|
|
Hi all,
well I have a category Table in SQL2005 and I wanna show just the names of the categories in a table like structure with 4-5 columns.
c1 c4 c7
c2 c5 c8
c3 c6 c9
How can I make such a view. I know abt paging but thats totally differnt
Thanks in advance
Rocky
Success is a ladder which you can't climb with your hands in your pockets.
|
|
|
|
|
Hi,
if you wanna show in SQL Server then you have to Post this query in Sql Server forums.
If you wanna show in Asp.net page then try usign datalist.
Thanks,
Sun Rays
To get something you must have to try once.
My Articles
|
|
|
|
|
hi
I'm trying to do it in asp .net 2.0 but I dont know how to show a single column of the Table in multiple columns of the DataList control.
can u plz tel me how
Rocky
Success is a ladder which you can't climb with your hands in your pockets.
|
|
|
|
|
Hi,
take a datalist control and then try to bind data with it.
You can have lots of examples on Google just search on it.
Just put one label in Item template and bind column of Sql table to label's Text property.
And ya just remebmer to set property of Datalist,
set RepeatCloumn = 4 and RepeatDirection = vertical.
Hope it will help you.
Thanks,
Sun Rays
To get something you must have to try once.
My Articles
|
|
|
|
|
okay thanks a bundle for ur help,
well actually I've just recently started working in asp .net earlier I used to work in desktop apps. I'm a bit unfamiliar with these asp .net controls.
I just needed a little hint and u gave it to me in the form of RepeatColumn and RepeatDirection so again thanks alot for that.
Now I've almost made it with the asp table control. I'm adding td's and tr's myself with hyperlinks for the categories.
Cheers...
Rocky
Success is a ladder which you can't climb with your hands in your pockets.
|
|
|
|
|
Hi,
you can try this.
See this example.
Link- To Help[^]
Thanks,
Sun Rays
To get something you must have to try once.
My Articles
|
|
|
|
|
yea that looks to be quite useful.
thanx
Rocky
Success is a ladder which you can't climb with your hands in your pockets.
|
|
|
|
|
hi to all
i am having some problem ..so need ur help again.
there is a gridview where i am showing the employeedetails where empcode is the primary key in the a
table.
emp table is having
empcode,name ,age,sex,.
these values are getting from the frontend of the respective field.
i ma able to dispaly the record in the gridview after saving it.
there is an select option for each row of the gridview.
my problem starts here" when i want to select any particular row of the
gridview.based up on the empcode of the respective row the data shuld be dispaly in the corresponding
field in the form so that i can update it.
my objective is 1st i catch the empcode of the selected row and then based up on that empcode
other values willbe displayed in the corresponding field of the form.
i am using asp.net along with c#.net(2005) and sqlserver2005 as database.
|
|
|
|
|
|
Hi!
I guess you are using BoundFiled. when you want to update some data in gridview you have to use TemplateFiled.
in TemplateField you will have ItemTemplate, EditItemTemplate and FooterTemplate.
As per your requirement you need to use ItemTemplate and EditItemTemplate.
ItemTemplate acts just like BoundField. EditItemTemplate allows to Update the Data.
I hope this will work fine
|
|
|
|
|
Hi,
First of all you have to add Datakey names in dataGrid property.
Write your empCode (i.e. Table Column Name of Employeecode) and now in Datagrid selectedindexChanges Event get that datakey value (i.e. empcode).
And according to that fetch all data from database.
In Event you can get datakey value like this.
MyGridView.DataKeys[e.NewSelectedIndex].Value.ToString();
Now you have EmpCode so go ahead..
Thanks,
Sun Rays
To get something you must have to try once.
My Articles
|
|
|
|
|
All,
I am currently working on a school project that requires me to collect RSS messages, dissect the text, compare it to previous text, and then post it onto a web site. I have done most of my programming thus far on C#, and from my research, it looks like I will have to use ASP.NET for this part of the project.
This is what I am thinking, using C# to collect the text and put it into a SQL database (when need to compare against old one), then use ASP.NET to get the data from the SQL database and display it on the web page.
I know most of you are probably very advance in your programming domain, can you please give me a heads on whatever
1) my approach works?
2) what do you suggest?
Best regards,
T
|
|
|
|
|
Hey,
Yeah you're approach is fine by all means. I don't know how you are planning to dissect the text in anyway but I presume it's not difficult or you know how to do it. Yeah save the data to a database if it's successful and then get the web page to query that table using a dataset object to just bind it to a grid.
I suggest making a table for successful and unsuccessful results so if it doesn't go to the database it's not just thrown in the bin and never seen again.
Cheers,
Michael
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
