Hi, I think You are asking about "IDENTITY" Property in SQL Server right. If you will use IDENTITY while creating table, It will Increment Automatically based on your Starting value and Increment. For Example, CREATE TABLE #T1 (ID INT NOT NULL IDENTITY(1,1), Name VARCHAR(12)) INSERT INTO #T1(Name) VALUES('A') SELECT * FROM #T1 BEGIN TRAN T1 INSERT INTO #T1(Name) VALUES('B') ROLLBACK TRAN T1 INSERT INTO #T1(Name) VALUES('C') SELECT * FROM #T1 So Once Identity values is Incremented, In case If Transaction Roll backed also you will get next value only. Regards, GVPrabu.

Are you not going to process it? If so then you could and probably should validate it then. However, there are two possibilities: explicit name space or default. Then you add the url, xsd, and namespace prefix (if not default.) Following link is good enough. Read the comments of the first answer. http://stackoverflow.com/questions/751511/validating-an-xml-against-referenced-xsd-in-c-sharp[^]

i am commiting the changes. i have also tried to unlock tables before alter but to no success. think i have to re-think the whole process.

You probably already googled your issue, but I did find this (search phrase is "C# windows service load 509 certificate"): http://msdn.microsoft.com/en-us/library/ms731899.aspx[^] ".45 ACP - because shooting twice is just silly" - JSOP, 2010 ----- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010 ----- "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997

of course you can use the database.table.field syntax on mysql. the query i wrote works i only asked if someone has a better approach because the query gets difficult to follow once i use more databases and tables. The join operation joins tables on certain values. I don't need the joined. I just need to see where in those tables (the row id) a value is found.

As Abhishek suggested, you need to maintin the session. When users loogs in, store user info in session variable, on every page load check session is null or not, if null , redirect to Login page. You have to clear the session on Log off. Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.

Thanks for your help. I've done it with DateTime.Parse() already.

You can use the sql server import and export data wizard Alexei Rodriguez

realSql is a dll refference to a sql class i've created. it has an select(string select) which open an sql connection then returns a datareader ("SqlDataReader dr = realSql.Select(select)"). So the realSql.Close() closes the connection opened by the Select() method.

Where are you having problems ? It sounds to me like a poor DB design, you probably wanted one table with a column that tells you if it's a PC, a printer, etc. Either way, it sounds like you're saying you can't get the SQL right, which makes this a SQL question. Posting the SQL would sure help us to help you. Christian Graus Driven to the arms of OSX by Vista. "I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )

Change: private void btnSelectServer_Click(object sender, EventArgs e) { <<assign values from control boxes>> frmMain main = new frmMain(); main.Show(); this.Hide(); } ------- Nguyen Dai Duong Ha Noi University of Technology daiduongbk@gmail.com