DO NOT CROSSPOST the same question in multiple forums. You spammed about half the forums on the site... A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

Dave Kreskowiak wrote: same question in multiple forums Good God :| The OP obviously is clueless. "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

Quit cross posting the forums, man. veereshIndia wrote: i want to join this group If that is so, then learn how to post in an etiquette manner around here :mad: "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

No, it's not. If you post a question in multiple forums, you can get different answers, which isn't really a good thing. You're taking away a continuity of discussion, where the good answers are weeded out from bad ones, and more detail required of the OP is lost in one discussion, but exists in another, leading to misinformation on one discussion thread. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

You'll get a good starting point from this article: How Transactional Replication Works[^] The need to optimize rises from a bad design. My articles[^]

What format is your page data in? For example are you transfering data from a gridview or is it just the whole page text? Deliver yesterday, code today, think tomorrow. "http://www.heuse.com/cphumor.htm"

Double post. Has one just below. Shhhhh..... http://craptasticnation.blogspot.com/[^]

Hi, Thanks a lot.I have one more thing.Can i use sql server 2000 reporting service with visual studio 2005.? Regard's Veeresh i want to join this group

You are welcome Bob Ashfield Consultants Ltd

this is working ! DECLARE @IDNAL VARCHAR(36) DECLARE @ID_STAVKE VARCHAR(36) DECLARE @IDDOC VARCHAR(36) DECLARE @IDVL VARCHAR(36) DECLARE @IDLOK VARCHAR(36) DECLARE @NEVALJA CHAR(1) DECLARE @RECENICA AS VARCHAR(5000) DECLARE @LOCAL_KONTO AS VARCHAR(36) DECLARE @ID_FORMULE AS VARCHAR(36) DECLARE @FORMULA AS VARCHAR(500) SET @MySTRING=' UPDATE #A SET #A.col001=#A.col001+COALESCE((SELECT ('+@FORMULA+') FROM #LOCAL_STAVKE WHERE #LOCAL_STAVKE.VD='''+@IDDOC+''' AND #LOCAL_STAVKE.KONTO= CASE '''+@LOCAL_KONTO+''' WHEN '''' THEN #LOCAL_STAVKE.KONTO ELSE '''+@LOCAL_KONTO+''' END AND #LOCAL_STAVKE.ID=#A.IDNALOGA ),0)' EXECUTE(@MySTRING)

You would need to construct your SQL statement as a string and execute it using the EXEC statement. Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

ok Thanks where r u from?

Hi Sir, Thanks for helping me.I got it. Veeresh i want to join this group

Try the query within a bracket () while assigning it with set keyword. i am not sure try it.

Try This. SqlConnection con = new SqlConnection("Data Source=;Database=;User Id=;Password="); SqlCommand cmd; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { hfCounter.Value = "1"; } } protected void btLogin_Click(object sender, EventArgs e) { try { con.Open(); string xSql="select * from where userid='" + txtUser.Text + "' and pswd='" + txtPswd.Text + "'"; cmd = new SqlCommand(xSql,con); SqlDataReader rd = cmd.ExecuteReader(); int x = Convert.ToInt32(hfCounter.Value); if (x == 3) { lblMsg.Text = "User Locked....!"; // write your process here. to change the Lock Status from 0 to 1 OR 1 to 0 etc... } else { if (rd.HasRows != true) { x++; hfCounter.Value = x.ToString(); } } } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { con.Close(); } } I hope Helps you out. I used Two TextBox, Label, Button, HiddenField :rolleyes: " Good Things Goes with Good People "

Hi, Thanks friend.I wil try it now. Veeresh i want to join this group