Thanks for your valuable suggestion, code and time. actually my requirement is to create a Audit trail for User Login and Logout. if user login to the system, then i make a entry into the Database. if user successfully Logout to the system then i make the logout entry in the database. but what will happen if user close the IE directly with logout to the system or Alt + f4 or close IE by right click or any thing else. that is my actual requirement.. Amit Agarwal

I meant exactly what Damian said. This will allow you to identify how long a user is inactive and reset the flag if he is inactive for long time. Best wishes, Navaneeth

Amit Agarrwal wrote: want to insert record in both database but the major concern is that if any one failed its transaction then it should rollback both trasaction in both databases This is called distributed transaction where you have a special coordinator which takes care of the transactions. The transactions themselves are ended using two-phase commit. You could start here: http://msdn.microsoft.com/en-us/library/ms191440.aspx[^] A slightly different variation is using Linked Servers. Amit Agarrwal wrote: i have two database in sql server 2005 Just wondering what that actually means. If you have two different SQL Server instances, then you need to distribute the transaction (one way or another), but if you have two different databases inside a single SQL Server instance, you can use normal transactions. The need to optimize rises from a bad design.My articles[^]

Amit Agarrwal wrote: but it didn't work for me. You'll have to give a little more than this. What didn't work? Did you get exceptions? Did the file not write? only two letters away from being an asset

While I have never used the combo in a gridview I would expect you to have to set the selectedvalue = X of the combo NOT the cell. BTW you posted C# in the VB forum :) Never underestimate the power of human stupidity RAH

If the relation is one-to-one, I think you can do something like this: Me.cboDepartment.DataBindings.Clear() Me.cboDepartment.DataBindings.Add(New Binding("SelectedValue", Me.cboManager, "SelectedValue")) I assumed that you made your combobox setting like this: cboDepartment.ValueMember = "manager" cboDepartment.DisplayMember = "department" cboManager.ValueMember = "manager" cboManager.DisplayMember = "manager" So the program will read it like this: cboDepartment.SelectedValue = cboManager.SelectedValue cboManager.SelectedValue = cboDepartment.SelectedValue Thanks, I hope this can answer your question. Best Regard, Indra Permana Rusli - No Signature Available -

I think You should choose PHP,My Sql for web development as it is easier for a new user like you and also provide the flexibility of working in a Cross Platform Environment. But It will be better to chose J2EE if wants more security and reliability as well as flexibility of working in a Cross Platform Environment.But it is vast. If you are willing to use Windows as OS then No other Can Give you better performance, working satisfaction then Microsoft .NET technology.So If you are a windows man go for .NET.

if your database service running and you can use it on local machine that could be wrong connection string(user/pass/server) or sql ports being blocked by firewall on server. I Wish the Life Had CTRL-Z Wizard's First Rule : People are fool,they believe what they want to believe or what they afraid to believe www.subaitech.blogspot.com

Thnaks for the reply, yeah, I did the certain changes from server surface area Management.i'm trying to connect sql server 2005 express edition with asp.net 2.0 on a single my PC. but still getting the same error. Amit Agarwal

Christian Graus wrote: Access mdb files are easier. What about SQL Express? led mike

Yeah i tried this but it is a Paid Control.but no worries I have found another one which is free also. http://www.codeproject.com/KB/ajax/typeahead.aspx[^] it is really very simple and useful Control. Thanks Guys. Amit Agarwal

use System.Globalization and use Cultureinfo and regioninfo class if you create object of an regioninfo class you can get the CourencyFormat!! if you want to create own or cutome CurrencyFormat .. use sysglobl.dll and use CultureRegionandInfo Builder Class. :) Best Regards ----------------- Abhijit Jana View My Latest Article :- SpyNet : Your Network Spy "Success is Journey it's not a destination"

Use File.ReadAllBytes() to get a byte array of the file. Like this take two byte arrays represents two files. By checking the array length, you will find which is big one. If both are same length, then loop through each bytes and check with the same location in second array. Hope you can make it. All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia My Website | Ask smart questions

Do you want to get the total in footer Template? on RowDataBound Event of gridview,get values of perticular rows and set footer template. if (e.Row.RowType == DataControlRowType.DataRow) { Totalvalues +=convert.ToInt32(((Lable)e.Rows.Findcontrol("lbl")).Text) //If you have take Label cotrol //Totalvalues is global var and assign 0 } if (e.Row.RowType == DataControlRowType.Footer) { ((Label)e.Row.FindControl("lblTotal")).Text=Totalvalues.ToString(); } best regard pathan please don't forget to vote on the post that helped you.

This Site[^], duhhh :) "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

:D