Pothirajan C wrote: In a table how to check only primary key fields are there or not I'm not sure what you mean. Do you mean: How do I check if a table contains a primary key or not? IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE TABLE_SCHEMA = 'dbo' AND TABLE_NAME = 'Orders' AND CONSTRAINT_TYPE = 'PRIMARY KEY') BEGIN -- The primary key exists END ELSE BEGIN -- The primary key does not exist END My: Blog | Photos WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

The reason is that "GO" is not part of SQL. It is a command for the Query Analyser to tell it to run the next set of statements in a different batch. Also, as your query is not returning a result set you should not be trying to Fill a DataSet. You should create a SqlCommand object then ExecuteNonQuery() on it. For example: SqlCommand cmd = new SqlCommand("if exists (select * from dbo.sysobjects where id ="+ "object_id(N'[dbo].[sp_createAddEditscript]') and OBJECTPROPERTY(id, N'IsProcedure')"+ " = 1) drop procedure [dbo].[sp_createAddEditscript]", myConnection); myConnection.Open(); cmd.ExecuteNonQuery(); myConnection.Close(); Does this help? My: Blog | Photos WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

Hi there, Can you be more specific about what you want to do with the particular row of the GridView control without postback? The GridView control is rendered as a table at the client side, and basically what you want to do is supposed to run on the client machine. So you can use the client side stuff: javascript, behavior ... to get it done.

Hi Jitendra, What code u have given working fine, but I am loosing the sorting functionality for the DataGrid / Gridview. What to do for that Expecting reply, Pothirajan C

If you are changing the value clientside - are you then sure you get it submitted on postback? Try checking the Form object as the first thing on page load, and see if the value is "there" or not. If it isn't, then try making an input field (hidden or what not) and placing the value there, and then pulling it out again. (sorry - if I don't make sences, but I'm not that terrible experienced (yet) ;)) --------------------------- 127.0.0.1 - Sweet 127.0.0.1

public[^] is explained within the C# Programmer's Reference on MSDN. - Nick Parker My Blog | My Articles

First of all, to start with, make sure you have HTML meta tag "Keywords" and list of keywords in each and every page of your site.:laugh: ARSALAN MALIK