View Complete Post
actually i came across this senario for new project where userstatus must change to log off when ever he do fallowing activity.I have maintain user status when he log in to web based system.
1.user click log off
2.or user click browser close button or close brwoser tab.
3.or Fource fully shut down his Pc
I am able to get first 2 but not the last one.I googled it but not get any satified ans for that.
I m looking for guidens for this. Any help is grate help for me as i want it.And also other suggesstion also welcomed.
thanks in advance
I have table A in database A , in table A i have trigger to insert record to database B table A, each update and insert of database A -table A, triiger fire and insert record in database B table A, when i try to update some times asp.net application gives error
"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
and then error log says System.Data.SqlClient.SqlException: Database 'database B is being recovered. Waiting until recovery is finished. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean ret
I have a requirement to import the profile properties from a text file in sFTP to update the MOSS Profile Database. The objective is to create a single repository for the Staff Directory in MOSS.
Can I use BDC to connect and update the Profile database?
What is the alternate approach?
Hi, I am a hobbyist learning SQL and .asp and am using Visual Web Developer Express 2008 to produce a website for a sports club.
I have created normalised data tables to hold look up information (such as venues, players, teams etc) and want to dynamically update the 'matches' data table (my transactions) using webpages instead of running SQL queries.
What I want to do is select a name from a drop down list and then post the relevant ID associated with that name to my 'matches' table. At the moment I can only link to the value in the drop down list, i.e. the name which is incompatible with the validation which expects a primary key integer.
I'm sure this problem is a fairly common one but I haven't found the right answer on any of the tutorials or blogs, all of them assume that the data is de-normalised or describe things in more technical ways than I can yet understand. If anyone can point me to a 'how to article' or tell me what I am doing wrong, I would be grateful.
I have a problem with updating data in database from importing excelfile. What I want is:
1.Export table in database to excelfile
2. Make changes in excelfile
3. Via asp.net web form upload file, do some validation, and update table in database with changes from excelfile.
I have written code to get the current data to a dataset. Also been able to get the exceldata in to another dataset.
When I try to copy the datatable in the first dataset to the other( dataset ds1 = ds2.copy() )and then tries to do an sqldataadapter.update(). The changes are not updated in database.
Is this the wrong approach? Is it better to read the excelfile into a dataset. Truncate table in database and loop through each records in databable and do a sql insert?