hi dharmendr

thanks alot this is exactly what I want.

I change this part of codes because when we drop table we don't need to update query

        string script = "";
        updateQuery = "UPDATE " + tableName + " SET " + updateQuery + " WHERE " + PrimaryKey + " = ' " + iDValues + "'";
        int index = updateQuery.LastIndexOf(",");
        string updatqry = updateQuery.Remove(index, 1);
        if (i == 1)
        {
            script += "DECLARE @updateCount INT;" + Environment.NewLine;
            script += "DECLARE @insertCount INT;" + Environment.NewLine;
            script += "DECLARE @count INT;" + Environment.NewLine;
            script += " SET @updateCount = 0;" + Environment.NewLine;
            script += " SET @insertCount = 0;" + Environment.NewLine;
            script += "SELECT @count = COUNT(*) FROM [" + tableName + "] WHERE [" + PrimaryKey + "] = '" + iDValues + "'" + Environment.NewLine;
            //script += "IF @count = 0" + Environment.NewLine;
            script += "BEGIN " + Environment.NewLine;
            script += "SET IDENTITY_INSERT " + tableName + " ON" + Environment.NewLine;
            script += insertqry + " " + Environment.NewLine;
            script += "SET IDENTITY_INSERT " + tableName + " OFF" + Environment.NewLine;
            script += " SET @insertCount = @insertCount + 1 " + Environment.NewLine;
            script += "END" + Environment.NewLine;
            //script += "ELSE" + Environment.NewLine;
            //script += "BEGIN" + Environment.NewLine;
            //script += updatqry + "" + Environment.NewLine;
            //script += " SET @updateCount = @updateCount + 1 " + Environment.NewLine;
            //script += "END" + Environment.NewLine;
            StreamWriter sw = new StreamWriter(Server.MapPath("~/" + tableName + ".sql"), true, Encoding.UTF8);
            sw.Write(script);
            sw.Close();
        }
        else
        {
            script += "SELECT @count = COUNT(*) FROM [" + tableName + "] WHERE [" + PrimaryKey + "] = '" + iDValues + "'" + Environment.NewLine;
            //script += "IF @count = 0" + Environment.NewLine;
            script += "BEGIN " + Environment.NewLine;
            script += "SET IDENTITY_INSERT " + tableName + " ON" + Environment.NewLine;
            script += insertqry + "" + Environment.NewLine;
            script += "SET IDENTITY_INSERT " + tableName + " OFF" + Environment.NewLine;
            script += "SET @insertCount = @insertCount + 1 " + Environment.NewLine;
            script += "END" + Environment.NewLine;
            //script += "ELSE" + Environment.NewLine;
            //script += "BEGIN " + Environment.NewLine;
            //script += updatqry + "" + Environment.NewLine;
            //script += "SET @updateCount = @updateCount + 1 " + Environment.NewLine;
            //script += "END" + Environment.NewLine;
            StreamWriter sw = new StreamWriter(Server.MapPath("~/" + tableName + ".sql"), true, Encoding.UTF8);
            sw.Write(script);
            sw.Close();
        }