|
Colin Angus Mackay wrote: InProc session being lost is if the app pool is recycled, or IIS is reset because the process that holds the session is lost.
That's right. I have also seen antivirus programs making problems by scanning the configuration files and assemblies.
|
|
|
|
|
thanks 4 your reply...
i tried this
it gives me an error........
sessionState mode="StateServer"
stateConnectionString="tcpip=65.182.97.156:42424"
cookieless="false"
timeout="20"
thanx...
Nour Abdel-Salam...
A Trainer and a Web Developer in Jedda Int'l Computer Center(JICC)
|
|
|
|
|
nour123 wrote: it gives me an error........
What is the error, you have only detailed your configuration settings.
|
|
|
|
|
thanks 4 reply...
I wrote:
sessionState
mode="StateServer"
stateConnectionString="tcpip=127.0.0.1:42424"
cookieless="false"
timeout="20" /
the error is...
Unable to make the session state request to the session state server. Please ensure that the ASP.NET State service is started and that the client and server ports are the same. If the server is on a remote machine, please ensure that it accepts remote requests by checking the value of HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\aspnet_state\Parameters\AllowRemoteConnection. If the server is on the local machine, and if the before mentioned registry value does not exist or is set to 0, then the state server connection string must use either 'localhost' or '127.0.0.1' as the server name.
Nour Abdel-Salam...
A Trainer and a Web Developer in Jedda Int'l Computer Center(JICC)
|
|
|
|
|
Go to Run type
services.msc
and press enter
From the window select the service with name
ASP.NET State Service
Check its status. If it is not started, then Start this service.
This will solve your problem
|
|
|
|
|
nour123 wrote: The session timeout within 30sec or less eventhough i had code
Then you have some serious issues in your code. Are you sure the session is set correctly? Also try the points which I pointed out here[^]
|
|
|
|
|
|
nour123 wrote: why it works in my own iis, and doesn't work in the web host?
Because they are configured differently? Because it wasn't uploaded properly? Becuase the security context is different? Because you weren't actually using IIS on your machine? (A lot of people mistake Visual Studio's build in web server for IIS. It is different and it responds in subtly different ways)
Any number of reasons.
|
|
|
|
|
In my Application I am creating Some Html Images Dynamically.when i select any Image i want Display Resizable Box..(Foe example when u select any control at Design Time it Display Rectangular Seletion Box Like Wise I want in my application)..
Plz Help me any One..
Thanks.......
|
|
|
|
|
how to insert and update record in grid view using stored procedure....
modified on Saturday, January 3, 2009 7:31 AM
|
|
|
|
|
Please don't ask question blindly . Try Google. There are lots of sample are available.
cheers,
Abhijit
|
|
|
|
|
After editing the new value in textbox, it sets to existing one.....how can avoid this.......
|
|
|
|
|
Check This[^]
cheers,
Abhijit
|
|
|
|
|
Label id = (Label)gvrecord.Rows[e.RowIndex].FindControl("Lblid");
TextBox fname = (TextBox)gvrecord.Rows[e.RowIndex].FindControl("txtFirstName");
TextBox lname = (TextBox)gvrecord.Rows[e.RowIndex].FindControl("txtLastName");
TextBox age = (TextBox)gvrecord.Rows[e.RowIndex].FindControl("txtAge");
dbcom = db.GetStoredProcCommand("UPDATEVALUES");
db.AddInParameter(dbcom, "@eid", DbType.Int32, Int32.Parse(id.Text));
db.AddInParameter(dbcom, "@FirstName", DbType.String, fname.Text);
db.AddInParameter(dbcom, "@LastName", DbType.String, lname.Text);
db.AddInParameter(dbcom, "@Age", DbType.Int16,Int16.Parse(age.Text));
db.ExecuteNonQuery(dbcom);
This is the code i wrote for updating the values......i am not getting any error.....the values is not updating in the database why....
|
|
|
|
|
ksarchana wrote: why....
Try to Execute your stored procedure, manually from SQL Server with those parameter and check weather your procedure working fine or not. Then debug your code using Break Point.
BTW : Why you have deleted the original Message.
cheers,
Abhijit
|
|
|
|
|
ALTER PROCEDURE [dbo].[UPDATEVALUES] @eid as bigint,@FirstName as varchar(50),@LastName as varchar(50),@Age as int
Update Name set FirstName=@FirstName,LastName=@LastName,Age=@Age where eid=@eid
END
stored procedure is executing properly.....
|
|
|
|
|
First, write stored procedure in sql. next, in front end get txtbox value
in some other variable and call that stored procedure name.
Make also sqlconnection......
|
|
|
|
|
while editing the new value is not set into textbox......The textbox shows only the existing value.......
|
|
|
|
|
Then try three tier architechture.. That problem may arise in file system.
also use DatabaseFactory
|
|
|
|
|
see this
http://www.codeproject.com/KB/cs/N-Tier22.aspx[^]
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswam@its.co.za
|
|
|
|
|
Hello friends,
My idea is given below.
While clicking a button, mas-word should open within the browser with an existing Template file (.dot). After typing its contents and clicking save button, it will come back to the aspx page. Then I will fill other details of the file in aspx page and finally click Submit. Then the word file should be saved into SQL server table.
I should be able to open that word file later from SQL server table itself.
Can anybody give the code for this logic
Regards
Shivan
Shivanandan C V
|
|
|
|
|
My Suggestion, Never store files on SQL Server, Stored files on Hard Drive and Store the path into Table , retrieve the files name from database and open the file from corresponding path !!
cheers,
Abhijit
|
|
|
|
|
Shivan Nandan wrote: While clicking a button, mas-word should open within the browser with an existing Template file (.dot).
That's not possible in web application. You have to provide an option for user to download the template file. Let them fill it and come back to your webpage for uploading it.
Shivan Nandan wrote: hen the word file should be saved into SQL server table.
Try to avoid keeping files in SQL server unless there is a strong need for that. Keep the file in server HDD and store the path in database. Files are kept in SQL server database in BLOB fields. You have to use varbinary(max) type.
|
|
|
|
|
N a v a n e e t h wrote: Try to avoid keeping files in SQL server unless there is a strong need for that
Just for curiosity, why not to store the documents into SQL Server.
|
|
|
|
|
That realy depends. I felt difficulties to manage the files which are kept in database. On a shared hosting, you will have limited database space and more HDD space. So keeping files in database will increase DB size and you will run out of the limit easily.
For accessing the file, you need to query the database, and write to response with correct content type. If the file is in HDD, you only have to take the file path from DB and redirect to it.
Since files are stored in varbinary column, I think no SQL functions can be applied to it. So IMO it is pointless. Please correct me if I am wrong
|
|
|
|